Re: Archive Logs

"Rick Anderson" <Richard.Anderson_at_oracle.com> wrote in message news:Xns933A4EEFC6598RichardAndersonoracl_at_148.87.1.53...
> Do NOT use V$PARAMETER - use V$ARCHIVE_DEST.
> For example:
>
> select dest_id,status,destination from v$archive_dest;

In the first instance I would use SHOW PARAMETER ARCHIVE in the first instance. I get (on 9i2)

SQL> show parameter archive

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------------------
---
archive_lag_target                   integer     0
log_archive_dest                     string
log_archive_dest_1                   string
<snip>
log_archive_dest_state_1             string      enable
<snip>
log_archive_duplex_dest              string
log_archive_format                   string      ARC%S.%T
log_archive_max_processes            integer     2
log_archive_min_succeed_dest         integer     1
log_archive_start                    boolean     FALSE
log_archive_trace                    integer     0
remote_archive_enable                string      true
standby_archive_dest                 string      %ORACLE_HOME%\RDBMS

In other words archiving is not started and I haven't set any parameters at all. Now v$archived_log will be empty (or maybe have a gap in it) in this instance but why do two queries when one statement will show what is going on.

If I run your query I get

   DEST_ID STATUS DESTINATION

---------- --------- ------------------------------
         1 VALID     C:\oracle\ora92\RDBMS
         2 INACTIVE
         3 INACTIVE
         4 INACTIVE
         5 INACTIVE

etc etc. Received on Mon Mar 10 2003 - 08:18:23 CST