DATAGURAD主库
系统:solaris 10
数据库:10.2.0.4 RAC ASM
备库:
物理备库
其注册在11G的监听上。
注:该备库主机上有一套11GRAC还有10G的备库。
以下是详细处理过程:
1、重做日志不能同步至备库,ALERT日志中报如下错:
Tue May 6 09:34:50 2014
Errors in file /oracle/admin/dbrac/bdump/dbrac1_lns1_23898.trc:
ORA-12170: TNS:Connect timeout occurred
LNS: Failed to archive log 32 thread 1 sequence 206745 (12170)
Tue May 6 09:38:55 2014
Error 12170 received logging on to the standby
Tue May 6 09:38:55 2014
Errors in file /oracle/admin/dbrac/bdump/dbrac1_arc3_8899.trc:
ORA-12170: TNS:Connect timeout occurred
FAL[server, ARC3]: Error 12170 creating remote archivelog file 'dbrac_standby'
FAL[server, ARC3]: FAL archive failed, see trace file.
2、通过排查,备库IP能通,TNS配置正常,由于备库的监听HANG住,
a、查看备库监听状态发现监听HANG住
bash-3.00$ lsnrctl status
LSNRCTL for Solaris: Version 11.2.0.3.0 - Production on 06-MAY-2014 10:09:22
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
^C 《《===========查看监听状态一直卡住,只能CTRL+C
bash-3.00$ which lsnrctl
/oracle/app/db/product/11.2.0/db/bin/lsnrctl
bash-3.00$ lsnrctl stop
LSNRCTL for Solaris: Version 11.2.0.3.0 - Production on 06-MAY-2014 10:10:32
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
^C 《《===========停掉监听一直卡住,只能CTRL+C
bash-3.00$
b、将监听进程予以kill重启后,重做日志能正常同步至备库。
bash-3.00$ ps -ef |grep lsnr
oracle 22160 1 0 Apr 06 ? 1:56 /oracle/app/asm/11.2.0/grid/bin/tnslsnr LISTENER -inherit
oracle 26696 23355 0 10:10:09 pts/5 0:00 grep lsnr
oracle 13109 1 3 Apr 11 ? 2696:02 /oracle/app/db/product/11.2.0/db/bin/tnslsnr LISTENER -inherit
bash-3.00$ kill -9 13109
bash-3.00$ lsnrctl start
LSNRCTL for Solaris: Version 11.2.0.3.0 - Production on 06-MAY-2014 10:10:59
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /oracle/app/db/product/11.2.0/db/bin/tnslsnr: please wait...
TNSLSNR for Solaris: Version 11.2.0.3.0 - Production
Log messages written to /oracle/app/db/product/11.2.0/db/log/diag/tnslsnr/dbbak1/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbbak1)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.3.0 - Production
Start Date 06-MAY-2014 10:10:59
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /oracle/app/db/product/11.2.0/db/log/diag/tnslsnr/dbbak1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbbak1)(PORT=1521)))
The listener supports no services
The command completed successfully
bash-3.00$
bash-3.00$ lsnrctl status
LSNRCTL for Solaris: Version 11.2.0.3.0 - Production on 06-MAY-2014 10:11:06
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.3.0 - Production
Start Date 06-MAY-2014 10:10:59
Uptime 0 days 0 hr. 0 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /oracle/app/db/product/11.2.0/db/log/diag/tnslsnr/dbbak1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbbak1)(PORT=1521)))
The listener supports no services
The command completed successfully
bash-3.00$
bash-3.00$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue May 6 10:11:19 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> alter system register;
System altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
bash-3.00$ lsnrctl status
LSNRCTL for Solaris: Version 11.2.0.3.0 - Production on 06-MAY-2014 10:11:35
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.3.0 - Production
Start Date 06-MAY-2014 10:10:59
Uptime 0 days 0 hr. 0 min. 36 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /oracle/app/db/product/11.2.0/db/log/diag/tnslsnr/dbbak1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbbak1)(PORT=1521)))
Services Summary...
Service "dbtest" has 1 instance(s).
Instance "dbtest1", status READY, has 1 handler(s) for this service...
Service "dbtestXDB" has 1 instance(s).
Instance "dbtest1", status READY, has 1 handler(s) for this service...
The command completed successfully
bash-3.00$
bash-3.00$ lsnrctl status
LSNRCTL for Solaris: Version 11.2.0.3.0 - Production on 06-MAY-2014 10:12:33
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.3.0 - Production
Start Date 06-MAY-2014 10:10:59
Uptime 0 days 0 hr. 1 min. 34 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /oracle/app/db/product/11.2.0/db/log/diag/tnslsnr/dbbak1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbbak1)(PORT=1521)))
Services Summary...
Service "dbrac" has 1 instance(s).
Instance "dbrac1", status READY, has 1 handler(s) for this service...
Service "dbrac" has 1 instance(s).
Instance "dbrac1", status READY, has 1 handler(s) for this service...
Service "dbrac_standby" has 1 instance(s).
Instance "dbrac1", status READY, has 1 handler(s) for this service...
Service "dbrac_standby_XPT" has 1 instance(s).
Instance "dbrac1", status READY, has 1 handler(s) for this service...
Service "dbtest" has 1 instance(s).
Instance "dbtest1", status READY, has 1 handler(s) for this service...
Service "dbtestXDB" has 1 instance(s).
Instance "dbtest1", status READY, has 1 handler(s) for this service...
The command completed successfully
备库监听恢复正常,检查主库ALERT日志,主库重做日志传输正常,详细如下:
LNS: Standby redo logfile selected for thread 1 sequence 203309 for destination LOG_ARCHIVE_DEST_2
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30633755/viewspace-2127678/
,如需转载,请注明出处,否则将追究法律责任。