ARCH is FULL - Oracle Database

Hari Om

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

Jul 19 '05 #1

Subscribe Post Reply

3029

Mark D Powell

ha*****@hotmail.com (Hari Om) wrote in message news:<d1**************************@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 --

Jul 19 '05 #2

Similar topics

Unexpected Full GC's?

by: daking | last post by:

I'm trying to track down a Java performance issue, and believe it may be related to GC behavior. Quick background: j2se app server running Caucho Resin 2.1.12, on RHEL3 with Sun JDK 1.4.2_04,...

Java

Anybody using Arch?

by: Gustavo Córdova Avila | last post by:

Does anybody have an Arch archive with the current python source I could slurp it from? Thanks in advance :-) -- Gustavo Córdova Avila <gustavo.cordova@q-voz.com>...

Python

Full-text search for Japanese characters

by: Tracey | last post by:

Hi there, I want to search Japanese characters with Full Text search function. I created a table (tbSearch) for Full-text search on SQL 2000, English Win2k Server. The table contains 4 fields,...

Microsoft SQL Server

Cast from int to unsigned char in powerpc arch

by: nightolo | last post by:

Hi all, after all I have to say that I'm not a native english speaker so I pray you to excuse for my poor english. I got a trouble writing an application in a powerpc enviroment, that's the...

C / C++

LGWR and ARCH

by: nour sal | last post by:

What is the relationship between LGWR and ARCH?

Oracle Database

SoapFormatter only works in Full Trust?

by: =?Utf-8?B?TWFydHluIEZld3RyZWxs?= | last post by:

Hi there. I posted an earlier issue under the name "That assembly does not allow partially trusted callers" but have now identified what the issue is. As explained before I am working in...

ASP.NET

No Full Justification With Access 2007 Rich Text Property?

by: Neil | last post by:

Just found out that the Microsoft Rich Textbox does not support full text justification, since it's based on Version 1.0 of the RichEdit Window Class, and full text justification is only available...

Microsoft Access / VBA

ARCH is FULL

by: Hari Om | last post by:

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

Oracle Database

Help With Full Text Search. Performing AND across columns

by: Sham | last post by:

I am trying to perform the following query on a table that has been indexed using Full Text Search. The table contains multiple columns than have been indexed. (Below, all xml columns are...

Microsoft SQL Server

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice