unable to restore datafile from backup
hi,
I have taken complete database backup using RMAN. When i try to restore datafile 2 which is already there in the backup, RMAN says it cannot find that datafile.
I have snapshot of whole thing below.
************************************************************************************************
-bash-2.05b$ rman target /
Recovery Manager: Release 9.2.0.4.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: VEN (DBID=2559410986)
RMAN> restore datafile 2;
Starting restore at 20-MAR-06
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=10 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/20/2006 17:21:01
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 704K DISK 00:00:00 20-MAR-06
BP Key: 6 Status: AVAILABLE Tag: TAG20060320T162917
Piece Name: /u01/orahome/dbs/06heerat_1_1
List of Datafiles in backup set 6
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 67610 20-MAR-06 /u01/ven/data/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 76K DISK 00:00:01 20-MAR-06
BP Key: 7 Status: AVAILABLE Tag: TAG20060320T163521
Piece Name: /u01/orahome/dbs/07heerm9_1_1
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 67807 20-MAR-06 /u01/ven/data/o1_mf_users_21x31qdk_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 156M DISK 00:00:45 20-MAR-06
BP Key: 8 Status: AVAILABLE Tag: TAG20060320T163805
Piece Name: /u01/orahome/dbs/08heerrd_1_1
SPFILE Included: Modification time: 14-MAR-06
List of Datafiles in backup set 8
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 67895 20-MAR-06 /u01/ven/data/system01.dbf
2 Full 67895 20-MAR-06 /u01/ven/data/o1_mf_sys_undo_21f30cyo_.dbf
3 Full 67895 20-MAR-06 /u01/ven/data/users01.dbf
4 Full 67895 20-MAR-06 /u01/ven/data/o1_mf_users_21x31qdk_.dbf
RMAN>
**********************************************************************************************************
I have checked physical backup file It is there.
-bash-2.05b$ ls -ltr /u01/ven/data/o1_mf_users_21x31qdk_.dbf
-rw-r----- 1 oracle dba 104859648 Mar 20 16:53 /u01/ven/data/o1_mf_users_21x31qdk_.dbf
And the database is in MOUNT state.
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- ----------
VEN MOUNTED
Every thing seems fine.but i am unable to restore datafile 3.
Even if i try to restore other files, RMAN is saying that it is unable to find....
Why this is happening...?
Please do give you opinions.
Thanks.