Home » RDBMS Server » Backup & Recovery » Can not allocate log error (?)
Can not allocate log error (?) [message #222622] Mon, 05 March 2007 12:38 Go to next message
mrlagarto
Messages: 8
Registered: October 2006
Junior Member
Hi, I have the next error.

"Oracle Instance xxxx - Can not allocate log, archival required"

But....When I try to archive:

ALTER SYSTEM ARCHIVE LOG ALL;

I have the message:
ORA-00271: there are no logs that need archiving

This is my init.ora:
log_archive_start=true
log_archive_dest=d:\Redologs
log_archive_format="TEST%S.ARC"

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination d:\borrar\Redologs
Oldest online log sequence 57682
Next log sequence to archive 57684
Current log sequence 57684

And I have 30gb free on my HD.

What it's the problem??
I'm stuck.

Thanks in advance.
Re: Can not allocate log error (?) [message #222635 is a reply to message #222622] Mon, 05 March 2007 12:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you have'nt mentioned the version/posted relevant entries from alert log.
??
use log_archive_dest_n
Re: Can not allocate log error (?) [message #222679 is a reply to message #222622] Mon, 05 March 2007 22:22 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:274415747140

regards
Taj
Previous Topic: Suggestion on Backup
Next Topic: relation b/w redo log,undo tablespace,rollback segment
Goto Forum:
  


Current Time: Thu Dec 08 20:26:47 CST 2016

Total time taken to generate the page: 0.05555 seconds