RE: Recovery database with RMAN after resetlogs

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 25 Feb 2004 13:20:30 -0500
Message-ID: <007201c3fbcc$0cd658a0$8459699f@vttaxnet.tax.state.vt.us>

Are you using a catalog? If you are, you can set the incarnation back to the original incarnation and restgore and recover until time or until scn. If not, you will have to do a manual recovery using the plsql package sys.dbma_backup_restore. This package is not really meant for users, so if you have support call them and have them help you. If not, let me know and I will try to find the paper which explains how to use it. You will have to recover the controlfile and datafiles separately. It is a pain, but I have done it.

Good luck,
Ruth

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
  [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Skurský Michal   Sent: Tuesday, February 24, 2004 12:05 PM   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 Wed Feb 25 2004 - 12:16:48 CST