Archive process is on but archive logs do not show in destination unless a manual switch is done.

Posted on 2007-10-02
Last Modified: 2013-12-19
* We are using Oracle 10g Rel. 1 on AIX.  
* We have our archive destination set to "/u02/oracle/admin/blah/arch/blah1".
*  In v$instance, ARCHIVER is set to "STARTED".  
* The owner of the archive directory, at the UNIX level is "oracle dba".  
* The permissions on "/u02/oracle/admin/blah/arch/blah1" are drwxr-sr-x.
* The alert.log file shows the ARC1 process creating local archive destination LOG_ARCHIVE_DEST_1: '/u02/oracle/admin/blah/arch/blah1/blah1_####-###### sequence ####) (blah1) and also later on closing the same file.
* The last ARC1 archivelog created today was at 04:04:29
* At 07:05:00 a crontab job executes "alter database backup controlfile to trace", which should have no affect on the archive log files.
* There are NO ".arc" files in our archive log destination
* When I do a manual "alter system switch logfile", the ".arc" file that is created IS in the archive log destination.

Does anyone have a clue as to what may be happening to our archive log files that are created from ARC1 process?  The only ones that are in our archive log destination are those that are created when a manual switch is completed.
Question by:cbetter
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    archive log files are only created when a redo log file group is full, or, if the archive settings are configured, after x time, or x mb to be written.
    so, if there is no traffic (UPDATE, INSERT, DELETE ...) on the database, then, getting an archive log file can take some time.
    LVL 9

    Expert Comment

    are there enough data writes ? check how offten log switch occurs in alertSID.log
    is your database in ARCHIVELOG mode?

    Accepted Solution

    That's not the issue here.  In the ALERT LOG, there are references to 26 archive log files being created on just Oct 01!

    We JUST actually found the problem!!!!   I went into my archive destination and the .arc file that I manually produced an hour ago was GONE!!!!

    We had previously checked our crontab (while logged in as Oracle) and there were no jobs set up to run there that even remotely looked like a purge job.....BUT, we never thought to look in the ROOT crobtab jobs!  SOMEONE (which we think we know who may have done this) went in and added a job to remove ALL .arc files from the archive destination.  VERY DANGEROUS!!!!  Shame on them!!! solved & we'll be taking a full backup this evening!  Thanks for the input!
    LVL 1

    Expert Comment

    Closed, 500 points refunded.
    Community Support Moderator

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now