Re: Archive Logs

"Christoph Bielitza" <c.bielitza_at_stadtwerke-remscheid.de> wrote in news:b4n1lg$c2r1_at_pen6.pen.k12.va.us:

> Hi,
> I have a question. Is it correct, that I am not able to use
> archive logs with the Oracle 8.1.7 standard edition ?
> I tried to use the following parameters in the init.ora-file:
>
> log_archive_start = true
> log_archive_dest = "location=e:\redos"
> log_archive_format = %T%TS%S.ARC
>
> but if I restart the database nothing happens.
>
> Any idea ?
>
> Thanks a lot
> Bye
> Christoph
>
>
>

Yes, you can use archivelogs in standard edition in 8i (or any release for that matter).
First, turn on archiving using ALTER DATABASE ARCHIVELOG command. Then, turn on the ARCH process using log_archive_start init.ora parameter (as you have done).
Then, Specify a valid archivelog destination (log_archive_dest='e:\redos'). DO NOT use LOCATION= attribute with "historical" init.ora parameters.

Open the database instance and you are good to go!

Then, I suggest reading the manuals some more...

Rick Received on Wed Mar 12 2003 - 05:06:55 CST