配置 Primary Database Standby Redo Log
创建 N+1 个 Standby Redo Log File Group,N 等于 Online Redo Log 数量,Size 等于 Online
Redo Log 的 Size
SQL> ALTER DATABASE ADD STANDBY LOGFILE 'D:\oracle\product\10.2.0\oradata\
orcl\redo4.log' SIZE 50M;
SQL>ALTER DATABASE ADD STANDBY LOGFILE 'D:\oracle\product\10.2.0\oradata\
orcl\redo5.log' SIZE 50M;
SQL>ALTER DATABASE ADD STANDBY LOGFILE 'D:\oracle\product\10.2.0\oradata\
orcl\redo6.log' SIZE 50M;
SQL>ALTER DATABASE ADD STANDBY LOGFILE 'D:\oracle\product\10.2.0\oradata\
orcl\redo7.log' SIZE 50M;
验证创建的 standby redo log file groups
SQL> SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM
V$STANDBY_LOG;
配置 Primary Database 的初始化参数
DB_UNIQUE_NAME=primary
LOG_ARCHIVE_CONFIG='DG_CONFIG=(primary,standby)'
LOG_ARCHIVE_DEST_1=
'LOCATION=USE_DB_RECOVERY_FILE_DEST
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=primary'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_2=
'SERVICE=standby LGWR ASYNC REOPEN=30
评论1
最新资源