topic tablespace for data has been damage in Operating System - HP-UX

tablespace for data has been damage

Deanna Tran_1 — Mon, 22 Jul 2002 17:01:37 GMT

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'

Re: tablespace for data has been damage

Jeanine Kone — Mon, 22 Jul 2002 18:42:10 GMT

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?

Re: tablespace for data has been damage

Dave Chamberlin — Mon, 22 Jul 2002 18:50:53 GMT

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.

Re: tablespace for data has been damage

Deanna Tran_1 — Mon, 22 Jul 2002 19:04:04 GMT

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

Re: tablespace for data has been damage

Juan González — Mon, 22 Jul 2002 19:10:00 GMT

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

Re: tablespace for data has been damage

Juan González — Mon, 22 Jul 2002 19:11:14 GMT

Sorry where I write
ALTER DATABASE MOUNT PFILE;

must be:
ALTER DATABASE MOUNT;