| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [SPAM] RE: Help datafiles corrupted - index tablespaces affected - no DDL lieing around
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tim Johnston
Sent: Tuesday, July 27, 2004 6:13 PM
To: oracle-l_at_freelists.org
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
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Jul 27 2004 - 17:38:25 CDT
 |
 |