Re: Standby database - how to check the mode of the recovery

From: Rick Anderson <Richard.Anderson_at_oracle.com>
Date: Fri, 23 Aug 2002 04:56:45 -0400
Message-ID: <3D65F8CC.7EA095D2@oracle.com>

EP,

"managed" vs "manual" recovery of a standby database is really the question. Managed recovery uses the "MRP0" process (or a foreground equivalent), which can be identified using the V$MANAGED_STANDBY fixed view. The "Data Guard Concepts and Administration" manual contains a description of the columns for this view.

Manual recovery will not have an entry in this view, obviously...

Hope this helps.

Rick

EP wrote:

> > How about v$database and v$instance?
>
> But what you have got there is the info that the database is mounted. AFAIK
> there is no data that would tell you whether it is managed or non-managed
> mode.
>
> Best regards
> EP
Received on Fri Aug 23 2002 - 03:56:45 CDT