Oracle之Rman常見錯誤

Oracle之Rman常見錯誤

---

===========================================================
RMAN-05501: aborting duplication of target database

原因:在初始化引數裡沒設定引數有問題

處理辦法：
認真檢查初始化檔案，看有沒有少什麼標點之類的

===========================================================
RMAN-06024: no backup or copy of the control file found to restore
原因：沒有備份控制檔案

處理辦法：
先去備份控制檔案

===========================================================
ORA-19502: write error on file "/backup/testdb1/rman/testdb1_full_22pnh0ea_1_1", block number 14976 (block size=8192)
ORA-27072: File I/O error
原因：磁碟錯誤

處理辦法：df -h檢視空間是不是滿了。

===========================================================
ORA-00202: control file: '/app/oracle/fast_recovery_area/testdb1/control02.ctl'

直接從備份集中恢復：
RMAN> restore controlfile from '/backup/testdb1/testdb1_control_bak_20141113';

Starting restore at 2014-11-13 15:19:40
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/app/oracle/oradata/testdb1/control01.ctl
output file name=/app/oracle/fast_recovery_area/testdb1/control02.ctl
Finished restore at 2014-11-13 15:19:42

RMAN>

===========================================================
ORA-01180: can not create datafile 1 ORA-01110: data file 1: '/app/oracle/oradata/testdb1/system01.d

原因：未知

處理辦法：重新註冊備份集
RMAN> catalog start with  '/backup/testdb1/';
RMAN> restore database;
RMAN> recover database;
SQL> alter database open resetlogs;
===========================================================