Re: How to set log archive mode parameters in 9i release2/

"Eric" <ericw24_at_yahoo.com> wrote in message news:m4A_a.8873$VG.310532_at_news20.bellglobal.com...
> Hi all;
>
> I just installed Oracle 9i Release 2 on my Windows 2000 server.
> I wanted to run in archive log mode, so I set the following three parameters
> in the init.ora parameter file.
> log_archive_start=true
> log_archiive_dest_1=C:\oracl\ora92\database\archive
> log_archive_format="Log_%s.arc"
>
> After restart the database several times I found these three parameters
> didn't work. I have used the same way to set such parameters in 8i many
> times before and there were no problem.
> I wonder if Oracle 9i has changed the way to set these parameters.
>
> Thanks!
>
> Eric
>
>
>

Nope they are the same. You must have forgotten the procedure then.

1. shutdown
2. edit the initialization parameters as you stated
3. startup mount
4. alter database archivelog;
5. alter database open;

All of which is sooo clearly mentioned in the admin manual which you seem to have forgotten :)
The manual does also state to backup your db before step 2 and after step 5

hth
Anurag Received on Wed Aug 13 2003 - 19:11:18 CDT