ARCHIVELOG + backup question
Date: 30 Dec 2001 00:43:22 -0800
Message-ID: <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
+ I've looked at copying entire database (at OS level) but I assume a
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 ?
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 - 09:43:22 CET