What's the setting for LOG_ARCHIVE_DEST_2 and LOG_ARCHIVE_DEST_1?
Mingbo
-----Original Message-----
From: Vijay Sekhar
[mailto:oracledba-ezmlmshield-x9570283.[Email address protected]
Sent: Saturday, October 02, 2004 3:01 AM
To: LazyDBA Discussion
Subject: RE: LGWR problem - second email
Thanks for the reply.
No, we use neither NetApps not EMC for storage. Just regular internal
hard
disk.
-----Original Message-----
From: Patterson Randy
[mailto:oracledba-ezmlmshield-x43310437.[Email address protected]
Sent: Friday, October 01, 2004 3:01 PM
To: LazyDBA Discussion
Subject: RE: LGWR problem - second email
Are you using NetApps or EMC for storage?
We use NetApps and occasionally the servers briefly loose connection. We
have since fixed the problem by having a failover connection.
-----Original Message-----
From: Vijay Sekhar
[mailto:oracledba-ezmlmshield-x58523606.[Email address protected]
Sent: Friday, October 01, 2004 1:50 PM
To: LazyDBA Discussion
Subject: LGWR problem - second email
<<<< sorry for the horrid formatting in my previous email. cut-n-paste
bungle in outlook. here is a better looking email>>>>
Hi All
Can anyone shed some light on this weird entry I have in my alert log ?
This is a QA database on Sun Solaris 5.8 (db version is 9.2.0.5.0
recently
patched):
Fri Oct 1 00:00:00 2004
LGWR received timedout error from KSR
LGWR: Destination LOG_ARCHIVE_DEST_2 not using standby redo logfiles;
cannot reconnect Network asynch I/O wait error 2 log 2 service
'trp4.digitrade.com' Fri Oct 1 00:00:00 2004 Errors in file
/export/home/oracle/admin/trp3/bdump/trp3_lgwr_4317.trc:
ORA-00002: Message 2 not found; product=RDBMS; facility=ORA Fri Oct 1
00:14:38 2004
LGWR: Completed archiving log 2 thread 1 sequence 18656
LGWR: Error 16164 disconnecting from destination LOG_ARCHIVE_DEST_2
standby host 'trp4.digitrade.com'
LGWR: Destination LOG_ARCHIVE_DEST_2 not using standby redo logfiles;
cannot reconnect
LGWR: Error 16169 closing archivelog file 'trp4.digitrade.com' Fri Oct
1 00:14:38 2004 Errors in file
/export/home/oracle/admin/trp3/bdump/trp3_lgwr_4317.trc:
ORA-16169: LGWR network server invalid parameters
Thread 1 advanced to log sequence 18657
Current log# 4 seq# 18657 mem# 0:
/export/home/oracle/oradata/trp3/redoa04A.log
Current log# 4 seq# 18657 mem# 1:
/export/home1/oracle/oradata/trp3/redoa04B.log
Fri Oct 1 00:14:39 2004
ARC1: Evaluating archive log 2 thread 1 sequence 18656
ARC1: Beginning to archive log 2 thread 1 sequence 18656 Creating
archive destination LOG_ARCHIVE_DEST_1:
'/export/home/oracle/admin/trp3/arch/1_18656.dbf'
ARC1: Completed archiving log 2 thread 1 sequence 18656
I tried to do some research on this but came up with a blank. Metalink
only points to a single note which is basically the OERR output. Has
anyone seen anything similar in their database ?
I have put in a TAR with Oracle support to find out if this is related
to the 9.2.0.5.0 patchset I recently installed.
Thanks for your time.
----
Sekhar Vijay
Global Banking & Brokerage
Thomson Financial
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
-----------------------------------------
Anadarko Confidentiality Notice: This electronic transmission and any
attached documents or other writings are intended only for the person or
entity to which it is addressed and may contain information that is
privileged, confidential or otherwise protected from disclosure. If you
have received this communication in error, please immediately notify
sender
by return e-mail and destroy the communication. Any disclosure, copying,
distribution or the taking of any action concerning the contents of this
communication or any attachments by anyone other than the named
recipient
is strictly prohibited.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page