Re: ARCHIVELOG + backup question

"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 - 02:22:54 CET