Display BRTOOLS logs using BRTOOLS

1. As oraSID, execute the brtools command.

> brtools

2. Choose 8 – Additional functions.

-------------------------------------------------------------------------------
BR*Tools main menu

 1 = Instance management
 2 - Space management
 3 - Segment management
 4 - Backup and database copy
 5 - Restore and recovery
 6 - Check and verification
 7 - Database statistics
 8 - Additional functions
 9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------

3. Choose 1 = Show profiles and logs.

-------------------------------------------------------------------------------
Additional BR*Tools functions

 1 = Show profiles and logs
 2 - Clean up DBA logs and tables
 3 - Adapt NEXT extents
 4 - Change password of database user
 5 - Create/change synonyms for DBA tables
 6 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------

4. At this screen, you can select any of BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRCONNECT & BRSPACE logs.

-------------------------------------------------------------------------------
Show profiles and logs

 1 = Oracle profile
 2 - BR*Tools profile
 3 - BRBACKUP logs
 4 - BRARCHIVE logs
 5 - BRRESTORE logs
 6 - BRRECOVER logs
 7 - BRCONNECT logs
 8 - BRSPACE logs

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------

5. As example, option 3 – BRBACKUP logs selected. You can see the list of backup logs.

-------------------------------------------------------------------------------
Display of BRBACKUP logs

Pos.  Log           Start                Type        Mode        Device     Rc

  1 = belrsatw.anf  2013-07-21 23.55.16  online      all         util_file   0
  2 - belrncza.anf  2013-07-20 23.55.22  online      all         util_file   0
  3 - belrifdz.anf  2013-07-19 23.55.23  online      all         util_file   0
  4 - belrdhip.anf  2013-07-18 23.55.15  online      all         util_file   0
  5 - belqyjnr.anf  2013-07-17 23.55.19  online      all         util_file   0
  6 - belqtlsn.anf  2013-07-16 23.55.17  online      all         util_file   0
  7 - belqonxp.anf  2013-07-15 23.55.21  online      all         util_file   0
  8 - belqjqcj.anf  2013-07-14 23.55.17  online      all         util_file   0
  9 - backSID.log   <summary_log>

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------

6. To be able to read the backup logs in details, you need to select from the above list. As example, below option selected. You can now read the logs!

1 = belrsatw.anf  2013-07-21 23.55.16  online      all         util_file   0
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

     1: BR0051I BRBACKUP 7.20 (31)
     2: BR0055I Start of database backup: belrsatw.anf 2013-07-21 23.55.16
     3: BR0484I BRBACKUP log file: /oracle/SID/sapbackup/belrsatw.anf
     4: BR0477I Oracle pfile /oracle/SID/112_64/dbs/initSID.ora created from spfile 
        /oracle/SID/112_64/dbs/spfileSID.ora
     5:
     6: BR0280I BRBACKUP time stamp: 2013-07-21 23.55.40
     7: BR0319I Control file copy created: /oracle/SID/sapbackup/cntrlSID.dbf 335
     8:
     9: BR0101I Parameters
    10:
    11: Name                           Value
    12:
    13: oracle_sid                     SID
    14: oracle_home                    /oracle/SID/112_64
    15: oracle_profile                 /oracle/SID/112_64/dbs/initSID.ora
    16: sapdata_home                   /oracle/SID
    17: sap_profile                    /oracle/SID/112_64/dbs/xsapSID.ora
    18: backup_mode                    ALL
    19: backup_type                    online
    20: backup_dev_type                util_file

BR0672I Press <Rtn> - scroll, c - cont, s - skip, b - back, h - header

Note

Similar result can be taken from transaction code DB14.

You May Also Like

Leave a Reply?