Highlighted

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?

1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

This is from the admin

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.

View solution in original post

2 Replies
Highlighted

"You can use BR*Tools for

"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

 

 

Highlighted
Accepted Solution!

This is from the admin

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.

View solution in original post