-
Hello All,
When I insert into a table from another table using select * from I get the following error
Archive process error: ORACLE Instance abd - Can not allocate log, archival required
.
I have enabled archiving in init.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
How do fix this problem
-
Increase the redo log file size.
-
It sounds like you might need to issue a manual archival statement. This can be done via svrmgr.
Chintz
