Re: ARCH is FULL

hari_om_at_hotmail.com (Hari Om) wrote in message news:<d1d5ebe4.0310151343.6147ecb4_at_posting.google.com>...
> I am using Oracle 9.2.0.1 on my IBM AIX 5.1L System.
>
> I have a DB instance "prod" running on it for TESTING purposes. I have
> set the DB to ARCHIVELOG Mode and the archive destination to
> "/archive".
>
> I "do not" use this db frequently but I am surprised that even after
> that my Archive destination become FULL (100%) without any
> transactions - wonder why....?
>
> Can anyone point out as to why the ARCH keeps on archiving the DB
> evenif there are NO TRANSACTIONS....?
>
> Is there any way by which ARCH or ORACLE notifies you or pings you
> that your archive destination is FULL.....What is the best way to take
> these archive files on TAPE and then delete them....I am sure there
> has to be some automatic process....
>
> Any related information on this is appreciated....

Version 9+ of Oracle commits a row in smon_scn_time for use with flashback queries once every 5 minutes; this creates redo. This are only 1440 rows per day but depending on the size of your redo logs, archive space, and redo created by real testing it can add up over time. In other words Oracle performs transactions on its own behalf so there is always some work going on in version 9+.

HTH -- Mark D Powell -- Received on Fri Oct 17 2003 - 15:33:30 CEST