Recreate the controflile with the RESETLOGS option.
1) Get the controlfile trace from below
command
:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS
'/tmp/control.sql'
resetlogs ;
2) Modify the CREATE CONTROLFILE script
/tmp/control
.sql and ensure that all directories
for
the online redo logs exist and Oracle has permission to write to it
3) Create the controlfile
in
NOMOUNT state :
SQL> STARTUP FORCE NOMOUNT
SQL> @
/tmp/control
.sql
controlfile created
4) Run a fake recovery :
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL ;
Type when prompted
5) Open with RESETLOGS option:
SQL> ALTER DATABASE OPEN RESETLOGS;
转载于:http://blog.itpub.net/31394774/viewspace-2285953/