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....