OraFAQ Forum: Data Guard » How do you stop ARCH?

Home » Server Options » Data Guard » How do you stop ARCH?

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

How do you stop ARCH? [message #237515]

Mon, 14 May 2007 13:47

mlgoins
Messages: 115
Registered: March 2007
Location: Denver, CO

Senior Member

How do you stop the Primary Database from attempting to send data to the Standby Database (currently using ARCHIVER)? Excuse if it's a dumb question, but the answer isn't where I expected it to be in the documentation.

Report message to a moderator

Re: How do you stop ARCH? [message #237517 is a reply to message #237515]

Mon, 14 May 2007 13:49

mlgoins
Messages: 115
Registered: March 2007
Location: Denver, CO

Senior Member

To answer my own question, I simply used:

alter system set log_archive_dest_state_2=DEFER;

That should take care of it. Embarassed

Report message to a moderator

Re: How do you stop ARCH? [message #238608 is a reply to message #237517]

Fri, 18 May 2007 12:51

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

mlgoins wrote on Mon, 14 May 2007 12:49

To answer my own question, I simply used:

alter system set log_archive_dest_state_2=DEFER;

That should take care of it. Embarassed

hey dere is oder way also

#log_archive_dest_state_2=ENABLE (in pfile)

lol

Report message to a moderator

Re: How do you stop ARCH? [message #239139 is a reply to message #238608]

Mon, 21 May 2007 09:54

mlgoins
Messages: 115
Registered: March 2007
Location: Denver, CO

Senior Member

Now why didn't I think of that! Thanks!

Report message to a moderator

Previous Topic:	is it possible to use dataguard between 64 bit oracle and 32 bit oracle
Next Topic:	Temporary tablespace is empty

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 01:44:41 CDT 2013

Total time taken to generate the page: 0.13368 seconds