ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1]
来源:互联网 发布:无证程序员 编辑:程序博客网 时间:2024/06/12 03:08
ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1]
Modified 20-APR-2009 Type PROBLEM Status 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 in alert.log of standby database during 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. Online redo logs will be created automatically when you activate the standby after switchover or failover.
If you want to fix 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 to internal 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-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1]
- ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1]
- ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1]
- ORA-00313 ORA-00312 ORA-27037
- UNNAMED FILE ERROR IN STANDBY AFTER ADDING NEW FILE TO PRIMARY DATABASE – ORA-01111, ORA-01110, ORA-
- standby database 中的登录触发器 导致 ORA-00604 ORA-16000
- ORA-10458: standby database requires recovery
- ORA-10458: standby database requires recovery
- ORA-10458: standby database requires recovery
- ORA-00312 ,ORA-00313
- ORA-00313: drop standby logfile
- Adding a standby database to a dataguard configuration fails with ORA-1017 (Doc ID 1072022.1)
- ORA-01103: database name 'test' in control file is not 'standby'
- ORA-10456: cannot open standby database; media recovery session may be in progress
- ORA-10456: cannot open standby database; media recovery session may be in
- ORA-10456: cannot open standby database; media recovery session may be in progress
- ORA-10456: cannot open standby database; media recovery session may be in progress
- ORA-16003: standby database is restricted to read-only access
- jcs缓存配置
- hdu2602——Bone Collector
- 动态查询
- Ibatis2.0使用说明(一)——入门实例篇
- 怎样在Sharepoint 2010中定制开发SharePoint Designer Workflows Activities
- ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1]
- TCP和UDP中关于消息边界
- Ibatis2.0使用说明(二)——配置篇(1)
- 市场营销及推广学习室---- 提高你企业的知名度
- Android APK 是怎么安装的?
- asp.net中网页间传递参数
- 【苹果VS魅族】 苹果封杀魅族所引发的五大启示
- 设置IP
- 众包,一个不成熟的类威客概念