Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 8 hot backup without archivelog mode ?
Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message
news:3972F1EE.7458_at_yahoo.com...
> Howard J. Rogers wrote:
> >
> > "Jeffrey Schott" <jschott_at_schottconsulting.com> wrote in message
> > news:n5Ib5.48$aO1.877_at_news3.voicenet.com...
> > > If you bring the tablespace offline you can perform a backup while the
rest
> > > of the tablespaces are available. Unfortunately, you will be not able
to
> > > access the tablespace that you are backing up. You may also be able
to
put
> > > the tablespace in "read only" mode (but I've never tried this myself).
> > >
> > > Good Luck!
> > >
> >
> > This simply won't work. Oh, you'll be able to backup the datafiles
> > associated with the offlined tablespace alright. And if you repeat the
> > process for all your tablespaces (except SYSTEM, of course, which can
never
> > be taken offline), you'll have something that resembles a backup of all
your
> > non-system datafiles. Except that what you really have is a backup set
that
> > is internally inconsistent -different datafiles taken at different
times.
> > Once you ever try and restore one or more of these datafiles, the first
> > thing Oracle will insist on is bringing the datafiles up to the same,
> > consistent, time -which will require the application of archived redo
logs.
> >
> > For the same reason, there are a number of backup utilities that appear
to
> > be able to take backups of open datafiles. They work fine, but the
> > timestamps on the files backed up are inconsistent with each other (and
thus
> > will require archives to be useful). Plus, because these are o/s
utilities,
> > there is no guarantee of the order in which the blocks within a datafile
are
> > copied. You therefore end up with each datafile being itself internally
> > inconsistent.
> >
> > I'm afraid there is no alternative: if you want hot backups, you MUST be
in
> > archivelog mode.
> >
> > Regards
> > HJR
> >
> > >
> > > Piotr Ga³uszkiewicz <pkg_at_poczta.fm> wrote in message
> > > news:8kms4n$q30$1_at_zeus.polsl.gliwice.pl...
> > > > Hi
> > > >
> > > > Know anybody some ways or software to "hot" backup (without
shutdown)
oracle
> > > > 8 database but
> > > > in NO ARCHIVELOG mode ? (Solaris / Sparc platform)
> > > >
> > > > Piotr
> > > >
> > > >
> > >
> > >
>
>
>
>
I must confess to not having encountered the concept of suspending a database before -so I can only guess that it sounds like a 'boot users off the system and put it into read-only' type of situation. Which is not exactly what our original poster wanted -he wanted to do 'hot' backups, which I am again assuming means that he wants to take backups whilst users are blattering his system to death with their various updates.
Regardless, you'd have to enlighten me on the benefits to be gained from suspending a database, rather than simply shutting the thing down completely and performing a cold backup.
Take care
HJR
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk
>
> We are born naked, wet and hungry...then things get worse
Received on Wed Jul 19 2000 - 00:00:00 CDT