Database Administration (MOSC)

MOSC Banner

what is the procedure to change system parameter spfile with dataguard?

Hi everyone,

In the primary, alter system set sga_target=xxx SCOPE=SPFILE and it needs db restart to take effect 1 week later together with dev apps rollout.

  1. Do I have to do the same in standby db? because this command should have already be propagated to the dg?
  2. When should I restart dg? is it after Primary db restart?

Thxs

Friendly

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center