Home » RDBMS Server » Server Administration » Oracle: Instance orcl - can not allocated log
Oracle: Instance orcl - can not allocated log [message #55181] Thu, 09 January 2003 06:48 Go to next message
Anthony pena
Messages: 12
Registered: July 2002
Junior Member
I check my oracle database server and it display the following error.
"Warning: The folowing error ocurred during oracle redo log archival.
Oracle: Instance ORCL - can not allocated log, archival required."
I would to know, what could i do for resolve this problem.
Please answer as soon as posible.
Re: Oracle: Instance orcl - can not allocated log [message #55185 is a reply to message #55181] Thu, 09 January 2003 07:26 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. you must have set 
   log_archive_start=true in initsid.ora
2. so u have enable archiving.
3. But u must not have specified a valid 
   log_archive_dest ( a destination for
   the archvied logs )
   or 
   the desitnation is full
   or 
   something is wrong with this.
4. so oracle does continue to function normally,
   unitll the contnents of the current log is archived.
5. either turn of archiving or
   look into clearing the archiving.              
6. you can force the logswitch
   using
   alter system switch logfile;
Previous Topic: parameter in init.ora
Next Topic: 9iR2 Database Configuration Assistant fails with "Out of Memory" error ORA-27102
Goto Forum:
  


Current Time: Fri Sep 20 05:41:27 CDT 2024