RE: Query Database while shutdown in progress

Of course, there is a checkpoint, and then there is a checkpoint. :-) Crash
recovery is all about when did the checkpoint complete, not when did it
begin, correct? :-)

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: Randy Johnson [mailto:randyjo@xxxxxxxxxxxxx]
  Sent: Wednesday, June 27, 2007 7:19 PM
  To: jkstill@xxxxxxxxx; andrew.kerber@xxxxxxxxx
  Cc: robertgfreeman@xxxxxxxxx; 'oracle-l'
  Subject: RE: Query Database while shutdown in progress


  Then the database will say these files require media recovery. Then you,
the expert DBA that you are, will do an "alter database datafile {filename}
end backup;" followed by an "alter database open;" and all will be well.
:-)

  My general approach to bouncing a database that typically takes a long
time to shutdown immediate is:
      1) shutdown abort
      2) startup restrict
      3) shutdown immediate

  BTW, unless I'm mistaken, checkpoints occur automatically at the least
every 3 seconds.

      -Randy






----------------------------------------------------------------------------
--
  From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jared Still
  Sent: Wednesday, June 27, 2007 3: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> 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


  No virus found in this incoming message.
  Checked by AVG Free Edition.
  Version: 7.5.476 / Virus Database: 269.9.10/873 - Release Date: 6/26/2007
11:54 PM




  No virus found in this outgoing message.
  Checked by AVG Free Edition.
  Version: 7.5.476 / Virus Database: 269.9.10/873 - Release Date: 6/26/2007
11:54 PM

Other related posts: