I have an oracle database with no asm. If I shut down the database, move some of the dbf files to a location where I cannot preserve the timestamp on the files, then move them back… Will the database start up without any problem? I will not change anything in the contents of the dbf files nor the permissions.. only the OS timestamp will change. is this ok? Thanks!
Timestamp change on Oracle dbf files
oracle
Related Question
- Windows – Oracle Express intermittently stops responding, requiring a OS reboot to fix
- How to load .dbf to run select queries
- How to find home information for Oracle RAC on Unix
- How to migrate old Oracle ASM disks
- How to do 10 G Database recovery without archive logs but available redo logs, ctl files and .dbf files
- Oracle 12c create manual script for automatic startup on RHEL7
Best Answer
Oracle does not care about the OS timestamp on data files. When it opens files it looks at the scn in all of the file headers and compares them to what is recorded in the control file. If all scn match, the database opens. If there is a mismatch between the scn of a file and that in the control file, it will throw an appropriate error. But none of this has to do with the OS time stamp on the file.