RMAN-06585: no copy of datafile 7 found 问题解决
来源:互联网 发布:面向对象的特征php 编辑:程序博客网 时间:2024/05/16 09:28
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制作数据库镜像文件的镜像成功了~~
总结:在使用backup copy of 命令前必须要确保被备份的文件或者数据库在disk存在其镜像(可以使用backup as copy先制作其镜像), 然后才能使用backup copy of 命令 ,因为该命令是对存在的镜像文件再次制作镜像文件,做之前一定要确保镜像文件的存在,切记!!
- RMAN-06585: no copy of datafile 7 found 问题解决
- RMAN-06023 : no backup or copy of datafile found to restore 说明
- RMAN-06023 : no backup or copy of datafile found to restore 说明
- RMAN-06023: no backup or copy of datafile 6 found to restore
- RMAN-06023: no backup or copy of datafile 1 found to restore
- RMAN-06023 no backup or copy of datafile 1 found to restore
- RMAN-06100: no channel to restore a backup or copy of datafile 681
- RMAN-06214: Datafile Copy
- RMAN-06214: Datafile Copy
- RMAN-06214: Datafile Copy .
- RMAN-06024: no backup or copy of the control file found to restore
- Oracle 使用RMAN COPY 移动 Datafile 位置
- RMAN-06183: datafile or datafile copy larger than maxsetsize
- RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
- RMAN-06183: datafile or datafile copy +DATA_ERP/ap_media35 (file number 27) larger than MAXSETSIZE
- RMAN RECOVER COPY OF使用方法
- RMAN-06172: no autobackup found
- RMAN-06025: no backup of log thread 1 seq 17 lowscn 1101318 found to restore
- EAI概念
- 惠普前总裁孙振耀指点职业规划
- Fedora 8安装过程详解【转载】
- 必须掌握的八个【cmd 命令行】
- Howto Sharepoint Enable Session State if not enabled
- RMAN-06585: no copy of datafile 7 found 问题解决
- 一个用C语言编写的小病毒
- Java实现随机验证码功能实例
- 关于Java的Cookie操作
- jspSmartUpload上传下载全攻略
- 三十岁了
- java读取配置文件的几种方法
- 孩子快抓紧妈妈的手
- JAVA编程技巧之如何实现HTTP的断点续传