| Sudden lost to a standby box [message #500995] |
Thu, 24 March 2011 22:53  |
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 #501002 is a reply to message #500995] |
Fri, 25 March 2011 00:38  |
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 |
knight
Messages: 111
Registered: January 2009
|
Senior Member |
|
|
Michel Cadot wrote on Fri, 25 March 2011 00:16alter 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 #501027 is a reply to message #501011] |
Fri, 25 March 2011 03:43 |
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 #501037 is a reply to message #501028] |
Fri, 25 March 2011 04:28 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
