I don't have a problem switching logfiles.  I get the errors when I issue the command

"alter database commit to switchover to standby with session shutdown;"

 

I'm thinking that when you have SE, you're not allowed to do the switch because you can't define a log_archive_dest_n.  Poked around some more and found a document "Graceful Switchover and Switchback" for versions 7.3,8.0,8.1.  It might be what I need to do.  Haven't read the entire doc yet though.

 

How did you do a graceful switchover on your SE databases?  What about a failover?

 

Sandy

 

On 7/11/07, Neil Overend <neiloverend@gmail.com > wrote:

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.