RMAN-06026: some targets not found – aborting restore
xixuefeng
RMAN
2014-05-28 0:35:33
4,184 次浏览
RMAN-06026
RMAN-06026: some targets not found – aborting restore已关闭评论
环境(源库、目标库):OEL5.6 Oracle 11.2.0.4
目标库只安装了软件,从参数文件开始恢复,当恢复到数据文件时,报如下错误。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
RMAN> run{ 2> SET NEWNAME FOR DATAFILE 1 TO '/u01/app/oracle/oradata/CRM/system01.dbf'; 3> SET NEWNAME FOR DATAFILE 2 TO '/u01/app/oracle/oradata/CRM/sysaux01.dbf'; 4> SET NEWNAME FOR DATAFILE 3 TO '/u01/app/oracle/oradata/CRM/undotbs01.dbf'; 5> SET NEWNAME FOR DATAFILE 4 TO '/u01/app/oracle/oradata/CRM/users01.dbf'; 6> SET NEWNAME FOR DATAFILE 5 TO '/u01/app/oracle/oradata/CRM/example01.dbf'; 7> RESTORE DATABASE ; 8> SWITCH DATAFILE ALL; 9> RECOVER DATABASE; 10> } executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at 28-FEB-14 using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 02/28/2014 19:35:46 RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 5 found to restore RMAN-06023: no backup or copy of datafile 4 found to restore RMAN-06023: no backup or copy of datafile 3 found to restore RMAN-06023: no backup or copy of datafile 2 found to restore RMAN-06023: no backup or copy of datafile 1 found to restore RMAN> list backup; specification does not match any backup in the repository RMAN> |
原因:备份集合不在原来的位置或控制文件中无相关备份信息。
解决此问题方法:可以手工将备份集所处的位置注册到控制文件中,如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
RMAN> catalog backuppiece '/u01/app/FRA/CRM/backupset/2014_02_28/o1_mf_nnndf_TAG20140228T185721_9k0twkh2_.bkp'; using target database control file instead of recovery catalog catalog backuppiece '/u01/app/FRA/CRM/backupset/2014_02_28/o1_mf_annnn_TAG20140228T185943_9k0v0zbh_.bkp'; catalog backuppiece '/u01/app/FRA/CRM/backupset/2014_02_28/o1_mf_ncsnf_TAG20140228T185721_9k0v0vv8_.bkp'; catalog backuppiece '/u01/app/FRA/CRM/backupset/2014_02_28/o1_mf_annnn_TAG20140228T185719_9k0twhj1_.bkp';cataloged backup piece backup piece handle=/u01/app/FRA/CRM/backupset/2014_02_28/o1_mf_nnndf_TAG20140228T185721_9k0twkh2_.bkp RECID=3 STAMP=840742756 RMAN> cataloged backup piece backup piece handle=/u01/app/FRA/CRM/backupset/2014_02_28/o1_mf_annnn_TAG20140228T185943_9k0v0zbh_.bkp RECID=4 STAMP=840742756 RMAN> cataloged backup piece backup piece handle=/u01/app/FRA/CRM/backupset/2014_02_28/o1_mf_ncsnf_TAG20140228T185721_9k0v0vv8_.bkp RECID=5 STAMP=840742756 RMAN> cataloged backup piece backup piece handle=/u01/app/FRA/CRM/backupset/2014_02_28/o1_mf_annnn_TAG20140228T185719_9k0twhj1_.bkp RECID=6 STAMP=840742757 RMAN> |
查看备份信息,哦了
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
RMAN> list backup; List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 1 345.50K DISK 00:00:00 28-FEB-14 BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20140228T185719 Piece Name: /u01/app/FRA/CRM/backupset/2014_02_28/o1_mf_annnn_TAG20140228T185719_9k0twhj1_.bkp List of Archived Logs in backup set 1 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 6 1013142 28-FEB-14 1014632 28-FEB-14 1 7 1014632 28-FEB-14 1014661 28-FEB-14 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 2 Full 1.14G DISK 00:02:08 28-FEB-14 BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20140228T185721 Piece Name: /u01/app/FRA/CRM/backupset/2014_02_28/o1_mf_nnndf_TAG20140228T185721_9k0twkh2_.bkp List of Datafiles in backup set 2 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1014673 28-FEB-14 /u01/app/oracle/oradata/CRM/system01.dbf 2 Full 1014673 28-FEB-14 /u01/app/oracle/oradata/CRM/sysaux01.dbf 3 Full 1014673 28-FEB-14 /u01/app/oracle/oradata/CRM/undotbs01.dbf 4 Full 1014673 28-FEB-14 /u01/app/oracle/oradata/CRM/users01.dbf 5 Full 1014673 28-FEB-14 /u01/app/oracle/oradata/CRM/example01.dbf BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 3 3.50K DISK 00:00:00 28-FEB-14 BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20140228T185943 Piece Name: /u01/app/FRA/CRM/backupset/2014_02_28/o1_mf_annnn_TAG20140228T185943_9k0v0zbh_.bkp List of Archived Logs in backup set 3 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 8 1014661 28-FEB-14 1014726 28-FEB-14 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 4 Full 9.36M DISK 00:00:00 28-FEB-14 BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20140228T185721 Piece Name: /u01/app/FRA/CRM/backupset/2014_02_28/o1_mf_ncsnf_TAG20140228T185721_9k0v0vv8_.bkp SPFILE Included: Modification time: 28-FEB-14 SPFILE db_unique_name: CRM Control File Included: Ckp SCN: 1014719 Ckp time: 28-FEB-14 RMAN> |