RMAN-06585: no copy of datafile 7 found 问题解决

最新推荐文章于 2024-04-24 15:20:33 发布

原创最新推荐文章于 2024-04-24 15:20:33 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#disk #database #数据库 #command #file #image

ORA 专栏收录该内容

9 篇文章

订阅专栏

本文通过实例详细解析了 RMAN 中 backup copyof 命令的使用方法及注意事项，强调了在使用此命令前必须确保已存在镜像文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

RMAN-06585: no copy of datafile 7 found 问题解决

今天在学习backup copy of 命令时出现 RMAN-06585: no copy of datafile 7 found错误，研究了好长时间，才解决，原来是自己看文档不够仔细造成的。

This form of backup is used to back up a database backup created as image copies on disk to tape

总结：在使用backup copy of 命令前必须要确保被备份的文件或者数据库在disk存在其镜像（可以使用backup as copy先制作其镜像），然后才能使用backup copy of 命令，因为该命令是对存在的镜像文件再次制作镜像文件，做之前一定要确保镜像文件的存在，切记！！

下面的试验过程：

RMAN> backup database;

Starting backup at 22-NOV-08
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00005 name=/opt/oracle/oradata/ge02/users01.dbf
input datafile fno=00001 name=/opt/oracle/oradata/ge02/system01.dbf
input datafile fno=00003 name=/opt/oracle/oradata/ge02/sysaux01.dbf
input datafile fno=00002 name=/opt/oracle/oradata/ge02/undotbs01.dbf
input datafile fno=00007 name=/opt/oracle/oradata/ge02/usertest01.dbf
input datafile fno=00006 name=/opt/oracle/oradata/ge02/indx01.dbf
input datafile fno=00004 name=/opt/oracle/oradata/ge02/tbs_01.dbf
channel ORA_DISK_1: starting piece 1 at 22-NOV-08
channel ORA_DISK_1: finished piece 1 at 22-NOV-08
piece handle=/opt/backup1/3vk0bedh_1_1 tag=TAG20081122T134417 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:12:58
Finished backup at 22-NOV-08

Starting Control File and SPFILE Autobackup at 22-NOV-08
piece handle=/opt/oracle/flash_recovery_area/GE02/autobackup/2008_11_22/o1_mf_s_671464636_4lh7t0y5_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 22-NOV-08

RMAN> backup copy of database;
Starting backup at 22-NOV-08
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/22/2008 14:02:14
RMAN-06587: one or more datafilecopies were not found
RMAN-06585: no copy of datafile 7 found
RMAN-06585: no copy of datafile 6 found
RMAN-06585: no copy of datafile 5 found
RMAN-06585: no copy of datafile 4 found
RMAN-06585: no copy of datafile 3 found
RMAN-06585: no copy of datafile 2 found
RMAN-06585: no copy of datafile 1 found

RMAN> backup tag=TAG20081119T233214 copy of database;
Starting backup at 22-NOV-08
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/22/2008 14:11:06
RMAN-06587: one or more datafilecopies were not found
RMAN-06585: no copy of datafile 7 found
RMAN-06585: no copy of datafile 6 found
RMAN-06585: no copy of datafile 5 found
RMAN-06585: no copy of datafile 4 found
RMAN-06585: no copy of datafile 3 found
RMAN-06585: no copy of datafile 2 found
RMAN-06585: no copy of datafile 1 found

RMAN> backup copy of database tag=TAG20081119T233214;
Starting backup at 22-NOV-08
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/22/2008 14:12:03
RMAN-06587: one or more datafilecopies were not found
RMAN-06585: no copy of datafile 7 found
RMAN-06585: no copy of datafile 6 found
RMAN-06585: no copy of datafile 5 found
RMAN-06585: no copy of datafile 4 found
RMAN-06585: no copy of datafile 3 found
RMAN-06585: no copy of datafile 2 found
RMAN-06585: no copy of datafile 1 found

RMAN> backup copy of datafile 4;
Starting backup at 22-NOV-08
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/22/2008 14:13:39
RMAN-06587: one or more datafilecopies were not found
RMAN-06585: no copy of datafile 4 found

