RE: Query Database while shutdown in progress

Robert,  

Who's "Viola"? ;-)  

Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Robert Freeman Sent: Wednesday, June 27, 2007 4:48 PM
To: Jared Still; andrew.kerber_at_gmail.com Cc: oracle-l
Subject: RE: Query Database while shutdown in progress

Or in 10g you just do an alter database end backup... So, if that possibility exists make your startup script:  

startup mount;
alter database end backup;
alter database open;  

Viola, no problems!!

RF  

Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com! Sig V1.1

-----Original Message-----
From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Wednesday, June 27, 2007 2:43 PM
To: andrew.kerber_at_gmail.com
Cc: robertgfreeman_at_yahoo.com; oracle-l
Subject: Re: Query Database while shutdown in progress

On 6/27/07, Andrew Kerber <andrew.kerber_at_gmail.com <mailto:andrew.kerber_at_gmail.com> > wrote:

What happens if you have datafiles in backup mode and you try and do a startup force?  

select

        'alter database datafile ' || '''' || f.name <http://f.name> || '''' || ' end backup;' from v$datafile f, v$backup b
where b.status = 'ACTIVE'
and f.file# = b.file#
/

run the generated SQL.

-- 

Jared Still 
Certifiable Oracle DBA and Part Time Perl Evangelist





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

Please access the attached hyperlink for an important electronic communications disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html


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



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