RMAN restore using set until scn
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