Hi All,
DB: 10g No Archive mode
OS: windows
I am unable to recover my datafile after renaming the same. Following are the steps that I have taken:
I have a old controlfile trace and the latest controlfile is lost. The old controlfile doesnt have the new datafile entry.So i am mounting the database with the old trace with resetlog option and then i will be renaming the unamed datafiles.
STARTUP MOUNT
Then i create controlfile
ALTER DATABASE OPEN RESETLOGS;
Now the newly added datafile is as below:
SQL> select name from v$datafile;
NAME
-----------------------------------------------------------------------------------------------------------------------------------
D:\ORAHOME_XPRESS10G\ORADATA\XE\SYSTEM.DBF
D:\ORAHOME_XPRESS10G\ORADATA\XE\UNDO.DBF
D:\ORAHOME_XPRESS10G\ORADATA\XE\SYSAUX.DBF
D:\ORAHOME_XPRESS10G\ORADATA\XE\USERS.DBF
D:\ORAHOME_XPRESS10G\ORADATA\XE\TEST01.DBF
D:\ORAHOME_XPRESS10G\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\MISSING00006
Then i rename the datafile as
SQL> alter database rename file 'D:\ORAHOME_XPRESS10G\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\MISSING00006' to 'D:\ORAHOME_XPRESS10G\ORADATA\XE\TEST02.DBF';
Database altered.
SQL> select FILE#,STATUS,NAME from v$datafile;
FILE# STATUS NAME
--------- ------- --------------------------------------------------
1 SYSTEM D:\ORAHOME_XPRESS10G\ORADATA\XE\SYSTEM.DBF
2 ONLINE D:\ORAHOME_XPRESS10G\ORADATA\XE\UNDO.DBF
3 ONLINE D:\ORAHOME_XPRESS10G\ORADATA\XE\SYSAUX.DBF
4 ONLINE D:\ORAHOME_XPRESS10G\ORADATA\XE\USERS.DBF
5 ONLINE D:\ORAHOME_XPRESS10G\ORADATA\XE\TEST01.DBF
6 RECOVER D:\ORAHOME_XPRESS10G\ORADATA\XE\TEST02.DBF
After this when i am trying to recover the concern datafiel i am getting the following errors:
SQL> recover datafile 6;
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [krhpfh_03-1202], [fno =], [6], [fhcrt =], [794948267], [cptim =], [0], []
ORA-01110: data file 6: 'D:\ORAHOME_XPRESS10G\ORADATA\XE\TEST02.DBF'
and also,
SQL> RECOVER AUTOMATIC DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 1 - file is in use or recovery
ORA-01110: data file 1: 'D:\ORAHOME_XPRESS10G\ORADATA\XE\SYSTEM.DBF'
BR
Sphinx
Edited by: $phinx19 on Sep 25, 2012 7:47 AM