RE: Good technical documents/references on tuning restores

From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com>
Date: Thu, 05 Jun 2003 02:07:36 -0700
Message-ID: <F001.005AA0F5.20030604081026@fatcity.com>

Paula,
Was the tablespace read-only?
Those weired MISSING... names refer to data files in those tablspaces. Do you have a controlfile trace? Look in there to see what is what.. Here is what I see in the CF trace for my read-only tablespace:

# Files in read-only tablespaces are now named. ALTER DATABASE RENAME FILE 'MISSING00002'   TO '/u07/oradata/DBCT/test_01.dbf';
# Online the files in read-only tablespaces. ALTER TABLESPACE "TEST" ONLINE;
# No tempfile entries found to add.
#

HTH,

• Kirti
  • Henry Poras <[EMAIL PROTECTED]> wrote:
    > RE: Good technical documents/references on tuning restoresPaula,
    >
    > IIRC 'MISSING' means it is in the data dictionary, but not the control file.
    > I've gotten that before, but haven't played that game in a while. You might
    > be able to 'DROP' them, but I'm not sure. Check that first on a mini-test
    > system.
    >
    > Henry
    >
    > -----Original Message-----
    > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
    > [EMAIL PROTECTED]
    > Sent: Tuesday, June 03, 2003 11:05 PM
    > To: Multiple recipients of list ORACLE-L
    > Subject: RE: Good technical documents/references on tuning restores
    >
    >
    > Okay,
    >
    > Database open and I wanted to not restore and not reference certain index
    > and materia. view datafiles. Now the datafiles show up with weird
    > MISSING...... names. How do I clean this up?
    >
    > Thanks,
    > paula
    >

    ---

Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Jun 05 2003 - 04:07:36 CDT