Active DataGuard 11gR2 Configuration

1.ADG Configuration

1-1 Primary DB

Primary     SQL> select dest_name,status from v$archive_dest_status where dest_name in ('LOG_ARCHIVE_DEST_1','LOG_ARCHIVE_DEST_2');     DEST_NAME -------------------------------------------------------------------------------- STATUS --------- LOG_ARCHIVE_DEST_1 VALID     LOG_ARCHIVE_DEST_2 VALID

   

1-2 Standby DB

Standby(mount)     SQL> select process,status from v$managed_standby;     PROCESS STATUS --------- ------------ ARCH CONNECTED ARCH CONNECTED ARCH CONNECTED ARCH CLOSING RFS IDLE RFS IDLE RFS IDLE     7 rows selected.     SQL> recover managed standby database using current logfile disconnect from session; Media recovery complete.     SQL> select process,status from v$managed_standby;     PROCESS STATUS --------- ------------ ARCH CONNECTED ARCH CONNECTED ARCH CONNECTED ARCH CLOSING RFS IDLE RFS IDLE RFS IDLE MRP0 APPLYING_LOG     8 rows selected.

   

1-3 Active Standby Database startup

Standby(mount)     SQL> alter database recover managed standby database cancel;     Database altered.     SQL> alter database open;     Database altered.     SQL> select process,status from v$managed_standby;     PROCESS STATUS --------- ------------ ARCH CONNECTED ARCH CONNECTED ARCH CONNECTED ARCH CLOSING RFS IDLE RFS IDLE RFS IDLE     7 rows selected.     SQL> alter database recover managed standby database using current logfile disconnect ;     Database altered.     SQL> select process,status from v$managed_standby;     PROCESS STATUS --------- ------------ ARCH CONNECTED ARCH CONNECTED ARCH CONNECTED ARCH CLOSING RFS IDLE RFS IDLE RFS IDLE MRP0 APPLYING_LOG     rows selected.

   

2.ADG 동작여부확인

Primary DB SQL> select database_role, open_mode from v$database;     DATABASE_ROLE OPEN_MODE ---------------- -------------------- PRIMARY READ WRITE     SQL> select i.instance_name, i.status instance_status, d.name dbname, d.database_role db_role, 2 d.switchover_status switchover_status , d.protection_mode 3 from v$database d, v$instance i;     INSTANCE_NAME INSTANCE_STA DBNAME DB_ROLE SWITCHOVER_STATUS ---------------- ------------ --------- ---------------- -------------------- PROTECTION_MODE -------------------- orcl OPEN ORCL PRIMARY TO STANDBY MAXIMUM PERFORMANCE

Standby DB     SQL> select database_role, open_mode from v$database;     DATABASE_ROLE OPEN_MODE ---------------- -------------------- PHYSICAL STANDBY READ ONLY WITH APPLY     SQL> select i.instance_name, i.status instance_status, d.name dbname, d.database_role db_role, 2 d.switchover_status switchover_status , d.protection_mode 3 from v$database d, v$instance i;     INSTANCE_NAME INSTANCE_STA DBNAME DB_ROLE SWITCHOVER_STATUS ---------------- ------------ --------- ---------------- -------------------- PROTECTION_MODE -------------------- stby OPEN ORCL PHYSICAL STANDBY NOT ALLOWED MAXIMUM PERFORMANCE

   

• Primary alert Log file /Standby alert Log file에서 sequence number가 일치하는지 확인 한다.

     

3.ADG 동기화 확인

• Primary 에서 유저 등록 및 테이블생성과 같은 DB작업을 할 경우, Standby에도 잘 반영이되는지 확인해야 합니다.

SQL > create user test identified by test

SQL > create table test (a char(10)

   

   

[참고문헌]

http://h391106.tistory.com/231

http://docs.oracle.com/cd/B19306_01/server.102/b14239/concepts.htm

http://h391106.tistory.com/238

http://download.oracle.com/docs/cd/E11882_01/server.112/e17023/dgmgrl.htm