Can a datafile from a standby database be used to restore a production database that has a corrupted of missing file?

Hi,

A good question!

Yes, the standby datafiles are no different to that of Production. Only the controlfile differs on a standby database.

Copying a standby datafile to production would be no different to restoring an earlier backup copy of that datafile.

Then the next step is to recover that datafile by doing say,

SQLPLUS> alter database recover datafile 6;

All on-line/archived logs will be applied to fully recover the datafile. Thus restoring the Production database.

NB. The tablespace would need to be taken offline to perform the datafile moves and recover.

Hope this helps.

James

Thanks James I wasn't 100% sure this could be done but you confirmed it.

Thanks again.