tablespace for data has been damage

[Deanna Tran_1]

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'

[Jeanine Kone]

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]

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]

hi
i 'd like to be able to open the database without these files....

[Juan González]

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]

Sorry where I write
ALTER DATABASE MOUNT PFILE;

must be:
ALTER DATABASE MOUNT;