配置oracle 11g r2 datagurad出现ora-10458错误
首页 → 数据库技术
背景：
阅读新闻
配置oracle 11g r2 datagurad出现ora-10458错误
[日期：2011-08-18]来源：linux社区 作者：mengzhaoliang[字体：]
备库：
sql> alter database open read only;
alter database open read only
*
error at line 1:
ora-10458: standby database requires recovery
ora-01152: file 1 was not restored from a sufficiently old backup
ora-01110: data file 1: '/u01/app/oracle/oradata/bhoms/system01.dbf'
查看备库：
sql> select switchover_status from v$database;
switchover_status
--------------------
to primary
查看主库：
sql> select switchover_status from v$database;
switchover_status
--------------------
not allowed
再次查看主库的参数：
sql> show parameter log_archive_dest_2
name                                 type        value
------------------------------------ ----------- ------------------------------
log_archive_dest_2                   string      service=standby lgwr async noa
                                                 ffirm
原来这里设置错误：
sql> alter system set log_archive_dest_2='service=bhoms02 async valid_for=(online_logfiles,primary_role) db_unique_name=bhoms02';
再查主库：
sql> select switchover_status from v$database;
switchover_status
--------------------
to standby
查看备库：
sql> show parameter log_archive_dest_2
name                                 type        value
------------------------------------ ----------- ------------------------------
log_archive_dest_2                   string      service=standby lgwr async noa
                                                 ffirm
原来这里设置错误：
sql> alter system set log_archive_dest_2='service=bhoms01 async valid_for=(online_logfiles,primary_role) db_unique_name=bhoms01';
重启备库，，解决问题：
sql> shutdown immediate;
ora-01109: database not open
database dismounted.
oracle instance shut down.
sql> startup nomount
oracle instance started.
total system global area 6747725824 bytes
fixed size                  2213976 bytes
variable size            5100275624 bytes
database buffers         1610612736 bytes
redo buffers               34623488 bytes
sql> alter database mount standby database;
database altered.
sql> alter database open read only;
database altered.
sql> alter database recover managed standby database disconnect from session;
database altered.
0
ora-01281: scn range specified is invalid错误
aix 5.3安装oracle 11g r2 ssh 互信问题
相关资讯       oracle教程
图片资讯
本文评论查看全部评论 (0)
评论声明
最新资讯
本周热门
linux公社简介 - 广告服务 - 网站地图 - 帮助信息 - 联系我们
本站（linuxidc）所刊载文章不代表同意其说法或描述，仅为提供更多信息，也不构成任何建议。
copyright © 2006-2011　linux公社　all rights reserved 浙icp备06018118号