Home » Server Options » Data Guard » Hot Standby Schemes
Hot Standby Schemes [message #75156] Tue, 02 April 2002 07:23 Go to next message
Mike Barnes
Messages: 1
Registered: April 2002
Junior Member
For this new redundant production environment we are configuring, we were going to use dataguard to hot copy the database. In performing a test installation, the implementation of Dataguard appears to require archived log files to go to two places at once, and Standard Edition allows only one. There is no other documentation we can find that insists on the enterprise edition tho. Are you aware of any such restriction? Since we run a tight ship, the very large license cost of upgrading to the enterprise edition just for dataguard is prohibitive. Here are a couple of options we are considering:

1) Make a copy of the Production
Database (standard edition) on each server, and copy archived files as they
appear. Apply them on some schedule, like nightly. Possibly we could get
this down to a nightly operation. When the production server breaks, apply
all the accumulated log files, and restart the database on the backup
machine. The down time depends on two major items: detection of "down" and
the time to apply all the daily accumulated redo; perhaps an hour or two.
In Microsoft land this approach is called "log shipping".
2) buy Shareplex from Quest Software; still expensive, but less than upgrading
to the enterprise edition.

Do you have any other wisdom on workable standby schemes?
Re: Hot Standby Schemes [message #75201 is a reply to message #75156] Sat, 29 June 2002 06:28 Go to previous messageGo to next message
Najeeb Ud Din
Messages: 1
Registered: June 2002
Junior Member
I have no idea on stand by database but I want ot learn with ur successfull package
Re: Hot Standby Schemes [message #193126 is a reply to message #75156] Fri, 15 September 2006 00:04 Go to previous message
Messages: 34
Registered: May 2006
Location: West Des Moines

Did you try Cascaded Redo Log Destinations ??

Visit the link.


Previous Topic: Data Guard on ASM
Next Topic: data guard on 10g(urgent)
Goto Forum:

Current Time: Sun Jan 16 21:38:35 CST 2022