FW: Restore with RMAN

From: Muqthar Ahmed <Muqthar.Ahmed_at_decoratetoday.com>
Date: Tue, 25 Jun 2002 13:41:20 -0800
Message-ID: <F001.004879F2.20020625134120@fatcity.com>

Luc,

RMAN catalog will always restore the latest CONTROLFILE. If you can restore OLDER version of CONTROLFILE then you can restore the previous one.

Muqthar Ahmed
DBA -----Original Message-----
Sent: Tuesday, June 25, 2002 4:50 PM
To: Multiple recipients of list ORACLE-L

Luc -

        I wondered about this issue, but since it wasn't going to be on the OCP B&R exam, it obviously wasn't worth knowing (just a little dark OCP humor).

        My initial guess would be either:
1) RMAN would just "know" to go to the earlier backup if the first failed (I doubt that).
2) Manually go into the RMAN catalog and delete the reference to the bad backup so RMAN no longer knows it exists. I also believe there may be an RMAN command to accomplish this.
3) Hope someone else on this list knows the answer.

Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, June 25, 2002 1:29 PM
To: Multiple recipients of list ORACLE-L

Hi gurus,

I'm in a process of testing our backup and recovery strategies.

Question:
For a restore of a noarchivelog database : Is't possible to restore other backups than the last one?
What's happen if the last one is not good?

TIA Luc

---

Luc Demanche
luckyref_at_yahoo.com

---

Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com
--

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

Author: Luc Demanche
  INET: luckyref_at_yahoo.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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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: Muqthar Ahmed
  INET: Muqthar.Ahmed_at_decoratetoday.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). Received on Tue Jun 25 2002 - 16:41:20 CDT