Oracle Data Guard Create a physical standby database

Oracle Data Guard Create a physical standby database

Create a physical repository

Machine name A1 A2

ip:192.168.1.10 192.168.1.20

Net_name A1 A2

SID A1 A2

Db_unique_name A1 A2

Note: Create the database A1 on the master node, install only Oracle software on the standby node and do not create any databases;

1. Configure Listener.ora

Master node Listener.ora:

Sid_list_listener=

(sid_list=

(sid_desc=

(GLOBAL_DBNAME=A1)

(oracle_home=/u01/app/oracle/product/11.2.0/db_1)

(SID_NAME=A1)

)

)

LISTENER =

(address_list=

(Address= (PROTOCOL=TCP) (host=192.168.1.10) (port=1521))

(Address= (PROTOCOL=IPC) (Key=pnpkey))

)

Standby node Listener.ora:

Sid_list_listener=

(sid_list=

(sid_desc=

(GLOBAL_DBNAME=A1)

(oracle_home=/u01/app/oracle/product/11.2.0/db_1)

(SID_NAME=A1)

)

)

LISTENER =

(address_list=

(Address= (PROTOCOL=TCP) (host=192.168.1.20) (port=1521))

(Address= (PROTOCOL=IPC) (Key=pnpkey))

)

2. Configure Tnsnames.ora (same as Tnsname.ora content of primary standby node:)

a1=

(DESCRIPTION =

(Address_list =

(address = (PROTOCOL = TCP) (HOST = 192.168.1.10) (PORT = 1521))

)

(Connect_data =

(service_name = A1)

)

)

A2=

(DESCRIPTION =

(Address_list =

(address = (PROTOCOL = TCP) (HOST = 192.168.1.20) (PORT = 1521))

)

(Connect_data =

(service_name = A2)

)

)

3. Enable archiving in the main library and enable mandatory archiving

Steps 1:alter database force logging;

Archive log list;

Step 2: In the Mount State

ALTER DATABASE Archivelog;

Step 3:alter database open;

Archive log list;

4. Create a password file on the main library

Orapwd file= '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwa1.ora ' password=xyc entries=10

5. Create standby Redo Log

ALTER DATABASE ADD standby logfile

Group 4 ('/u01/app/oracle/oradata/a1/standby_redo04a.log ', '/u01/app/oracle/oradata/a1/standby_redo04b.log ') size 50m,

Group 5 ('/u01/app/oracle/oradata/a1/standby_redo05a.log ', '/u01/app/oracle/oradata/a1/standby_redo05b.log ') size 50m,

Group 6 ('/u01/app/oracle/oradata/a1/standby_redo06a.log ', '/u01/app/oracle/oradata/a1/standby_redo06b.log ') size 50m,

Group 7 ('/u01/app/oracle/oradata/a1/standby_redo07a.log ', '/u01/app/oracle/oradata/a1/standby_redo07b.log ') size 50m;

Note: Oracle recommends that you consider the problem of standby redolog configuration when creating standby. Standby redologs and online redologs

Very similar, it should be said that the two are only different service objects, other parameter properties and even the operation of the command format is almost the same, you are designing standby

Redologs can be used to create online redologs ideas, such as multiple file groups, each group of multiple file redundancy and so on.

In addition, Oracle has provided some standard recommendations as follows: