Home » RDBMS Server » Backup & Recovery » Problem in Starting Database
Problem in Starting Database [message #184172] Tue, 25 July 2006 10:56 Go to next message
Rehan Mirza
Messages: 63
Registered: July 2004
Location: Pakistan
Member

When i start database with startup command i get this error

SQL> startup
ORACLE instance started.

Total System Global Area 73701404 bytes
Fixed Size 75804 bytes
Variable Size 56770560 bytes
Database Buffers 16777216 bytes
Redo Buffers 77824 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\DG\SYSTEM01.DBF'
ORA-01200: actual file size of 55553 is smaller than correct size of 56832
blocks

Actully i was restore my backup through import command during this IMPORT process electricity power failure and the result is as above i dont have any dbf file please tell me any procedure for running my db without reinstalling

thanks in advance


Please reply as soon as possible
Re: Problem in Starting Database [message #184214 is a reply to message #184172] Tue, 25 July 2006 14:27 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
It did not recover the system file correctly or completely. There is no fix that I am aware of that rebuilds the system file. You might just try the imp again after saving and removing the database files you did recover.
Re: Problem in Starting Database [message #184228 is a reply to message #184172] Tue, 25 July 2006 15:52 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Are you saying that you are using EXPORTS as your backup mechanism? EXPORTS are fine as a complement to a RMAN or cold/hot backup, but I wouldn't consider using EXPORTS as backups for a production system.

If you still have a valid export, then you may want to recreate a database with DBCA and then import your file.
Previous Topic: Recovery Scenario
Next Topic: not enough disk space error
Goto Forum:
  


Current Time: Mon Dec 05 03:05:25 CST 2016

Total time taken to generate the page: 0.10516 seconds