Re: archivelog or not

From: Detlef Jockheck <djockheck_at_gauselmann.de>
Date: Wed, 08 Jan 2003 12:56:47 +0100
Message-ID: <4m3hva.0cr.ln@java.adp-entwicklung.gauselmann.de>

Rick Anderson wrote:

> Detlef Jockheck <djockheck_at_gauselmann.de> wrote in
> news:4tsgva.vvp.ln_at_java.adp-entwicklung.gauselmann.de:
> 

>> Hi!
>>
>> I'm using oracle 8.1.7 on red hat linux.
>>
>> The Server-Manager shows that archive log is active:
>> --- cut ---
>> SVRMGR> archive log list
>> Datenbank-Log-Modus Archivierungsmodus
>> Automatische Archivierung Aktiviert
>> Archivierungsziel /home/oracle/arch/CDB
>> Älteste Online-Log-Sequenz 12
>> Nächste Log-Sequenz zum Arch. 14
>> Aktuelle Log-Sequenz 14
>> -- cut --
>>
>> but when I check the above location I only see:
>>
>> --- cut ---
>> -- [oracle_at_bslixp01 oracle]$ ls -la /home/oracle/arch/CDB/
>> insgesamt 8
>> drwxr-xr-x 2 oracle dba 4096 Okt 6 00:00 .
>> drwxr-xr-x 3 oracle dba 4096 Mai 30 2001 ..
>> --- cut ---
>>
>> What does this mean?
>>
>> ciao
>> Detlef
>>
>> # Detlef Jockheck
>>
>>

> 
> Detlef,
> 
> Did you start the ARCH processes, using either the LOG_ARCHIVE_START
> init.ora parameter or the ALTER SYSTEM ARCHIVE LOG START sql command?
> 
> What happens if you issue the ALTER SYSTEM ARCHIVE LOG CURRENT
> command?
> 
> Rick

Hi!

The LOG_ARCHIVE_START is activated in init.ora . When I enter ALTER SYSTEM ARCHIVE LOG CURRENT in svrmgrl a new archive is generated :-)

Another Question:
Where is the maximum size and number of archives defined?

ciao
Detlef

-- 
# Detlef Jockheck

Received on Wed Jan 08 2003 - 05:56:47 CST