RMAN Duplicate database [message #435331] |
Tue, 15 December 2009 11:35 |
babuknb
Messages: 1736 Registered: December 2005 Location: NJ
|
Senior Member |
|
|
Hello,
In RMAN Duplicate database facing some issues. In my catalog database having only December backup details. But I want create duplicate database from Nov 8-13 backup.
In Oracle 10g having CATALOG BACKUPPIECE command to register backup but in 9i tried CATALOG DATAFILECOPY, ARCHIVELOG but it seems not working. Please let me know is there any way to register old backup details in catalog database.
- Babu
RMAN> run
2> {
3> set until time="TO_DATE('11/13/2009 15:30:00', 'MM/DD/YYYY HH24:MI:SS')";
4> Allocate auxiliary channel ch1 type disk;
5> Allocate auxiliary channel ch2 type disk;
6> Allocate auxiliary channel ch3 type disk;
7> DUPLICATE TARGET DATABASE TO UAT;
8> release channel ch1;9
9> release channel ch2;
10> release channel ch3;
11> }
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 15-DEC-09
released channel: ch1
released channel: ch2
released channel: ch3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/15/2009 11:09:54
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 57 found to restore
RMAN-06023: no backup or copy of datafile 56 found to restore
RMAN-06023: no backup or copy of datafile 55 found to restore
RMAN-06023: no backup or copy of datafile 54 found to restore
RMAN-06023: no backup or copy of datafile 53 found to restore
RMAN-06023: no backup or copy of datafile 52 found to restore
RMAN-06023: no backup or copy of datafile 51 found to restore
RMAN-06023: no backup or copy of datafile 50 found to restore
RMAN-06023: no backup or copy of datafile 49 found to restore
RMAN-06023: no backup or copy of datafile 48 found to restore
RMAN-06023: no backup or copy of datafile 47 found to restore
RMAN> catalog DATAFILECOPY '/u02/backup/UAT/UAT_LVL0_200912130300_mkl0p4fn_s724_p5' LEVEL 0;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of catalog command on default channel at 12/15/2009 12:47:53
ORA-19563: datafile copy header validation failed for file /u02/backup/UAT/UAT_LVL0_200912130300_mkl0p4fn_s724_p5
[Updated on: Tue, 15 December 2009 11:38] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|