| clone database from previous incarnation/dbid [message #309134] |
Wed, 26 March 2008 09:27  |
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  |
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 |
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?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
