Home » RDBMS Server » Server Administration » archive log destination filling very fast (oracle,8.1.7,solaris)
archive log destination filling very fast [message #301323] Wed, 20 February 2008 01:09 Go to next message
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 #301335 is a reply to message #301323] Wed, 20 February 2008 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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.

Regards
Michel
Re: archive log destination filling very fast [message #301362 is a reply to message #301323] Wed, 20 February 2008 04:28 Go to previous messageGo to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
HI Michael,
is there anyway to find out the way when my archived log was purged and how many days archived were there in archived log????
Re: archive log destination filling very fast [message #301372 is a reply to message #301362] Wed, 20 February 2008 05:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
when my archived log was purged

Oracle does not purge your archived logs. Precise your point.

Quote:
how many days archived were there in archived log

v$archived_log, v$loghist, v$log_history

Regards
Michel
Re: archive log destination filling very fast [message #301451 is a reply to message #301323] Wed, 20 February 2008 12:28 Go to previous messageGo to next message
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
Re: archive log destination filling very fast [message #301454 is a reply to message #301451] Wed, 20 February 2008 12:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If it is from 14 Feb, you have to use Log Miner which is available in 8i.

Regards
Michel

Re: archive log destination filling very fast [message #301461 is a reply to message #301323] Wed, 20 February 2008 13:23 Go to previous message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
thanks you very michel

Previous Topic: list partition
Next Topic: Charater sets usage in oracle
Goto Forum:
  


Current Time: Fri Dec 09 17:47:29 CST 2016

Total time taken to generate the page: 0.32697 seconds