June 27, 2017

Physical Standby Databases

Physical Standby Databases

*** COMING SOON ***




ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

ALTER DATABASE ACTIVATE STANDBY DATABASE;
ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE;
ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE FINISH;
ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE FINISH APPLY;

1 comment:

  1. Can a physical standby database remain in snapshot mode for at least 30 days? During this time, logs will be deferred from primary db and no changes will be made on stanby. I need it for reporting purposes

    ReplyDelete