OraFAQ Forum: Server Administration » ORA-01157: cannot identify/lock data file 9

Home » RDBMS Server » Server Administration » ORA-01157: cannot identify/lock data file 9 - see DBWR trace file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01157: cannot identify/lock data file 9 - see DBWR trace file [message #52809]

Wed, 14 August 2002 23:47

Aji
Messages: 1
Registered: August 2002

Junior Member

ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
This was the message shown when i opened the database.
file 9 was a temporary tablespace named "datatemp".
the file was present in the specified location.
then i did after mounting the database
svrmgrl>2) alter database datafile '....' offline;
but it shows the message "media recovery not enabled".
Now i want the data back. i have no backup or
database was not in Archieve mode.all i have is control
files and other tablespaces. i tried a lot of options
but all of them failed. after sometime i was even able to mount the database. when i start the database it
shows the message "database already started shutdown first". then i give the shutdown command then it shows
"not connected".
any body now what is the problem.anyhow i want then data back. we are using windows NT as oracle server(8.1.6). it has 255 MB RAM . and plenty of disk space.pls replay.

Report message to a moderator

Re: ORA-01157: cannot identify/lock data file 9 - see DBWR trace file [message #52813 is a reply to message #52809]

Thu, 15 August 2002 05:14

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

login with svrmgrl as sys or internal.
try to do a clean shutdown..else
give a shutdown abort.
then

startup nomount pfile ='....'
alter database mount;

if any errors,like need to recover etc, give

alter database recover;

then
alter database mount;

Report message to a moderator

Re: ORA-01157: cannot identify/lock data file 9 - see DBWR trace file [message #52846 is a reply to message #52809]

Fri, 16 August 2002 06:46

횆jiR처ck
Messages: 1
Registered: August 2002

Junior Member

Recovery-Temporary Tablespace의 유실

1. Database를 기동

$svrmgrl
SVRMGR> connect / as sysdba
SVRMGR> startup
SVRMGR> select tablespace_name, file_name from dba_datafiles ;
--> Temporary Tablespace의 Data File 경로명을 확인
SVRMGR> !ls -la $HOME/DATA/DISK3/temp01.dbf
--> 크기 확인

2. Failure를 만든다.

SVRMGR> shutdown abort
--> Failure를 상상
SVRMGR> ! mv $HOME/DATA/DISK3/temp01.dbf $HOME/DATA/DISK3/temp01.org
SVRMGR> startup
ORA-01157: cannot identify data file 4 - file not found
ORA-01110: data file 4:'/home/disk1/userDBA205/DATA/DISK3/temp01.dbf'

3. Recovery 수행
--> Temporary Tablespace 이므로 Drop하고 새로 만들면 됨

SVRMGR> alter database datafile '$HOME/DATA/DISk3/temp01.dbf' offline drop ;
SVRMGR> alter database open ;
Statement processed.
SVRMGR> select * from dba_tablespaces ;
--> "Temp_data" Tablespace는 그래도 존재함
--> "Temp_data" Tablespace의 구성 File 중 하나를 Drop 한 것 뿐이니까.(여기선 우연히 하나였다.)
SVRMGR> drop tablespace temp_data including contents ;
SVRMGR> create tablespace temp_data
2 datafile '$HOME/DATA/DISK3/temp01.dbf' size 1M ;
--> 앞에서 확인한 크기로 다시 생성
SVRMGR> shutdown immediate
--> Shutdown 과 Startup을 해봐서 잘 되는지 확인
SVRMGR> startup
SVRMGR> shutdown immediate
SVRMGR> !rm $HOME/DATA/DISK3/temp01.org
--> 필요 없는 file을 삭제
SVRMGR> exit

Report message to a moderator

Previous Topic:	Insufficient Privileges in Oracle!!!
Next Topic:	Re: Oracle 7 to Oracle 8

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 13:51:25 CDT 2024