OraFAQ Forum: General » HELP !! ORA-01157 - One ROLLBACK file is corrupt

Home » Other » General » HELP !! ORA-01157 - One ROLLBACK file is corrupt

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

HELP !! ORA-01157 - One ROLLBACK file is corrupt [message #103468]

Sun, 26 October 2003 01:11

nicioli
Messages: 1
Registered: October 2003

Junior Member

Hi,

after a checkdisk operation one of four rollback-segments has a size of 0 bytes instead of 1 gigabyte.
When i start the database i get the errors:

> database with mount connected
ORA-01157: cannot identify/lock data file 16 - see DBWR trace file
ORA-01110: datafile 16: 'Y:DBMAPSRV3ROLLBACKRBS3.DBF'

I've made only online backups with Arcserve Oracle-Backup-Agent 2 days ago.

How are the steps to recover the database?

Report message to a moderator

Re: HELP !! ORA-01157 - One ROLLBACK file is corrupt [message #103470 is a reply to message #103468]

Mon, 27 October 2003 16:27

Jonathan Ferreira
Messages: 1
Registered: October 2003

Junior Member

Hi,

Make sure that your datafile exists. If yes, make sure that you have privs... to acccess the datafile.

[[]]s,
Jhonn

Report message to a moderator

Re: HELP ! ORA-01157 - One ROLLBACK file is corrupt [message #104017 is a reply to message #103470]

Mon, 28 June 2004 18:34

PC
Messages: 6
Registered: August 2000

Junior Member

I'm also facing the same problem.
I checked the datafile. However, unfortunately, the datafile doesn't exist.
I don't the datafile anymore.
How to solve this problem and bring up the database?.

Report message to a moderator

Previous Topic:	row num and row id
Next Topic:	Oracle Job Networking

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 21:57:49 CST 2024