Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!o13g2000cwo.googlegroups.com!not-for-mail From: "Dusan Bolek" Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc Subject: Re: Takeover time, reverse replication in DataGuard setup? Date: 6 Jun 2005 06:22:21 -0700 Organization: http://groups.google.com Lines: 28 Message-ID: <1118064141.931904.153590@o13g2000cwo.googlegroups.com> References: <1117972556.162288.138820@g14g2000cwa.googlegroups.com> NNTP-Posting-Host: 194.228.113.140 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1118064147 21643 127.0.0.1 (6 Jun 2005 13:22:27 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 6 Jun 2005 13:22:27 +0000 (UTC) In-Reply-To: <1117972556.162288.138820@g14g2000cwa.googlegroups.com> User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: o13g2000cwo.googlegroups.com; posting-host=194.228.113.140; posting-account=fAia6g0AAAADdyRCneOVrn-0gkeCBzJM Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244325 comp.databases.oracle.misc:119651 qazmlp1209@rediffmail.com wrote: > There are two servers between which DataGuard is setup. The replication > happens from server-1 to server-2. server-1 is currently serving and > server-2 acts as a standby. I would like to know the following related > to this setup: > 1) server-2 is in standby mode. Can server-2 start serving immediately > in case if server-1 goes out-of-service due to some problems? If not > immediate, how much time it will typically take for take-over? No, it is not immediate. How long this opearation will take is dependent on your setup. According to my experiencies it can take few minutes. > > 2) Assume server-2 has started serving and hence it is in 'Active' > mode. Is it possible to do reverse replication of DB changes from > server-2 to server-1(similar to the replication from server-1 to > server-2 before takeover happened)? Everything is in Data Guard documentation. After failover you have to create a new standby database on server-1 from formerly standby now primary database (database on server-2) backup and after synchronization of these two databases you can perform a switchover which will replace primary and standby positions (that means server-1 is primary and server-2 standby again). -- Dusan Bolek