Re: Archiver error
Date: 1995/05/12
Message-ID: <3p0uoc$93c_at_newsbf02.news.aol.com>#1/1
Your on-line redo logs are full and the oldest redo log needs to be archived before Oracle can overwrite it. Try 'alter system archive log all' to manually archive the on-line redo logs then you will want to either start automatic archiving or alter your database into 'noarchive' log mode.
The sqldba command 'archive log list' will tell you your archive log mode.
The command 'alter system archive log start' will enable automatic archiving once the database is in 'archive' mode Be sure to set the init.ora parameters log_archive_start, log_archive_format, and log_archive_dest before trying to start archiving. The dba manual explains the proper way to start archiving in about two pages in chapter 17.
Good luck,
Mark Powell -- no witty disclaimer -- Received on Fri May 12 1995 - 00:00:00 CEST