Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: Oracle9i Standby Database Question
Depends on whether this was a graceful shutdown of the primary or not. If
it was not, then what you've done is a failover. The database that started
as the primary cannot be used as a new standby database. This must be
completely rebuilt using backups and logs from the new primary (old standby)
database. The normal failover process that forces database recreation occurs
when all of the available archive logs are applied to the standby database,
and the standby is opened as the primary using the following SQL command:
alter database activate standby database;
When this command is executed, a resetlogs operation is performed automatically on the standby and the new logs cannot be applied to the old primary.
If however, you've done a switchover (new in 9i) then you're OK. Switchover is possible only if the standby and its primary database can be brought to the same point in time. The prerequisites of initiating switchover include:
.1. The primary database has been shut down in an orderly fashion; that is,
SHUTDOWN NORMAL, SHUTDOWN TRANSACTIONAL or SHUTDOWN IMMEDIATE.
.2. All archive logs required to bring the standby to the primary's point
in time are available.
.3. The primary database's online redo logs are available and intact, as
are its data files and control files.
-- HTH. Additions and corrections welcome. Pete Author of "Oracle8i: Architecture and Administration Exam Cram" "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA "K. C." <the_ada_at_hotmail.com> wrote in message news:be879ba7.0201241847.545913fb_at_posting.google.com...Received on Fri Jan 25 2002 - 11:11:40 CST
> I have a question regarding Oracle9i Standby Database on Unix. Say I
> have a primary database running on Server A and a standby database
> running on Server B. For some reason, Server A goes down and the
> standby database is activated. What is the quickest way to switch the
> databases so that Server A (assuming whatever problem it had was
> fixed) becomes the primary again?
>
> Thanks in advance.
>
> KC
========= WAS CANCELLED BY =======: From: "Pete Sharman" <peter.sharman_at_oracle.com> Control: cancel <tjg48.9$If3.139_at_inet-nntp1.oracle.com> Subject: cmsg cancel <tjg48.9$If3.139_at_inet-nntp1.oracle.com> Date: Mon, 28 Jan 2002 00:05:36 GMT Message-ID: <cancel.tjg48.9$If3.139_at_inet-nntp1.oracle.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.fh-hannover.de!fu-berlin.de!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40722606 This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.