oraclerman异机恢复 - 数据库编程

re from AUTOBACKUP complete Finished restore at 14-NOV-14 重启nomout RMAN> startup nomount force; Oracle instance started Total System Global Area 613797888 bytes Fixed Size 2255712 bytes Variable Size 427820192 bytes Database Buffers 180355072 bytes Redo Buffers 3366912 bytes 恢复控制文件 RMAN> restore controlfile from '/u01/backup/control20141114 .bak'; Starting restore at 14-NOV-14 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=/u01/app/oracle/oradata/orcl/control01.ctl output file name=/u01/app/oracle/fast_recovery_area/orcl/control02.ctl Finished restore at 14-NOV-14 RMAN> startup mount RMAN>restore database；如果这一步没法执行可以使用list incarnation产看相关信息，切换一下再执行 reset database to incarnation XX； RMAN> recover database; RMAN-03002: failure of recover command at 11/14/2014 22:19:36 RMAN-06053: unable to perform media recovery because of missing log RMAN-06025: no backup of archived log for thread 1 with sequence 13 and starting SCN of 1208284

这一步竟然报错了，后来我发现没有执行catalog

然后我执行了catalog start with ‘/u01/backup/’；

完了再次执行recover

但是还是出错现了同样的错误

然后我执行list backup of archivelog all查看后，执行了以下脚本就好了

RMAN> run {
2> set until scn 1208284;
3> recover database;
4> }


executing command: SET until clause


Starting recover at 14-NOV-14
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4


starting media recovery
media recovery complete, elapsed time: 00:00:00


Finished recover at 14-NOV-14

然后登陆数据库执行

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-19751: could not create the change tracking file
ORA-19750: change tracking file:
'/u01/app/oracle/oradata/orcl/ORCL/changetracking/o1_mf_b51rj77x_.chg'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

又出错了，我就去/u01/app/oracle/oradata/orcl/ORCL/changetracking/目录查看没有这个目录

然后我执行了

SQL>ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;

然后关闭数据库shutdown immediate；

再执行startup；

数据库成功启动

搞这个异机恢复，第一次搞了2天，头都大了，好多解决方法都没用，以上为个人遇到的问题，希望对一些遇到同类问题的朋友有帮助

改变change tracking file的位置
1) 不关闭数据库的方式
SQL> ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE 'new_location';
注意：这种方式会丢失change tracking file的内容

oraclerman异机恢复(二)