1. Administration Guide
  2. Backup Service
  3. View Backup Information
  4. List Incremental Backup Files (Binary Logs)

List Incremental Backup Files (Binary Logs)

View the incremental backups (binary log files) created since the last full backup. Incremental backups are always located on the local STA server.

Note:

Frequent incremental backups can generate a significant number of binary log files that may consume considerable hard drive space. You may want to purge old binary logs periodically.

  1. Open a terminal session on the STA server, and log in as the Oracle user.
  2. Change to the incremental backup directory.
    $ cd /var/log/tbi/db
  3. List the directory. This example shows the following incremental backup files:
    • Incremental backups (binary log files), which have the file names stadb-bin.000028 and stadb-bin.000029. These files are created at the intervals defined with the staservadm utility.
    • Index file for the binary log files, which has the name stadb-bin.index.
    • "Slow queries" log, which has the name stadb-slow.log. This log lists MySQL queries that take a long time to execute and is a tool used by Oracle Service and development. 
    $ ls -l
total 876
drwxr--r-- 2 oracle oinstall   4096 Jan 24 02:52 backups
-rw-rw---- 1 oracle oinstall 161351 Jan 24 17:03 stadb-bin.000028
-rw-rw---- 1 oracle oinstall 146592 Jan 25 14:55 stadb-bin.000029
-rw-rw---- 1 oracle oinstall     66 Jan 24 17:03 stadb-bin.index
-rw------- 1 oracle oinstall   6561 Jan 24 17:03 stadb-slow.log