-- 主备库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