Re: Standard Edition standby database

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