Oracle Database Discussions

Hi,

Currently practicing RMAN incomplete recover in home.. i have two backup level 0 and level 2


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
52 Incr 0 528M DISK 00:00:56 31-MAY-09
BP Key: 54 Status: AVAILABLE Tag: TAG20090531T115136
Piece Name: /opt/oracle/oradata/orcl/backup/DORCL_T31_U1nkgdcu8_P1_C1_TM688305096
List of Datafiles in backup set 52
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 947472 31-MAY-09 /opt/oracle/oradata/orcl/system01.dbf
2 0 Incr 947472 31-MAY-09 /opt/oracle/oradata/orcl/undotbs01.dbf
3 0 Incr 947472 31-MAY-09 /opt/oracle/oradata/orcl/cwmlite01.dbf
4 0 Incr 947472 31-MAY-09 /opt/oracle/oradata/orcl/drsys01.dbf
5 0 Incr 947472 31-MAY-09 /opt/oracle/oradata/orcl/example01.dbf
6 0 Incr 947472 31-MAY-09 /opt/oracle/oradata/orcl/indx01.dbf
7 0 Incr 947472 31-MAY-09 /opt/oracle/oradata/orcl/odm01.dbf
8 0 Incr 947472 31-MAY-09 /opt/oracle/oradata/orcl/tools01.dbf
9 0 Incr 947472 31-MAY-09 /opt/oracle/oradata/orcl/users01.dbf
10 0 Incr 947472 31-MAY-09 /opt/oracle/oradata/orcl/xdb01.dbf
11 0 Incr 947472 31-MAY-09 /opt/oracle/oradata/orcl/UNDO.DBF
12 0 Incr 665465 26-MAY-09 /opt/oracle/oradata/orcl/UNDO4.DBF
13 0 Incr 947472 31-MAY-09 /opt/oracle/oradata/orcl/sam.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
56 Full 1M DISK 00:00:01 31-MAY-09
BP Key: 58 Status: AVAILABLE Tag:
Piece Name: /opt/oracle/oradata/orcl/backup/c-1212452606-20090531-06
SPFILE Included: Modification time: 30-MAY-09

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
57 Incr 2 560K DISK 00:00:35 31-MAY-09
BP Key: 59 Status: AVAILABLE Tag: TAG20090531T120946
Piece Name: /opt/oracle/oradata/orcl/backup/DORCL_T31_U1skgde0a_P1_C1_TM688306186
List of Datafiles in backup set 57
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 2 Incr 951120 31-MAY-09 /opt/oracle/oradata/orcl/system01.dbf
2 2 Incr 951120 31-MAY-09 /opt/oracle/oradata/orcl/undotbs01.dbf
3 2 Incr 951120 31-MAY-09 /opt/oracle/oradata/orcl/cwmlite01.dbf
4 2 Incr 951120 31-MAY-09 /opt/oracle/oradata/orcl/drsys01.dbf
5 2 Incr 951120 31-MAY-09 /opt/oracle/oradata/orcl/example01.dbf
6 2 Incr 951120 31-MAY-09 /opt/oracle/oradata/orcl/indx01.dbf
7 2 Incr 951120 31-MAY-09 /opt/oracle/oradata/orcl/odm01.dbf
8 2 Incr 951120 31-MAY-09 /opt/oracle/oradata/orcl/tools01.dbf
9 2 Incr 951120 31-MAY-09 /opt/oracle/oradata/orcl/users01.dbf
10 2 Incr 951120 31-MAY-09 /opt/oracle/oradata/orcl/xdb01.dbf
11 2 Incr 951120 31-MAY-09 /opt/oracle/oradata/orcl/UNDO.DBF
13 2 Incr 951120 31-MAY-09 /opt/oracle/oradata/orcl/sam.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
58 Full 1M DISK 00:00:00 31-MAY-09
BP Key: 60 Status: AVAILABLE Tag:
Piece Name: /opt/oracle/oradata/orcl/backup/c-1212452606-20090531-07
SPFILE Included: Modification time: 30-MAY-09




*RMAN> run{*
*2> set until time 'May 31 2009 12:30:00';*
*3> restore database;*
*4> recover database;*
*5> }*

executing command: SET until clause

Starting restore at 01-JUN-09

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=13 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/01/2009 13:26:43
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 12 found to restore





Dont ask me about datafile 12 ..it is one of the extra undo tablespace datafile ..i have datafile 12 in level 0 backup (but dont in level 2)

ORacle 9.2
redhat 5.3


Thank u
selva..