RE: no archivelog incomplete recovery?
Date: Sun, 6 Jul 2008 22:26:18 -0500
You can still recover from a database in noarchivelog mode. You need to restore from a cold backup, perform a recover until cancel and open with resetlogs. Sometimes, this will result in the system scn being incorrect. When this happens, just perform a recover and open and you should be up and running.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Smith Sent: Sunday, July 06, 2008 6:58 PM
Subject: no archivelog incomplete recovery?
I am studying for the OCP, and one of the practice test questions is how to recover from a lost active online redo log in noarchivelog mode. the answer they give is to restore a consistent backup, startup in mount mode, perform a cancel based recovery, and open with resetlogs.
Is that answer correct? I didnt think you could do a recovery if you arent in archivelog mode.Received on Sun Jul 06 2008 - 22:26:18 CDT