RE: Question re applying archive logs

From: Goulet, Dick <richard.goulet_at_capgemini.com>
Date: Tue, 20 Nov 2007 14:33:59 -0500
Message-ID: <746B47FAF6783042B256C0E7CC0795CD0247E6EE@caonmastxm02.na.capgemini.com>

Bill,

Since you have the database open, the database SCN can be incrementing, you'll have to re-restore the database and roll it forward to the new time. Would have been better to open it READ ONLY.

Dick Goulet / Capgemini
North America P&C / East Business Unit
Senior Oracle DBA / Hosting
Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com Fax: 508.229.2019 / Email: richard.goulet_at_capgemini.com 45 Bartlett St. / Marlborough, MA 01752

Together: the Collaborative Business Experience

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of William Wagman Sent: Tuesday, November 20, 2007 1:57 PM 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

This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 20 2007 - 13:33:59 CST