RE: Recovery database with RMAN after resetlogs

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 24 Feb 2004 11:24:37 -0600
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B0002D@EXCHMN3>

Michal

    I haven't tried what you describe. You may find it beneficial to study what Robert Freeman has to say on this subject in his Oracle9i RMAN Backup & Recovery book.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: Skursk Michal [mailto:Michal.Skursky_at_pvt.cz] Sent: Tuesday, February 24, 2004 11:05 AM To: Oracle-L Freelists
Subject: Recovery database with RMAN after resetlogs

Hello,
I am testing my recovery scenario.
I completed first step of RMAN online backup and incomlete recovery with resetlogs without problems.
But in second step I am in trouble:
- after reseting recovery catalog and switch to next incarnation I am
proceeding with RMAN online backup
- then I try to recover from these online backups (after incomlete recovery
with resetlogs)
- restore database is OK

• recover database using backup controlfile until change (resetlogs_change#-1) is also OK for all archived logs
• alter database open resetlogs reports error ORA-1113 and ORA-1110 - system01.dbf needs data recovery or ORA-1152 and ORA-1110 - system01.dbf was not recovered from sufficient old backup (sorry -I am translating error messages from Czech)

I know I should do full cold backup after incomlete recovery but there is no way how to recover from online backups?
Or am I missing something?
Thanks
Michal

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Feb 24 2004 - 11:23:37 CST