Re: Standard Edition standby database
- From: "Neil Overend" <neiloverend@xxxxxxxxx>
- To: sbecker6925@xxxxxxxxx
- Date: Wed, 11 Jul 2007 20:31:37 +0100
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
