czwartek, 27 września 2012
Data Guard - Real Time Apply
In a normal configuration Data Guard , applying changes I turn on by command:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY DISCONNECT FROM SESSION;
But in this mode, standby database apply changes after switching redolog group.
In order to applying changes in real time need to use the command:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
and now in v$managed_standby on standby, status for MRP0 (managed recovery process) process is APPLYING_LOG
Subskrybuj:
Komentarze do posta (Atom)
Brak komentarzy:
Prześlij komentarz