导读：今天单独启动了Data Guard的primary 数据库，出现了这个错误：ORA-03113: end-of-file on communication channel [[email?protected] ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 12 23:16:48 2012 Copyright (c) 1982,2
今天单独启动了Data Guard的primary 数据库，出现了这个错误：ORA-03113: end-of-file on communication channel
[[email?protected] ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 12 23:16:48 2012
Copyright (c) 1982,2005,Oracle.? All rights reserved.
Connected to an idle instance.
SQL> startup ORACLE instance started.
Total System Global Area? 314572800 bytes Fixed Size????????????????? 1219160 bytes Variable Size????????????? 88081832 bytes Database Buffers????????? 222298112 bytes Redo Buffers??????????????? 2973696 bytes Database mounted. ORA-03113: end-of-file on communication channel
?
归结原因是例如以下：
Data Guard的数据库的启动，和关闭顺序非常重要
?
关闭：先关primary database,后关闭standby database
启动：先启动standby database to mount,后open primary database. 当然要记得在主备库上先于数据库启动监听哦
?
解决上面的错误例如以下：
一，在standby 端操作：
1，启动监听
[[email?protected] oradata]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 20-JUN-2014 21:13:56
TNSLSNR for Linux: Version 10.2.0.1.0 - Production System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=even.oracle.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=even.oracle.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias???????????????????? LISTENER Version?????????????????? TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date??????????????? 20-JUN-2014 21:13:56 Uptime??????????????????? 0 days 0 hr. 0 min. 0 sec Trace Level?????????????? off Security????????????????? ON: Local OS Authentication SNMP????????????????????? OFF Listener Parameter File?? /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Listener Log File???????? /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log Listening Endpoints Summary... ? (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=even.oracle.com)(PORT=1521))) Services Summary... Service "OMR" has 1 instance(s). ? Instance "OMR",status UNKNOWN,has 1 handler(s) for this service... Service "SBDB" has 1 instance(s). ? Instance "SBDB",has 1 handler(s) for this service... Service "SBDB_DGMGRL" has 1 instance(s). ? Instance "SBDB",has 1 handler(s) for this service... The command completed successfully
2，mount standby database
SQL> startup mount; ORACLE instance started.
Total System Global Area? 285212672 bytes Fixed Size????????????????? 1218992 bytes Variable Size????????????? 92276304 bytes Database Buffers????????? 188743680 bytes Redo Buffers??????????????? 2973696 bytes Database mounted.
?
二，在primary 端操作
1，启动监听
[[email?protected] ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 12-DEC-2012 23:21:20
TNSLSNR for Linux: Version 10.2.0.1.0 - Production System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vmoel5u4.oracle.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vmoel5u4.oracle.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias???????????????????? LISTENER Version?????????????????? TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date??????????????? 12-DEC-2012 23:21:20 Uptime??????????????????? 0 days 0 hr. 0 min. 0 sec Trace Level?????????????? off Security????????????????? ON: Local OS Authentication SNMP????????????????????? OFF Listener Parameter File?? /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Listener Log File???????? /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log Listening Endpoints Summary... ? (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vmoel5u4.oracle.com)(PORT=1521))) Services Summary... Service "DUPROD" has 1 instance(s). ? Instance "DUPROD",has 1 handler(s) for this service... Service "PLSExtProc" has 1 instance(s). ? Instance "PLSExtProc",has 1 handler(s) for this service... Service "PROD" has 1 instance(s). ? Instance "PROD",has 1 handler(s) for this service... Service "PROD_DGMGRL" has 1 instance(s). ? Instance "PROD",has 1 handler(s) for this service... The command completed successfully
2，打开primary数据库
SQL> startup ; ORACLE instance started.
Total System Global Area? 314572800 bytes Fixed Size????????????????? 1219160 bytes Variable Size????????????? 88081832 bytes Database Buffers????????? 222298112 bytes Redo Buffers??????????????? 2973696 bytes Database mounted. Database opened.
