RE: no archivelog incomplete recovery?
- From: "Blanchard William" <William.Blanchard@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- 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.
William
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of John Smith
Sent: Sunday, July 06, 2008 6:58 PM
To: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
