Re: Db crashed with no backups :confused:
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sun, 01 Feb 2009 18:32:41 +0100
Message-ID: <4985dcb9$0$2870$ba620e4c_at_news.skynet.be>
dbagtcol schreef:
> Hi all
> We've just had a scenario here; one of our dev db has just crashed due
> to unavoidable power failure. We've had no backup for this since the
> beginning. I could recover redo logfiles; I couldn't RECOVER datafiles
> though. I am trying out CREATE CONTROLFILE REUSE DATABASE orcl
> RESETLOGS NOARCHIVELOG option, provided I don't have backups for
> control files, redo logfile, datafiles, spfiles or anything. I am on
> RHEL 4, Oracle 10gR2.
>
> Please suggest.
Date: Sun, 01 Feb 2009 18:32:41 +0100
Message-ID: <4985dcb9$0$2870$ba620e4c_at_news.skynet.be>
dbagtcol schreef:
> Hi all
> We've just had a scenario here; one of our dev db has just crashed due
> to unavoidable power failure. We've had no backup for this since the
> beginning. I could recover redo logfiles; I couldn't RECOVER datafiles
> though. I am trying out CREATE CONTROLFILE REUSE DATABASE orcl
> RESETLOGS NOARCHIVELOG option, provided I don't have backups for
> control files, redo logfile, datafiles, spfiles or anything. I am on
> RHEL 4, Oracle 10gR2.
>
> Please suggest.
After a power failure, you only need to start the database normally. It will roll back all non-commited transactions and that's it. What have you tried to do? Received on Sun Feb 01 2009 - 11:32:41 CST