recover datafile after renaming

[Roshan]

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

[ErmanArslansOracleBlog]

It s not timestamp.. It is SCN and it is an Oracle thing. Dont move files while an oracle database is running. Use rman for backing up a running oracle database. anyways. It seems it is a standby db, right?

15 Mar 2017 18:53 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

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

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/recover-datafile-after-renaming-tp2374.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Roshan]

Thanks Erman :)