| Problem in Starting Database [message #184171] |
Tue, 25 July 2006 10:55  |
Rehan Mirza
Messages: 67
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 #185180 is a reply to message #184197] |
Mon, 31 July 2006 07:10  |
dibuleng
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
. If is in ARCHIVELOG mode, then try to make recover database until the time in the past.