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 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. #2 von SYED AFZAL SYED RAVOOF am August 6, 2019 - 05:40

    yes you can move datafile in standby also.

  3. #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?

Kommentar verfassen

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:


Du kommentierst mit deinem WordPress.com-Konto. Abmelden /  Ändern )


Du kommentierst mit deinem Facebook-Konto. Abmelden /  Ändern )

Verbinde mit %s

Diese Seite verwendet Akismet, um Spam zu reduzieren. Erfahre, wie deine Kommentardaten verarbeitet werden..