-
Can not allocate log, archival required
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
-
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
-
Hrishy,
Are you sure this database is in NOARCHIVELOG mode? I believe it is in ARCHIVELOG.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Hi Sanjay
Please see my above paraneter file and teh archive log list they surely tell me different stories..whats goin on ?
regards
Hrishy
-
It is running in ARCHIVELOG mode. You will have to set it manually to NOARCHIVELOG.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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
-
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.
Last edited by ggnanaraj; 03-12-2003 at 01:35 AM.
-
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
-
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
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
$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.
alapps
Fast, Cheap, Reliable... Pick Two(2)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|