Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Guard protection modes

user5913719Jan 19 2012 — edited Jan 20 2012
Hi,

I have an Oracle Database 11.2.0.1 database and I'm trying some things regarding protection modes for education purposes.

I've configured a physical standby database with standby redo log files.

At primary side the redo transport service is configured asynchronous:
log_archive_dest_2='SERVICE=lcro async valid_for=(online_logfiles, primary_role) db_unique_name=lcro'

And now I stopped the primary database and switched it to the MAXIMUM AVAILABLITY mode (in this mode redo transport service should be synchronous and affirm but as you see it isn't):

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
Database mounted.
SQL> alter database set STANDBY DATABASE TO MAXIMIZE AVAILABLITY;
Database altered.
SQL> alter database open;
Database altered.

Database says that it is in MAXIMUM AVAILABLITY mode but can this be true because of the log_archive_dest_2 parameter? What will Oracle do now and why is there no warning or something like that?

Thank you.

Best regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 17 2012
Added on Jan 19 2012
5 comments
2,391 views