Look in v$database column log_mode.
Tested on 7.3.4 on NT.
Work also in 8.1.6 and 9.0.1
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 7:13 PM
> Anybody knows how to get status of archiver process pro
y: [EMAIL PROTECTED]
06/05/2002 10:13 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Archiver process in 7.3.4
Anybody knows how to get status of archiver process programmatically in
Oracle 7.3.
Title: RE: Archiver process in 7.3.4
how about examining v$parameter for the value of
the log_archive_start parameter?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Contrary to popular opinion, Unix is user friendly.
It's just particular about who it makes friends
How about the ARCHIVE LOG LIST command in svrmgrl ?
-Original Message-
Sent: Wednesday, June 05, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L
Anybody knows how to get status of archiver process programmatically in
Oracle 7.3.4?
This information is available from v$instance
select value from v$parameter where name = 'log_archive_start';
I know that this is set in 8.0.5. Try it for 7.3.4.
Kevin
-Original Message-
Sent: Wednesday, June 05, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L
Anybody knows how to get status of archiver process programmat
Anybody knows how to get status of archiver process programmatically in
Oracle 7.3.4?
This information is available from v$instance in Oracle 8+.
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex Hillman
INET: [EMAIL PROTECTED]
Fat City Network Ser