Home » Infrastructure » Windows » backup strategy with standby database (Windows 2k, Oracle 9i)
backup strategy with standby database (Windows 2k, Oracle 9i) [message #100803] Wed, 15 October 2003 15:00 Go to next message
William Jones
Messages: 3
Registered: October 2003
Junior Member
We are planning to move from a single database on a Windows 2000 (Dell) server with archiving and standard backups to having a primary database on one Windows 2000 (Dell) server and a standby database on an identical Windows 2000 (Dell) server. We plan to implement this "after" upgrading from Oracle 8i to 9i. Looking at using Oracle 9i Data Guard.

While I know it is important to backup the database and not to rely solely on the standby as the backup, would it be possible to do backups from the standby database (Oracle 9i Data Guard) instead of the primary? If so, are there any things to look out for? Due to availability concerns, it would be easier to schedule if the main backup work was from the standby database versus the primary database.

Regards,

William
Re: backup strategy with standby database (Windows 2k, Oracle 9i) [message #100820 is a reply to message #100803] Fri, 07 November 2003 13:33 Go to previous message
robert malikian
Messages: 18
Registered: October 2001
Junior Member
I would stop recovery and shut the database then do a cold backup. You could recover this database as the archive logs are there….
Robert
Previous Topic: SQLPlus installation path
Next Topic: Oralce 8.0.6 on Win2K
Goto Forum:
  


Current Time: Thu Apr 18 05:28:09 CDT 2024