ARCH is FULL

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Hari Om
    #1

    ARCH is FULL

    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....
    Tags: None
    • Mark D Powell
      #2
      Re: ARCH is FULL

      hari_om@hotmail .com (Hari Om) wrote in message news:<d1d5ebe4. 0310151343.6147 ecb4@posting.go ogle.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 --

        Comment

        Previous template Next
        Working...