RMAN中能list backup到文件 但是restore datafile的时候找不到文件求解释

[Easy丶洋]

RMAN中能list backup到文件 但是restore datafile的时候找不到文件使用ID和绝对路径都找不到文件

求解释。具体操作如下；

RMAN> list backup;


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


BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22 Incr 0 1.03G DISK 00:18:17 22-MAY-13
BP Key: 22 Status: AVAILABLE Compressed: NO Tag: INC_BK_LVL0_%T
Piece Name: /home/oracle/oracleBak/dbkup_ORCL_20130522_1soaa083_1_1_L0
List of Datafiles in backup set 22
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 949332 22-MAY-13 /home/oracle/app/oracle/oradata/orcl/system01.dbf
2 0 Incr 949332 22-MAY-13 /home/oracle/app/oracle/oradata/orcl/sysaux01.dbf
3 0 Incr 949332 22-MAY-13 /home/oracle/app/oracle/oradata/orcl/undotbs01.dbf
4 0 Incr 949332 22-MAY-13 /home/oracle/app/oracle/oradata/orcl/users01.dbf
5 0 Incr 949332 22-MAY-13 /home/oracle/app/oracle/oradata/orcl/example01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
23 Incr 1 30.43M DISK 00:04:18 22-MAY-13
BP Key: 23 Status: AVAILABLE Compressed: NO Tag: INC_BK_LVL0_%T
Piece Name: /home/oracle/oracleBak/dbkup1_ORCL_20130522_1voaadpq_1_1_L0
List of Datafiles in backup set 23
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 1 Incr 954995 22-MAY-13 /home/oracle/app/oracle/oradata/orcl/system01.dbf
2 1 Incr 954995 22-MAY-13 /home/oracle/app/oracle/oradata/orcl/sysaux01.dbf
3 1 Incr 954995 22-MAY-13 /home/oracle/app/oracle/oradata/orcl/undotbs01.dbf
4 1 Incr 954995 22-MAY-13 /home/oracle/app/oracle/oradata/orcl/users01.dbf
5 1 Incr 954995 22-MAY-13 /home/oracle/app/oracle/oradata/orcl/example01.dbf

RMAN> restore datafile 23;

Starting restore at 23-MAY-13
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/23/2013 19:21:58
RMAN-20201: datafile not found in the recovery catalog
RMAN-06010: error while looking up datafile: 23

RMAN> restore datafile '/home/oracle/oracleBak/dbkup1_ORCL_20130522_1voaadpq_1_1_L0'
2> ;

Starting restore at 23-MAY-13
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/23/2013 19:22:13
RMAN-20201: datafile not found in the recovery catalog
RMAN-06010: error while looking up datafile: /home/oracle/oracleBak/dbkup1_ORCL_20130522_1voaadpq_1_1_L0

RMAN>

[Easy丶洋]

引用 2 楼 vanjayhsu 的回复:

select * from v$datafile where file#=23--看看你的数据文件是哪个吧，你RMAN里面只有12345。

select 后数据是空的 那个1 2 3 4 5 是23包含的文件 不是bs key 不知道是我理解有问题还是粘贴的太乱误导了大家

[sych888]

命令使用错了，23是备份集号，不是数据文件号

[惜分飞]

你文件号只有12345

[vanjayhsu]

select * from v$datafile where file#=23--看看你的数据文件是哪个吧，你RMAN里面只有12345。