RE: Question re applying archive logs
- From: "Goulet, Dick" <richard.goulet@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Nov 2007 14:33:59 -0500
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@xxxxxxxxxxxxx
45 Bartlett St. / Marlborough, MA 01752
Together: the Collaborative Business Experience
______________________________________________________________
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of William Wagman
Sent: Tuesday, November 20, 2007 1:57 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx
(530) 754-6208
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
