Shulou(Shulou.com)06/01 Report--

Environment description:

Objective:

(1) create an oracle 12c single instance dataguard environment under the linux operating system

(2) Test dataguard master-slave switching

Main library: 10.50.115.12 (DB_UNIQUE_NAME=cdbtest,service_name=cdbtest,db_name=cdbtest)

Slave Library: 10.50.115.20 (DB_UNIQUE_NAME=cdbtest1,service_name=cdbtest,db_name=cdbtest)

Remarks: DB_UNIQUE_NAME cannot be the same.

Create a dataguard environment for a single instance of oracle 12c

Main library:

Mkdir-p / u01/app/oracle/arch/

Chown oracle.oinstall / u01/app/oracle/arch/

1. Turn on archiving mode

Sqlplus / as sysdba

Startup mount

Alter database archivelog

Alter database open

two。 Configure TNS to increase the tns connected to the slave library:

Cat > > $ORACLE_HOME/network/admin/tnsnames.ora > $ORACLE_HOME/network/admin/tnsnames.ora

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.