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: Hot backup questions

Re: Hot backup questions

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 27 Oct 1999 20:02:55 GMT
Message-ID: <381e550c.5574323@news.siol.net>


On Wed, 27 Oct 1999 12:25:37 -0400, Doug Cowles <dcowles_at_nospambigfoot.com> wrote:

>Thanks for the thread everyone. It's all coming back to me now. I do remember
>this
>piece of information about hot backups but I had forgotten it. The problem was
>two-fold. A hot-backup was having trouble writting to tape, and abended without
>taking a tablespace out of backup mode. In addition, a sysadmin when rebooting
>the box didn't shut down Oracle cleanly (I think), so the frozen SCN number
>required an application of some archive logs to fix itself, even though it wasn't
>really out of synch as these posts suggest, but more a few SCN numbers behind.
>I'm not sure what happens if you bring
>a database down cleanly while in hot backup mode, but I'll try it. Maybe Oracle
>was shut
>down cleanly after all.

Oracle will not allow you to shut down the database (unless it is shutdown abort) if any of the tablespaces is in hot backup mode.

>Thanks again,
>Dc.

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Oct 27 1999 - 15:02:55 CDT

Original text of this message

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