Oracle Database Discussions

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!

LGWR ASYNC doest not working for redolog files, while archiving is working

Hassan R. KhanOct 21 2009 — edited Oct 31 2009

Hi All,

I am using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0.

I have created a database named black. I then creaetd a standby database. now I want to syncronize the redo logs file as well.
SO I added log_archive_dest_2='SERVICE=standby LGWR ASYNC',
I have also added following standby log files on standby database.
ALTER DATABASE ADD STANDBY LOGFILE '/oracle/oradata/black/srl1.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE '/oracle/oradata/black/srl2.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE '/oracle/oradata/black/srl3.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE '/oracle/oradata/black/srl4.f' SIZE 52428800;

Now I want to confirm that the redo log files are syncronizing same time on both Primary and Standby. I have checked thru alter system switch logfile; when i executed the redo log sync at both sides.
Archive logs are also applying successfully.

The Primary database is in MAXIMUM PERFORMANCE Mode;

Regards,

Hassan

This post has been answered by orawarebyte on Oct 30 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 28 2009

Added on Oct 21 2009

#general-database-discussions

17 comments

4,482 views