Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Block Corruption, cant start DB -SOS
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