From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Subject: Re: archivelog mode in Oracle 8.1.6 standart edition?
Date: 2000/08/08
Message-ID: <965764304.16840.0.pluto.d4ee154e@news.demon.nl>#1/1
X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78
References: <39905F48.6D158814@nextra.com>
X-Trace: news.demon.nl 965764304 pluto:16840 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Newsgroups: comp.databases.oracle.server
X-Complaints-To: abuse@nl.demon.net


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@nextra.com> wrote in message
news:39905F48.6D158814@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