Oracle 9i Can't allocate log, archival required

When your getting below error message means you enable the archivelog mode for Oracle 9i database but still didn't "start" archive.

For example:

In oracle 9i we need to enable archivelog mode as well as we need to start.

1. LOG_ARCHIVE_START parameter we need to also set for start archivelog mode.

see below:

SQL> archive log list

Database log mode Archive Mode

Automatic archival Disabled

Archive destination C:\Ora9ihome\RDBMS

Oldest online log sequence 4

Next log sequence to archive 4

Current log sequence 6

In above Database is archive log mode but archiving is not start means following parameter is not TRUE.

SQL> show parameter log_archive_start
NAME TYPE VALUE

------------------------------------ ----------- -----------log_archive_start boolean FALSE

LOG_ARCHIVE_START is static parameter so we need to restart Oracle database, ( startup followed by shutdown)

SQL> alter system set log_archive_start=TRUE scope=spfile;
System altered.

SQL> shutdown immediate;

SQL> startup

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\Ora9ihome\RDBMS
Oldest online log sequence 5
Next log sequence to archive 7
Current log sequence 7