Forum Discussion

mizen's avatar
mizen
Level 2
10 years ago

Sap brrestore newbie question

Hi guys!

Newbie here!

 In case of disaster do you know if its possible restore log files using brrestore?

I played with the command option "-n" but seems util_file its not supported.

brrestore -u / -p initDAILY.sap -u util_file -n det_log

root@saptest:/]/usr/openv/netbackup/bin/bplist -C saptest -t 17 -l -R /
-rw-r----- orat01    dba              2634 09 Sep 23:08 /oracle/T01/11203/dbs/initT01.ora
-rw-r----- orat01    dba              5632 08 Sep 11:53 /oracle/T01/11203/dbs/spfileT01.ora
-rw-r--r-- root      system           7045 13 Aug 16:53 /oracle/T01/11203/dbs/initT01.DAILY.sap
-rw-r--r-- root      system          15450 13 Aug 16:53 /oracle/T01/11203/dbs/initT01.DAILY.utl
-rw-r--r-- orat01    dba              9738 04 Jul  2013 /oracle/T01/sapreorg/spaceT01.log
-rw-r--r-- orat01    dba              2675 14 Mar  2013 /oracle/T01/sapreorg/strucT01.log
-rw-r--r-- orat01    dba              2177 02 May  2012 /oracle/T01/sapreorg/paramT01.log
-rw-r--r-- orat01    dba              5782 09 Sep 23:09 /oracle/T01/saparch/aeosdyas.svd
-rw-rw---- orat01    sapsys         700516 09 Sep 23:08 /oracle/T01/saparch/archT01.log
-rw-r----- orat01    dba         229451264 09 Sep 23:07 /oracle/T01/oraarch/T01arch1_840_832591578.dbf
-rw-r----- orat01    dba              2634 09 Sep 21:30 /oracle/T01/11203/dbs/initT01.ora
-rw-r----- orat01    dba              5632 08 Sep 11:53 /oracle/T01/11203/dbs/spfileT01.ora
-rw-r--r-- root      system           7045 13 Aug 16:53 /oracle/T01/11203/dbs/initT01.DAILY.sap
-rw-r--r-- root      system          15450 13 Aug 16:53 /oracle/T01/11203/dbs/initT01.DAILY.utl
-rw-r--r-- orat01    dba              9738 04 Jul  2013 /oracle/T01/sapreorg/spaceT01.log
-rw-r--r-- orat01    dba              2675 14 Mar  2013 /oracle/T01/sapreorg/strucT01.log
-rw-r--r-- orat01    dba              2177 02 May  2012 /oracle/T01/sapreorg/paramT01.log
-rw-r--r-- orat01    dba             49889 09 Sep 23:08 /oracle/T01/sapbackup/beosdhil.anf
-rw-rw---- orat01    sapsys          97019 09 Sep 23:07 /oracle/T01/sapbackup/backT01.log

any idea to restore to get these files without an OS backup?

7.5
Agent for SAP Applications
AIX
Backup and Recovery
Error messages
NetBackup
Recovering
Restore
  • INT_RND's avatar
    INT_RND
    10 years ago

    This is from the admin guide:

    "To restore the first available copy of an archive log file, issue the
    following command:
    brrestore -d util_file -a log_number
    where log_number is the number of the archive log you want to
    restore."

    Here is the Netbackup for SAP administrator's guide:

    http://www.symantec.com/business/support/index?page=content&id=DOC6482

     

    You might find more information in a SAP support forum.

2 Replies

Sort By
  • mizen's avatar
    mizen
    Level 2
    10 years ago

    "You can use BR*Tools for Oracle to recover from a disaster. You use BRRECOVER to restore missing or damaged profiles and log files. BRRESTORE is not called by disaster recovery, because it always requires the BRBACKUP Logs or the BRARCHIVE Logs, which might not be available in a disaster"

    Mmm..seems I need BR*Tools Disaster recovery option for restore BRBACKUP/BRARCHIVE logs

     

     

  • INT_RND's avatar
    INT_RND
    Level 6
    10 years ago

    This is from the admin guide:

    "To restore the first available copy of an archive log file, issue the
    following command:
    brrestore -d util_file -a log_number
    where log_number is the number of the archive log you want to
    restore."

    Here is the Netbackup for SAP administrator's guide:

    http://www.symantec.com/business/support/index?page=content&id=DOC6482

     

    You might find more information in a SAP support forum.