RE: Recovery database with RMAN after resetlogs
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Feb 2004 11:24:37 -0600
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@xxxxxxxxxxxxx
-----Original Message-----
From: Skursk Michal [mailto:Michal.Skursky@xxxxxx]
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
