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
Printable View
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
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
Yes I am running in archivelog mode, how do I set automatic archiving
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..
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
you also need
log_archive_start = true
for automatic archiving.
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.