Re: archivelog or not

From: Rick Anderson <Richard.Anderson_at_oracle.com>
Date: Wed, 08 Jan 2003 11:01:37 GMT
Message-ID: <Xns92FD3C46F8F01RichardAndersonoracl@148.87.1.53>

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 Received on Wed Jan 08 2003 - 05:01:37 CST