Re: Block Corruption, cant start DB -SOS

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sat, 21 Sep 2002 11:22:52 +1000
Message-ID: <9HPi9.36807$g9.105559@newsfeeds.bigpond.com>

Hi Tanel, Candido and all,

Quite right and point taken

Although taking the other data files offline and performing recovery still constitutes a 'database' recovery which was the point I was trying to make.

However, spit left hand, spit right hand, 10 of my best push ups coming up.

1, pant pant pant 2, oh god pant pant, 3 .........

Cheers

Richard
"Tanel Poder" <tanel_at_peldik.kom> wrote in message news:3d8b2a35$1_1_at_news.estpak.ee...
> > 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..
>
> Of course you have to check dependencies as well, e.g. LOBs in different
> tablespaces I think etc.. you should include all these TSes in recovery
set.
>
> Tanel.
>
Received on Fri Sep 20 2002 - 20:22:52 CDT