automatic archival is diabled everytime reboot the database

[mike2000]

HI all,

this is a 9i database and below is parameter I have :

log_archive_start = TRUE
log_archive_dest = C:\Oracle\admin\TEST\Arch
log_archive_format = TEST_%S.arc
#log_archive_min_succeed_dest = 2


everytime I restart the instance, the archival is disabled; however when I shutdown and startup mount and alter database with archive log start and it's enabled. What weird about this is that when I look into the archive log list and I got the archive location to someewhere else instead of the location specified as above.

log_archive_dest = C:\Oracle\admin\TEST\duplex, I expect the have the log_archive_dest is pointing to this location C:\Oracle\admin\TEST\Arch but it's not.



please advise,

[jmodic]

Obviously your databas is not started with the init/spfile file you think it is.

Find out which initialisation file it uses when starting up and set automatic archiving there or redirect the instance to use the initialisation file where you have set automatic archiving.

[akhadar]

Yes this is true as 9i by default start with SPFILE. If u have changed the Archive settings in your init file and reboot the systems u are lost as next time the database will start with SPFILE.So as mentioned by jmodic