| Unable to Recover the dbf file - URGENT! [message #64402] |
Sun, 23 January 2005 04:27  |
Prashanth
Messages: 41
Registered: September 1999
|
Member |
|
|
Hi all
One of out Prod dbf file was physically moved to a diff locn by mistake. I am trying to recover the same. Have tried all these (in sequence)
1.Added one more dbf file to this TblSpace and renamed that to the moved location.
2.Offline dropped the dbf file in OLD LOCATION
3.Took the backup of Control File to trace and removed the entry for old location (from which file was moved) and reconstructed the control file.
I cud be abl to describe the tables but not any SELECTs.I am getting the falg error
SQL> select * from TRN_VEH_ALLCN;
select * from TRN_VEH_ALLCN
*
ERROR at line 1:
ORA-00376: file 61 cannot be read at this time
ORA-01111: name for data file 61 is unknown - rename to correct file
ORA-01110: data file 61: '/dbv01/oracle/visdbdb/9.2.0/dbs/MISSING00061'
---
'/dbv03/CUSTOM01.dbf' IS THE OLD LOCATION
'/dbv02/CUSTOM01.dbf' IS THE NEW LOCATION
---
Then I renamed '/dbv01/oracle/visdbdb/9.2.0/dbs/MISSING00061' to '/dbv03/CUSTOM01.dbf' and ShutDown - Restart dB in normal mode.And i tried to Select from tables.Getting the falg error
ORA-00376: file 61 cannot be read at this time
ORA-01110: data file 61: '/dbv03/CUSTOM01.dbf'
I queried in v$datafile for the status.And the result is as below
/dbv03/CUSTOM01.dbf --- RECOVER READ WRITE
/dbv02/CUSTOM01.dbf --- ONLINE READ WRITE
And i could not change the status from RECOVER to ONLINE.Falg error appears
SQL> alter database datafile '/dbv03/CUSTOM01.dbf' ONLINE;
alter database datafile '/dbv03/CUSTOM01.dbf' ONLINE
*
ERROR at line 1:
ORA-01122: database file 61 failed verification check
ORA-01110: data file 61: '/dbv03/CUSTOM01.dbf'
ORA-01251: Unknown File Header Version read for file number 61
I also tried the falg.
1.FTPd this dbf file to another dB.
2.Created another TableSpace and User.
3. alter TB NEW_TB datafile - REUSE;
4.This dbf is getting attached but no objects were to be seen inside!?
Pls help me out ASAP
Prashanth
|
|
|
|
| Re: Unable to Recover the dbf file - URGENT! [message #64455 is a reply to message #64402] |
Mon, 31 January 2005 01:20  |
Sreedhar Reddy
Messages: 55
Registered: January 2002
|
Member |
|
|
you have to bring the original file of
'/dbv03/CUSTOM01.dbf' to the location which is there in the dba_data_files.
If your are creating a new file and renaming it, it will be default give you eror, because the datafile may consists data of different data, which will not be there in the new datafile, eventhough you rename.
so you need to detect the original file and copy to the original location.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
