RE: no archivelog incomplete recovery?

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.  

William

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Smith Sent: Sunday, July 06, 2008 6:58 PM
To: oracle-l_at_freelists.org
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.

--
http://www.freelists.org/webpage/oracle-l