配置Oracle 11g R2 Datagurad出现ORA-10458错误

备库：
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_2NAME                                 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_2NAME                                 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 openDatabase 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.ORA-01281: SCN range specified is invalid错误AIX 5.3安装Oracle 11g R2 SSH 互信问题相关资讯 Oracle教程

Oracle中纯数字的varchar2类型和（07/29/2015 07:20:43）
Oracle教程：Oracle中查看DBLink密（07/29/2015 07:16:55）
[Oracle] SQL*Loader 详细使用教程（08/11/2013 21:30:36）

Oracle教程：Oracle中kill死锁进程（07/29/2015 07:18:28）
Oracle教程：ORA-25153 临时表空间（07/29/2015 07:13:37）
Oracle教程之管理安全和资源（04/08/2013 11:39:32）

本文评论查看全部评论（0）