Re: Returning to Old Datafiles

Dean:

You won't be able to do this exactly as you'd like (and not at all if you are not running in archivelog mode). In Oracle7, you can't recover a single tablespace to a previous point in time (you can in Oracle8). You have a couple of choices:

1. Don't do anything at all.
2. Recover the entire database to the previous Monday.
3. IF you have an export from Monday night, you can truncate all of the necessary tables and import Monday's data.

If you're not running in archivelog mode, you won't be able to do step#4 below. If you are running in archivelog mode and you have all the archive logs since last Monday, the database will force you to recover the tablespace up to the current SCN.

If this is a recurring problem, consider:

1. Taking a nightly export. OR
2. Upgrade to Oracle8 and use archivelog mode so you can do a "point-in-time tablespace recovery". OR
3. Find a new employer with some common sense!

Seriously, study the Recovery section of the Server Administrator's guide. It spells out all the different recovery options, and the necessary steps and requirements.

Good luck!
Dave

Dean Mah wrote in message <6iamum$8eq_at_ds2.acs.ucalgary.ca>...
>I am a totally newbie when it comes to recovery and I assuming that this
>is a simple question.
>
>What I want to do is to go back to using last Monday's data for a
>particular tablespace. What I plan to do is:
>
>1) Get the old datafiles from tape.
>2) Take the tablespace offline.
>3) Overwrite the current datafiles with the old ones.
>4) Re-open the tablespace.
>
>However, I don't want to run all of the transactions from last Monday
>forward.
>
>Are there any gotcha's here that I have to look out for? Any advice?
>
>Our set-up is Oracle 7.3.2 on AIX 4.1.5. Cold backups are done nightly.
>
>Thanks,
>Dean
>
>
Received on Sat May 02 1998 - 23:43:25 CDT