What happens to the Standby when you move a datafile on the Primary?

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. #1 by Noons on May 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. #2 by SYED AFZAL SYED RAVOOF on August 6, 2019 - 05:40

    yes you can move datafile in standby also.

  3. #3 by Kevin Romans on December 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?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: