In 12c, we have introduced online datafile movement as a new feature. Now does that impact an existing standby database? I got asked that yesterday during an online webinar. My answer was that I expect no impact at all on the standby database since redo apply doesn’t care about the physical placement of the datafile on the primary. But I added also that this is just an educated guess because I didn’t test that yet. Now I did:
You know, I like to practice what I preach: Don’t believe it, test it! 🙂
#1 von Noons am Mai 9, 2015 - 16:42
Excellent post! Thanks for that.
One question: is it at all possible to move the file also in the standby?
Presumably, it’d be moved in the primary because of disk storage re-arrangement.
As such that might also be needed at some stage in the standby?
#2 von SYED AFZAL SYED RAVOOF am August 6, 2019 - 05:40
yes you can move datafile in standby also.
#3 von Kevin Romans am Dezember 26, 2020 - 03:54
There are two file systems set up in ASM, +DAT and +DATS. The standby database is reading from +DATS. A datafile was created in +DAT and is not being read by the standby database. Is it the same process to moving the datafile from +DAT to +DATS? Will this cause any issues on the standby? Are there any further steps that needs to be performed to insure the standby is consistent with the primary?