Re: activate standby

On Wed, 6 Mar 2002, Ray Stell wrote:

> I activated a standby this morning and found that the archive
> log number was reset back to 1. Could I have avoided this reset?

If you are performing a planned failover, and you wish to convert the presently running primary into the standby after the failover, you can just do the following. It is called variously graceful switchover, role reversal and graceful failover.

Dump the primary's trace controlfile and edit it to say: create controlfile reuse database "foo" noresetlogs archivelog...

With the primary shut down, completely recover the standby, including applying the current online log from the primary at the time of shutdown.

Copy all the online redologs from the primary to the standby. (possible efficiency - can all but the current online log be copied ahead of time to save time?)

Run the "create controlfile" command on the standby.

Alter the standby open.

Dump a standby controlfile from the just activated database, and replace the old primary's controlfiles with it.

Start running the old primary as a standby.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).