Point-in-time recovery test

[khas]

I am testing archive logging point-in-time recovery on Oracle 8.1.6. What I'd like to do is recover twice really. Recover to a point in time BEFORE the change and then recover to a point in time AFTER the change.

What I've tried is this:

1. Did a physical backup of files
2. Made a change to the database
3. Switched the log files.
4. Simulated a database crash.
5. Restored datafiles from physical backup (no logs or control files)
6. Recovered to a point BEFORE the change was made to show that the change is gone.
- recover database until time 'BEFORE CHANGE';
- alter database open noresetlogs;

7. Then recovered to a point AFTER the change to show that the change can come back from the archive log file.
- recover database until time 'AFTER CHANGE';
- alter database open resetlogs;

Is this possible? If so, what am I missing because this is not working.

Thank you in advance.

[vinit]

I guess after an incomplete recovery, you need to open DB with resetlogs.

[pando]

if you resetlogs you cannot recover it further more with OLD archived logs so basically what you are trying to do does NOT work

[vinit]

Originally posted by pando
if you resetlogs you cannot recover it further more with OLD archived logs so basically what you are trying to do does NOT work

Yes, perhaps he should start all over again, barring steps 1 (if backups are still available) and 6.

[khas]

You are all right. It's not working. I'm trying to figure out how to make it work.

I'm testing to see if I can recover to BEFORE the change and THEN roll forward again to bring the change back. Is this possible?

I guess I should have clarified myself more.

[anandkl]

Hi Friends,
I dont think you can do it in this way..
Nore you have any recover method for this kind of a senario.

regards
anandkl