1 、 环境信息

2 、主库配置

2.1 主库开启归档模式

SHELL> su - oracle

SQL> archive log list;

-- 未开启归档，通过下面命令开启

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter system set log_archive_dest_1='location=+arch';

SQL> alter database open;

2.2 主库开启 force logging

SHELL> su - oracle

SQL> select force_logging from v$database;

-- 未开启强日志，通过下面命令开启

SQL> alter database force logging;

2.3 备库 1 节点开启静态监听

SHELL> su - grid

SHELL> vi $ORACLE_HOME/network/admin/listener.ora

LISTERNER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.19)(PORT = 11521))

    )

  )

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC=

        (GLOBAL_DBNAME=zborcl)

        (ORACLE_HOME=/u01/app/oracle/product/19c/db)

        (SID_NAME=orcl)

    )

   )

SHELL> lsnrctl stop

SHELL> lsnrctl start

SHELL> srvctl config listener

SHELL> srvctl modify listener -l LISTENER -p "TCP:11521"

注意此处的 TCP/IP 的监听端口

2.4 主双节点、备单节点配置连接串

SHELL> su – oracle

SHELL> vi  $ORACLE_HOME/network/admin/tnsnames.ora

orcl1 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.17)(PORT = 11521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

      (INSTANCE_NAME=orcl1)

    )

  )

orcl2 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.18)(PORT = 11521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

      (INSTANCE_NAME=orcl2)

    )

  )

zborcl =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.19)(PORT = 11521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = zborcl)

    )

  )

Shll> tnsping zborcl

Shll> tnsping orcl1

Shll> tnsping orcl2

2.5 主库修改参数配置

-- 备份spfile

SQL> create pfile='/tmp/initorcl_1120.ora' from spfile;

-- 修改参数

SQL> alter system set standby_file_management=auto scope=both sid='*';

SQL> alter system set log_archive_config="DG_CONFIG=(orcl,zborcl)" scope=both sid='*';

SQL> ALTER SYSTEM set LOG_ARCHIVE_DEST_STATE_2=DEFER scope=both sid='*';

SQL> alter system set log_archive_dest_2='SERVICE=zborcl LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=zborcl COMPRESSION=enable' scope=both sid='*';

SQL> alter system set fal_server='zborcl' scope=both sid='*';

SQL> alter system set fal_client='orcl1' scope=both sid='orcl1';

SQL> alter system set fal_client='orcl2' scope=both sid='orcl2';

-- 路径一致，未配置convert

2.6 主库添加 standby 日志

SQL> alter database add standby logfile thread 1 group 25'+STANDBY_LOG/ORCL/standby01.log' size 8192m;

SQL> alter database add standby logfile thread 1 group 26'+STANDBY_LOG/ORCL/standby02.log' size 8192m;

SQL> alter database add standby logfile thread 1 group 27'+STANDBY_LOG/ORCL/standby03.log' size 8192m;

SQL> alter database add standby logfile thread 1 group 28'+STANDBY_LOG/ORCL/standby04.log' size 8192m;

SQL> alter database add standby logfile thread 1 group 29'+STANDBY_LOG/ORCL/standby05.log' size 8192m;

SQL> alter database add standby logfile thread 1 group 30'+STANDBY_LOG/ORCL/standby06.log' size 8192m;

SQL> alter database add standby logfile thread 1 group 31'+STANDBY_LOG/ORCL/standby07.log' size 8192m;

SQL> alter database add standby logfile thread 1 group 32'+STANDBY_LOG/ORCL/standby08.log' size 8192m;

SQL> alter database add standby logfile thread 1 group 33'+STANDBY_LOG/ORCL/standby09.log' size 8192m;

SQL> alter database add standby logfile thread 1 group 34'+STANDBY_LOG/ORCL/standby10.log' size 8192m;

SQL> alter database add standby logfile thread 1 group 35'+STANDBY_LOG/ORCL/standby11.log' size 8192m;

SQL> alter database add standby logfile thread 1 group 36'+STANDBY_LOG/ORCL/standby12.log' size 8192m;

SQL> alter database add standby logfile thread 1 group 37'+STANDBY_LOG/ORCL/standby13.log' size 8192m;

SQL> alter database add standby logfile thread 2 group 38'+STANDBY_LOG/ORCL/standby14.log' size 8192m;

SQL> alter database add standby logfile thread 2 group 39'+STANDBY_LOG/ORCL/standby15.log' size 8192m;

SQL> alter database add standby logfile thread 2 group 40'+STANDBY_LOG/ORCL/standby16.log' size 8192m;

SQL> alter database add standby logfile thread 2 group 41'+STANDBY_LOG/ORCL/standby17.log' size 8192m;

SQL> alter database add standby logfile thread 2 group 42'+STANDBY_LOG/ORCL/standby18.log' size 8192m;

SQL> alter database add standby logfile thread 2 group 43'+STANDBY_LOG/ORCL/standby19.log' size 8192m;

SQL> alter database add standby logfile thread 2 group 44'+STANDBY_LOG/ORCL/standby20.log' size 8192m;

SQL> alter database add standby logfile thread 2 group 45'+STANDBY_LOG/ORCL/standby21.log' size 8192m;

SQL> alter database add standby logfile thread 2 group 46'+STANDBY_LOG/ORCL/standby22.log' size 8192m;

SQL> alter database add standby logfile thread 2 group 47'+STANDBY_LOG/ORCL/standby23.log' size 8192m;

SQL> alter database add standby logfile thread 2 group 48'+STANDBY_LOG/ORCL/standby24.log' size 8192m;

SQL> alter database add standby logfile thread 2 group 49'+STANDBY_LOG/ORCL/standby25.log' size 8192m;

SQL> alter database add standby logfile thread 2 group 50'+STANDBY_LOG/ORCL/standby26.log' size 8192m;