Data Guard Broker 19c(完整)

hostnamectl set-hostname ol7-19-dg1

yum install -y oracle-database-preinstall-19c

 passwd oracle

vim /etc/selinux/config

 

 systemctl stop firewalld

systemctl disable firewalld

mkdir -p /u01/app/oracle/product/19.0.0/db_1

chown -R oracle:oinstall /u01

chmod -R 775 /u01

 

 mkdir /home/oracle/scripts

cat > /home/oracle/scripts/setEnv.sh <<EOF
# Oracle Settings
export TMP=/tmp
export TMPDIR=\$TMP

export ORACLE_HOSTNAME=ol7-19-dg1
export ORACLE_UNQNAME=cdb1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/19.0.0/db_1
export ORA_INVENTORY=/u01/app/oraInventory
export ORACLE_SID=cdb1
export PDB_NAME=pdb1

export PATH=/usr/sbin:/usr/local/bin:\$PATH
export PATH=\$ORACLE_HOME/bin:\$PATH

export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib
EOF

echo ". /home/oracle/scripts/setEnv.sh" >> /home/oracle/.bash_profile

 

 chown -R oracle:oinstall /home/oracle/scripts

chmod u+x /home/oracle/scripts/*.sh

mkdir /ruanjian

chown -R oracle:oinstall /ruanjian

chmod -R 775 /ruanjian

 

 env | grep ORA

 cd $ORACLE_HOME

unzip -oq /ruanjian/LINUX.X64_193000_db_home.zip

 

 

 

 

 

yum install kmod

 yum install kmod-libs

 

 

 

 

 

 

 

 

https://ol7-19-dg1:5500/em

 

hostnamectl set-hostname ol7-19-dg2 

 

 

 

SELECT log_mode FROM v$database;

archive log list 

 

 select FORCE_LOGGING,log_mode from v$database;

ALTER DATABASE FORCE LOGGING;

col member for a50

select group#, type, member from v$logfile order by 1;

select GROUP#,BYTES/1024/1024,thread# from v$log;

select GROUP#,BYTES/1024/1024,thread# from v$standby_log;

 

 ALTER SYSTEM SWITCH LOGFILE;

 ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 10 ('/u01/app/oracle/oradata/cdb1/standby_redo01.log') SIZE 200M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 11 ('/u01/app/oracle/oradata/cdb1/standby_redo02.log') SIZE 200M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 12 ('/u01/app/oracle/oradata/cdb1/standby_redo03.log') SIZE 200M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 13 ('/u01/app/oracle/oradata/cdb1/standby_redo04.log') SIZE 200M;

ALTER DATABASE FLASHBACK ON;

 

 show parameter standby_file_management

alter system set standby_file_management=auto;

show parameter db_name
show parameter db_unique_name

 vim $ORACLE_HOME/network/admin/tnsnames.ora

cdb1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ol7-19-dg1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = cdb1)
    )
  )

cdb1_stby =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ol7-19-dg2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = cdb1)
    )
  )

vim $ORACLE_HOME/network/admin/listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = cdb1_DGMGRL)
      (ORACLE_HOME = /u01/app/oracle/product/19.0.0/db_1)
      (SID_NAME = cdb1)
      (ENVS="TNS_ADMIN=/u01/app/oracle/product/19.0.0/db_1/network/admin")
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

 

vim $ORACLE_HOME/network/admin/listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ol7-19-dg2)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = cdb1_stby_DGMGRL)
      (ORACLE_HOME = /u01/app/oracle/product/19.0.0/db_1)
      (SID_NAME = cdb1)
      (ENVS="TNS_ADMIN=/u01/app/oracle/product/19.0.0/db_1/network/admin")
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

lsnrctl stop

lsnrctl start

 

 tnsping ol7-19-dg2

tnsping ol7-19-dg1

vim /tmp/initcdb1_stby.ora

*.db_name='cdb1'

mkdir -p /u01/app/oracle/oradata/cdb1/pdbseed

mkdir -p /u01/app/oracle/oradata/cdb1/pdb1

mkdir -p /u01/app/oracle/fast_recovery_area/CDB1

mkdir -p /u01/app/oracle/admin/cdb1/adump

cd $ORACLE_HOME/dbs

scp orapwcdb1 ol7-19-dg2:$ORACLE_HOME/dbs

export ORACLE_SID=cdb1

sqlplus / as sysdba

STARTUP NOMOUNT PFILE='/tmp/initcdb1_stby.ora';

rman TARGET sys/Password1@cdb1 AUXILIARY sys/Password1@cdb1_stby

 

 DUPLICATE TARGET DATABASE

  FOR STANDBY

  FROM ACTIVE DATABASE

  DORECOVER

  SPFILE

    SET db_unique_name='cdb1_stby' COMMENT 'Is standby'

  NOFILENAMECHECK;

 

 

 show parameter dg_broker_start

ALTER SYSTEM SET dg_broker_start=true;

 

 

dgmgrl sys/Password1@cdb1

CREATE CONFIGURATION my_dg_config AS PRIMARY DATABASE IS cdb1 CONNECT IDENTIFIER IS cdb1;

ADD DATABASE cdb1_stby AS CONNECT IDENTIFIER IS cdb1_stby MAINTAINED AS PHYSICAL;

ENABLE CONFIGURATION;

 

 

 

 

 

SHOW DATABASE cdb1_stby;