| archive log destination filling very fast [message #301323] |
Wed, 20 February 2008 01:09  |
sheldon1982
Messages: 59
Registered: February 2008
Location: india
|
Member |
|
|
Hi Experts,
i am facing a problem that my archive log destination is filling very fast.
The space that was available in the partition earlier in the day was sufficient for 3-5 days of "normal" archive log buildup, yet it seems to have filled up in only about a 45 minute time frame immediately before the processing stopped.
oblem that my archive log destination very fast.i am unable to find the exact reason. could you please help me out??
Thanks,
Daniesh
|
|
|
|
|
|
|
|
|
|
| Re: archive log destination filling very fast [message #301451 is a reply to message #301323] |
Wed, 20 February 2008 12:28  |
sheldon1982
Messages: 59
Registered: February 2008
Location: india
|
Member |
|
|
Hi Michel,
I send your reply to my client i.e You can check v$sesstat for statistic 'redo size' (join with v$statname) to know which sessions currently generate redo.
You can also use LogMiner to know what happened.
my client replied me is what i pasted down. want to tell you one more thing the error occured on 14th feb so it possible to know the real cause now.
the error is pasted down which i found in alert log.
RA-16038: log 4 sequence# 10840 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 4 thread 1: '/ora01/oradata/pbm1/redo/redo04a'
ORA-00312: online log 4 thread 1: '/usr1/oradata/pbm1/redo/redo04b'
Thu Feb 14 20:16:24 2008
Thread 1 advanced to log sequence 10842
Current log# 6 seq# 10842 mem# 0: /ora01/oradata/pbm1/redo/redo06a
Current log# 6 seq# 10842 mem# 1: /usr1/oradata/pbm1/redo/redo06b
Current log# 6 seq# 10842 mem# 0: /ora01/oradata/pbm1/redo/redo06a
Current log# 6 seq# 10842 mem# 1: /usr1/oradata/pbm1/redo/redo06b
Thu Feb 14 20:16:24 2008
ARC1: Beginning to archive log# 4 seq# 10840
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive log# 4 seq# 10840
ARCH: Archival stopped, error occurred. Will continue retrying
Thu Feb 14 20:16:24 2008
ORACLE Instance stndby - Archival Error
ARCH: Connecting to console port...
Thu Feb 14 20:16:24 2008
ORA-16014: log 4 sequence# 10840 not archived, no available destinations
ORA-00312: online log 4 thread 1: '/ora01/oradata/pbm1/redo/redo04a'
ORA-00312: online log 4 thread 1: '/usr1/oradata/pbm1/redo/redo04b'
ARCH: Connecting to console port...
ARCH:
ORA-16014: log 4 sequence# 10840 not archived, no available destinations
ORA-00312: online log 4 thread 1: '/ora01/oradata/pbm1/redo/redo04a'
ORA-00312: online log 4 thread 1: '/usr1/oradata/pbm1/redo/redo04b'
Thu Feb 14 20:16:34 2008
could you please explain me in more detail. please i know i am irritating you. please try to understand .
can the concept of log miner is available in 8i
Thanks,
Daniesh
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
