RE: Question re applying archive logs

Bill,

What you can do is

• Restore from backup
• Mount DB
• Recover until 6am.
• Enable flashback. (Make sure you have enough room in flashback area)
• Create an guaranteed named restore point.
• Open resetlogs
• let users do their changes

To revert back and rollforward
- startup force mount

• flashback to named restore point created above.
• Drop restore point (Guaranteed restored points needs to be dropped manually other it keeps using space in flashback area
• Recover until next day 6am (rollforward)
• Create an guaranteed named restore point.
• Open resetlogs
• let users do their changes

Cheers,
Vishal

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of William Wagman
Sent: 20 November 2007 18:57
To: oracle-l_at_freelists.org
Subject: Question re applying archive logs

Greetings,

We are trying to track down a problem which occurred a month ago and the developers have requested that I restore a database incrementally. This is Oracle 10gR2 and we are using RMAN to do backups. They wish the database be recovered and restored to 6:00am on a particular day, they will look at the data. They then want to see the state of the database 4 hours later. I have restored the database to 6:00am on that day and I have archive logs generated over the next 24 hour period. The database is in a consistent state and open now, how do I apply the next two archive logs? Can I do that? I haven't been able to figure it out. I hope I am stating the problem clearly.

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l