Home » Server Options » Data Guard » stopping log shipping (ORACLE 11G R2 (, ASM , SOLARIS 10, RAC of two Nodes)
stopping log shipping [message #549260] Thu, 29 March 2012 04:05 Go to next message
Messages: 180
Registered: September 2009
Senior Member
i want to stop log shipping to standby database. i am a newbie in this regard. the whole configuration was done by someone else and now i have been ask to stop it. it is done on test bases and now want to stop it.what i have got from internet is as foloows
Alter system set log_archive_dest_2='DEFER';

and i have got the fol error
ORA-32107:failure in updating spfile
ORA-16179:Incremental changes to "Log_archive_dest_2" not allowed

Kindly guide



[Updated on: Thu, 29 March 2012 04:07]

Report message to a moderator

Re: stopping log shipping [message #549267 is a reply to message #549260] Thu, 29 March 2012 05:31 Go to previous message
John Watson
Messages: 5617
Registered: January 2010
Location: Global Village
Senior Member
Previous Topic: how to get sql plan in standby database
Next Topic: standby database
Goto Forum:

Current Time: Mon Nov 30 13:49:30 CST 2015

Total time taken to generate the page: 0.08681 seconds