Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: shutdown immediate or abort for cold-backup?

Re: shutdown immediate or abort for cold-backup?

From: Frank Zimmer <zimmer_at_i7-business.com>
Date: Mon, 27 Aug 2001 15:11:17 +0200
Message-ID: <3B8A46F5.31943E6@i7-business.com>

Hemant K Chitale schrieb:
>
> You would need to do a RECOVER database
> after a SHUTDOWN ABORT if ...
> you were running an Online Backup and one
> more tablespaces were in BEGIN BACKUP mode
> when the database was shutdown.
>
> You do NOT need to restore datafiles. Most times,
> the recovery should go through from the online redo logs
> unless there has been a lot of activity on the tablespaces
> in backup mode and the activity has already been archived
> out.
>
> Hemant K Chitale
> http://hkchital.tripod.com
>
> "Charles J. Fisher" <cfisher_at_rhadmin.org> wrote in message
> news:Pine.LNX.4.33.0108211507480.29526-100000_at_galt.rhadmin.org...
> > On Tue, 21 Aug 2001, Randy wrote:
> >
> > > I guess I would have less concern about shutdown abort if it forced the
> > > checkpoint immediately before aborting the instance.
> >
> > Jason Couchman's 8i OCP text says the following on page 669:
> >
> > "When the database starts, all checkpoint sequence numbers in all
> > datafiles, redo log files, and control files must match. If they do not,
> > Oracle will not start, and you must perform media recovery on your
> > database to get the files synchronized and in a consistent state."
> >
> > HJR says this is total horse-hockey and I should ignore it, but it
> > implies that an abort during a checkpoint trashes the database.
> >
> > Bearing this in mind, HAS ANYBODY EVER BEEN FORCED INTO MEDIA RECOVERY
> > BECAUSE OF A SHUTDOWN ABORT?
> >
> > And, more importantly, DID THIS RECOVERY REQUIRE ANYTHING MORE THAN
> > "RECOVER AUTOMATIC DATABASE" (IE, RESTORING OLD DATAFILES FROM A BACKUP)?
> >
> > Let's face it, folks, Oracle backups are a black art. What is stated in
> > the books is nothing like what happens in the real world (and please don't
> > get me started on this). While a lot of self-appointed "experts" will
> > offer "authoritative" advice, the best work that happens in this group is
> > trial and error, and the report of the findings.
> >
> > While Oracle remains closed-source, this is the best we can do.
> >
> > ------------------------------------------------------------------------
> -----
> > | Boo, Forever
> |
> > |
> |
> > | Spinning like a ghost on the bottom of a top,
> |
> > | I'm haunted by all the space that I will live
> |
> > | without you.
> |
> > |
> |
> > | -Richard Brautigan.
> |
> > ------------------------------------------------------------------------
> -----
> > / Charles J. Fisher | cfisher_at_rhadmin.org |
> http://rhadmin.org /
> > --------------------------------------------------------------------------
> ---
> >
Received on Mon Aug 27 2001 - 08:11:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US