RE: Query Database while shutdown in progress

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Wed, 27 Jun 2007 19:24:36 -0600
Message-ID: <KEEDIPJOJLCHPPAIDPDOAELBEBAA.robertgfreeman@yahoo.com>

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? :-)

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_at_sbcglobal.net] Sent: Wednesday, June 27, 2007 7:19 PM To: jkstill_at_gmail.com; andrew.kerber_at_gmail.com Cc: robertgfreeman_at_yahoo.com; '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:

shutdown abort
startup restrict
shutdown immediate

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

-Randy

--

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

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 27 2007 - 20:24:36 CDT