Home » Server Options » Data Guard » Sudden lost to a standby box (Oracle 9i, 9.2.0.1.0, RHEL 2.1)
Sudden lost to a standby box [message #500995] Thu, 24 March 2011 22:53 Go to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Friends,

While i'm trying some of fail over and switch over scenario's on my primary and standby db configuration. But suddenly i completely loss my standby db box, due to hardware failure. so now i'm not able to recover that box. It is almost non recoverable hardware failure to that box. My primary db is still up and running well. When i check the alert logs of primary db it has some errors related to standby db. Due to configuration it tries to sync the standby db, which is not possible to connect anymore. So my main question is how get rid of that errors/stop that errors from primary db. Please suggest some thing that , which parameter's i've to turn off in primary db. Herewith i'm giving some of initSID parameter of Primary db and a snap of alert log from primary db. Please suggest me what to do?

My primary db is in MAXIMUM AVAILABILITY mode.
Snap from alert files
Errors in file /ora9isoft/odb/OH1/admin/wbdata/bdump/wbdata_lgwr_1248.trc:
ORA-12541: TNS:no listener
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Creating archive destination LOG_ARCHIVE_DEST_2: 'wbdata.wbhouse'
LGWR: Transmitting activation ID a043c21d
LGWR: Error 12541 creating archivelog file 'wbdata.wbhouse'
Fri Mar 25 07:21:01 2011
Errors in file /ora9isoft/odb/OH1/admin/wbdata/bdump/wbdata_lgwr_1248.trc:
ORA-12541: TNS:no listener

At interval of each five mins in alert log
Fri Mar 25 09:09:20 2011
Errors in file /ora9isoft/odb/OH1/admin/wbdata/bdump/wbdata_arc0_1264.trc:
ORA-12541: TNS:no listener
Fri Mar 25 09:14:27 2011
Errors in file /ora9isoft/odb/OH1/admin/wbdata/bdump/wbdata_arc0_1264.trc:
ORA-12541: TNS:no listener


Parameter of my initSID
###########################################
log_archive_start=TRUE
log_archive_max_processes=2
log_archive_dest_1='LOCATION=/ora9idb/odb/OH1/archivedata/ '
log_archive_dest_2='SERVICE=wbdata.wbhouse lgwr'
log_archive_dest_state_1=ENABLE
log_archive_dest_state_2=ENABLE
log_archive_format=ARCH%S.ARC
log_archive_min_succeed_dest=1
REMOTE_ARCHIVE_ENABLE=true
LOG_ARCHIVE_TRACE=4095
###############


Regards

Jimit
Re: Sudden lost to a standby box [message #501000 is a reply to message #500995] Fri, 25 March 2011 00:16 Go to previous messageGo to next message
Michel Cadot
Messages: 67295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter system set log_archive_dest_state_2=defer;

Regards
Michel
Re: Sudden lost to a standby box [message #501002 is a reply to message #500995] Fri, 25 March 2011 00:38 Go to previous messageGo to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Michel

If i run this command from my primary db, but still i'm in impression that should i not be remark some of the archive related parameters in initSID. file.

Regards

Jimit
Re: Sudden lost to a standby box [message #501005 is a reply to message #501000] Fri, 25 March 2011 00:55 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
Michel Cadot wrote on Fri, 25 March 2011 00:16
alter system set log_archive_dest_state_2=defer;

Regards
Michel

defer the destination,oracle wont try to transport archive logs to standby and you wont get the error,once you rebuild your standby database you can enable it back again
Re: Sudden lost to a standby box [message #501006 is a reply to message #501005] Fri, 25 March 2011 01:04 Go to previous messageGo to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Michel

I'm not able to rebuild the standby db anymore, so i want to remove it for permanently. Give your advice.

Regards

Jimit
Re: Sudden lost to a standby box [message #501011 is a reply to message #501006] Fri, 25 March 2011 01:56 Go to previous messageGo to next message
Michel Cadot
Messages: 67295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter system set log_archive_dest_2='';
Add "scope=both" if yoiu use a spfile or remove it from your init.ora file.

Regards
Michel
Re: Sudden lost to a standby box [message #501027 is a reply to message #501011] Fri, 25 March 2011 03:43 Go to previous messageGo to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Michel

As i'm using pfile means initSID.ora, so i'm just shutdown the primary db and remark the following line in initSID.ora. Then startup the normal database with this initSID.ora. I've question about will following parameter isn't creating a problem.

Remark the parameter in initSID.ora
##log_archive_dest_state_2=ENABLE


To leave this parameter unremarked isn't creating a problem, i think lgwr is needed a single service to handle.
log_archive_dest_2='SERVICE=wbdata.wbhouse lgwr'


Please post your comments.

Regards

Jimit
Re: Sudden lost to a standby box [message #501028 is a reply to message #501027] Fri, 25 March 2011 03:50 Go to previous messageGo to next message
Michel Cadot
Messages: 67295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Comment the latter line; do not rely on implicit behaviour.

Regards
Michel
Re: Sudden lost to a standby box [message #501037 is a reply to message #501028] Fri, 25 March 2011 04:28 Go to previous messageGo to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Michel

i m exactly not getting. clear what you suggesting please.
should i need to comment both the lines? like this.

##log_archive_dest_state_2=ENABLE
##log_archive_dest_2='SERVICE=wbdata.wbhouse lgwr'


Regards

Jimit
Re: Sudden lost to a standby box [message #501040 is a reply to message #501037] Fri, 25 March 2011 04:58 Go to previous message
Michel Cadot
Messages: 67295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Previous Topic: Recovery interrupted.
Next Topic: Data Guard setup/ Archive Destination configuration
Goto Forum:
  


Current Time: Tue Aug 11 17:29:42 CDT 2020