List All Files for a Full Database Dump

Verify that files for a full backup have been successfully saved to the right location and check the size of the files.

  1. Open a terminal session on the applicable server, and log in as the Oracle user.
  2. Change to the backup directory.

    The backup directory may be on the local STA server or an external server. Oracle recommends backing up the database to an external backup server. The backup location is defined by the staservadm utility. See Display Current STA Backup Settings for instructions on displaying the location.

    The following example shows an external backup server.

    $ cd /remote_backups/stabackups
    
  3. List the files for the backup in question. This example includes the following files for the full backup done on January 23, 2020.
    • A full dump of the STA database, identified by the file name ending in stafullbackup.sql.
    • MySQL server configuration files, identified by the file name ending in fmwconfig.zip.
    • STA services configuration files, identified by the name ending in conf.zip.
    $ ls -l *20200123*
    
    -rw-r--r-- 1 oracle oinstall  11081 Jan 23 17:02 20200123_170250.conf.zip.gz
    -rw-r--r-- 1 oracle oinstall 195524 Jan 23 17:02 20200123_170250.fmwconfig.zip.gz
    -rw-r--r-- 1 oracle oinstall  37968 Jan 24 17:03 20200123_170250.stadb-bin.000028.gz
    -rw-r--r-- 1 oracle oinstall 461721 Jan 23 17:02 20200123_170250.stafullbackup.sql.gz