Auto Archive log not getting enabled

Printable View

07-10-2002, 05:01 AM
amolik

I have made the folowing settings in my initkdb.ora file.

log_archive_start=true
log_archive_dest='/usr/local/localamol/oradata/archivelog'
log_archive_format = _%s.arc

I have also started the database in the archive log mode , still the database is showing me the auto archival is disabled. What is the parameter I have to set to start the automatic archival. The ARCHIVE LOG LIST command gives following results.

Database log mode Archive Mode
Automatic archival Disabled
Archive destination /opt/oracle/product/9.0.1/dbs/arch
Oldest online log sequence 4
Next log sequence to archive 5
Current log sequence 6

Amol
07-10-2002, 05:10 AM
akimtiaz

Quote:

Originally posted by amolik
I have made the folowing settings in my initkdb.ora file.

log_archive_start=true
log_archive_dest='/usr/local/localamol/oradata/archivelog'
log_archive_format = _%s.arc

I have also started the database in the archive log mode , still the database is showing me the auto archival is disabled. What is the parameter I have to set to start the automatic archival. The ARCHIVE LOG LIST command gives following results.

Database log mode Archive Mode
Automatic archival Disabled
Archive destination /opt/oracle/product/9.0.1/dbs/arch
Oldest online log sequence 4
Next log sequence to archive 5
Current log sequence 6

Amol

Dear Mr Amol!
What ever you have done that is OK .But you have to start manaualy first time to your database in archive mod.For this just you start your darabase and after that connect as server manager and
apply the command
archive log start;
Now I think you problem will be solved
Thanks
Imtiaz
07-10-2002, 05:11 AM
aarroyob

1. Shutdown the instance with shutdown immediate
2. Startup mount
3. Alter database archivelog;
4. Alter database open;

Cheers

Angel
07-10-2002, 05:35 AM
amolik

Hi Imti , Angel

I did as per you said. It starts for that instance when I say Archive log start' but it doesn't enable it if I have to shutdown and restart database. If this database is started it still shows AUTO ARCHIVAL as disabled

Amol
07-10-2002, 05:42 AM
aarroyob

Did you do alter database archivelog after mounting the database?
07-10-2002, 06:27 AM
amolik

Hi

I have done with following sequence.
1) Changed in initkendb.ora file
2) shutdown current database
3) startup mount
4) alter databae archivelog;
5) alter database open;
6) archive log start

Then it showed me auto archival as enabled but when I restarted the database the lo mode was 'archive log' only but auto archival was 'Disabled'. I am using initkendb.ora in /opt/oracle/admin/kendb/pfile/
and which has symbolink link to $ORACLE_HOME/dbs/init.ora (same parameters). What can be the problem. Am I using correct parameter file. How do I know that oracle using which parameter file.

(Note: I queried V$PARAMETER file but it showed me log_archive_start as false. That means Oracle is using wrong file ... but which ?)

Amol
07-10-2002, 06:41 AM
aarroyob

It is nt or unix?

If it is NT/2000 you could search in the registry wich is the default Oracle_yourinstance_PFILE.

Cheers

Angel
07-10-2002, 06:45 AM
amolik

IT's RH Linux 7.2 with oracle 9i

Amol
07-10-2002, 07:24 AM
aarroyob

Probably it is getting the default init in dbs. Then delete all lines in this file (make a backup of the file) and add the next:

ifile=the path where it is your init modified, then restart the database.

Cheers

Angel
07-10-2002, 08:37 AM
amolik

There is a file spfilekendb.ora in $ORACLE_HOME/dbs/

If I remove this file and create another file with ifile pointed to proper parameter file and start the database then it gives me the error 'end of communication channel' .
Even if I modify the spfilekendb.ora then also the same error occurrs.
(ORA-03113). I googled on this error not nothing comes up. It is a generalised error.
Can anyone tell me why this is happening. In which file the parameter is stored which tells oracle to access file name only spfilekendb.ora. Even if I comment any of the parameters the database does not starts.
Evenif I set ifile in spfilekendb.ora it does not work.

Amol

(Note: the spfilekendb.ora contains some binary data as well and the parameter starts with *. Now why is that)

Expecting help...otherwise may not be able to modify init.ora any time.

Amol
07-10-2002, 08:43 AM
aarroyob

In the left in this page you could read more about spfile:

http://www.dbasupport.com/oracle/ora9i/spfile.shtml

Cheers

Angel
07-10-2002, 08:53 AM
Sonia

hi,
check for the file permission for the folders of
archive destination.
07-11-2002, 01:24 AM
amolik

Hi

The auto archival enabled by this way.

1. startup pfile='/opt/oracle/admin/kendb/pfile/initkendb.ora'

2. create spfile from pfile;

3. shutdown

3. startup

Now I have both Archivelog and Auto Archival Enabled.

Thanks All for your help

Angel .. Thanks for your links .. that really helped a lot.

Amol