In ORacle 8 while Updating table which is having 49492 records the following error is generated. 'Oracle instance orc1-cannot allocate log, archival required'.
Please explain what is this error and how to solve?
That warning occurs when a database is running in archive log mode (for media recovery) and we need to reuse an online redo log file (because you are filling them up quickly) and the one we need to reused has not yet been archived safely to another location.
This will be because either
o you did not enable automatic archiving with log_archive_start but you have placed the database into archive log mode or...
o you are filling up archive logs so fast that ARCH cannot copy them to the other location quickly enough (wait a minute and it'll copy it and then work will proceed, we'll need to tune arch but its a temporary situation) or...
o your archive destination is full and we cannot put any more logs there.
See
</code>
http://docs.oracle.com/cd/A58617_01/server.804/a58397/ch23.htm#553 <code>
for information in archive log mode, archiving, turning it on and off, enabling automatic archiving, tuning it and so on.