Home » RDBMS Server » Server Administration » Problem in Starting Database
Problem in Starting Database [message #184171] Tue, 25 July 2006 10:55 Go to next message
Rehan Mirza
Messages: 63
Registered: July 2004
Location: Pakistan

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

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 #184197 is a reply to message #184171] Tue, 25 July 2006 12:39 Go to previous messageGo to next message
Messages: 242
Registered: February 2006
Senior Member
If your database in NOARCHIVELOG mode, then say good bye them Smile. If is in ARCHIVELOG mode, then try to make recover database until the time in the past.
Re: Problem in Starting Database [message #185180 is a reply to message #184197] Mon, 31 July 2006 07:10 Go to previous message
Messages: 2
Registered: July 2006
Junior Member
did your export terminated successfully without warnings?Was it a full dump file.I suggest you re-run the import if your export was terminated succesfully.

If this a production you should run your database in archivelog mode.
Previous Topic: Autoextend on
Next Topic: version upgrade and utlrp.sql
Goto Forum:

Current Time: Mon Oct 24 05:50:55 CDT 2016

Total time taken to generate the page: 0.06365 seconds