Restore an archive log when you are restoring any of the following data items:
-
A database to the most recent state after a database failure.
-
Specific logs which are identified using a serial number or identification tag, that are missing in the database.
-
Logs from a specific time range that were lost due to a hard disk corruption.
For information on the BRBACKUP command options, go to the SAP Help website, Command Options for BRRESTORE.
Procedure
Note
If you use SAP Secure Store, replace the slash ("/") with a double slash ("//") in all examples.
UTIL_FILE Interface
-
On the command line, type one of the following commands.
Restore with the log sequence numbers
Substitute the start_seq and end_seq variables.
brrestore -d util_file -a start_seq-end_seq -u /Restore with a specified log sequence number
Substitute the variable log_seq_no.
brrestore -d util_file -a log_seq_no -u /
RMAN_UTIL Interface
-
On the command line, type one of the following commands.
Restore with the log sequence numbers
Substitute the start_seq and end_seq variables.
brrestore -d rman_util -a start_seq-end_seq -u /Restore with a specified log sequence number
Substitute the variable log_seq_no.
brrestore -d rman_util -a log_seq_no -u /
What to Do Next
-
Recover the database.
-
If you performed a point-in-time restore, open the database with the RESETLOGS option.