RMAN10g: backup copy of database (Doc ID 266980.1)
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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- rman backup as copy database format '/tmp/%U.dbf'DatabaseORM
- Recover a Database Having Added a Datafile Since Last Backup (Doc ID 29430.1)DatabaseAST
- Backup and Recovery Scenarios (Doc ID 94114.1)iOS
- RMAN Backup Shell Script Example (Doc ID 137181.1)
- Recover A Lost Datafile With No Backup (Doc ID 1060605.6)
- * Master Note: Database Performance Overview (Doc ID 402983.1)ASTDatabaseORMView
- Troubleshooting Database Hang Issues (Doc ID 1378583.1)Database
- How to Duplicate a Database in NOARCHIVELOG mode (Doc ID 275480.1)DatabaseHive
- backup or restore OLR in 11.2 Grid Infrastructure (Doc ID 1193643.1)RESTASTStruct
- Oracle10G RMAN Database Duplication (Doc ID 259694.1)OracleDatabase
- How To Size the Database Smart Flash Cache (Doc ID 1317950.1)Database
- RMAN backup validate database on databases in noarchivelog modeDatabaseHive
- Manually Backup - Restore or Clone a Database to Another Node [ID 562556.1]RESTDatabase
- oracle full database backupOracleDatabase
- Rman backup standby databaseDatabase
- Cold Database backup scriptDatabase
- Performing duplicate database with ASM/OMF/RMAN (Doc ID 340848.1)ORMDatabaseASM
- How To List All The Named Events Set For A Database (Doc ID 436036.1)Database
- Information On Installed Database Components and Schemas (Doc ID 472937.1)ORMDatabase
- Can Tapes Be Used For RMAN Convert Database (Doc ID 563816.1)Database
- Recover database after disk loss (Doc ID 230829.1)Database
- oracle database backup and recovery user's guide part IVOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part IIIOracleDatabaseGUIIDE
- RMAN : Consistent Backup, Restore and Recovery using RMAN (Doc ID 162855.1)REST
- How to Collect Diagnostics for Database Hanging Issues (Doc ID 452358.1)Database
- Master Note of Linux OS Requirements for Database Server (Doc ID 851598.1)ASTLinuxUIREMDatabaseServer
- JavaVM Component Database PSU and RU Patches(Doc ID 1929745.1)JavaDatabase
- [轉帖]Release Schedule of Current Database Releases (Doc ID 742060.1)Database
- Cold backup and restore the entire databaseRESTDatabase
- rman backup database force 功能Database
- oracle database backup and recovery user's guide part VII & VIIIOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part V & VIOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part I & IIOracleDatabaseGUIIDE
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase
- ORA-1578 Corrupt Block Found in Encrypted Database (Doc ID 1329437.1)BloCDatabase
- How to Move or Copy a Tablespace to Another Database (61)Database
- Rman Backup Failed With Error Rman-00600 [8201] (Doc ID 412786.1)AIError
- T-SQL Verify Database BackupSQLDatabase