Re: ARCHIVELOG + backup question

Run in archive log mode.
Then you can do hot backups.
Jim
"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 Sun Dec 30 2001 - 15:05:46 CET