-
corrupt redolog
I corrupted a redolog on purpose on a test service 4 some exercise.
I made a coldback of the redo this morning. I then replaced the corrupted redo with the backup redo. No archive enabled
Problem: Database in mount,not open mode.
Can anyone assist me in recovering this db (if possible).
Note: This is an area that I'm very bad at because I never get to practice :D
my guess its a media recovery and that I'm screwed!!
ORA-00322:log 3 of thread 1 is not current copy
ORA-00322:online log 3 thread 1:'C:\ORACLE\ORADATA\IAMMV3\REDO03.LOG
Please help if possible
-
drop the group and open the database, or copy a good member of that group over the top
-
This was the only way. Incomplete recovery
SQL> recover database until time '2005-11-17:10:00:00'
Media recovery complete.
SQL> alter database open resetlogs
2 ;
Database altered.
SQL>