Search This Blog

Saturday, August 2, 2008

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

2 comments:

lottery online said...

For us when we visit some blog site our main objective is to ensure that we will be entertained with this blog.

Anonymous said...

Good brief and this mail helped me alot in my college assignement. Thanks you for your information.