如上面报的错误理解，backup copy of database 命令是对数据库的镜像文件再制作镜像文件，
上面检查了检查了确实没有数据库的镜像文件，下面使用backup as copy database命令来制作数据库的镜像文件，过程如下：
RMAN> backup as copy database;
Starting backup at 22-NOV-08
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00005 name=/opt/oracle/oradata/ge02/users01.dbf
output filename=/opt/backup1/data_D-GE02_I-1566649158_TS-USERS_FNO-5_41k0bgf2 tag=TAG20081122T141914 recid=59 stamp=671466220
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:35
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/opt/oracle/oradata/ge02/system01.dbf
output filename=/opt/backup1/data_D-GE02_I-1566649158_TS-SYSTEM_FNO-1_42k0bgnm tag=TAG20081122T141914 recid=60 stamp=671466382
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:35
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/opt/oracle/oradata/ge02/sysaux01.dbf
output filename=/opt/backup1/data_D-GE02_I-1566649158_TS-SYSAUX_FNO-3_43k0bgsh tag=TAG20081122T141914 recid=61 stamp=671466538
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:35
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/opt/oracle/oradata/ge02/undotbs01.dbf
output filename=/opt/backup1/data_D-GE02_I-1566649158_TS-UNDOTBS_FNO-2_44k0bh1c tag=TAG20081122T141914 recid=62 stamp=671466634
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:35
channel ORA_DISK_1: starting datafile copy
input datafile fno=00007 name=/opt/oracle/oradata/ge02/usertest01.dbf
output filename=/opt/backup1/data_D-GE02_I-1566649158_TS-USERTEST_FNO-7_45k0bh4c tag=TAG20081122T141914 recid=63 stamp=671466655
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile fno=00006 name=/opt/oracle/oradata/ge02/indx01.dbf
output filename=/opt/backup1/data_D-GE02_I-1566649158_TS-INDX_FNO-6_46k0bh55 tag=TAG20081122T141914 recid=64 stamp=671466672
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=/opt/oracle/oradata/ge02/tbs_01.dbf
output filename=/opt/backup1/data_D-GE02_I-1566649158_TS-TBS_1_FNO-4_47k0bh5k tag=TAG20081122T141914 recid=65 stamp=671466677
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 22-NOV-08
Starting Control File and SPFILE Autobackup at 22-NOV-08
piece handle=/opt/oracle/flash_recovery_area/GE02/autobackup/2008_11_22/o1_mf_s_671466678_4lh9st9g_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 22-NOV-08

--显示出刚刚制作出的数据库镜像文件
RMAN> list copy;
List of Datafile Copies
Key     File S Completion Time Ckp SCN    Ckp Time        Name
------- ---- - --------------- ---------- --------------- ----
60      1    A 22-NOV-08       1614928    22-NOV-08       /opt/backup1/data_D-GE02_I-1566649158_TS-SYSTEM_FNO-1_42k0bgnm
62      2    A 22-NOV-08       1615047    22-NOV-08       /opt/backup1/data_D-GE02_I-1566649158_TS-UNDOTBS_FNO-2_44k0bh1c
61      3    A 22-NOV-08       1614994    22-NOV-08       /opt/backup1/data_D-GE02_I-1566649158_TS-SYSAUX_FNO-3_43k0bgsh
65      4    A 22-NOV-08       1615096    22-NOV-08       /opt/backup1/data_D-GE02_I-1566649158_TS-TBS_1_FNO-4_47k0bh5k
59      5    A 22-NOV-08       1614838    22-NOV-08       /opt/backup1/data_D-GE02_I-1566649158_TS-USERS_FNO-5_41k0bgf2
64      6    A 22-NOV-08       1615090    22-NOV-08       /opt/backup1/data_D-GE02_I-1566649158_TS-INDX_FNO-6_46k0bh55
63      7    A 22-NOV-08       1567508    19-NOV-08       /opt/backup1/data_D-GE02_I-1566649158_TS-USERTEST_FNO-7_45k0bh4c
List of Archived Log Copies
Key     Thrd Seq     S Low Time Name
------- ---- ------- - --------- ----
115     1    64      A 19-NOV-08 /opt/oracle/flash_recovery_area/GE02/archivelog/2008_11_20/o1_mf_1_64_4lbvydsm_.arc
116     1    65      A 20-NOV-08 /opt/oracle/flash_recovery_area/GE02/archivelog/2008_11_22/o1_mf_1_65_4lh5vs5q_.arc

下面是制作数据库镜像文件的镜像，如下：
RMAN> backup copy of database;
Starting backup at 22-NOV-08
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: including datafile copy of datafile 00005 in backupset
input filename=/opt/backup1/data_D-GE02_I-1566649158_TS-USERS_FNO-5_41k0bgf2
channel ORA_DISK_1: including datafile copy of datafile 00001 in backupset
input filename=/opt/backup1/data_D-GE02_I-1566649158_TS-SYSTEM_FNO-1_42k0bgnm
channel ORA_DISK_1: including datafile copy of datafile 00003 in backupset
input filename=/opt/backup1/data_D-GE02_I-1566649158_TS-SYSAUX_FNO-3_43k0bgsh
channel ORA_DISK_1: including datafile copy of datafile 00002 in backupset
input filename=/opt/backup1/data_D-GE02_I-1566649158_TS-UNDOTBS_FNO-2_44k0bh1c
channel ORA_DISK_1: including datafile copy of datafile 00007 in backupset
input filename=/opt/backup1/data_D-GE02_I-1566649158_TS-USERTEST_FNO-7_45k0bh4c
channel ORA_DISK_1: including datafile copy of datafile 00006 in backupset
input filename=/opt/backup1/data_D-GE02_I-1566649158_TS-INDX_FNO-6_46k0bh55
channel ORA_DISK_1: including datafile copy of datafile 00004 in backupset
input filename=/opt/backup1/data_D-GE02_I-1566649158_TS-TBS_1_FNO-4_47k0bh5k
channel ORA_DISK_1: starting piece 1 at 22-NOV-08
channel ORA_DISK_1: finished piece 1 at 22-NOV-08
piece handle=/opt/backup1/49k0bhhr_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:07:57
Finished backup at 22-NOV-08

Starting Control File and SPFILE Autobackup at 22-NOV-08
piece handle=/opt/oracle/flash_recovery_area/GE02/autobackup/2008_11_22/o1_mf_s_671467544_4lhbnvcb_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 22-NOV-08

这次 backup copy of database制作数据库镜像文件的镜像成功了~~