nitin_kaul_at_rediffmail.com schrieb:
> hi
> I work on oracle 9.2.0.1.0 win 2k
> i have a physical standby database...we have implemented it using
> datagaurd.
>
> i want to perform a switchover..
> but when i query my primary db the following query :
>
> sql>select switchover_status from v$database;
>
> SWITCHOVER_STATUS
> ------------------
> SESSIONS ACTIVE
>
>
> but is't supposed to show me TO STANDBY
>
> so can i perform switchover with this switchover_status..
>
I suppose, there are some background processes running, if you set
job_queue_processes=0 and aq_tm_processes=0, so you should see "TO
STANDBY", but as pointed by Stephen Howard, "WITH SESSION SHUTDOWN"
should work as well...
Best Regards
Maxim
Received on Mon Apr 11 2005 - 19:42:43 CDT
