开启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