automatic archiving?

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. Received on Mon Sep 18 2000 - 19:40:18 CDT