ADG搭建

1 查看主库状态

select database_role, protection_mode from v$database;
select name,db_unique_name,database_role,open_mode,dbid,protection_mode from v$database
select force_logging from v$database;
archive log list
select group#, bytes/1024/1024 from v$log;

2 备库-配置静态监听

vi listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl19c)
      (ORACLE_HOME = /home/oracle/soft/19.3.0)
      (SID_NAME = orcl19c)
    )
  )

lsnrctl stop
lsnrctl start

3 主备库-配置TNS

vi tnsname.ora

19cbak =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 19cbak )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl19c)
    )
  )

recover =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = recover )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl19c)
    )
  )

tnsping recover

4 主库-口令文件

scp $ORACLE_HOME/dbs/orapworcl19c recover:$ORACLE_HOME/dbs/orapworcl19c
输入密码

5 主库-参数文件

create pfile='/home/oracle/pfile.woqu' from spfile;

修改下列参数

vi $ORACLE_HOME/dbs/initorcl19c.ora

db_name='orcl19c'
db_unique_name='recover'
db_create_file_dest='/data/orcl19c'
db_create_online_log_dest_1='/data/orcl19c'
log_archive_dest_1='location=/arch/orcl19c'
control_files='/data/orcl19c/control01.ctl'
log_archive_config='dg_config=(recover, 19cbak)'
audit_file_dest='/opt/oracle/admin/orcl19c/adump'
service_names=recover
log_archive_dest_2='service=recover db_unique_name=recover reopen=30 compression=enable valid_for=(all_logfiles, primary_role)'
db_files=2000
processes=1000
db_writer_processes=16
cpu_count=60
cpu_min_count='60'
filesystemio_options='SETALL'
sga_target=180G

scp /home/oracle/pfile.woqu recover:$$ORACLE_HOME/dbs/initorcl19c.ora

6 备库-创建相关命令

mkdir /data/orcl19c
mkdir /arch/orcl19c
mkdir -p /opt/oracle/admin/orcl19c/adump

7 备库-启动到nomount

export $ORACEL_SID=orcl12c
startup nomount pfile='$ORACLE_HOME/dbs/initorcl19c.ora';
或
create spfile from spfile;
startup nomount;

8 主库-活动数据库复制

rman target 'sys/"oracle_4U"' auxiliary 'sys/"oracle_4U"@recover'

configure device type disk parallelism 96;
show all;
duplicate target database for standby from active database dorecover;

9 主库-修改参数

alter system set log_archive_config = 'dg_config=(19cbak,recover)';
alter system set log_archive_dest_2='SERVICE=recover LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=recover';

alter system set log_archive_dest_state_2=defer;
alter system set log_archive_dest_state_2=enable;
show parameter log_archive_config
show parameter log_archive_dest_2

ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE {AVAILABILITY | PERFORMANCE | PROTECTION};

10 备库-修改参数，启动备库

show parameter log_archive_config
show log_archive_dest_2

alter system set log_archive_config = 'dg_config=(recover,19cbak)';
alter system set log_archive_dest_2 = 'service=10cbak lgwr async valid_for=(online_logfile,primary_role) db_unique_name=19cbak';

alter database open
alter database recover managed standby database using current logfile disconnect from session;

11 主库-手动切一次归档

alter system switch logfile;