Re: RMAM duplicate database - until when?

  • From: "Rajeev Prabhakar" <rprabha01@xxxxxxxxx>
  • To: duncan.lawie@xxxxxxxxxxxxxxxxx
  • Date: Thu, 21 Dec 2006 13:24:51 -0500

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@xxxxxxxxxxxxxxxxx> 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

==============================================================================

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



Other related posts: