List, I'm suffering at the hands of the rman cloning code. I'm doing a "backup database incremental level zero plus archivelog" I've shown an output from the "list backup" at the bottom of the email. What I want to do is run { set until scn XXX duplicate target database to TESTDBE30; } Where XXX is the last SCN in the backup. How do I find this? rc_backup_archivelog_details will tell me the next_change# of the archivelog - but that isn't the last SCN in the current file is it? BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 4280 Incr 0 108.34M DISK 00:00:51 20 Dec 11:37:23 BP Key: 4286 Status: AVAILABLE Compressed: YES Tag: TAG20061220T113632 Piece Name: /app/oracle/TESTRAC80/admin/rman/whole_db_online_backup_TESTRAC80_70_26i5duq0_1_1_20061220 List of Datafiles in backup set 4280 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------------- ---- 1 0 Incr 45670185 20 Dec 11:36:33 /data/oracle/TESTRAC80/u01/system01.dbf . . . 8 0 Incr 45670188 20 Dec 11:36:34 /data/oracle/TESTRAC80/u01/soeindex.dbf BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 4306 27.50K DISK 00:00:02 20 Dec 11:37:53 BP Key: 4313 Status: AVAILABLE Compressed: YES Tag: TAG20061220T113742 Piece Name: /app/oracle/TESTRAC80/admin/rman/whole_db_online_backup_TESTRAC80_72_28i5dusf_1_1_20061220 List of Archived Logs in backup set 4306 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------------- ---------- --------- 1 3004 45670151 20 Dec 11:36:03 45670267 20 Dec 11:37:29 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 4307 2.00K DISK 00:00:02 20 Dec 11:37:53 BP Key: 4314 Status: AVAILABLE Compressed: YES Tag: TAG20061220T113742 Piece Name: /app/oracle/TESTRAC80/admin/rman/whole_db_online_backup_TESTRAC80_73_29i5dusf_1_1_20061220 List of Archived Logs in backup set 4307 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------------- ---------- --------- 2 2952 45670149 20 Dec 11:34:03 45670270 20 Dec 11:35:31 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 4323 Full 15.98M DISK 00:00:02 20 Dec 11:38:00 BP Key: 4325 Status: AVAILABLE Compressed: NO Tag: TAG20061220T113758 Piece Name: /app/oracle/TESTRAC80/admin/rman/whole_db_online_backup_TESTRAC80_c-2618574194-20061220-02 Control File Included: Ckp SCN: 45670323 Ckp time: 20 Dec 11:37:58 SPFILE Included: Modification time: 14 Dec 19:11:16 Duncan Lawie DBE - Oracle 020 788 3 9229 "Problems cannot be solved at the same level of awareness that created them." -- Albert Einstein ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ============================================================================== -- //www.freelists.org/webpage/oracle-l