`
hunxiejun
  • 浏览: 1137910 次
文章分类
社区版块
存档分类
最新评论

ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1]

 
阅读更多

ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1]


Modified 20-APR-2009Type PROBLEMStatus MODERATED

In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.4
This problem can occur on any platform.

Symptoms

Following errors inalert.log of standby databaseduring startup of the standby database:

ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u03/oradata/prod/redo01b.log'
ORA-27037: unable to obtain file status

Cause

Online Redo logs missing on standby database.

Solution

You can safely ignore these messages. Onlineredo logs will be created automatically when you activate the standby after switchover or failover.

If you want tofix these messages then please use following steps:

1.Check and set "log_file_name_convert" parameter if the location of log files are different on primary and standby.

SQL> alter system set log_file_name_convert = "'<location on primary>','<location on standby>'" scope=spfile;

If you are using pfile then set the parameter in init file after shutting down the database:

*.log_file_name_convert = '<location on primary>','<location on standby>'

For 10gR2 only : Set this parameter even if the location of the redo logs are same on both primary and standby otherwise you may get ORA-19527 and ORA-312 while or after implementing the below steps.
This is due tointernal bug in 10.2.

2.Cancel Managed Recovery process on the standby:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

3. Execute the command to clear all log groups on standby for each log group (for each log group):

SQL>alter database clear logfile group 1;

4. Check the v$log view to confirm the size and status.

5.Recreate standby redo logs on standby (only if standby Redo logs are also missing) using:

(a) Drop the standby redo logfile group(s) (check v$standby_log)

SQL> alter database drop standby logfile group 4;

(b) Recreate the standby logfile group(s)

SQL> alter database add standby logfile group 4 ('/u03/redo/stby01.log') size 50m;

References

BUG:4724888 - DATAGUARD ERROR IN 10.2
NOTE:185076.1 - Standby Redo Logs are not Created when Creating a 9i Data Guard DB with RMAN
NOTE:352879.1 - ORA-19527 reported in 10gR2 Standy database


------------------------------------------------------------------------------

Blog http://blog.csdn.net/tianlesoftware

网上资源: http://tianlesoftware.download.csdn.net

相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群:62697716(); DBA2 群:62697977()

DBA3 群:62697850 DBA 超级群:63306533;

聊天 群:40132017

--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请

分享到:
评论

相关推荐

    数据库ORA-01196故障-归档日志丢失恢复详解

    ORA-10458: standby database requiresrecovery ORA-01196: 文件 1 由于介质恢复会话失败而不一致 ORA-01110: 数据文件 1:’+DATA/htdb7/datafile/system.313.884996245′ 查看归档日志应用情况,发现一部分日志没...

    Oracle备库宕机启动的完美解决方案

    ORA-10458: standby database requires recovery ORA-01196: 文件 1 由于介质恢复会话失败而不一致 ORA-01110: 数据文件 1: ‘XXXXXXXXXXXXXXXXXX\XXXXX1.DBF’ 一个项目做了Oracle主从数据库同步,通过Dataguard...

    Oracle9i的init.ora参数中文说明

    默认值 : 1 circuits: 说明 : 指定可用于入站和出站网络会话的虚拟电路总数。 该参数是构成某个例程的总 SGA 要求的若干参数之一。 默认值 : 派生: SESSIONS 参数的值 (如果正在使用共享服务器体系结构); 否则为 0...

    p28412269_112040_WINNT.zip

    CELLSRV FAILS DUE TO ORA-7445 [KAF4F0RST9IR2SRP1] 11733603 ORA-54 WITH SELECT STATEMENT USING NOWAIT CLAUSE WITH NO CONCURRENT ACTIVE TX 11786053 SR11.2.0.3ASM - TRC - KFMDXGRPREGLMON 11883252 REDO...

    RH4下Ora9[1].2安装及Standby,RMAN实施.doc

    RH4下Ora9[1].2安装及Standby,RMAN实施.docRH4下Ora9[1].2安装及Standby,RMAN实施.docRH4下Ora9[1].2安装及Standby,RMAN实施.docRH4下Ora9[1].2安装及Standby,RMAN实施.docRH4下Ora9[1].2安装及Standby,RMAN实施.doc

    Oracle11G DataGuard相同SID物理Standby搭建手册

    Oracle11G DataGuard相同SID物理Standby搭建手册,可以看看大牛如何撰写的

    ORACLE DATAGURD 物理standby配置

    ORACLE DATAGURD 物理standby配置

    Win8下DG物理Standby搭建

    第一篇 软硬件需求 1 1.1 硬件及操作系统需求 1 1.2 软件需求 1 第二篇 物理standby创建示例 2 2.1 阶段一:Primary库配置 2 1、确认主库处于归档模式 2 2、将 primary数据库置为FORCE LOGGING模式 2 3、更改归档...

    Oracle DataGuard 生产库dg最佳实施文档

    2. 配置standby redolog Standby 3. 重建密码文件 4. 修改主库参数文件 5. 配置主从数据库的网络 6. 备份主库数据文件 7. 在主库上建立备库控制文件 三、 备库配置 1. 准备备库参数文件 2. 创建11g数据库...

    Oracle数据库学习指南

    45.使用Database Configuration Assistant安装第二个数据库 46.Oracle 数据库向 MS SQL Server 7.0 的迁移 Oracle1: 1. Decode()函数使用技巧(NT+IIS+ASP+ORACLE) 2. Dual伪列 3. EXP、IMP 命令详解 4. ...

    [手工整理]208个Oracle安装文档,包含各个平台各个版本的单实例RAC以及DataGuard(1).xlsx

    20 ADG Oracle 12c dg-setup-rac-phys-standby-to-rac-prim 21 ADG oracle 12cR2 for linux 单机+dataguard实施文档(最详细) 22 ADG Oracle 19c rac+adg 23 ADG Oracle 9i搭建DG方案 24 ADG oracle active ...

    创建物理dataguard

    2.Standby数据库 1 逻辑standby 1 物理standby 1 二、物理datagurad创建步骤 2 1、 2 2、 2 三、主数据上的准备工作 2 1、设置主数据库为Force logging 2 2、建立password file 2 3、配置standby redo log 2 4、设置...

    【ADG】12c cdb,pdb Datagard 搭建(rac to 单节点).pdf

    通过本文档可以完成oracle12c的ADG搭建,过程包括rman duplicate过程。 主库 系统 IP 实例名 rac1 rhel6.9 192.168.1.41 test1 rac2· rhel6.9 192.168.1.42 test2 ...ora12standby rhel6.9 192.168.1.46 standby

Global site tag (gtag.js) - Google Analytics