Message-Id: <10520.107804@fatcity.com>
From: Linda Hagedorn <Linda@pets.com>
Date: Tue, 6 Jun 2000 03:05:18 -0700 
Subject: RE: Working, middle of night

Richard, 

Is there a way to determine the tablespace name without the benefit of using
SVRMGRL or SQLPLUS?  I cannot query dba_data_files with the database in it's
current state, that is, pointing to all files which are in the wrong
location; Missing for all intensive purposes.  Without the tablespace name,
I cannot execute the ALTER TABLESPACE command.   

Any suggestion is appreciated. 

Thanks, Linda  

-----Original Message-----
From: Klavers, Richard [mailto:R.Klavers@arbeidsbureau.nl]
Sent: Tuesday, June 06, 2000 3:25 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Working, middle of night


Linda,

it's daylight here (Holland)...so there's always someone around to help.

I think you should try to rename the datafiles from within Oracle, not Unix:
ALTER TABLESPACE xxxx RENAME DATAFILE '/oradata/PETS/data1/system01.dbf' 
  TO ' /opt/oracle/app/oracle/oradata/PETS/data/system01.dbf';

First, startup the database in MOUNT mode.

Regards, Richard Klavers

> ----------
> Van: 	Linda Hagedorn[SMTP:Linda@pets.com]
> Antwoord naar: 	ORACLE-L@fatcity.com
> Verzonden: 	dinsdag 6 juni 2000 10:49
> Aan: 	Multiple recipients of list ORACLE-L
> Onderwerp: 	Working, middle of night
> 
> Hope someone's around tonight... 
> 
> I have some datasets in the 'wrong' place, and the database is failing to
> open with this error: Database mounted.
> ORA-01157: cannot identify data file 1 - file not found
> ORA-01110: data file 1: '/oradata/PETS/data1/system01.dbf'
> 
> I want to create soft links from the recorded name:
> /oradata/PETS/data1/system01.dbf, to the location where the dataset
> actually
> resides: /opt/oracle/app/oracle/oradata/PETS/data/system01.dbf
> 
> I don't have root, and am reluctant to move the datasets around.  
> 
> Does someone know the syntax to create a Unix soft-link?  
> 
> Thanks very much.  Linda 
> 
> PS.  The source of the problem is no mystery.  In an effort to make space
> in
> an emergency, files were moved (not by me) to different directories.  This
> has been done to a significant number of the files.  While this is not
> production, it is QA/Dev, and I'm anxious to put the house back in order.
> This is a temporary situation, and meetings are underway to work out the
> space issues.  In the mean time, I need to get this database back on-line,
> and the Unix soft-link is, I think, the least painful way to get the
> system
> up.  I'm looking at 18 hours processing, so if you know the soft-link
> syntax, I'd appreciate knowing it.  Thanks.     
> 
> 
> -- 
> Author: Linda Hagedorn
>   INET: Linda@pets.com
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California        -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru@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).
> 
-- 
Author: Klavers, Richard
  INET: R.Klavers@arbeidsbureau.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@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