Oracle 11g DG Build under Linux

Environment: Simulating the creation of the main library use the Install option in the DBCA Start graphical interface option---> select Create and configure a database

Create a mock-up library using the Install option in the DBCA Startup graphical interface option---> Check the install database software only

Preparation using the Oracle 11g Rman feature for database cloning (database cloning ensures that the main and standby repositories are fully consistent with the software)

Main Library (PORCL 192.168.1.11)

Modify Parameter Db_unique_name

Show parameter Db_unique_name;alter system set db_unique_name= ' PORCL ' scope=spfile;shutdown immediate

Turn on database archiving mode

Startup Mountalter database archivelog;alter database open;

Configure a static network (Netmgr's graphical interface is used here)

Add Database service

PORCL SORCL PORCL_DGMGRL

/u01/app/oracle/11g/u01/app/oracle/11g/u01/app/oracle/11g

ORCL ORCL ORCL

Restart monitoring

Configure local name resolution Tnsnames.ora

ORCL-----> 192.168.1.11

PORCL-----> 192.168.1.11

SORCL-----> 192.168.1.10

Creating a parameter file

Create Pfile from SPFile;

Copy parameter file, password file to repository host

SCP Initorcl.ora ORAPWORCL 192.168.1.10:/u01/oracle/11g/dbs/

Add Repository Log

ALTER DATABASE add standby logfile Group 10;alter database add standby logfile Group 11;alter database add standby logfile Group 12;alter Database Add standby logfile Group 13;

Standby library (SORCL 192.168.1.10)

Configure a static network

Add Database service

PORCL SORCL SORCL_DGMGRL

/u01/app/oracle/11g/u01/app/oracle/11g/u01/app/oracle/11g

ORCL ORCL ORCL

Restart monitoring

Configure local name resolution Tnsnames.ora

ORCL-----> 192.168.1.10

PORCL-----> 192.168.1.11

SORCL-----> 192.168.1.10

Modify the parameter file (remote copy of Initorcl.ora)

Place Db_unique_name as Sorcl

(The parameter file directory under the Spfileorcl.ora Delete, if any)

Create the necessary folders

grep "/u01" initupdb.oramkdir/u01/oracle/admin/updb/adump/u01/oracle/oradata/updb/u01/oracle/fast_recovery_area/ Updb-p

Set environment variable Oracle_sid

Export ORACLE_SID=ORCL

Booting to Nomount state using Initorcl.ora

Startup Nomount

Generate SPFile

Create SPFile from Pfile;

Reboot to Nomount state

Startup Force Nomount

Add Repository Log

ALTER DATABASE add standby logfile Group 10;alter database add standby logfile Group 11;alter database add standby logfile Group 12;alter Database Add standby logfile Group 13;

Cloning a repository from the main library

Rman target Sys/[email protected] Auxiliary sys/[email protected]duplicate target database for standby from active Databas E nofilenamecheck;exit

Implementing DG

Set (Master and standby settings) parameter Dg_broker_start=true

alter system set dg_broker_start=true;

Create and take effect configuration files using the DGMGRL command

DGMGRL sys/[email protected]create configuration DGC as primary database is Pupdb;add database supdb as connect identifie R is supdb maintained as physical;enable configuration;show configuration;

Problems that may occur

1. When using Rman to connect to the master repository, the error-----> The network connection to the repository is incorrect, please recheck the network configuration and local name resolution

2. Show configuration library prompts for warning that there is a problem with a property setting for the repository, but there is no problem checking-------> Restart the repository

Oracle 11g DG Build under Linux