1 Reply Latest reply: Oct 22, 2012 8:13 PM by Srini Chavali-Oracle RSS

    Change the maxsize of the datafiles in DataGuard 10gR2

    568397
      We have the DataGuard 10gR2, 1 is primary and other is physical standby in production.
      My questions:
      1/ The maxsize of the datafiles is being modified by either increasing or decreasing in primary, does it modification change automatically also in standby ? Note: the parameter is set in the init.ora file standby_file_management = AUTO.
      If it does not change in standby, what can we do to change it in stanby

      2/ We want to resize the datafile in primary using the below command, does it modification change automatically also in standby ?
      If it does not change in standby, what can we do to change it in stanby

      ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/stuff01.dbf' RESIZE 100M;