Re: Hot Backup Issue

hi,

i feel u need to give the name of online redo log file after u had applied all the archived log files, if it's asking for more files. this should solve ur problem.

pls let me know if it not. i'll try finding other issues also.

saurabh
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, October 01, 2001 5:50 PM

> Hi All,
> I am trying for hot backup restore/recovery.
> Oracle 8.1.7.0.0 on WIN 2K Server. I am performing
> the operations in following order:
>
> 1. Put all the tablespaces in backup mode.
> 2. Copy all the datafiles to backup location.
> 3. Do end backup for all the tablespaces. Also switch logfile
> after every end backup ( some more switch logfile at the end).
> 4. Shutdown the database ( after all its test instance).
>
> When I try to "completely recover" the database using
> backed up datafile the recovery goes upto last archived logfile
> and even after applying last archived logfile it asks for the
> next archived logfile.
> This is a very awkward situation, how can I provide next
> archived logfile if there is no activity and I had shutdown the
> database immediately after last switch logfile.
>
> If I try to open the database, then I get following error:
>
> ORA-01113: file 1 needs media recovery
> ORA-01110: data file 1: 'D:\ORACLE\ORADATA\OHIR\SYSTEM01.DBF'
>
> Upon checking the metalink, some guys suggest, using
> _allow_resetlogs_corruption = true. But I am afraid of using this,
> because I have to implement this into production environment too
> (where same problem is happening).
>
> After lots of testing I have found that incomplete recovery
> (cancel based) goes fine with the same backup and I can open the
> database without any error. But keeping the needs of production
> database in mind, it would be very difficult to do an incomplete
> recovery every time.
> Why can't I perform complete recovery? Am I missing something?
> I hope someone on this list would have experienced the problem and
> would have got the solution as well. Please share your experience.......
>
> Thanks in Advnace,
> Rajesh
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rajesh Dayal
> INET: Rajesh_at_ohitelecom.com
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Saurabh Sharma
  INET: ssharma1_at_fcsltd.com

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).