setting up Dataguard [message #548847] |
Mon, 26 March 2012 12:50 |
|
BeefStu
Messages: 208 Registered: October 2011
|
Senior Member |
|
|
I am trying to setup DG in a test enviorment. My primary DB (dev1) and my stdby DB (dev2).
my config parameters
initdev1.ora
*.log_archive_config='DG_CONFIG=(dev1,dev2)'
*.log_archive_dest_1='LOCATION=/u02/arch/dev1/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES
) DB_UNIQUE_NAME=dev1'
*.log_archive_dest_2='SERVICE=dev2 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE
) DB_UNIQUE_NAME=dev2'
*.log_archive_dest_state_1=ENABLE
*.log_archive_dest_state_2=ENABLE
*.fal_client=dev1
*.fal_server=dev2
initdev2.ora
============
*.log_archive_dest_1='LOCATION=/u02/arch/dev2 VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=dev2'
*.LOG_ARCHIVE_DEST_2='SERVICE=dev1 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE
) DB_UNIQUE_NAME=dev1'
*.log_archive_dest_state_1=ENABLE
*.log_archive_dest_state_2=ENABLE
*.fal_server=dev1
*.fal_client=dev2
When I bounce the servers I get the following:
SQL> select name, open_mode, protection_mode, database_role, dataguard_broker, force_logging from v$database;
NAME OPEN_MODE PROTECTION_MODE DATABASE_ROLE DATAGUAR
--------- -------------------- -------------------- ---------------- --------
FOR
---
DEV1 READ WRITE MAXIMUM PERFORMANCE PRIMARY DISABLED
NO
SQL> select name, open_mode, protection_mode, database_role, dataguard_broker, force_logging from v$database;
NAME OPEN_MODE PROTECTION_MODE DATABASE_ROLE DATAGUAR
--------- -------------------- -------------------- ---------------- --------
FOR
---
DEV2 READ WRITE MAXIMUM PERFORMANCE PRIMARY DISABLED
NO
I see that DATAGAURD is disabled on both DB's. In additon, I create a simple
table on dev1, add a few rows and commit, switch logfile and I dont' see the
changes come across.
It looks like I a missing something, does anybody know what?
Thanks in advance to all who answer
|
|
|
|
|
|
|
Re: setting up Dataguard [message #551430 is a reply to message #548864] |
Wed, 18 April 2012 04:27 |
|
ceocio
Messages: 1 Registered: April 2012
|
Junior Member |
|
|
I must say first an awesome website www.orafaq.com. I am new to this. @BeefStu, may I have a step by step guide to set up DataGuard.
Any other one is also most welcomed.
|
|
|