oracle 19c pdb搭建adg,ASM 管理的 Oracle 19C 数据库ADG的搭建及主备切换

-- 主备库Grid及Oracle Home 目录

/u01/app/grid/product/19.0.0/gihome_1

/u01/app/oraInventory

/u01/app/oracle/product/19.0.0/dbhome_1

-- 主库开启强制日志模式、归档模式

SQL> alter database force logging;

SQL> select force_logging from v$database;

SQL> archive log list;

SQL> shutdown immediate

SQL> startup mount

SQL> alter database archivelog;

SQL> alter database open;

SQL> alter system set sga_max_size=180G scope=spfile;

SQL> alter system set sga_target=180G scope=spfile;

SQL> alter system set pga_aggregate_target=30G scope=spfile;

-- 主库查询添加 stby redo logfile

SQL> select group#, members, bytes from v$log;

SQL> select member from v$logfile;

SQL> alter database add standby logfile group 7 ('+DATA') size 1G;

SQL> alter database add standby logfile group 8 ('+DATA') size 1G;

SQL> alter database add standby logfile group 9 ('+DATA') size 1G;

SQL> alter database add standby logfile group 10 ('+DATA') size 1G;

SQL> alter database add standby logfile group 11 ('+DATA') size 1G;

SQL> alter database add standby logfile group 12 ('+DATA') size 1G;

SQL> alter database add standby logfile group 13 ('+DATA') size 1G;

-- 分别在主备库配置监听并启动,直接使用 netmgr 工具生成 添加如下内容

$ vi listener.ora

-- prmy

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = ynsb)

(ORACLE_HOME =/u01/app/oracle/product/19.0.0/dbhome_1)

(SID_NAME = ynsb)

)

)

-- stby

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOB