Home » RDBMS Server » Backup & Recovery » ORA-01200 resolution (Oracle 10g R2 (, AIX 5.3)
ORA-01200 resolution [message #481990] Mon, 08 November 2010 23:03 Go to next message
Messages: 196
Registered: February 2010
Location: Philippines
Senior Member

Sirs/ Madame:

Our HR production database crashes due to hardware failure from Oct. 18 to 22, 2010. It was restored using an Oct. 8 offline backup last Nov. 3 using BRTools (with assistance from SAP Consultant). It's already running since last week but as of this date it encountered a datafile corruption which resulted to this error:
"Database mounted.
ORA-01122: database file 11 failed verification check
ORA-01110: data file 11: '/oracle/PRD/sapdata2/sr3_8/sr3.data8'
ORA-01200: actual file size of 210068 is smaller than correct size of 256000 blocks"

Although I've read many Oracle forums on database recovery but I have not yet experienced it (meaning, I can execute it easily via command line, but I don't know how it will affect the database-- maybe it could restart the db or it would be more disastrous than it's current state). We don't have RMAN tools to recover it, the BRTools have been failing and our last good offline backup was dated Oct. 8, 2010.

Could you give me a step-by-step procedures on how to do it? I guess it's our only option for now.

Thank you very much.

Re: ORA-01200 resolution [message #481991 is a reply to message #481990] Mon, 08 November 2010 23:08 Go to previous message
Messages: 25231
Registered: January 2009
Location: SoCal
Senior Member
>Could you give me a step-by-step procedures on how to do it?
You should submit a Service Request to My Oracle Support
Previous Topic: need inputs on RMAN Backup and Recovery for multiple restore of clean backup.
Next Topic: ORA-01195
Goto Forum:

Current Time: Mon Feb 27 14:34:08 CST 2017

Total time taken to generate the page: 0.08876 seconds