Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Block Corruption, cant start DB -SOS

Re: Block Corruption, cant start DB -SOS

From: Tanel Poder <tanel_at_peldik.kom>
Date: Fri, 20 Sep 2002 17:02:40 +0300
Message-ID: <3d8b2a35$1_1@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 - 09:02:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US