Oracle15001,ORACLE 11G 配置DG 报ORA-10458、ORA-01152、ORA-01110

操作系统:

Oracle Linux Server release 5.7

数据库版本：

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

主：yoon 备：yoondg

备库：

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: '/opt/oracle/oradata/yoon/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=yoon async valid_for=(

online_logfiles,primary_role)

db_unique_name=yoon

log_archive_dest_20 string

蓝色地方设置错误：

SQL>alter system set log_archive_dest_2='servce=yoondg async valid_for=(online_logfiles,primary_role) db_unique_name=yoondg';

修改完再次查看：

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=yoondg async valid_for=(

online_logfiles,primary_role)

db_unique_name=yoondg

log_archive_dest_20 string

依旧蓝色地方设置错误：

SQL>alter system set log_archive_dest_2='service=yoon async valid_for=(online_logfies,primary_role) db_unique_name=yoon';

重启备库：

SQL>shutdown immediate;

SQL>startup nomount;

SQL>alter database mount standby database;

SQL>alter database open read only;

OK,问题解决.

配置ORACLE-DG的时候一定要认真、仔细，造成的报错往往都是由于小错误引起的，报错的时候不要着急，仔细分析alterSID.log和trace文件.