RE: [SPAM] RE: Help datafiles corrupted - index tablespaces affected - no DDL lieing around
- From: <Paula_Stankus@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Jul 2004 18:41:35 -0400
That was what I was thinking - maybe you don't care anymore based on =
RAID - yadayada - but here is one reason to keep those suckers separate =
- which I never moved away from !!!
Guys,
The controller was replaced - the database came up very happy. I am =
running the RMAN backup which failed the first time (before the =
controller was replaced) and I am thinking - I might not have to recover =
nada - that maybe the files were showing up corrupt because the read =
from the bad controller - but the data wasn't truly bad.
I am running dbverify but on some files it never seems to write out =
anything!!! - like it stalls. Anyone experience that?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Tim Johnston
Sent: Tuesday, July 27, 2004 6:13 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: [SPAM] RE: Help datafiles corrupted - index tablespaces
affected - no DDL lieing around
Paul Drake wrote:
>yes.
>use the INDEXFILE option.
>That will create a file (that you specify the path
>for)
>that you can run to create the indexes.
>The table creation code will be commented out.
>
>imp help=3Dy
>
>Aren't you glad that you had your tables and indexes
>separated by tablespace?
>
>Pd
>
> =20
>
Damn... Forgot about the indexfile option... Much cleaner then the=20
show=3Dy method...=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 5658943) is spam:
Spam: =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D5658943&m=3D7071b=
91ef97a
Not spam: =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D5658943&m=3D7071b=
91ef97a
Forget vote: =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D5658943&m=3D7071b=
91ef97a
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
