Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!l41g2000cwc.googlegroups.com!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.oracle.server Subject: Re: High Availability Requirements/Concepts Date: 4 Apr 2005 01:52:15 -0700 Organization: http://groups.google.com Lines: 43 Message-ID: <1112604735.347185.85200@l41g2000cwc.googlegroups.com> References: <1112583292.926512.161290@f14g2000cwb.googlegroups.com> NNTP-Posting-Host: 193.130.12.157 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1112604739 8293 127.0.0.1 (4 Apr 2005 08:52:19 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 4 Apr 2005 08:52:19 +0000 (UTC) In-Reply-To: <1112583292.926512.161290@f14g2000cwb.googlegroups.com> User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: l41g2000cwc.googlegroups.com; posting-host=193.130.12.157; posting-account=YUT-nQ0AAACyUty0w2mW272E_Xv4Aa-F Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:239584 Gump wrote: > R4. We must be able to manually turn off the "synchronisation" between > the two sites to allow the database at the secondary site to become a > test environment. It is acceptable in this circumstance that the > primary site does not have a standby site for unplanned outages. > > My investigation of many discussions, oracle documents and metalink > posts shows there are different ways to achieve the above but I am > unsure about the following: > > Q1. Can R4 (above) be met if using Oracle Data Guard? That is, can you > turn a standby database into a test database that can operate > independantly to the production database? Yes, by breaking the standby. > Q2. Following on from Q1, is the standby database rebuilt from a backup > of production after you have finished testing? Yes. So yes, DataGuard can fulfill all your requirements. R4 is very curious though, you obviously have data that you really, really care about as both the primary and the standby are clustered (in addition to you actually having a standby in the first place). R4 states - sometime we don't care (or more strictly are prepared to risk) losing all our data permanently. - It sort of begs the question under what circumstances are you prepared to tolerate loss of the datacentre. Dan's point about licensing is worth bearing in mind as well, if you are using the db for test rather than opening the standby as a reporting db then you might well find you need a full license for it. Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com