unable to reset the database to previous incarnation
sonidbaMar 24 2011 — edited Mar 24 2011Hello,
I want to perform database point in time recovery to some ancestor incarnation. But getting following erro:
RMAN> shutdown
database closed
database dismounted
Oracle instance shut down
RMAN> startup nomount
connected to target database (not started)
Oracle instance started
Total System Global Area 281018368 bytes
Fixed Size 1258440 bytes
Variable Size 88083512 bytes
Database Buffers 188743680 bytes
Redo Buffers 2932736 bytes
RMAN> reset database to incarnation 4;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of reset command on default channel at 03/24/2011 12:53:07
ORA-01507: database not mounted
As far as I read, reset database to incarnation must be issued in nomount state. Then , why the above error? Pls correct me where am i wrong.