Re: RMAM duplicate database - until when?

On your source db, get the scn info :

select max(next_change#)-1 from v$archived_log;

-Rajeev

On 12/21/06, Lawie, Duncan <duncan.lawie_at_credit-suisse.com> wrote:
>
> 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
>
> ==============================================================================
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l