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!

unable to restore datafile from backup

user489046Mar 20 2006 — edited Feb 18 2010
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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 18 2010
Added on Mar 20 2006
9 comments
26,196 views