Re: Block Corruption, cant start DB -SOS

"Candido Dessanti" <termy_at_blunet.it> wrote in message news:3D8ADA06.8020603_at_blunet.it...
> > Besides, if he has no backups and no mirroring anywhere, it's
> > gonna be awfully difficult to recover anything. With or without SCN.
>
> Of course the backup have to be done, when possible.
> Do you have an idea how much takes backing up 1Terabyte database?
>A vary
> long time, so maybe he isnt able to do backups;
> but the point is...if he has backups why he isnt doing a datafile
> recovery? I guess he hasnt a backup. And even with a backup success isnt
> guaranted, because it looks like there is logical corruption.
>
> > I'm quite sure we don't. Not that kind.
>
> Crash recovery is performed by database after a crash or shutdown abort
> recovering the database with the online redo logs, so idea of mine was
> simply to force an incomplete crash recovery

There's no such thing as an incomplete crash recovery. Instance recoveries are, by definition, complete. If you want an incomplete recovery, you are required to restore all datafiles from a backup and roll them all forward to a point of your choosing. Since you've restored all datafiles, we're talking media recovery, not crash recovery.

Without restoring all datafiles, your idea of rolling partway forward through the online logs would result in an inconsistent database, since some datafiles would be at different SCNs from others.

HJR
>until the transaction is
> generating the problem,even i dont think it would be successfull it wont
> damage in any way the database just because it would immediatly fail
> doing anything to database files.
>
>
Received on Fri Sep 20 2002 - 06:49:02 CDT