oracle adg switch over,oracle 11G DATAGUARD SwitchOver 问题

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

系统版本：

Linux version 2.6.18-238.el5 (mockbuild@ls20-bc2-13.build.redhat.com) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-50)) #1 SMP Sun Dec 19 14:24:47 EST 2010

报错：

SQL> startup;

ORACLE instance started.

Total System Global Area 790941696 bytes

Fixed Size 1347848 bytes

Variable Size 465571576 bytes

Database Buffers 318767104 bytes

Redo Buffers 5255168 bytes

Database mounted.

ORA-10458: standby database requires recovery

ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01110: data file 1: '/oradata/baby2/system01.dbf'

启动备库报错，请问这个问题该怎么解决？下面是一些参数

主库：

①SWITCHOVER状态:

SQL> select SWITCHOVER_STATUS from v$database;

SWITCHOVER_STATUS

--------------------

FAILED DESTINATION

②参数

SQL> show parameter LOG_ARCHIVE_DEST_2;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_2 string SERVICE=baby2 DB_UNIQUE_NAME=b

aby2

log_archive_dest_20 string

log_archive_dest_21 string

log_archive_dest_22 string

log_archive_dest_23 string

log_archive_dest_24 string

log_archive_dest_25 string

log_archive_dest_26 string

log_archive_dest_27 string

log_archive_dest_28 string

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_29 string

③查看相关日志

Fatal NI connect error 12541, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.112.11)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=baby2)(CID=(PROGRAM=oracle)(HOST=stu01)(USER=oracle))))

VERSION INFORMATION:

TNS for Linux: Version 11.2.0.3.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

Time: 01-DEC-2013 01:50:45

Tracing not turned on.

Tns error struct:

ns main err code: 12541

TNS-12541: TNS:no listener

ns secondary err code: 12560

nt main err code: 511

TNS-00511: No listener

nt secondary err code: 111

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12541, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.112.11)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=baby2)(CID=(PROGRAM=oracle)(HOST=stu01)(USER=oracle))))

VERSION INFORMATION:

TNS for Linux: Version 11.2.0.3.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

Time: 01-DEC-2013 01:50:45

Tracing not turned on.

Tns error struct:

ns main err code: 12541

TNS-12541: TNS:no listener

ns secondary err code: 12560

nt main err code: 511

TNS-00511: No listener

nt secondary err code: 111

nt OS err code: 0

Error 12541 received logging on to the standby

Check whether the listener is up and running.

PING[ARC1]: Heartbeat failed to connect to standby 'baby2'. Error is 12541.

备库：

①SWITCHOVER状态:

SQL> select SWITCHOVER_STATUS from v$database;

SWITCHOVER_STATUS

--------------------

TO PRIMARY

②参数

SQL> show parameter LOG_ARCHIVE_DEST_2;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_2 string SERVICE=baby1 DB_UNIQUE_NAME=b

aby1

log_archive_dest_20 string

log_archive_dest_21 string

log_archive_dest_22 string

log_archive_dest_23 string

log_archive_dest_24 string

log_archive_dest_25 string

log_archive_dest_26 string

log_archive_dest_27 string

log_archive_dest_28 string

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_29 string

③查看相关日志

***********************************************************************

Fatal NI connect error 12541, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.112.10)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=baby1)(CID=(PROGRAM=oracle)(HOST=stu02)(USER=oracle))))

VERSION INFORMATION:

TNS for Linux: Version 11.2.0.3.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

Time: 01-DEC-2013 01:54:44

Tracing not turned on.

Tns error struct:

ns main err code: 12541

TNS-12541: TNS:no listener

ns secondary err code: 12560

nt main err code: 511

TNS-00511: No listener

nt secondary err code: 111

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12541, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.112.10)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=baby1)(CID=(PROGRAM=oracle)(HOST=stu02)(USER=oracle))))

VERSION INFORMATION:

TNS for Linux: Version 11.2.0.3.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

Time: 01-DEC-2013 01:54:44

Tracing not turned on.

Tns error struct:

ns main err code: 12541

TNS-12541: TNS:no listener

ns secondary err code: 12560

nt main err code: 511

TNS-00511: No listener

nt secondary err code: 111

nt OS err code: 0

Error 12541 received logging on to the standby

Check whether the listener is up and running.

PING[ARC2]: Heartbeat failed to connect to standby 'baby1'. Error is 12541.

本人正在求职阶段

有岗位空缺的希望能考虑考虑我，谢谢了！

联系我麻烦请致邮箱guchenguang913@163.com