Originally posted by gajananpkini ORACLE Instance HNS - Can not allocate log, archival required
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 2700154
All online logs needed archiving
Logon " / as sysdba" and restart the archiving e.g. ALTER SYSTEM ARCHIVE LOG START;
Originally posted by gajananpkini manual says that we can stop archiving any time,
no need to restart the db
but what caused the issue here
As long as it's in ARCHIVELOG MODE the logs will need to be archived - so it should be very exceptional to stop the archiving process (which normally should be done automatically: ALTER SYSTEM ARCHIVE LOG START; ) Yes, you can stop the process, but WHY?
OK: What are you really trying to do? What is your objective?