Re: Block Corruption, cant start DB -SOS

> 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.

No, you need only:

1) system ts files
2) rollback segment tablespace files
3) control file
4) all datafiles for TS you wish to recover.

There was some issue with indexes as well.. don't remember exactly..

Tanel. Received on Fri Sep 20 2002 - 08:59:04 CDT