Re: dataguard fail over test... what did I miss? part 2

From: Vince Laurent <vincelaurent_at_REMOVETHISsbcglobal.net>
Date: Wed, 03 Aug 2005 17:46:25 GMT
Message-ID: <dl02f1l962mchqq8d86j9tclsr1n2l6o8i@4ax.com>

When I check the status I still get:

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE; SWITCHOVER_STATUS

---

SESSIONS ACTIVE SQL> select sid, process, program from v$session;

       SID PROCESS PROGRAM
---------- ------------

---

         1 897          oracle_at_sapude (PMON)
         2 899          oracle_at_sapude (DBW0)
         3 901          oracle_at_sapude (LGWR)
         4 903          oracle_at_sapude (CKPT)
         5 905          oracle_at_sapude (SMON)
         6 907          oracle_at_sapude (RECO)
         7 909          oracle_at_sapude (ARC0)
         8 911          oracle_at_sapude (ARC1)
         9 5424         sqlplus_at_sapude (TNS V1-V3)
        12

10 rows selected.

Session 12 is ME. Is the "SESSIONS ACTIVE" one of the other ones?

---

Come race with us!
http://www.mgpmrc.org Received on Wed Aug 03 2005 - 12:46:25 CDT