Oracle-L: RE: RMAN restore question

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Wed, 09 Apr 2003 12:49:35 -0800
Message-ID: <F001.0057E747.20030409124935@fatcity.com>

you could use the -- set time until ...use RMan to do the restore set until time "to_date($DB_DATETIME,'YYYY-MM-DD:HH24:MI:SS')"; do it right in the run{ command

You could just do the RESTORE DATABASE but leave off the RECOVER DATABASE at the and..then go to SQLplus and finish up with the media recovery and recover
rolling the logs forward.

Or do a point in time recovery in RMAN before the last backup or incremental was
taken and a RMAn will have to get the previous backup.

Brian Spears

-----Original Message-----

Sent: Wednesday, April 09, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L

Hello,
I lost one of my devices on the server. I need to restore from an RMAN backup. There were 4 datafiles and 1 redo-log file on this device. I restored, 3 of the datafiles, but when attempting to restore #4, I am finding that there is an issue with reading from that portion of the tape. (I get bad block errors).
The question is: Is there a way to force RMAN to restore from the second newest backup of this datafile instead of the newest (which is apparently bad)?

OS: SunOS 5.6
Oracle DB & RMAN: 8.0.4.4.4

Thank you.
-Fred S.

Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Gary Jackson
INET: fred_fred_1_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

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

Author: Spears, Brian
INET: BSpears_at_Limitedbrands.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message