473,324 Members | 2,511 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

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....
Jul 19 '05 #1
1 3024
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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
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,...
0
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>...
0
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,...
3
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...
2
by: nour sal | last post by:
What is the relationship between LGWR and ARCH?
5
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...
4
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...
1
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...
8
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.