RE: Good technical documents/references on tuning restores

From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com>
Date: Wed, 04 Jun 2003 08:10:26 -0800
Message-ID: <F001.005AA101.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 <hporas_at_etal.uri.edu> 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: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
    > Paula_Stankus_at_doh.state.fl.us
    > 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: kirtikumar_deshpande_at_yahoo.com

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: ListGuru_at_fatcity.com (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 Wed Jun 04 2003 - 11:10:26 CDT