RE: alter database recover managed standby database disconnectfrom session;

From: Roger Xu <Roger.Xu_at_dp7upbg.com>
Date: Wed, 20 Sep 2006 09:37:24 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F70C8D41D2@irv2kexch01.tx.bg.corp>

Thanks for your help.
I was able to create my standby last night. Yes, the "disconnect from session" works just like nohup and it has nothing to do with disconnecting from the current SQL*plus session.

-----Original Message-----
From: Jörg Jost [mailto:jost_at_unitrade.com] Sent: Wednesday, September 20, 2006 7:42 AM To: Oracle-L_at_Freelists. Org (E-mail)
Cc: Roger Xu
Subject: RE: alter database recover managed standby database disconnectfrom session;

On Tue, 2006-09-19 at 14:00 -0600, Reidy, Ron wrote:
> What does this mean? Are you saying that you can still issue SQL
> statements?
>
>
>
> Obviously, the prompt returns, but is the session still active? Is it
> in the process list of v$session/v$process?
>

Hi Ron,

here is the discription of the disconnect clause from the SQL Reference:

"DISCONNECT Specify DISCONNECT to indicate that Redo Apply should be performed in the background. Doing so leaves the current session available for other tasks. The FROM SESSION keywords are optional and are provided for semantic clarity."

So for me, without testing, it seems that something like a nohup from the unixworld is happening, if you use this clause.

hth

Jörg

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use o

---

This email has been scanned for all viruses by the MessageLabs Email Security System.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 20 2006 - 09:37:24 CDT