| Unable to startup database [message #55314] |
Fri, 17 January 2003 02:27  |
vinit
Messages: 7
Registered: October 1999
|
Junior Member |
|
|
I have got following error while up my oracle
database 8-
"ORA-01157: cannot identify data file 6 - file not found
ORA-01110: data file 6: 'T_DB2'
I had removed the T_db2 datafile with OS command, and i don't have anybackup of that datafile.
now my database is not getting start its shos above error,
how can i solve this problem.
please give your kind suggestion asap.
regards,
vinit
|
|
|
|
| Re: Unable to startup database [message #55324 is a reply to message #55314] |
Fri, 17 January 2003 09:40  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
since you do NOT have a backup:
in MOUNT mode:
ALTER DATABASE DATAFILE 6 OFFLINE;
ALTER DATABASE OPEN;
DROP TABLESPACE tsname IMMEDIATE;
NOTE: You are removing this tablespace from the db and any data in that tablespace will be gone.
if you want to recover that datafile, you either need a backup (which you said you do not have) or all archive logs since the tablespace was created.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
