We are using roll-your-own standby with SE just as you with copying the
archivelogs to the standby server and applying them as you describe. It
never occurred to me to try to use the "alter database commit to
switchover ..." command because I thought (possibly mistakenly) that
that requires dataguard which is not available with SE.
In order to bring up the standby database we use:
Alter database activate standby database; Alter database open;
Hi,
Oracle 9.2.0.6 <http://9.2.0.6> Standard Edition
I have issues when I want to switch between my standby and primary database.
I got this error
ARCH: Archiving not possible: No standby destinations
ARCH: Failed to archive log 1 thread 1 sequence 61
ORA-16014 signalled during: alter database commit to switchover to standby wi
We are running the Standard Edition so I can't use "log_archive_dest_n ...."
I copy my archive log file with a script and apply them using "recover automatic standby database".
-- Regards
Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- //www.freelists.org/webpage/oracle-l