随笔 - 404  文章 - 4  评论 - 0  阅读 - 25万

开启Oracle11.2.0.4 DG库的克隆库

开启Oracle11.2.0.4 DG库的克隆库

  • (1)演练库启动到mount

SQL> startup mount;

  • (2)备库停止日志接受并完成已收日志应用

SQL> alter database recover managed standby database finish;

  • (3)检查备库状态

SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
TO PRIMARY
SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS
---------------- ------------
orcl MOUNTED

  • (4)备库切为主库

SQL> alter database commit to switchover to PRIMARY with session shutdown;

Database altered.

SQL> alter database open;

Database altered.
SQL> select open_mode,database_role,db_unique_name from v$database;

OPEN_MODE DATABASE_ROLE DB_UNIQUE_NAME
-------------------- ---------------- ------------------------------
READ WRITE PRIMARY orcldg

  • (5)修改实例名、取掉DG配置

SQL> alter system set log_archive_dest_state_2=defer;

System altered.
SQL> alter system set job_queue_processes=400;

System altered.
SQL> alter system set service_names=orclyldb;

System altered.
SQL> alter system set db_unique_name=orclyldb scope=spfile;

System altered.
SQL> alter system set log_archive_dest_1='location=/u01/app/oracle/archivelog';

System altered.
SQL> alter system set log_archive_config='';

System altered.

SQL> alter system set log_archive_dest_2='';

System altered.

SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup;

$ ll
total 8
drwxr-xr-x 3 oracle oinstall 4096 Apr 11 22:30 orcldg
drwxr-xr-x 3 oracle oinstall 4096 May 6 10:14 orclyldb
[oracle@8202-orclzbdb rdbms]$ rm -rf orcldg

  • (6)配置监听文件

$ cat listener.ora
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST= 10.172.11.242)(PORT=1521))
))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=orcl)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME=orcl)
)
)

$ cat tnsnames.ora
orclyldb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.172.11.242)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

  • (7)状态检查:

字符集: ZHS16GBK
配置RMAN,清理归档
RMAN> DELETE ARCHIVELOG ALL;
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;


$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 06-MAY-2022 10:40:15

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.172.11.242)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 06-MAY-2022 10:08:15
Uptime 0 days 0 hr. 32 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/8202-orclzbdb/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.172.11.242)(PORT=1521)))
Services Summary...
Service "orclyldb" has 2 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for torcl service...
Instance "orcl", status READY, has 1 handler(s) for torcl service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for torcl service...
The command completed successfully

posted on   HelonTian  阅读(152)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· SQL Server 2025 AI相关能力初探
· AI编程工具终极对决:字节Trae VS Cursor,谁才是开发者新宠?
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
< 2025年3月 >
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5

点击右上角即可分享
微信分享提示