Redo log

[vinay_p]

Hi All

I am getting a message on my oracle server. Redo log Oracle Instance met -can not allocate log ,archiveal required.
How do I archive the redo lof files.


Thanks

[nirasha]

Are you running in archivelog mode?

you can check by typing in:

archive log list; (svrmgrl)

and is automatic archiving set:

archive log start; (svrmgrl as well)

Good Luck
Nirasha

[vinay_p]

Yes I am running in archivelog mode, how do I set automatic archiving

[st2000]

did you uncomment the 3 parameters in the init.ora related to the archiving.. if you did that after you made it archive did you bounce the db.. ??
Thx..

[vinay_p]

Yes , below is a extract out of the inti.ora file

##### For archiving if ARCHIVELOG is on ########
LOG_ARCHIVE_DEST =D:\orant\database\archive
LOG_ARCHIVE_FORMAT =arc%S.%T
LOG_ARCHIVE_BUFFERS =4
LOG_ARCHIVE_BUFFER_SIZE =127

Thanks

[pwoneill]

you also need

log_archive_start = true

for automatic archiving.

[Halo]

The error 'cannot allocate new log, archival required' suggests that your redo log files are small in size. You will tend to see this during a bulk insert/delete or during an import. Increase the size of the redo log files.