Re: ARCHIVELOG + backup question

Yes, but doing so is useless.
Jim

"Richard Shea" <rshea_at_my-deja.com> wrote in message news:43160f6f.0112301722.3993749c_at_posting.google.com...
> "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
 news:<_aFX7.26852$uM.229074_at_rwcrnsc54>...
> > Run in archive log mode.
> > Then you can do hot backups.
> > Jim
> OK. Thanks for the info. Is it possible to switch into ARCHIVELOG mode
> just for the duration of the backup (and any subsequent restore) ? If
> so how ?
>
> thanks
> richard
> rshea_at_NOTTHISBITopendoor.co.nz
> > "Richard Shea" <rshea_at_my-deja.com> wrote in message
> > news:43160f6f.0112300043.17899526_at_posting.google.com...
> > > Hi - I want to take a backup of all the tables belonging to user X so
> > > that I can quickly and easily restore them. I will need to do this
> > > repeatedly over a short period of time and it's only the data (hmmm,
> > > sequences ?) that will change (it's for a dev env). Database is
> > > running as NOARCHIVELOG. I have complete control of server (ie can
> > > close down or do whatever/whenever) but I don't want to restore over
> > > other users.
> > >
> > > What's the best way to do this ?
> > >
> > > + I've looked at copying tablespaces (at OS level) but NOARCHIVELOG
> > > precludes this ... or can I go into ARCHIVELOG 'mode' just long enough
> > > for the backup and restore ? If so I can someone tell me how ?
> > >
> > > + I've looked at copying entire database (at OS level) but I assume a
> > > restore must restore the entire database ?
> > >
> > > + I've looked at using IMP but would have to drop the user every time
> > > - bit boring !
> > >
> > > If anyone can suggest a nice and simple "trash the current data and
> > > replace it with this" option then I'd appreciate it.
> > >
> > > thanks
> > >
> > > richard shea
> > > rshea_at_NOTTHISBITopendoor.co.nz
Received on Mon Dec 31 2001 - 05:25:14 CET