Re: Block Corruption, cant start DB -SOS

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 21 Sep 2002 08:00:03 +1000
Message-ID: <0MMi9.36726$g9.105206@newsfeeds.bigpond.com>

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:bgFi9.36609$g9.104610_at_newsfeeds.bigpond.com... [snip]
>
> BONG !! (this isn't copyrighted is it Howard ?)
>

Yes, the copyright in everything I write is vested in Oracle Corporation.

Apparently.

Regards
HJR
> You *must* perform a incomplete *database* recovery in order to perform a
> tablespace point in time recovery. There is no such thing as an isolated
> tablespace point in time recovery.
>
> To perform a TSPITR, you must restore *all* the datafiles (and all things
> being equal the backup control file as well). In mount, you *must* RECOVER
> DATABASE UNTIL blab blah. You then must open the database with resetlogs.
> IE, You have just performed a database incomplete recovery.
>
> Now you can export the database or tablespace or transportable tablespace
> (depending on database version) and re-import the tablespace or
> transportable tablespace back to your original database.
>
> That's a TSPIT recovery !!
>
> And note the restore of all data files (which naturally requires a backup)
> is a crucial and unavoidable step.
>
> Cheers
>
> Richard
> >
> >
>
>
Received on Fri Sep 20 2002 - 17:00:03 CDT