• 【ORA错误大全】 ORA-19527


    在做主备切换的时候,需要将备库的联机日志文件清除(clear online redo logfile),为了加快switchover的速度,Oracle10g在将备库置于manged standby状态的时候就提前将这个clear的动作做了,这个想法是好的,只是实现有点糟糕,会在alert里记录错误一堆错误:

    Errors in file /u01/oracle/admin/ning/bdump/ning_mrp0_319584.trc:
     ORA-00367: checksum error in log file header
     ORA-00316: log 1 of thread 1, type 0 in header is not log file
     ORA-00312: online log 1 thread 1: ‘/u01/oracle/oradata/ning/redo01_01.dbf’
     Clearing online redo logfile 1 /u01/oracle/oradata/ning/redo01_01.dbf
     Clearing online log 1 of thread 1 sequence number 3715
     Tue Mar 4 19:00:07 2008
     Errors in file /u01/oracle/admin/ning/bdump/ning_mrp0_319584.trc:
     ORA-19527: physical standby redo log must be renamed
     ORA-00312: online log 1 thread 1: ‘/u01/oracle/oradata/ning/redo01_01.dbf’
     Clearing online redo logfile 1 complete

    Oracle不承认这是bug,不过还是给出了解决方法:首先要在备库创建online redo logfile,然后设置log_file_name_convert参数,即使主备库日志文件的路径和名字都一样也要设置,不然还是会报ORA-19527。

    找到了一段正式的解释
    Cause
    This is in fact an enhancement to the Dataguard product in 10gR2 ..
    The goal here is to improve speed of switchover. Before this a switchover would require to clear the online logfiles before we can become a primary. In this release we attempt to clear the online logfiles when starting Managed Recovery.
    If the files exist then they will be cleared, but if they do not exist we report the error and the MRP does not fail.
    As an extra enhancement if the online redo logs do exist you must specify the log_file_name_convert parameter even if there is no difference in the name. This has been implemented to reduce the chances that the primary online redo logs are cleared when MRP starts. It is the equivalent of asking - Are you sure you want the logs to be called this....
    If the log_file_name_convert parameter is not set then the ORA-19527 is reported and the log file is not cleared at this time..

    Solution
    Solution to stop both of these errors is to create the online redo logs and ensure log_file_name_convert is set.

    友情参考链接

    http://www.taobaodba.com/html/80_oracle10g_standby_ora_00367_ora_19527.html

    http://space.itpub.net/11258275/viewspace-666811

    http://www.xifenfei.com/4388.html

  • 相关阅读:
    github单独下载一个文件夹
    搭建github服务器
    ssh xshell 连接在vim中无法用 ctrl+insert 复制黏贴
    centos 下文件夹共享
    rootkit 内核函数hook
    centos dhcp获取不到ip解决方法 Bringing up interface eth0: Device eth0 does not seem to be present,delaying initialization.
    ipc 入侵步骤
    linux 无交互添加用户设置密码
    C++笔记
    感谢路遥 感谢平凡的世界
  • 原文地址:https://www.cnblogs.com/51linux/p/3210869.html
Copyright © 2020-2023  润新知