Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

tablespace for data has been damage

Deanna Tran_1
Frequent Advisor

tablespace for data has been damage

some of the tablespace datafile got corrupted, therefore I was unable to mount them...metadata
got so corrupted fsck with fullnolog won't work.... because of these problems, database wont' open....although I do have the system tablespace is available along with control file and redologs
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 17 - see DBWR trace file
ORA-01110: data file 17: '/tablespace_data04/oradata/saki/tbs_data04a.dbf'
5 REPLIES
Jeanine Kone
Trusted Contributor

Re: tablespace for data has been damage

Deanna,

I can't tell from your message what exactly you are asking. What is it that you want to do at this point? Do you want to try to recover the data? Do you just want to open the database without the tablespace?

To help once you answer: what kind of backups do you have available?
Dave Chamberlin
Trusted Contributor

Re: tablespace for data has been damage

Deanna,
These errors do not imply corruption. Check the permissions and ownership of the indicated datafile - it must be owned by the oracle user , normally with 644 permission.
Deanna Tran_1
Frequent Advisor

Re: tablespace for data has been damage

hi
i 'd like to be able to open the database without these files....
Juan González
Trusted Contributor

Re: tablespace for data has been damage

Hi,
to start without the corrupted datafiles:

SVRMGR> STARTUP MOUNT PFILE;
For each of the corrupted datafiles
SVRMGR> ALTER DATABASE DATAFILE '' OFFLINE; SVRMGR> ALTER DATABASE OPEN;

Good luck,
Juan
Juan González
Trusted Contributor

Re: tablespace for data has been damage

Sorry where I write
ALTER DATABASE MOUNT PFILE;

must be:
ALTER DATABASE MOUNT;