OracleDG-build PhysicalStandby

OracleDG-build PhysicalStandby system environment: Operating System: RedHatEL4Oracle: Oracle10.2.0.1.0 ..

OracleDG-build PhysicalStandby system environment: Operating System: RedHatEL4Oracle: Oracle10.2.0.1.0 ..

Oracle DG -- building Physical Standby

System Environment:

Operating System: RedHat EL4

Oracle: Oracle 10.2.0.1.0

As shown in the middle: the master database is bj (db_unique_name), and the slave database is sh.

Case Analysis:

This case uses RMAN Duplicate to create a standby database.

1. Configure Master/Slave database initialization parameters

Initialization parameter of the master database: initbj. ora

[Oracle @ ocmtest dbs] $ more initbj. ora *. audit_file_dest = '/u01/app/oracle/admin/bj/adump '*. background_dump_dest = '/u01/app/oracle/admin/bj/bdump '*. compatible = '10. 2.0.1.0 '*. control_files = '/u01/app/oracle/oradata/bj/control01.ctl', '/u01/app/oracle/oradata/bj/control02.ctl ', '/u01/app/oracle/oradata/bj/control03.ctl '*. core_dump_dest = '/u01/app/oracle/admin/bj/cdump '*. db_block_size = 8192 *. db_domain = ''*. db_file_multiblock_read_count = 16 *. db_name = 'bj '*. db_recovery_file_dest = '/u01/app/oracle/flash_recovery_area '*. db_recovery_file_dest_size = 2147483648 *. dispatchers = '(PROTOCOL = TCP) (SERVICE = bjXDB )'*. job_queue_processes = 10 *. open_cursors = 300 *. pga_aggregate_target = 68157440 *. processes = 150 *. remote_login_passwordfile = 'clusive '*. sga_target = 205520896 *. undo_management = 'auto '*. undo_tablespace = 'undotbs1 '*. user_dump_dest = '/u01/app/oracle/admin/bj/udump'

The following are the parameters for configuring DG:

DB_UNIQUE_NAME = bjLOG_ARCHIVE_CONFIG = 'dg _ CONFIG = (bj, sh) 'Log _ ARCHIVE_DEST_1 = 'location =/u01/disk1/arch/bj/VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = bj 'log_archive_dest_2 = 'service = sh lgwr async VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = sh 'partition = encoding = ENABLEREMOTE_LOGIN_PASSWORDFILE = encoding = 3FAL_SERVER = shFAL_CLIENT = bjDB_FILE_NAME_CONVERT = '/u01/app/oracle/oradata/sh /', '/u01/app/oracle/oradata/bj/'log_file_name_convert ='/u01/app/oracle/oradata/sh /', '/u01/app/oracle/oradata/bj/' STANDBY_FILE_MANAGEMENT = AUTO

Backup database initialization parameter: initsh. ora

[Oracle @ ocmtest1 dbs] $ more initsh. ora *. audit_file_dest = '/u01/app/oracle/admin/sh/adump '*. background_dump_dest = '/u01/app/oracle/admin/sh/bdump '*. compatible = '10. 2.0.1.0 '*. control_file_record_keep_time = 7 *. control_files = '/u01/app/oracle/oradata/sh/control01.ctl', '/u01/app/oracle/oradata/sh/control02.ctl ', '/u01/app/oracle/oradata/sh/control03.ctl '*. core_dump_dest = '/u01/app/oracle/admin/sh/cdump '*. db_block_size = 8192 *. db_domain = ''*. db_file_multiblock_read_count = 16 *. DB_FILE_NAME_CONVERT = '/u01/app/oracle/oradata/bj/', '/u01/app/oracle/oradata/sh /'*. db_name = 'bj '*. db_recovery_file_dest = '/u01/app/oracle/flash_recovery_area '*. db_recovery_file_dest_size = 2147483648 *. open_cursors = 300 *. pga_aggregate_target = 68157440 *. processes = 150 *. REMOTE_LOGIN_PASSWORDFILE = 'clusive '*. sga_target = 205520896 *. undo_management = 'auto '*. undo_tablespace = 'undotbs1 '*. user_dump_dest = '/u01/app/oracle/admin/sh/udump'

The following are the parameters for configuring DG:

*. DB_UNIQUE_NAME = 'sh '*. FAL_CLIENT = 'sh '*. FAL_SERVER = 'bj '*. job_queue_processes = 10 *. LOG_ARCHIVE_CONFIG = 'dg _ CONFIG = (bj, sh )'*. LOG_ARCHIVE_DEST_1 = 'location =/u01/disk1/arch/sh/VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = Sh '*. LOG_ARCHIVE_DEST_2 = 'service = bj lgwr async VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = bj '*. LOG_ARCHIVE_DEST_STATE_1 = 'enable '*. LOG_ARCHIVE_DEST_STATE_2 = 'enable '*. log_archive_format = 'arch _ % t _ % s _ % r. log '*. LOG_ARCHIVE_MAX_PROCESSES = 3 *. LOG_FILE_NAME_CONVERT = '/u01/app/oracle/oradata/bj/', '/u01/app/oracle/oradata/sh /'*. STANDBY_FILE_MANAGEMENT = 'auto'

2. Create standby logs on the master database

Standby redo logfiles is not required for the default maximum performance protection mode. However, standby redo logfiles can be created to better store redo logs. The number of standby redo log groups should be equal to or greater than the number of redo logs, the log size should be consistent. SQL> alter database add standby logfile group 4 ('/u01/app/oracle/oradata/bj/redo04.log') size 50 m; SQL> alter database add standby logfile group 5 ('/u01/app/oracle/oradata/bj/redo05.log. rdo ') size 50 m; SQL> alter database add standby logfile group 6 ('/u01/app/oracle/oradata/bj/redo06.log') size 50 m;