Re: archive log question?

From: <xsun1913_at_my-dejanews.com>
Date: Tue, 27 Oct 1998 15:33:31 GMT
Message-ID: <714p4b$kjg$1@nnrp1.dejanews.com>

In article <363499A8.F40_at_neostrata.com>, dliu_at_neostrata.com wrote:
> I have some questions about Oracle archive log, hope someone can help me
> Thanks in advance!
>
> 1)how can I decide if a database uses archive log mode? I need a way to
> get this info from system table/view instead of using server manager.
>
> 2)the destination directory for archive log files containing a
> environment variable %RDBMS73%. how can I get its real value? the
> program is not on the server machine so I can't get it from operating
> system. Is there somewhere Oracle stores the environment variable
> values?!
>
> dennis

Hi, Dennis,

You could issue a query like "select log_mode from v$database" from SQL*Plus.

2)On UNIX system, you can get environment variables $ORACLE_BASE or $ORACLE_HOME directly from shell. On Win NT/95, you can get them from registry.

Hope this help.

Xuening Sun

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 27 1998 - 09:33:31 CST