應對 "RMAN-06023: no backup or copy of datafile 1 found to restore"錯誤
----錯誤資訊:
執行restore database 或 duplicate target database to vmdb2;
報如下錯誤:
1、$ rman target /
<wbr> <wbr> RMAN> restore database;
RMAN-03002: failure of restore command at 06/11/2005 01:19:01
RMAN-06026: some targets not found - aborting 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-06026: some targets not found - aborting 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
----經過深入檢討,發現問題並非沒有備份,而是恢復目標路徑不存在。
----解決辦法:
----解決辦法:
1, 建立目標路徑。 mkdir -p /opt/app/oracle/oradata/VMDB2/
2,建立路徑對映,(注意:需對所有恢復的資料檔案作路徑對映檢查)
db_file_name_convert='/VMDB1','/VMDB2','/opt/app/oracle/oradata/VMDB1/','/data/VMDB2'
log_file_name_convert='/VMDB1','/VMDB2','/opt/app/oracle/oradata/VMDB1/','/data/VMDB2'
[@more@]
log_file_name_convert='/VMDB1','/VMDB2','/opt/app/oracle/oradata/VMDB1/','/data/VMDB2'
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/350519/viewspace-1054405/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RMAN-06023 no backup or copy of datafile 1 found to restoreREST
- RMAN-06100: no channel to restore a backup or copy of datafileREST
- 應對RMAN-06026錯誤,使用dbms_backup_restore進行恢復REST
- restore database報RMAN-06026和RMAN-06023錯誤RESTDatabase
- rman copy asm datafile(rename asm datafile)ASM
- SQL Server Backup & RestoreSQLServerREST
- TFS Express backup and restoreExpressREST
- backup and restore tipsREST
- 冷備_並行copy datafile並行
- Cold backup and restore the entire databaseRESTDatabase
- rman restore database(spfile,controlfile, datafile)RESTDatabase
- DBMS_BACKUP_RESTORE.DBMS_BACKUP_RESTORE用於特殊情況下的恢復REST
- read only tablespace backup restoreREST
- WARNING: datafile #1 was not in online backup mode 出現的原因
- Oracle 使用RMAN COPY 移動 Datafile 位置Oracle
- 轉貼_RMAN-DBMS_BACKUP_RESTOREREST
- 小程式錯誤:Component is not found in path
- MyBatis 錯誤:Invalid bound statement (not found)MyBatis
- Oracle OCP 1Z0 053 Q505(RMAN DATAFILE BACKUP COPIES)Oracle
- DBV驗證ASM裡的datafile,出現錯誤ASM
- DBCA建庫出現CHMOD NOT FOUND錯誤
- Invalid bound statement (not found)錯誤解決
- 還原資料庫RMAN-06023錯誤的解決方法資料庫
- How to copy a datafile from ASM to a file system not using RMANASM
- client backup was not attempted because backup window closed 錯誤解決一例client
- Eclipse 啟動專案錯誤:class not foundEclipse
- 解決ntp的錯誤 no server suitable for synchronization foundServerUI
- db2備份恢復(backup restore)DB2REST
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- Manually Backup - Restore or Clone a Database to Another Node [ID 562556.1]RESTDatabase
- 資料庫restore時遇到1119錯誤資料庫REST
- bash: ssh-copy-id: command not found...
- Recover A Lost Datafile With No Backup (Doc ID 1060605.6)
- rman backup as copy database format '/tmp/%U.dbf'DatabaseORM
- 解決shell指令碼錯誤$’r’ command not found指令碼
- shell指令碼執行錯誤 $‘\r‘:command not found指令碼
- Mysql啟動錯誤-server PID file could not be foundMySqlServer
- nacos2.3.0版本403 user not found錯誤