Hello Team,
We have little situation here , our DBA has recently restored database DEV with PROD Backup . He faced issues while restoring with duplicate names and he dropped those datafiles
in offline mode and restored those datafiles with set newname option and it was successful , right after it he fired resetlog and opened database.
Its a 5 TB database .
Upon checking found those 3 datafiles still in offfline mode . When tried to online it , it throws an error.
SQL> alter database datafile '/oracle/MOC/sapdata1/ora/sysaux.data1' online;
alter database datafile '/oracle/MOC/sapdata1/ora/sysaux.data1' online
*
ERROR at line 1:
ORA-01122: database file 3 failed verification check
ORA-01110: data file 3: '/oracle/MOC/sapdata1/ora/sysaux.data1'
ORA-01206: file is not part of this database - wrong database id
FILE# ONLINE ONLINE_ ERROR CHANGE# TIME
---------- ------- ------- ----------------------------------------------------------------- ---------- ---------
3 OFFLINE OFFLINE WRONG DATABASE 9.3557E+10 27-FEB-16
168 OFFLINE OFFLINE WRONG DATABASE 9.3557E+10 27-FEB-16
174 OFFLINE OFFLINE WRONG DATABASE 9.3557E+10 27-FEB-16
1) Is it possible to recover those 3 datafiles without restoring the whole database.
2) Using transportable tablespace - Can I restore only those 3 datafiles . Not sure if any option to achieve .
Would be really greatful if someone thow light on the above, if it can be achievable without complete restore of 5TB database.
Thanks & Regards
Mohammed