Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Working, middle of night
Yes you have to do the media recovery .
Do it in mount state.
Vikas
-----Original Message-----
From: Linda Hagedorn [mailto:Linda_at_pets.com]
Sent: Tuesday, June 06, 2000 4:56 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Working, middle of night
Things are going the right direction now. I did the rename, and have 20 more files to go. I received a different error on the first file:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'/opt/oracle/app/oracle/oradata/PETS/data/system01.dbf'
If the error still exists after all 20 files are altered, would RECOVER DATABASE be the correct action, and should the database be in nomount state?
Your assistance is greatly appreciated.
Thanks, Linda
-----Original Message-----
Sent: Tuesday, June 06, 2000 2:35 AM
To: Multiple recipients of list ORACLE-L
Instead of creating softlink (ln -s from_file to_file) try rename data file :
>startup mount
>alter database rename file '/oradata/PETS/data1/system01.dbf' to
'/opt/oracle/app/oracle/oradata/PETS/data/system01.dbf';
> alter database open;
HTH,
Serge Kosourikhin
Oracle DBA
JSC Bratsk Aluminium Plant
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Tuesday, June 06, 2000 5:49 PM
> 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_at_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_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).
>
>
-- Author: Serge Kosourikhin INET: kosour_at_braz.ru 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_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). -- Author: Linda Hagedorn INET: Linda_at_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_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 mayReceived on Tue Jun 06 2000 - 07:05:43 CDT