RE: Query Database while shutdown in progress

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Wed, 27 Jun 2007 19:18:28 -0600
Message-ID: <KEEDIPJOJLCHPPAIDPDOAELAEBAA.robertgfreeman@yahoo.com>

BLAH.... Voila!!

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: Baumgartel, Paul [mailto:paul.baumgartel_at_credit-suisse.com]   Sent: Wednesday, June 27, 2007 3:24 PM   To: 'robertgfreeman_at_yahoo.com'
  Cc: oracle-l
  Subject: 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!!

  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> wrote:

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

select

'alter database datafile ' || '''' || 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 Received on Wed Jun 27 2007 - 20:18:28 CDT