Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Media Recovery needed
On 2002.05.25 19:48 Simon Waibale wrote:
> Hi all,
> In dire need of help right now -leave all that U R doing and help!!
> Hot Backup process cancelled and while re-starting the DB, following
> errors
> occur:
>
> 1)ORA-00304: requested INSTANCE_NUMBER is busy
>
> 2) IF I set INSTANCE_NUMBER=2, then I get
> ORA-01113: file 5 needs media recovery
> ORA-01110: data file 5: '/data1/oradata/flag/userdata01.dbf'
>
Startup the database into the mount mode, check whether your file is in
the backup
mode (v$backup, status='ACTIVE') and, if it is, try something like
ALTER DATABSE DATAFILE 5 END BACKUP;
If this is successfull, your problem is solved.
Otherwise, you need to have a hot backup and all archives at hand. It
may take
much less then 2 hours. You will have to:
a) Restore the hot backup to /data1/oradata/flag/userdata01.dbf.
b) Restore all the archives since the hot backup was taken (take a look
into the v$archived_log,
there is a column called "first_time", which tells you when was the first change in the log file
committed.) into a directory (let's call it "/arch") c) Startup the database in the mount mode.
d) Issue the folowing commands:
ALTER SYSTEM SET LOG_ARCHIVE_DEST='/arch';
SET AUTORECOVERY ON
e) Recover the database by using the following command:
RECOVER DATABASE;
When you get the rely "Media Recovery complete.", type 'ALTER DATABASE
OPEN;'
and you are done.
-- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: mgogala_at_adelphia.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Sat May 25 2002 - 20:43:20 CDT