Duplicate did not restore some archivelog
gamietJul 29 2008 — edited Jul 30 2008Hello,
I am question about the rman Duplicate command.
I have the following senario :
Every night full backup of my database : "backup database plus archivelog "
During the day, every hours, backup archivelog : "backup archivelog all"
Both backups are copied on the test server in the same location.
Now I would like to duplicate the PROD database to TEST database.
The duplicate fail on the restore because he restore only the full backup but note archivelog.
I have check if the backup was on the disk before the duplicate with a "cross check" and every thing seams ok, log below (cross check and duplicate).
I do not anderstand why dupliate ask for some archivelog "RMAN-06025: no backup of log thread 1 seq 9126 lowscn 6452873242 found to restore" that he can find in the backup "archive log filename=+DG\_TSAPHPRD\_RECOVERY/tsaphprd\_site1/archivelog/2008\_07\_29/thread\_1\_seq\_9137.2327.661343727 recid=9126 stamp=661343727
validation succeeded for archived log"
Any Advices ?
```
29/07/2008-10:44:50.32 Start rman_duplicate ------------------------------------------
ORACLE_SID=TSAPHTE1
FILENAME=rman_duplicate
DB_USERNAME=SYS
TNS_ALIAS=TSAPHPRD
CONFIGFILE=C:\oracle\product\10.2.0\admin\Scripts\rman_config.rcm
CMDFILE=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2rman_duplicate_TSAPHTE1.rcm
LOGFILE=C:\oracle\product\10.2.0\admin\log\TSAPHTE1\TSAPHTE1_Rman_duplicate.log
LOGFILE_RMAN=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2rman_duplicate_TSAPHTE1.log
rman target SYS/DB_PASSWORD@TSAPHPRD cmdfile= C:\oracle\product\10.2.0\admin\Scripts\rman_config.rcm msglog C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2rman_duplicate_TSAPHTE1.log
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Jul 29 10:44:50 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: TSAPHPRD (DBID=2286317535)
RMAN> configure controlfile autobackup off;
2> configure backup optimization on;
3> exit;
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored
Recovery Manager complete.
ORA-01507: database not mounted
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 4294967296 bytes
Fixed Size 2169520 bytes
Variable Size 815588688 bytes
Database Buffers 3472883712 bytes
Redo Buffers 4325376 bytes
rman target SYS/DB_PASSWORD@TSAPHPRD auxiliary / cmdfile=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2rman_duplicate_TSAPHTE1.rcm msglog C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2rman_duplicate_TSAPHTE1.log
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Jul 29 10:45:03 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: TSAPHPRD (DBID=2286317535)
RMAN> connect catalog *
2> connect auxiliary *
3> crosscheck backup of database;
4> crosscheck backup of controlfile;
5> crosscheck archivelog all;
6> run {
7> allocate channel C1 device type disk;
8> allocate auxiliary channel C2 device type disk;
9> duplicate target database to TSAPHTE1 until time 'sysdate' ;
10> }
11> exit;
connected to recovery catalog database
connected to auxiliary database: TSAPHTE1 (not mounted)
starting full resync of recovery catalog
full resync complete
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=57 devtype=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\870_R6JLPFOG_1_1 recid=869 stamp=660389649
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\871_R7JLPFUK_1_1 recid=870 stamp=660389844
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\932_T4JM1GJ6_1_1 recid=931 stamp=660652646
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\933_T5JM1GP9_1_1 recid=932 stamp=660652841
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\969_U9JM5JG0_1_1 recid=968 stamp=660786688
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\970_UAJM5JM3_1_1 recid=969 stamp=660786883
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\990_UUJM6V39_1_1 recid=989 stamp=660831337
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\991_UVJM6VBS_1_1 recid=990 stamp=660831612
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\1005_VDJM87SD_1_1 recid=1004 stamp=660873101
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\1006_VEJM882G_1_1 recid=1005 stamp=660873296
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\FULL2008_07_24\TSAPHPRD_2286317535_20080724_1022_1_UKVUJM9O62_1_1 recid=1021 stamp=660922562
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\FULL2008_07_24\TSAPHPRD_2286317535_20080724_1023_1_UKVVJM9OCF_1_1 recid=1022 stamp=660922767
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\FULL2008_07_24\TSAPHPRD_2286317535_20080724_1039_1_UK0FJMAS7O_1_1 recid=1038 stamp=660959480
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\FULL2008_07_24\TSAPHPRD_2286317535_20080724_1040_1_UK0GJMASDR_1_1 recid=1039 stamp=660959675
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_25_FULL\TSAPHPRD_2286317535_20080725_1055_1_UK0VJMC5N8_1_1 recid=1054 stamp=661001960
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_25_FULL\TSAPHPRD_2286317535_20080725_1056_1_UK10JMC5TB_1_1 recid=1055 stamp=661002155
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_25_FULL\TSAPHPRD_2286317535_20080725_1071_1_UK1FJMDGIB_1_1 recid=1070 stamp=661045836
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_25_FULL\TSAPHPRD_2286317535_20080725_1072_1_UK1GJMDGOF_1_1 recid=1071 stamp=661046031
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_26_FULL\TSAPHPRD_2286317535_20080726_1097_1_UK29JMG4U0_1_1 recid=1096 stamp=661132224
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_26_FULL\TSAPHPRD_2286317535_20080726_1098_1_UK2AJMG543_1_1 recid=1097 stamp=661132420
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_27_FULL\TSAPHPRD_2286317535_20080727_1123_1_UK33JMIPA0_1_1 recid=1122 stamp=661218624
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_27_FULL\TSAPHPRD_2286317535_20080727_1124_1_UK34JMIPG3_1_1 recid=1123 stamp=661218819
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1140_1_UK3KJMJSBU_1_1 recid=1139 stamp=661254528
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1141_1_UK3LJMJSO0_1_1 recid=1140 stamp=661254912
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1147_1_UK3RJMJU83_1_1 recid=1146 stamp=661256451
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1148_1_UK3SJMJUHU_1_1 recid=1147 stamp=661256766
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1153_1_UK41JMJV87_1_1 recid=1152 stamp=661257479
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1154_1_UK42JMJVJ0_1_1 recid=1153 stamp=661257824
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1177_1_UK4PJMLDRO_1_1 recid=1176 stamp=661305209
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1178_1_UK4QJMLE26_1_1 recid=1177 stamp=661305414
Crosschecked 30 objects
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\FULL2008_07_24\TSAPHPRD_2286317535_20080724_1024_1_UK00JM9OF4_1_1 recid=1023 stamp=660922854
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\FULL2008_07_24\TSAPHPRD_2286317535_20080724_1041_1_UK0HJMASGG_1_1 recid=1040 stamp=660959762
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_25_FULL\TSAPHPRD_2286317535_20080725_1057_1_UK11JMC60K_1_1 recid=1056 stamp=661002261
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_25_FULL\TSAPHPRD_2286317535_20080725_1073_1_UK1HJMDGRO_1_1 recid=1072 stamp=661046137
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_26_FULL\TSAPHPRD_2286317535_20080726_1099_1_UK2BJMG57D_1_1 recid=1098 stamp=661132526
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_27_FULL\TSAPHPRD_2286317535_20080727_1125_1_UK35JMIPJC_1_1 recid=1124 stamp=661218926
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1142_1_UK3MJMJSR9_1_1 recid=1141 stamp=661255018
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1149_1_UK3TJMJUKJ_1_1 recid=1148 stamp=661256852
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1155_1_UK43JMJVLV_1_1 recid=1154 stamp=661257921
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1179_1_UK4RJMLE55_1_1 recid=1178 stamp=661305510
Crosschecked 10 objects
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=57 devtype=DISK
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_28/thread_1_seq_8409.3189.661220123 recid=8398 stamp=661220122
validation succeeded for archived log
archive log
filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9113.2303.661340117 recid=9102 stamp=661340119
validation succeeded for archived log
archive log
.... filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9114.2304.661340129 recid=9103 stamp=661340130
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9115.2305.661340141 recid=9104 stamp=661340144
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9116.2306.661340157 recid=9105 stamp=661340160
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9117.2307.661340169 recid=9106 stamp=661340170
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9118.2308.661340313 recid=9107 stamp=661340313
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9119.2309.661341023 recid=9108 stamp=661341023
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9120.2310.661341035 recid=9109 stamp=661341036
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9121.2311.661341055 recid=9110 stamp=661341057
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9122.2312.661341063 recid=9111 stamp=661341064
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9123.2313.661341143 recid=9112 stamp=661341144
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9124.2314.661341651 recid=9113 stamp=661341651
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9125.2315.661341669 recid=9114 stamp=661341669
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9126.2316.661341933 recid=9115 stamp=661341933
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9127.2317.661341945 recid=9116 stamp=661341950
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9128.2318.661341965 recid=9117 stamp=661341969
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9129.2319.661341975 recid=9118 stamp=661341977
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9130.2320.661342115 recid=9119 stamp=661342117
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9131.2321.661342823 recid=9120 stamp=661342823
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9132.2322.661342835 recid=9121 stamp=661342837
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9133.2323.661342849 recid=9122 stamp=661342850
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9134.2324.661342863 recid=9123 stamp=661342867
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9135.2325.661342879 recid=9124 stamp=661342880
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9136.2326.661343717 recid=9125 stamp=661343718
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9137.2327.661343727 recid=9126 stamp=661343727
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9138.2328.661343739 recid=9127 stamp=661343741
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9139.2329.661343757 recid=9128 stamp=661343757
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9140.2330.661343767 recid=9129 stamp=661343770
validation succeeded for archived log
archive log filename=+DG_TSAPHPRD_RECOVERY/tsaphprd_site1/archivelog/2008_07_29/thread_1_seq_9141.2331.661343905 recid=9130 stamp=661343905
Crosschecked 748 objects
released channel: ORA_DISK_1
allocated channel: C1
channel C1: sid=57 devtype=DISK
allocated channel: C2
channel C2: sid=70 devtype=DISK
Starting Duplicate Db at 29-JUL-08
WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to diskgroup only.
contents of Memory Script:
{
set until scn 6453013095;
set newname for datafile 1 to
"+dg_tsaphte1_sys";
set newname for datafile 2 to
"+dg_tsaphte1_recovery";
set newname for datafile 3 to
"+dg_tsaphte1_sys";
set newname for datafile 4 to
"+dg_tsaphte1_sys";
set newname for datafile 5 to
"+dg_tsaphte1_data";
set newname for datafile 6 to
"+dg_tsaphte1_data";
set newname for datafile 7 to
"+dg_tsaphte1_data";
set newname for datafile 8 to
"+dg_tsaphte1_data";
set newname for datafile 9 to
"+dg_tsaphte1_data";
set newname for datafile 10 to
"+dg_tsaphte1_data";
set newname for datafile 11 to
"+dg_tsaphte1_data";
set newname for datafile 12 to
"+dg_tsaphte1_data";
set newname for datafile 13 to
"+dg_tsaphte1_data";
set newname for datafile 14 to
"+dg_tsaphte1_data";
set newname for datafile 15 to
"+dg_tsaphte1_data";
set newname for datafile 16 to
"+dg_tsaphte1_data";
set newname for datafile 17 to
"+dg_tsaphte1_data_report";
set newname for datafile 18 to
"+dg_tsaphte1_data_report";
restore
check readonly
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 29-JUL-08
channel C2: starting datafile backupset restore
channel C2: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +DG_TSAPHTE1_SYS
restoring datafile 00002 to +DG_TSAPHTE1_RECOVERY
restoring datafile 00003 to +DG_TSAPHTE1_SYS
restoring datafile 00004 to +DG_TSAPHTE1_SYS
restoring datafile 00005 to +DG_TSAPHTE1_DATA
restoring datafile 00006 to +DG_TSAPHTE1_DATA
restoring datafile 00007 to +DG_TSAPHTE1_DATA
restoring datafile 00008 to +DG_TSAPHTE1_DATA
restoring datafile 00009 to +DG_TSAPHTE1_DATA
restoring datafile 00010 to +DG_TSAPHTE1_DATA
restoring datafile 00011 to +DG_TSAPHTE1_DATA
restoring datafile 00012 to +DG_TSAPHTE1_DATA
restoring datafile 00013 to +DG_TSAPHTE1_DATA
restoring datafile 00014 to +DG_TSAPHTE1_DATA
restoring datafile 00015 to +DG_TSAPHTE1_DATA
restoring datafile 00016 to +DG_TSAPHTE1_DATA
channel C2: reading from backup piece E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1177_1_UK4PJMLDRO_1_1
channel C2: restored backup piece 1
piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1177_1_UK4PJMLDRO_1_1 tag=TAG20080728T235328
channel C2: restore complete, elapsed time: 00:04:05
channel C2: starting datafile backupset restore
channel C2: specifying datafile(s) to restore from backup set
restoring datafile 00017 to +DG_TSAPHTE1_DATA_REPORT
restoring datafile 00018 to +DG_TSAPHTE1_DATA_REPORT
channel C2: reading from backup piece E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1178_1_UK4QJMLE26_1_1
channel C2: restored backup piece 1
piece handle=E:\ORACLEBACKUP\TSAPHPRD\2008_07_28_FULL\TSAPHPRD_2286317535_20080728_1178_1_UK4QJMLE26_1_1 tag=TAG20080728T235328
channel C2: restore complete, elapsed time: 00:01:15
Finished restore at 29-JUL-08
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TSAPHTE1" RESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 2920
LOGFILE
GROUP 1 ( '+DG_TSAPHTE1_SYS/tsaphte1/redo01_01.log', '+DG_TSAPHTE1_RECOVERY/tsaphte1/redo01_02.log' ) SIZE 100 M REUSE,
GROUP 2 ( '+DG_TSAPHTE1_SYS/tsaphte1/redo02_01.log', '+DG_TSAPHTE1_RECOVERY/tsaphte1/redo02_02.log' ) SIZE 100 M REUSE,
GROUP 3 ( '+DG_TSAPHTE1_SYS/tsaphte1/redo03_01.log', '+DG_TSAPHTE1_RECOVERY/tsaphte1/redo03_02.log' ) SIZE 100 M REUSE
DATAFILE
'+DG_TSAPHTE1_SYS/tsaphte1/datafile/system.271.661344449'
CHARACTER SET AL32UTF8
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=661344669 filename=+DG_TSAPHTE1_RECOVERY/tsaphte1/datafile/undotbs1.267.661344353
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=661344669 filename=+DG_TSAPHTE1_SYS/tsaphte1/datafile/sysaux.272.661344515
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=661344669 filename=+DG_TSAPHTE1_SYS/tsaphte1/datafile/users.273.661344541
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=661344669 filename=+DG_TSAPHTE1_DATA/tsaphte1/datafile/phoenix_data_small.299.661344497
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=661344669 filename=+DG_TSAPHTE1_DATA/tsaphte1/datafile/phoenix_data_medium.292.661344353
datafile 7 switched to datafile copy
input datafile copy recid=6 stamp=661344669 filename=+DG_TSAPHTE1_DATA/tsaphte1/datafile/phoenix_data_pos.300.661344509
datafile 8 switched to datafile copy
input datafile copy recid=7 stamp=661344669 filename=+DG_TSAPHTE1_DATA/tsaphte1/datafile/phoenix_data_pos_res.293.661344353
datafile 9 switched to datafile copy
input datafile copy recid=8 stamp=661344669 filename=+DG_TSAPHTE1_DATA/tsaphte1/datafile/phoenix_data_trans.301.661344529
datafile 10 switched to datafile copy
input datafile copy recid=9 stamp=661344669 filename=+DG_TSAPHTE1_DATA/tsaphte1/datafile/phoenix_index_small.296.661344355
datafile 11 switched to datafile copy
input datafile copy recid=10 stamp=661344669 filename=+DG_TSAPHTE1_DATA/tsaphte1/datafile/phoenix_index_medium.295.661344353
datafile 12 switched to datafile copy
input datafile copy recid=11 stamp=661344669 filename=+DG_TSAPHTE1_DATA/tsaphte1/datafile/phoenix_index_pos.294.661344353
datafile 13 switched to datafile copy
input datafile copy recid=12 stamp=661344669 filename=+DG_TSAPHTE1_DATA/tsaphte1/datafile/phoenix_index_pos_res.297.661344355
datafile 14 switched to datafile copy
input datafile copy recid=13 stamp=661344669 filename=+DG_TSAPHTE1_DATA/tsaphte1/datafile/phoenix_index_trans.302.661344537
datafile 15 switched to datafile copy
input datafile copy recid=14 stamp=661344669 filename=+DG_TSAPHTE1_DATA/tsaphte1/datafile/phoenix_lob.298.661344355
datafile 16 switched to datafile copy
input datafile copy recid=15 stamp=661344669 filename=+DG_TSAPHTE1_DATA/tsaphte1/datafile/phoenix_mvlog.303.661344541
datafile 17 switched to datafile copy
input datafile copy recid=16 stamp=661344669 filename=+DG_TSAPHTE1_DATA_REPORT/tsaphte1/datafile/phoenix_rpt_data.262.661344591
datafile 18 switched to datafile copy
input datafile copy recid=17 stamp=661344669 filename=+DG_TSAPHTE1_DATA_REPORT/tsaphte1/datafile/phoenix_rpt_index.263.661344591
contents of Memory Script:
{
set until time "sysdate";
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 29-JUL-08
starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 17 was not restored from a sufficiently old backup
ORA-01110: data file 17: '+DG_TSAPHTE1_DATA_REPORT/tsaphte1/datafile/phoenix_rpt_data.262.661344591'
released channel: C1
released channel: C2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/29/2008 10:51:12
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 9141 lowscn 6453013095 found to restore
RMAN-06025: no backup of log thread 1 seq 9140 lowscn 6453003055 found to restore
RMAN-06025: no backup of log thread 1 seq 9139 lowscn 6452994700 found to restore
RMAN-06025: no backup of log thread 1 seq 9138 lowscn 6452984686 found to restore
RMAN-06025: no backup of log thread 1 seq 9137 lowscn 6452976007 found to restore
RMAN-06025: no backup of log thread 1 seq 9136 lowscn 6452966254 found to restore
RMAN-06025: no backup of log thread 1 seq 9135 lowscn 6452957300 found to restore
RMAN-06025: no backup of log thread 1 seq 9134 lowscn 6452947959 found to restore
RMAN-06025: no backup of log thread 1 seq 9133 lowscn 6452938830 found to restore
RMAN-06025: no backup of log thread 1 seq 9132 lowscn 6452929445 found to restore
RMAN-06025: no backup of log thread 1 seq 9131 lowscn 6452920241 found to restore
RMAN-06025: no backup of log thread 1 seq 9130 lowscn 6452910932 found to restore
RMAN-06025: no backup of log thread 1 seq 9129 lowscn 6452900719 found to restore
RMAN-06025: no backup of log thread 1 seq 9128 lowscn 6452892220 found to restore
RMAN-06025: no backup of log thread 1 seq 9127 lowscn 6452882592 found to restore
RMAN-06025: no backup of log thread 1 seq 9126 lowscn 6452873242 found to restore
Recovery Manager complete.
29/07/2008-10:51:14.69 End rman_duplicate ----------------------------------------------
29/07/2008-10:51:14.69 End Rman_duplicate TSAPHTE1
[pre]
```