RE: Query Database while shutdown in progress

  • From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
  • To: oracle.rdbms@xxxxxxxxx, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 27 Jun 2007 08:00:37 -0500

The simplest method on unix is to tail -f  the alert log.

 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sinardy Xing
Sent: Tuesday, June 26, 2007 9:58 PM
To: oracle-l
Subject: Re: Query Database while shutdown in progress

 

Hi all,

I would like to rephrase my question, how do we monitor the progress of
shutting down immediate mode.


Thanks.




On 6/27/07, Sinardy Xing <oracle.rdbms@xxxxxxxxx> wrote:

Hi all,

When we shutdown Oracle instance with shutdown immediate mode. The
Oracle will wait until all rollback completed. 

The challenge is, how we can login to the instance to check the progress
of rolling back, assume we are given sysdba privilege. 

Our attempt:
Login / as sysdba unable to query v$transaction. as shutdown in progress
not allow query.
Why Oracle allow to log in as sysdba while nothing can be done in the so
call session.


Thanks for sharing your ideas. 

-- 
regards,
Santos 






------------------------------------------------------------------------------
NOTICE:  This electronic mail message and any attached files are confidential.  
The information is exclusively for the use of the individual or entity intended 
as the recipient.  If you are not the intended recipient, any use, copying, 
printing, reviewing, retention, disclosure, distribution or forwarding of the 
message or any attached file is not authorized and is strictly prohibited.  If 
you have received this electronic mail message in error, please advise the 
sender by reply electronic mail immediately and permanently delete the original 
transmission, any attachments and any copies of this message from your computer 
system. Thank you.

==============================================================================

Other related posts: