• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

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

* 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.
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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.
are there enough data writes ? check how offten log switch occurs in alertSID.log
is your database in ARCHIVELOG mode?
cbetterAuthor Commented:
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!!!  So......case solved & we'll be taking a full backup this evening!  Thanks for the input!
Closed, 500 points refunded.
Community Support Moderator
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now