-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|