Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN restore using set until scn

user222828Jan 4 2010 — edited Jan 5 2010
Hi guys.
Quick question about using set until scn

when I do list backup output shows multiple scn's for one full (I allocated 4 tape channels for the backup so there are 4 scn's in the output)

Which one do I specify in the set until scn command? Below there is ..163 ...164 ...165 ...166

Here is the backup I want to use:


BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
12526 Incr 0 19G SBT_TAPE 00:27:22 Dec 31 2009 10:25:30
BP Key: 12526 Status: AVAILABLE Tag: TAG20091231T095808
Piece Name: rcworaprd-vprd2-full<12920:707047088:1>.dbf
List of Datafiles in backup set 12526
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
1 0 Incr 1697159163 Dec 31 2009 09:58:08 /u02/oradata/vprd2/system01.dbf
11 0 Incr 1697159163 Dec 31 2009 09:58:08 /u02/oradata/vprd2/ppa_data01.dbf
12 0 Incr 1697159163 Dec 31 2009 09:58:08 /u02/oradata/vprd2/ppa_index01.dbf
13 0 Incr 1697159163 Dec 31 2009 09:58:08 /u02/oradata/vprd2/itd_index01.dbf
16 0 Incr 1697159163 Dec 31 2009 09:58:08 /u02/oradata/vprd2/rcl_data01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
12527 Incr 0 21G SBT_TAPE 00:29:19 Dec 31 2009 10:27:27
BP Key: 12527 Status: AVAILABLE Tag: TAG20091231T095808
Piece Name: rcworaprd-vprd2-full<12921:707047088:1>.dbf
List of Datafiles in backup set 12527
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
4 0 Incr 1697159164 Dec 31 2009 09:58:08 /u02/oradata/vprd2/tools01.dbf
7 0 Incr 1697159164 Dec 31 2009 09:58:08 /u02/oradata/vprd2/xdb01.dbf
8 0 Incr 1697159164 Dec 31 2009 09:58:08 /u02/oradata/vprd2/user_index02.dbf
9 0 Incr 1697159164 Dec 31 2009 09:58:08 /u02/oradata/vprd2/una_data01.dbf
14 0 Incr 1697159164 Dec 31 2009 09:58:08

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
12528 Incr 0 29G SBT_TAPE 00:33:48 Dec 31 2009 10:31:57
BP Key: 12528 Status: AVAILABLE Tag: TAG20091231T095808
Piece Name: rcworaprd-vprd2-full<12923:707047089:1>.dbf
List of Datafiles in backup set 12528
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
6 0 Incr 1697159166 Dec 31 2009 09:58:09 /u02/oradata/vprd2/user_index01.dbf
17 0 Incr 1697159166 Dec 31 2009 09:58:09 /u02/oradata/vprd2/rcl_index01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
12529 Incr 0 23G SBT_TAPE 00:38:09 Dec 31 2009 10:36:17
BP Key: 12529 Status: AVAILABLE Tag: TAG20091231T095808
Piece Name: rcworaprd-vprd2-full<12922:707047088:1>.dbf
List of Datafiles in backup set 12529
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
2 0 Incr 1697159165 Dec 31 2009 09:58:09 /u02/oradata/vprd2/drsys01.dbf
3 0 Incr 1697159165 Dec 31 2009 09:58:09 /u02/oradata/vprd2/eng_data01.dbf
5 0 Incr 1697159165 Dec 31 2009 09:58:09 /u02/oradata/vprd2/user_data01.dbf
10 0 Incr 1697159165 Dec 31 2009 09:58:09 /u02/oradata/vprd2/una_index01.dbf
15 0 Incr 1697159165 Dec 31 2009 09:58:09 /u02/oradata/vprd2/eng_index01.dbf

Or would it be better to use the set until time... using the oldest time from the backupset 12529 (Dec 31 2009 10:36:17)

All input is appreciated.

Thanks

Jamie
This post has been answered by Pierre Forstmann on Jan 4 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 2 2010
Added on Jan 4 2010
7 comments
4,042 views