1.Connect
to target Database with RMAN.
i)If you have lost your spfile while
your database is running then,
RMAN> CONNECT TARGET /
ii)If your database is not up and
you don't use recovery catalog then use,
RMAN>CONNECT TARGET /
RMAN>SET DBID
3386862614
2)Start
the instance with dummy parameter file.
RMAN>STARTUP FORCE
NOMOUNT
3)
Restore server parameter file.
i)
To
restore in default location,
RMAN>RESTORE SPFILE
FROM AUTOBACKUP;
ii)
To
restore in another location,
RMAN> RESTORE SPFILE
TO 'new_location' FROM AUTOBACKUP;
iii)
If
you want to restore to a pfile then use,
RMAN> RESTORE SPFILE
TO PFILE '/tmp/initTEMP.ora';
4) Start the instance.
RMAN>STARTUP;
No comments:
Post a Comment