Re: Standby database, and its status

From: Michel Cadot <micadot2removethat_at_free.fr>
Date: Sat, 27 Sep 2003 11:04:48 +0200
Message-ID: <3f7551e3$0$10412$626a54ce@news.free.fr>

"mar" <mar_at_notexist.com> a écrit dans le message de news:bl3hbc$7rmkv$1_at_ID-174077.news.uni-berlin.de...
> I have a standby database (8i on Win2k). How can I
> programmatically find out whether it's in one of three
> possible states (recovery status, read-only status,
> and activated status)?
>

select status, database_status, open_mode from v$instance, v$database;

Hope this helps
Michel Cadot Received on Sat Sep 27 2003 - 04:04:48 CDT