IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    RMAN error:ORA-19755: could not open change tracking file

    Adamhuan发表于 2016-09-26 10:29:34
    love 0

    如题所示,在执行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。



沪ICP备19023445号-2号
友情链接