restore achive logs from tape

[Former Member]

Hi

I need to restore archive logs from the tape. I am pretty new on this, do i have to go brtools and restore the archive logs or there is a t code in sap that I can recover from that? if it is using brtools, what is step and procedure? do I have to use sqlplus? while I am doing this type of recovery, do I need to shut the dabase down?

please share

thanks

[Former Member]

Wei,

You can restore redo logs from below command.

brrestore -a <start_log#>-<end_log#> -c -d util_file -r <Oracle_Home>\database\initSID.utl

If you want to do a restore & recovey you can go for point intime recovery. Here You need to restore online backup & then additionally need to apply redologs which were generated after the online backup.

Check below link for details.

http://help.sap.com/saphelp_nw04/helpdata/en/93/4ffb72309fb04e80ebfefae1b7a96f/frameset.htm

also check below SAP notes which will answers of your questions.

602497 - BRRECOVER - New tool for Oracle Restore and Recovery

Note 4161 - Complete Recovery

Note 23070 - Backup and Recovery: Basic Concepts

Note 4160 - Tape management for recovery

Hope this helps

Thanks

Sushil