3
Oracle 11G ADG switchover切换演练V1.1.docx
10墨值下载
Oracle 11G ADG switchover
切换演练
1.
基础环境检查
1.1
主库检查
1.1.1
参数检查
SQL> set lines 200
SQL> col name for a25
SQL> col value for a96
SQL> select name,value from v$parameter where name in ('log_archive_config','log_archive_dest_2','log_archive_dest_state_2');
NAME VALUE
------------------------- -----------------------------------------------------------------------------------------
log_archive_dest_2 service= zhcdbdg lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=zhcdbdg
log_archive_dest_state_2 enable
log_archive_config DG_CONFIG=(zhcdb,zhcdbdg)
SQL>
1.1.2
监听检查
[oracle@clobdb02 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 12-JUN-2024 16:38:22
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.106.127.6)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 19-APR-2024 10:28:08
Uptime 54 days 6 hr. 10 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0.4/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/clobdb02/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.106.127.6)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "oggdb001" has 1 instance(s).
Instance "oggdb002", status READY, has 1 handler(s) for this service...
Service "oggdb001XDB" has 1 instance(s).
Instance "oggdb002", status READY, has 1 handler(s) for this service...
Service "oggdb002" has 1 instance(s).
Instance "oggdb002", status READY, has 1 handler(s) for this service...
Service "zhcdbXDB" has 1 instance(s).
Instance "zhcdbdg", status READY, has 1 handler(s) for this service...
Service "zhcdbdg" has 2 instance(s).
Instance "zhcdbdg", status UNKNOWN, has 1 handler(s) for this service...
Instance "zhcdbdg", status READY, has 1 handler(s) for this service...
The command completed successfully
1.2
备库参数查看
1.2.1
参数检查
SQL> set lines 200
SQL> col name for a25
SQL> col value for a92
SQL> select name,value from v$parameter where name in ('log_archive_config','log_archive_dest_2','log_archive_dest_state_2');
of 12
10墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论