Re: Some one tested RESETLOGS new functionality on 10g?

From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Mon, 28 Feb 2005 23:03:00 -0800 (PST)
Message-ID: <Pine.LNX.4.60.0502282258470.3124@cpq7598>

On Mon, 28 Feb 2005, Tim Gorman wrote:

> So, now it seems like Oracle10g has taken the next step and started
> performing the above steps automatically, using only the most current
> controlfile. I bet this saves a few lives...

Here's the doc for 10g.

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10734/recoscen.htm#1006821

There was also a nice paper on Metalink at one time by Lawrence To and Stefan Pommerenk of the Oracle Support CoE on recovery past resetlogs for Oracle7 and 8.

Luckily I saved a copy! It basically takes the steps that Tim outlined.

--
Jeremiah Wilton
ORA-600 Consulting
Emergencies - Seminars - Hiring
http://www.ora-600.net
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 01 2005 - 02:06:14 CST