Hey guys - gotta question.
I have a few sites on 8i utilizing automated standby.
We have a script on the standby server running in cron that makes a
connection every minute to the primary database. If the connection
fails, it brings the standby server into production mode with ALTER
DATABASE ACTIVATE STANDBY DATABASE. According to Oracle/Lawrence To's
"Graceful Switchover and Switchback," that command will perform an
implicit open resetlogs, hence will not allow the procedures outlined
there.
Additionally, as far as I could tell, there appeared to be downtime in
the procedures outlined in that strategy.
Here's what I need to do.
Let's say server1 houses my primary database and server2 houses my
standby.
If server1 crashes, server2 will activate and become the production
database.
I would then need to rebuild server1 and make it the standby with no
downtime to server2.
Is this going to be possible?
I was thinking that I could just export the database from server2 to
server1, build my standby controlfile from server2 and ftp to server1.
Will this work at all?
Ideas appreciated.
Blaine
Received on Fri Jul 09 2004 - 09:29:27 CDT
