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.
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
Online Redo logs missing on standby database.
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;
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-10458: standby database requiresrecovery ORA-01196: 文件 1 由于介质恢复会话失败而不一致 ORA-01110: 数据文件 1:’+DATA/htdb7/datafile/system.313.884996245′ 查看归档日志应用情况,发现一部分日志没...
ORA-10458: standby database requires recovery ORA-01196: 文件 1 由于介质恢复会话失败而不一致 ORA-01110: 数据文件 1: ‘XXXXXXXXXXXXXXXXXX\XXXXX1.DBF’ 一个项目做了Oracle主从数据库同步,通过Dataguard...
默认值 : 1 circuits: 说明 : 指定可用于入站和出站网络会话的虚拟电路总数。 该参数是构成某个例程的总 SGA 要求的若干参数之一。 默认值 : 派生: SESSIONS 参数的值 (如果正在使用共享服务器体系结构); 否则为 0...
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实施.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搭建手册,可以看看大牛如何撰写的
ORACLE DATAGURD 物理standby配置
第一篇 软硬件需求 1 1.1 硬件及操作系统需求 1 1.2 软件需求 1 第二篇 物理standby创建示例 2 2.1 阶段一:Primary库配置 2 1、确认主库处于归档模式 2 2、将 primary数据库置为FORCE LOGGING模式 2 3、更改归档...
2. 配置standby redolog Standby 3. 重建密码文件 4. 修改主库参数文件 5. 配置主从数据库的网络 6. 备份主库数据文件 7. 在主库上建立备库控制文件 三、 备库配置 1. 准备备库参数文件 2. 创建11g数据库...
45.使用Database Configuration Assistant安装第二个数据库 46.Oracle 数据库向 MS SQL Server 7.0 的迁移 Oracle1: 1. Decode()函数使用技巧(NT+IIS+ASP+ORACLE) 2. Dual伪列 3. EXP、IMP 命令详解 4. ...
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 ...
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、设置...
通过本文档可以完成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