To add to Jared's response...
If it's a:
Cold Backup: Is the database really down?
Hot Backup: Make sure you issue a "Backup control file
to ..." then back that control file up.
Regards,
satar
- Jared Still <jkstill_at_cybcon.com> wrote:
>
> Janet,
>
> I would investigate the backup process to see what
> the final step is before the controlfiles are
> backed up to tape.
>
> Could be that you need a delay of a few seconds
> in there somewhere to allow for the controlfiles
> to be updated.
>
> Jared
>
>
> On Monday 24 September 2001 16:45, Janet Linsy
> wrote:
> > Hi all,
> >
> > I got the following from our Unix admin. Looks
> like
> > control files for some database on many boxes got
> > changed when being backed up on tape. (I suppose
> the
> > backup on tape happened during mid-night) Does
> > anybody know what the reason is, and why this only
> > happened to control files? Thank you. -- Janet
> >
> >
> > Following are Oracle warnings during the nightly
> tape
> > backup:
> >
> > SNOW:
> > snow:/orafs/ora1 save: Warning -
> > `/orafs/ora1/oradata/GOLD404/control01.ctl'
> changed
> > during save
> > * snow:/orafs/ora1 save: Warning -
> > `/orafs/ora1/oradata/AMY40/control01.ctl' changed
> > during save
> >
> > SLEET:
> > sleet:/orafs/ora1 save: Warning -
> > `/orafs/ora1/oradata/oradata/TEST/control01.ctl'
> > changed during save
> >
> > ICE:
> > ice:/orafs/ora1 save: Warning -
> > `/orafs/ora1/oradata/CP40TD/control01.ctl' changed
> > during save
> >
> >
> > TSUNAMI:
> > * tsunami:/orafs save: Warning -
> > `/orafs/ora1/oradata/AB406CNV/control01.ctl'
> changed
> > during save
> > * tsunami:/orafs save: Warning -
> > `/orafs/ora2/oradata/AU406CNV/control02.ctl'
> changed
> > during save
> > * tsunami:/orafs save: Warning -
> > `/orafs/ora3/oradata/AU406CNV/control03.ctl'
> changed
> > during save
> >
> >
> >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get email alerts & NEW webcam video instant
> messaging with Yahoo!
> > Messenger. http://im.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger.
http://im.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: satar naghshineh
INET: satarnag_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Sep 25 2001 - 17:45:44 CDT