RMAN10g: backup copy of database (Doc ID 266980.1)

***Checked for relevance on 22-Feb-2013*** *** This article is being delivered in Draft form and may contain errors. Please use the MetaLink "Feedback" button to advise Oracle of any issues related to this article. *** PURPOSE ------- To resolve RMAN-06587 when making an image copy of the entire database. SCOPE & APPLICATION ------------------- All RMAN users, intermediate to advanced RMAN 10g: backup copy of database -------------------------------- In previous Oracle database releases, you could backup the entire database into backup sets. With Oracle Database 10g, you can backup the entire database to image copies. However, you may encounter the RMAN-06587 when there is no available backup copies of the datafiles, as shown in the example below. RMAN> list copy; specification does not match any archive log in the recovery catalog RMAN> backup copy of database; Starting backup at 31-MAR-2004 03:53:54 using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 03/31/2004 03:53:54 RMAN-06587: one or more datafilecopies were not 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 as copy database; Starting backup at 31-MAR-2004 03:54:03 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy input datafile fno=00001 name=/usr/oracle/oradata/RH10/system01.dbf output filename=/usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_system_06o1scs6_.dbf tag=TAG20040331T035403 recid=25 stamp=522215699 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05 channel ORA_DISK_1: starting datafile copy input datafile fno=00003 name=/usr/oracle/oradata/RH10/sysaux01.dbf output filename=/usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_sysaux_06o1vf5f_.dbf tag=TAG20040331T035403 recid=26 stamp=522215759 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55 channel ORA_DISK_1: starting datafile copy input datafile fno=00005 name=/usr/oracle/oradata/RH10/example01.dbf output filename=/usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_example_06o1x4hv_.dbf tag=TAG20040331T035403 recid=27 stamp=522215780 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting datafile copy input datafile fno=00002 name=/usr/oracle/oradata/RH10/undotbs01.dbf output filename=/usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_undotbs1_06o1xxw0_.dbf tag=TAG20040331T035403 recid=28 stamp=522215795 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting datafile copy input datafile fno=00004 name=/usr/oracle/oradata/RH10/users01.dbf output filename=/usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_users_06o1y55o_.dbf tag=TAG20040331T035403 recid=29 stamp=522215797 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting datafile copy copying current controlfile output filename=/usr/oracle/flash_recovery_area/RH10/controlfile/o1_mf_TAG20040331T035403_06o1y6gc_.ctl tag=TAG20040331T035403 recid=30 stamp=522215798 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset including current SPFILE in backupset channel ORA_DISK_1: starting piece 1 at 31-MAR-2004 03:56:39 channel ORA_DISK_1: finished piece 1 at 31-MAR-2004 03:56:40 piece handle=/usr/oracle/flash_recovery_area/RH10/backupset/2004_03_31/o1_mf_nns nf_TAG20040331T035403_06o1y7pw_.bkp comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 31-MAR-2004 03:56:40 RMAN> backup copy of database; Starting backup at 31-MAR-2004 03:56:58 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: including datafilecopy of datafile 00001 in backupset input filename=/usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_system_06o1scs6_.dbf channel ORA_DISK_1: including datafilecopy of datafile 00003 in backupset input filename=/usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_sysaux_06o1vf5f_.dbf channel ORA_DISK_1: including datafilecopy of datafile 00005 in backupset input filename=/usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_example_06o1x4hv_.dbf channel ORA_DISK_1: including datafilecopy of datafile 00002 in backupset input filename=/usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_undotbs1_06o1xxw0_.dbf channel ORA_DISK_1: including datafilecopy of datafile 00004 in backupset input filename=/usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_users_06o1y55o_.dbf channel ORA_DISK_1: starting piece 1 at 31-MAR-2004 03:56:59 channel ORA_DISK_1: finished piece 1 at 31-MAR-2004 03:58:54 piece handle=/usr/oracle/flash_recovery_area/RH10/backupset/2004_03_31/o1_mf_nnndf__06o1yv86_.bkp comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:55 Finished backup at 31-MAR-2004 03:58:54 RMAN> list copy; specification does not match any archive log in the recovery catalog List of Datafile Copies Key File S Completion Time Ckp SCN Ckp Time Name ------- ---- - -------------------- ---------- -------------------- ---- 25 1 A 31-MAR-2004 03:54:59 34739482 31-MAR-2004 03:54:03 /usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_system_06o1scs6_.dbf 28 2 A 31-MAR-2004 03:56:35 34739551 31-MAR-2004 03:56:29 /usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_undotbs1_06o1xxw0_.dbf 26 3 A 31-MAR-2004 03:55:59 34739509 31-MAR-2004 03:55:09 /usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_sysaux_06o1vf5f_.dbf 29 4 A 31-MAR-2004 03:56:37 34739555 31-MAR-2004 03:56:37 /usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_users_06o1y55o_.dbf 27 5 A 31-MAR-2004 03:56:20 34739535 31-MAR-2004 03:56:04 /usr/oracle/flash_recovery_area/RH10/datafile/o1_mf_example_06o1x4hv_.dbf List of Controlfile Copies Key S Completion Time Ckp SCN Ckp Time Name ------- - -------------------- ---------- -------------------- ---- 30 A 31-MAR-2004 03:56:38 34739556 31-MAR-2004 03:56:37 /usr/oracle/flash_recovery_area/RH10/controlfile/o1_mf_TAG20040331T035403_06o1y6gc_.ctl RMAN> list backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ -------------------- 43 Full 0 DISK 00:00:00 31-MAR-2004 03:56:39 BP Key: 43 Status: AVAILABLE Compressed: NO Tag: TAG20040331T035403 Piece Name: /usr/oracle/flash_recovery_area/RH10/backupset/2004_03_31/o1_mf_nnsnf_TAG20040331T035403_06o1y7pw_.bkp SPFILE Included: Modification time: 31-MAR-2004 03:46:09 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ -------------------- 44 Full 737M DISK 00:01:52 31-MAR-2004 03:58:51 BP Key: 44 Status: AVAILABLE Compressed: NO Tag: Piece Name: /usr/oracle/flash_recovery_area/RH10/backupset/2004_03_31/o1_mf_nnndf__06o1yv86_.bkp List of Datafiles in backup set 44 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- -------------------- ---- 1 Full 34739482 31-MAR-2004 03:54:03 /usr/oracle/oradata/RH10/system01.dbf 2 Full 34739551 31-MAR-2004 03:56:29 /usr/oracle/oradata/RH10/undotbs01.dbf 3 Full 34739509 31-MAR-2004 03:55:09 /usr/oracle/oradata/RH10/sysaux01.dbf 4 Full 34739555 31-MAR-2004 03:56:37 /usr/oracle/oradata/RH10/users01.dbf 5 Full 34739535 31-MAR-2004 03:56:04 /usr/oracle/oradata/RH10/example01.dbf RELATED DOCUMENTS ----------------- Oracle Database 10g: New Performance and Availability Features

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1160605/，如需轉載，請註明出處，否則將追究法律責任。