This discussion is archived
1 Reply Latest reply: Oct 22, 2012 5:43 PM by 568397 RSS

Change the maxsize of the datafiles in DataGuard 10gR2

568397 Newbie
Currently Being Moderated
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;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points