RE: no archivelog incomplete recovery?

From: Blanchard William <>
Date: Sun, 6 Jul 2008 22:26:18 -0500
Message-ID: <>

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.  


[] 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

Original text of this message