RE: alter database recover managed standby database disconnectfrom session;

From: "Roger Xu" <Roger.Xu@xxxxxxxxxxx>
To: Jörg Jost <jost@xxxxxxxxxxxx>, "Oracle-L@Freelists. Org \(E-mail\)" <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 20 Sep 2006 09:37:24 -0500

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@xxxxxxxxxxxx]
Sent: Wednesday, September 20, 2006 7:42 AM
To: Oracle-L@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.
--
//www.freelists.org/webpage/oracle-l

RE: alter database recover managed standby database disconnectfrom session;

Other related posts: