Re: automatic archiving?

In article <8q6cle$soq$1_at_nnrp1.deja.com>,   gdas_at_my-deja.com wrote:
> Hi,
>
> I am trying to implement a hot backup script for my database. The
> database is a development database, but I still do not want to
 practice
> this on it as our developers will be very upset with me should
> something go wrong. I am practicing on a home machine which
> unfortunately is running Oracle 8.1.5 personal edition on NT. (We run
> enterprise edition in the office)
>
> I'm having a problem getting the database to automatically archive.
> (I'm not sure if this is a limitation of personal edition or if I did
> something wrong).
>
> Here are the steps I took:
>
> shutdown immediate of the database
> startup exclusive mount oracle
> alter database archivelog
> shutdown immediate
> startup
>
> connected to database and issued command to confirm archivelog mode
> enabled:
> archive log list
>
> result: confirmed, but automatic archival is disabled.
>
> shutdown immediate
> set the following parameters in init.ora file:
> log_archive_start = true
> log_archive_dest = %ORACLE_HOME%\database\%ORACLE_SID%\archive
> log_archive_format = "%SAMPLE%T%TS%S.ARC"
>
> attempt to restart database with startup command
> Result: Error, the instance cannot be started.
>
> Commented the above init.ora parameters and tried again and this time
> the instance started.
>
> Have I missed a step or is it possible that personal edition does not
> support automatic archive mode?
>
> Thanks for any help,
> Gavin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Since the init<>.ora file is instance-specific I have always hard-coded my archive log destinations. Give that a try.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.