Archive Redo Logs

[GERPAT]

My database is operating in archive log mode but for some reason it has stopped archiving the online redo logs. I think it is trying to do so but for some reason can't.

Does any of you know whether I can check if Oracle is attempting to archive the logs? Also does the sequence number of the logs get incremented if Oracle attempts to archive logs but fails (for example if doesn't have rights to the archive log destination directory).

Thanks

 

[karluk]

Log in as sysdba and execute the command "archive log list" and verify that you are running in archive log mode with automatic archiving enabled

Database log mode Archive Mode
Automatic archival Enabled

Then check your alert log to see if there are any error messages from the last archive.

It's just a guess, but one likely cause of this kind of problem is if your hard disk is full. If that's the problem you will have to free up some space, perhaps by deleting old archive log files that are no longer needed.

 

[ThomVF]

check the init<sid>.ora file to see if the disk is full - you will see a message like &quot;archiver stuck&quot; is so &quot;Helping others to help themselves...&quot;
=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[alexhu]

ThomVF - having a bad day ?

Don't you mean the alert log ??? )

Alex

 

[GERPAT]

Thanks to everyone for there help.

It turns out I was just being paranoid. The only reason the online redo logs weren't being archived was because we had an usually quite day and the online redo logs weren't full.

 

[ThomVF]

Yeah...it was a tough day
Thanks for the correction.... &quot;Helping others to help themselves...&quot;
=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com