Can not allocate log, archival required

[hrishy]

Hi

One of my database runs in no archive log mode..but in the alert log i am seeing teh following message

ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 8
All online logs needed archiving

can anybody explain why this thing is goin no ??

regards
Hrishy

[hrishy]

Hi

I noticed some starnge things too..

when i say

SVRMGR> archive log list
Database log mode Archive Mode
Automatic archival Disabled
Archive destination /apps/home/ora817/dbs/arch
Oldest online log sequence 5
Next log sequence to archive 8
Current log sequence 8

but in the parameter file it is somethin like this

# Uncommenting the lines below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
# log_archive_start = true
# log_archive_dest_1 = "location=/apps/home/admin/tixh/arch"
# log_archive_format = arch_%t_%s.arc

regards
Hrishy

[SANJAY_G]

Hrishy,
Are you sure this database is in NOARCHIVELOG mode? I believe it is in ARCHIVELOG.

[hrishy]

Hi Sanjay

Please see my above paraneter file and teh archive log list they surely tell me different stories..whats goin on ?

regards
Hrishy

[SANJAY_G]

It is running in ARCHIVELOG mode. You will have to set it manually to NOARCHIVELOG.

[hrishy]

Hi Sanjay

Thanks..well i must confess..just todau i learnt something new ..i was under the impression that modes of operation of the database was mentioned in the init.ora file..whereas switching modes has nouthing to do with init.ora...

i can switch modes like this

alter databse archivelog

alter database noarchivelog..

and teh archive log files are being generated at $ORACLE_HOME/dbs directory..even though this directory is not mentioned in the init.ora file

regards
Hrishy

[ggnanaraj]

Originally posted by hrishy
Hi
SVRMGR> archive log list
Database log mode Archive Mode
Automatic archival Disabled
Archive destination /apps/home/ora817/dbs/arch
Oldest online log sequence 5
Next log sequence to archive 8
Current log sequence 8

As automatic archiving is disabled you have to manually archive to archive log destination.

You must also check the parameter file that it is reading when starting the instance. You could also specify the parameter file to be used, to avoid doubts on which is being used.

HTH.

[hrishy]

Hi

Is there any view through which i can check the location and the name of parameter file did my database use when it started up ?soemthing like show parameter paranmeter file

regards
Hrishy

[SANJAY_G]

Originally posted by hrishy
and teh archive log files are being generated at $ORACLE_HOME/dbs directory..even though this directory is not mentioned in the init.ora file

regards
Hrishy

I guess that is the default archive directory for *nix

[alapps]

$ORACLE_HOME/dbs is the location that Oracle will use to retrieve the pfile during startup unless otherwise explicitly specified
(i.e. startup pfile=/path1/path..n/mypfile.ora)

As for the current parameters in effect for this startup of the database, refer to the v$parameter view.