RE: RESETLOGS w/o incomplete recovery

I have simply recreated the controlfile in the past, although I am not sure this is the "best" way to do it.

backup controlfile to trace, alter the resulting trace file (modify those annoying comments so they are real sql*plus comments, and anything else you need/want). There are two scenarios in the backed up controlfile, the first a noresetlogs, the 2nd with resetlogs. I believe you will want the 2nd example. No recovery needed, unless (depending on how you shut down), the database will not start because sys needs "is not a current copy" and needs to be recovered. Simply point the recovery to the online redo logs, if this is the case.  

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bob Sent: Monday, April 24, 2006 7:12 PM
To: oracle-l
Subject: RESETLOGS w/o incomplete recovery

Guys, say I'm in a development environment ,and to be sure I dont have gaps in my archive log or I just feel like resetting them to 0 , I;d to to reset the logs without going through the trouble of performing incomplete recovery. Is there a way to do this?

Thanks
Bob

--

"Oracle error messages being what they are, do not highlight the correct cause of fault, but will identify some other error located close to where the real fault lies."

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Apr 24 2006 - 19:24:34 CDT