How Do I Restore Deleted Redo Logs
I currently have alter database archivelog set and am backing up my archive log redo file. However, I am trying to test a scenario where all of my redo log files have been deleted, and thus need to be restored. I have backups of my archivelog files. I'm trying to recover my redo log files by executing the following:
RMAN> restore archivelog all;
Starting restore at 14-AUG-02
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=9 devtype=DISK
archive log thread 1 sequence 102 is already on disk as file C:\ORACLE\ORA90\RDBMS\ARC00102.001
archive log thread 1 sequence 103 is already on disk as file C:\ORACLE\ORA90\RDBMS\ARC00103.001
archive log thread 1 sequence 104 is already on disk as file C:\ORACLE\ORA90\RDBMS\ARC00104.001
restore not done; all files readonly, offline, or already restored
Finished restore at 14-AUG-02
Since this doesn't work I'm assuming I'm doing something wrong. Therefore, what are the necessary steps for recovering my redo log files after they have been deleted? Thanks to all for your help.