Standby Database recover, after shutdown abort -URGENT-
ZerandibJun 20 2011 — edited Jun 20 2011Hello,
Our standby database is in mount state.
Normally, We are shutting down the database using 'SHUTDOWN IMMEDIATE' command.
But... mistakenly we have provide the SHUTDOWN command.
So it taking long time. It took 3 hrs . but not shutdown yet.
therefore, we have used 'SHUTDOWN ABORT'
Now i want to startup the database back.
Please let me know , what are the steps to follow?
(I want to get the database to MOUNT state)
Normally we are using these 2 commands;
startup nomount;
alter database mount standby database;
Do we need to perform a recovery? (Since we use , SHUTDOWN abort)
let me know how to do this
regards,