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;
===========================================================