Re: archivelog mode in Oracle 8.1.6 standart edition?

The lines you uncommented start automatic archival. They do *not* place the database in archivelog mode.
To do that close the database and execute alter database archivelog
followed by
alter database open
now shutdown and perform a full backup.
The 'location=' keyword doesn't occur in Oracle 7 (no Rman). Try to remove it and see what happens.

Hth,

Sybrand Bakker, Oracle DBA

"Andrew Zhilenko" <andrew_at_nextra.com> wrote in message news:39905F48.6D158814_at_nextra.com...
> Hello!
>
> I have installed Oracle software and created custom database
> using scripts created by dbassist. However, after I've have
> uncommented following lines in initMSPL.ora:
> log_archive_start = true
> log_archive_dest_1 = "location=/usr/app/oracle/admin/MSPL/arch"
> log_archive_format = arch_%t_%s.arc
>
> and I try to execute SIDarchive.sh, command:
> startup mount pfile= "/usr/app/oracle/admin/MSPL/pfile/initMSPL.ora";
> fails because of error:
> ORA-00439: feature not enabled: Managed Standby
>
> But I do not need managed stand by, I only need "normal"
> archivelog functionality! Any suggestions?
>
> WBR, Andrew
> --
> Andrew Zhilenko, AZ283-RIPE, System Administrator
> Nextra Czech Republic s.r.o.
> tel.+42-02-96159436 fax. +42-02-96159422
> e-mail: andrew@nextra.com http://www.nextra.cz
> Vaclavske namesti 4 - Praha 1 - 110 00
> Czech Republic
Received on Tue Aug 08 2000 - 00:00:00 CDT