recover datafile after renaming

Posted by Roshan on Mar 15, 2017; 3:46pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/recover-datafile-after-renaming-tp2374.html

Red Hat Linux 6
Oracle database 11g

Hi Erman,

on a test machine, I tried to rename a datafile o1_mf_system_d8cq0yz5_.dbf to o1_mf_system_d8cq0yz5_.dbfBK and copy it to original name(o1_mf_system_d8cq0yz5_.dbf).

When I start the database, I get the error below

ORA-10458: standby database requires recovery
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:
'/app/oracle/oradata/BOSTON/datafile/o1_mf_system_d8cq0yz5_.dbf'

It seems when renaming the file using mv, the timestamp of the file is unchnaged. When I copied it to original name, the timestamp changes.

How can I recover it?

Thanks,
Roshan