Home » Server Options » Data Guard » stopping log shipping (ORACLE 11G R2 (11.2.0.1.0), ASM , SOLARIS 10, RAC of two Nodes)
stopping log shipping [message #549260] Thu, 29 March 2012 04:05 Go to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
hi,
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

Regards

Janakors

[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: 8922
Registered: January 2010
Location: Global Village
Senior Member
log_archive_dest_state_2
Previous Topic: Archive Gap Script
Next Topic: standby database
Goto Forum:
  


Current Time: Fri Mar 29 03:05:32 CDT 2024