problem of physical standby with "service=standby arch sync noaffirm" mode

From: yoke wang <cnwy_at_263.net>
Date: 12 Apr 2005 23:09:27 -0700
Message-ID: <42c18ceb.0504122209.459dec1@posting.google.com>

Hi,

Primary Node
  OS: RAS3 Oracle: 9204

  log_archive_dest:
  log_archive_dest_1:location=/opt/oracle/oradata/orcl/archive
  log_archive_dest_2:service=standby arch sync noaffirm

  archive_lag_target:300

  log_archive_min_succeed_dest:1
  fal_client:
  fal_sever:

&#12288;standby_archive_dest&#65306;?/dbs/arch
&#12288;standby_file_management&#65306;MANUAL

  OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL DATABASE_ROLE

• -------------------- --------------------

  ---

  READ WRITE MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE PRIMARY

Standby Node
  OS: RAS3 Oracle: 9204

  log_archive_dest:/opt/oracle/oradata/orcl/archive
  log_archive_dest_1:
  log_archive_dest_2:

  archive_lag_target:300

  log_archive_min_succeed_dest:1
  fal_client:standby
  fal_sever:primary

&#12288;standby_archive_dest:/opt/oracle/oradata/orcl/standby_archive
&#12288;standby_file_management&#65306;auto

  OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL DATABASE_ROLE

• -------------------- --------------------

  ---

  MOUNTED MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE PHYSICAL STANDBY

  For testing,I disconnected standby node from the network,then repeated the sql 'alter system switch logfile', when I run the sql the third time,the sql lasts about 17 minute.(the primary database has three online redo groups).after that the sql can run fast again.Why?17 minute is too long for a production Environment.   But everything is fine when I just stop the listener of standby node instead of disconnecting it from the network.   

  Any suggestions?
  Thanks.

wy. Received on Wed Apr 13 2005 - 01:09:27 CDT