Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Working, middle of night

RE: Working, middle of night

From: Linda Hagedorn <>
Date: Tue, 6 Jun 2000 02:48:12 -0700
Message-Id: <>

Thanks for the command. I tried it, but permission was denied for me to mkdir to the high-level name. Does this sound reasonable for an alternative to start Oracle with datasets which don't match the location in the controlfile:
I used ALTER DATABASE BACKUP CONTROLFILE TO TRACE which generated the statement (CREATE CONTROLFILE) to create a control file with the current characteristics. I edited the control file to point to the current location of the files. I'm at the point where I can execute the statement, but had a couple of operational questions, for example, I have two control files specified in my existing system. What will happen to them, if anything, if I execute the CREATE CONTROLFILE command? Do they remain unchanged (can't imagine this - they don't match the statement I plan to submit)? Are their contents replaced by my executing the new statement?

Any information is appreciated.

Thanks, Linda

-----Original Message-----
From: Weerd de E.C. Kirsten [] Sent: Tuesday, June 06, 2000 2:21 AM
To: ''
Cc: 'Linda Hagedorn'
Subject: RE: Working, middle of night

Can't this be done with ln ?

See man ln for more info. I usually do :

ln -f -i -s exeisting_file new_file

Good luck !

> -----Original Message-----
> From: Linda Hagedorn []
> Sent: Tuesday, June 06, 2000 9:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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
> 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: (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
Received on Tue Jun 06 2000 - 04:48:12 CDT

Original text of this message