Re: Recover database using backup controlfile

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 26 Apr 1999 09:14:58 -0700
Message-ID: <37249101.8367508F@us.oracle.com>

The other answers have explained the why. It's important, though to realise that the effect of the resetlogs is to start the log sequence numbers from one again. Your next step must be a bckup of the entire database, since you can't recover across this operation without Oracle's help.

HTH. Pete

yew.poo.choon_at_mbf.com.my wrote:

> Is that a must that If I perform database recovering
> using backup controlfile, I have to open database with the resetlogs ?
>
> I try to use with noresetlogs but it fail with
> "must use RESETLOGS option for database open "
> Can any one explain why ?
> TQ
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Mon Apr 26 1999 - 11:14:58 CDT