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@xxxxxxxxxxxxxxxxx 
www.credit-suisse.com 

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Robert Freeman
Sent: Wednesday, June 27, 2007 4:48 PM
To: Jared Still; andrew.kerber@xxxxxxxxx
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@xxxxxxxxx]
Sent: Wednesday, June 27, 2007 2:43 PM
To: andrew.kerber@xxxxxxxxx
Cc: robertgfreeman@xxxxxxxxx; oracle-l
Subject: Re: Query Database while shutdown in progress


On 6/27/07, Andrew Kerber <andrew.kerber@xxxxxxxxx 
<mailto:andrew.kerber@xxxxxxxxx> > 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
==============================================================================

Other related posts: