RE: Rebuilding pimary db?

From: Alex <stant_98_at_yahoo.com>
Date: Thu, 7 Oct 2004 18:55:06 -0700 (PDT)
Message-ID: <20041008015506.35582.qmail@web51807.mail.yahoo.com>

How can convert the original db into standby instead of copying the files? Re-create controlfile as standby?

Thanks
"Parker, Matthew" <matthewp_at_amazon.com> wrote: Depends on why you flipped from the original primary. If the original primary is still good you can convert it immediately back into a standby database, instead of copying the datafiles from the current primary.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alex Sent: Thursday, October 07, 2004 12:44 PM To: oracle-l_at_freelists.org
Subject: Rebuilding pimary db?

Hello,

I am testing standby failover techniques, and would like to make sure that I am following the right steps while rebuilding the primary db. After the failover is done, the ex-primary db can no longer be used, and so to re-create it, I copy all datafiles, online and archived redo logs, create standby controlfiles, and first create it as a standby db. Then I perform a switchover, fom the new primary to the newly created standby db, revesring the roles, am I right?

Thanks!

Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.

--

http://www.freelists.org/webpage/oracle-l

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 07 2004 - 20:50:40 CDT