I am running 8.1.6 on NT and I kept getting the message from ORacle.exe, it said
WARNING: THE FOLLOWING ERRROR OCCUR DURING ORACLE REDO LOG ARCHIVAL
CANNOT ALLOCATE LOG, ARCHIVAL REQUIRED.
Please advise why I kept this getting this message and how to fix the problem.
Something is not setup correctly with your archiving. Check to make sure you have enough space in log_archive_dest, make sure log_archive_start=true, and that you don't have disk I/O contention between your log_archive_dest and your redo logs.
See http://metalink.oracle.com/metalink/...p_id=1030505.6 for details.
You may be on manual archiving.
connect as sysdba and issue:-
archive log list; - if on manual archiving issue :
archive log start;
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
my archvie is set to TRUE and the location of the archive log is different with the redo log.
how do we check for disk I/O??? any or thought ????
Make sure ur archive destination has sufficient space.
Another option is add another member to existing redo log group....
The checkpoint process is still in process of writing to redo log file and other redo log files are still being archived hence oracle is not finding any new redo log file to write.
Click Here to Expand Forum to Full Width