Re: How to set Archivelog mod ?

From: vigi98 <vigi98_at_caramail.com>
Date: Tue, 28 May 2002 10:46:51 +0200
Message-ID: <3CF343FB.70606@caramail.com>

Adam Buczynski wrote:

> Didn`t you forget to:
> 
> SHUTDOWN IMMEDIATE
> 
> STARTUP MOUNT
> 
> ALTER DATABASE ARCHIVELOG
> 
> ALTER DATABASE OPEN
> 
> Adam

I know this command line in mounted state. But, isn't it possible to set archivelog mode in init.ora and simply restart the database ?

Second question : I tried what you propose, but sqlplus answered me : ORA-00265 : instance recovery required, cannot set ARCHIVELOG mode

What does that mean ?

> 
> "vigi98" <vigi98_at_caramail.com> wrote in message
> news:cafa5ee3.0205272338.41ad1985_at_posting.google.com...
> 

>>Hi all,
>>
>>In my init.ora, I tried lots of parameters in order to set my database
>>in archivelog mode. There's nothing to do : I always have this :
>>
>>SQL> archive log list;
>>Database log mode No Archive Mode
>>Automatic archival Enabled
>>Archive destination /u08/backup
>>Oldest online log sequence 4771
>>Current log sequence 4778
>>
>>As you can see, something is enabled (I wonder what it means...) but
>>I'm not in archivelog mode. So what have I to do ?
>>
>>Following, the archive section of my init.ora :
>>#--- Archive Mode ---
>> log_archive_start = true
>> #log_archive_dest_1 = "location=/u08/backup/"
>> log_archive_dest_1 = "LOCATION=/u08/backup MANDATORY"
>> #log_archive_dest = "location=/u08/backup/"
>> log_archive_format = arch_%t_%s.arc
>> log_archive_max_processes = 1 #AHU
>> log_archive_dest_state_1 = ENABLE
>>
>>
>>Thanks in advance for your help.

> 
> 
> 

Received on Tue May 28 2002 - 03:46:51 CDT