如题所示,在执行RMAN恢复【recover】数据库的时候,你可能会遇到这样的问题:
channel ORA_DISK_1: restore complete, elapsed time: 00:01:17 archive log filename=/callcenter/arch/1_46156_863120821.arch thread=1 sequence=46156 archive log filename=/callcenter/arch/1_46157_863120821.arch thread=1 sequence=46157 archive log filename=/callcenter/arch/1_46158_863120821.arch thread=1 sequence=46158 archive log filename=/callcenter/arch/1_46159_863120821.arch thread=1 sequence=46159 archive log filename=/callcenter/arch/1_46160_863120821.arch thread=1 sequence=46160 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 09/26/2016 18:19:39 ORA-00283: recovery session canceled due to errors RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/callcenter/arch/1_46160_863120821.arch' ORA-00283: recovery session canceled due to errors ORA-19755: could not open change tracking file ORA-19750: change tracking file: '/callcenter/oradata/hftcc/block_change_trace.trc' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 RMAN>
对于这种情况,解决方法如下:
禁用BLOCK TRACKING:
SQL> ALTER DATABASE DISABLE BLOCK CHANGE TRACKING; Database altered. SQL> SQL> col filename for a30 SQL> set linesize 400 SQL> SQL> select filename,status,bytes/1024/1024 "MB" from v$block_change_tracking; FILENAME STATUS MB ------------------------------ ---------- ---------- DISABLED SQL>
然后,再次执行【recover】:
[oracle@hftdbtest ~]$ rman target / Recovery Manager: Release 10.2.0.5.0 - Production on Mon Sep 26 18:34:28 2016 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: HFTCC (DBID=13087093, not open) RMAN> recover database; Starting recover at 26-SEP-16 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=1090 devtype=DISK starting media recovery archive log thread 1 sequence 46160 is already on disk as file /callcenter/arch/1_46160_863120821.arch archive log thread 1 sequence 46161 is already on disk as file /callcenter/arch/1_46161_863120821.arch archive log thread 1 sequence 46162 is already on disk as file /callcenter/arch/1_46162_863120821.arch archive log thread 1 sequence 46163 is already on disk as file /callcenter/arch/1_46163_863120821.arch archive log filename=/callcenter/arch/1_46160_863120821.arch thread=1 sequence=46160 archive log filename=/callcenter/arch/1_46161_863120821.arch thread=1 sequence=46161 (... ... 更多的输出。)
————————————————
Done。