两个单节点搭建Data Guard

演示例子两个单节点的Data Guard环境，orcl作为Primary，sorcl作为Standby。

 

Oracle databaseversion 11.2.0.4

OS version CentOS release 6.5 (Final)

2、测试环境规划

Primary Database环境

Primary	orcl（生产环境，已开启归档模式）
public IP	192.168.1.201
db_unique_name	orcl
service_names	orcl
INSTANCE	orcl
DB_NAME	orcl

Standby Database环境

standby	sorcl（装好database软件，不建库）
public IP	192.168.1.200
db_unique_name	sorcl
service_names	orcl
INSTANCE	orcl
DB_NAME	orcl

 

3、配置步骤

3.1 检查orcl数据库归档模式是否开启

SQL> archive log list

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     2

Current log sequence           4

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 1486495744 bytes

Fixed Size                  2253384 bytes

Variable Size             452988344 bytes

Database Buffers         1023410176 bytes

Redo Buffers                7843840 bytes

Database mounted.

SQL> alter database archivelog ;

Database altered.

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             E