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.
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)
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.. ??
Yes , below is a extract out of the inti.ora file
##### For archiving if ARCHIVELOG is on ########
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.
Click Here to Expand Forum to Full Width