is it possible to force the datafile to online even if i can't recover the datafile.
say media recovery is not possible coz of loss of archive logs.
If you have lost the logs, I think you shall recover all your datafiles from backup to have a consistent database.
There is a way to get the file online, but as Arroyob stated your database will be inconsistent/unreliable. It is a technique that should only be used as a last resort or to extract data that would otherwize be lost.
If it is only one datafile, then it is possible that you can recover it with the logs available (if they are the most recent.)
It would probably be safer to just vary the file offline. The database will come up.
The best bet is tobite the bullet, restore your last cold backup and recover with the archive logs you have.
THere are other possibilities depending on your Oracle release.
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
could u state more specific on how to make a datafile online from recover state without sync. the change#
just like to know the way... in case a last resort is needed
Click Here to Expand Forum to Full Width