Home » RDBMS Server » Backup & Recovery » clone database from previous incarnation/dbid (10.2.0.3)
clone database from previous incarnation/dbid [message #309134] Wed, 26 March 2008 09:27 Go to next message
hpaccess
Messages: 17
Registered: October 2005
Junior Member
Can some please help me in resolving the issue?

1. I have taken full backup of FNQAS on Mar 16
2. FNQAS was refreshed (cloned) from FNPRD on Mar 17th
3. I want to clone HCARC from older FNQAS backup - before cloning from FNPRD (i.e., Mar 16th)

Tried cloning the database:
RMAN> run
2> {
3> set until time "TO_DATE('03-16-2008:06:43','MM-DD-YYYY:HH24:MI')";
4> duplicate target database to HCARC;
5> }

executing command: SET until clause
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 03/21/2008 14:59:42
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS
time

--------

Tried cataloging the backuppices:

RMAN> list incarnation;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
5129178 5129179 FNQAS 355768738 CURRENT 13833549768 17-MAR-08

RMAN> list backup summary;

List of Backups
===============

< deleted intentionally because of longer listing >


Because we dont have Mar 16th backupsets listed, i tried to catalog them so that i can clone as of Mar 16.

While trying to catalog Mar 16 backuppieces i got the following error.

RMAN> catalog backuppiece '/var/opt/recovery/backups/FNQAS/backupset/db0_FNQAS_20080316_dvjbchea
_1_1';

ORA-19870: error reading backup piece /var/opt/recovery/backups/FNQAS/backupset/db0_FNQAS_20080316_dvjbchea_1_1
ORA-19691: /var/opt/recovery/backups/FNQAS/backupset/db0_FNQAS_20080316_dvjbchea_1_1 is from different database: id=3544
08644, name=FNQAS
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 03/21/2008 10:41:56
RMAN-06209: List of failed objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Backup Piece /var/opt/recovery/backups/FNQAS/backupset/db0_FNQAS_20080316_dvjbchea_1_1



If any one has clue what i need to do, please do help me ...
Re: clone database from previous incarnation/dbid [message #309152 is a reply to message #309134] Wed, 26 March 2008 11:14 Go to previous messageGo to next message
mauric
Messages: 4
Registered: March 2008
Junior Member
Cause: UNTIL TIME and RECOVERY WINDOW cannot be less than the database creation time or RESETLOGS time.
Action: Check the UNTIL TIME or RECOVERY WINDOW. If the database needs to be restored to an old incarnation, use the RESET DATABASE TO INCARNATION command.

Re: clone database from previous incarnation/dbid [message #309196 is a reply to message #309134] Wed, 26 March 2008 14:58 Go to previous messageGo to next message
hpaccess
Messages: 17
Registered: October 2005
Junior Member
As you see in my note, the list incarnation is showing only one entry.

RMAN> list incarnation;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
5129178 5129179 FNQAS 355768738 CURRENT 13833549768 17-MAR-08

When you say reset incarnation, what incarnation i should set?
Re: clone database from previous incarnation/dbid [message #309232 is a reply to message #309196] Wed, 26 March 2008 19:16 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check the REST TIME 17-MAR-08 on that database.
Re: clone database from previous incarnation/dbid [message #309459 is a reply to message #309134] Thu, 27 March 2008 09:30 Go to previous messageGo to next message
hpaccess
Messages: 17
Registered: October 2005
Junior Member
can you please elaborate? Not sure what you meant by REST TIME?
Re: clone database from previous incarnation/dbid [message #309462 is a reply to message #309459] Thu, 27 March 2008 09:44 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You are trying to recover to a time prior to the RESET TIME.

In your situation, since FNQAS is essentially a "new" database, you'll probably need to perform recovery as Performing Recovery with a Backup Control File.
Previous Topic: Backup Strategy
Next Topic: LOST MY REDOS
Goto Forum:
  


Current Time: Sun Dec 04 06:26:26 CST 2016

Total time taken to generate the page: 0.12487 seconds