OraFAQ Forum: Data Guard » Data Guard Implementation

Home » Server Options » Data Guard » Data Guard Implementation (Oracle 10.2.0.1.0 - Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data Guard Implementation [message #375960]

Mon, 15 December 2008 08:16

danyromimd
Messages: 73
Registered: August 2008

Member

Hi!
I have already tried implementing Data Guard in testing servers. Now I'm about to implement Data Guard in the production servers. Is there any way to implement it without stoping the application service? I mean... I know there are things that should be done with the primary database down, but as I'm rather new in Oracle, maybe there's a solution to avoid having to spend a weekend at work.
Thanks a lot!
Daniela.

Report message to a moderator

Re: Data Guard Implementation [message #376562 is a reply to message #375960]

Wed, 17 December 2008 19:23

ebrian
Messages: 2794
Registered: April 2006

Senior Member

If your database is not in archivelog mode, then you'll need to restart your database to place it in archivelog mode; otherwise, a restart shouldn't be required.

Check Manually Create a Physical Standby Database Using Data Guard for complete details.

Report message to a moderator

Re: Data Guard Implementation [message #376721 is a reply to message #376562]

Thu, 18 December 2008 06:34

danyromimd
Messages: 73
Registered: August 2008

Member

But... when it's time to copy datafiles, logs, etc. to the standby ... shouldn't the primary database be down?
I thought I could bring this files from backup and then apply the necesary logs to avoid shutting down the DB... but there are other things such as creating the control file for the standby DB that has to be done with the database down. So... I'm in a mess!!!
Is it right what I'm pointing out?

Report message to a moderator

Re: Data Guard Implementation [message #376741 is a reply to message #376721]

Thu, 18 December 2008 07:27

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You'll only need to shutdown the primary if you are creating the standby via a cold backup. Otherwise, once you have the primary database in archivelog mode, you can generate a backup via RMAN and a controlfile backup for the standby and use this for creation of the standby.

The first link I provided showed creation via a cold backup. Check Creating a Standby Database with Recovery Manager for the full details of using RMAN and a hot backup to create a standby.

Report message to a moderator

Previous Topic:	Standby testing
Next Topic:	Data Guard Broker

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 08:06:32 CST 2024