OraFAQ Forum: Data Guard » How to disable transfers of LOGS to standby database

Home » Server Options » Data Guard » How to disable transfers of LOGS to standby database

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

How to disable transfers of LOGS to standby database [message #178813]

Thu, 22 June 2006 21:53

dlore
Messages: 6
Registered: June 2006
Location: Philippines

Junior Member

Hi Guru,

Does anyone knows how to cancel the transferring of logs to one my standby database?.. Because one of my standby database server is down and I'm continously received this error "ORA-12505: TNS:listener could not resolve SID given in connect descriptor". I have an idea that it may have something to do with "log_archive_dest_2" parameter.. How can I disable that?..

Guru's out there please help..

Thanks,
~DLORE

Report message to a moderator

Re: How to disable transfers of LOGS to standby database [message #178927 is a reply to message #178813]

Fri, 23 June 2006 07:35

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Try:

SQL> ALTER SYSTEM SET log_archive_dest_state_2 = DEFER;

System altered.

DEFER = Specifies that valid destination information and attributes are preserved, but the destination is excluded from archiving operations until re-enabled.

Report message to a moderator

Re: How to disable transfers of LOGS to standby database [message #179178 is a reply to message #178813]

Mon, 26 June 2006 04:13

dlore
Messages: 6
Registered: June 2006
Location: Philippines

Junior Member

Thanks Frank,

I have set log_archive_dest_state_2=DEFER, now it does'nt send the archived logs to the standby database.. Thank you very much Frank!.. Razz

Report message to a moderator

Previous Topic:	query on cluster database
Next Topic:	DBNAME and SID of standby database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 14:44:45 CST 2025