-
Hi,
I've a big problem
I use 8i 8.1.5. (unix) (with no archivelog)
I've do this :
1.shutdown db
2. copy all control, datafile, redo files (command : cp -p ....)
to a backup directory.
3. restore all control, datafile, redo files (command : cp -p ....)
from that backup directory to the original directory (=>all my files are overwrited)
3.startup (but my db is mounted only!)
but , for a reason i don't know, one of a datafile is different :
my datafile MI_idx_1.dbf ( = the copy , in fact) has not the same size of the original...
=> my copy (MI_idx_1.dbf ) has overwrited my original MI_idx_1.dbf !!
=> my original MI_idx_1.dbf !! is lost!
How can I startup correctly my db ??
ORACLE instance started.
roblem
Total System Global Area 28818832 bytes
Fixed Size 64912 bytes
Variable Size 11456512 bytes
Database Buffers 16777216 bytes
Redo Buffers 520192 bytes
Database mounted.
ORA-01122: database file 8 failed verification check
ORA-01110: data file 8: '/home2/oracle/oradata/mi/MI_idx_1.dbf'
ORA-01200: actual file size of 420607 is smaller than correct size of 430592
blocks
I think i have to create a new control file but i don't know how... :((
What can i do ?
help... help...
Thanks a lot , Thanks a lot
-
Hi,
Do u have a sample script of Creating Control File? Do u know the database name? Take the sample script, substitute the database name in the script with the name of your database, Substitute/Add the name of all the files e.g. redo log files, datafiles, in the script so as to match with the ones you have, except the one which is creating the problem. (dont give that one. This file u have already lost). Now rebuild the control file. Resetlogs while opening the database.
Hope this may solve some of ur problem.
-
I've tried this... except ' open with resetlogs' (because it seems it doesn't change anything :o) )
I've create the script of new control file (without the line where the bad tbsp name was)
so, when I open my db :))) (aaahhhh) I've drop +recreate the bad tbsp + import
thanks for your help :))
have a nice day
