Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

Re: Standard Edition standby database

Neil Overend

2007-07-11

Replies:

I've had a few 9204, 9207 and 9208 SE databases (Linux and Windows
2000) running with standbys.

These settings work for us
log_archive_dest                 directory path
log_archive_duplex_dest        directory path on different disk
log_archive_start                TRUE
log_archive_max_processes   2

we switch logs using a dbms_job

EXECUTE IMMEDIATE 'ALTER SYSTEM SWITCH LOGFILE' ;

make sure you grant alter system directly to the owner of the job (not
via a role).

Use "alter system archive log current" if you script the logswitch and
log transfer as the first statement returns immediatley (i.e your
script could carry on while the archive log is being written) but the
second statement only returns after the archive log is actually
written.

Hope this helps, it's always worked for us.
--
http://www.freelists.org/webpage/oracle-l


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.