Re: automatic archiving?

In article <8q6d6s$tcq$1_at_nnrp1.deja.com>,   oratune_at_aol.com wrote:
> 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
>

Thanks very much, that did the trick!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 19 2000 - 00:21:30 CDT