
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.


