Tuesday, July 11, 2017

steps to configure active data guard



Active data guard means standby database in read only mode and still archive logs will apply

 From standby db

SQL>Shu immediate;
SQL> startup mount;
SQL> alter database open read only;
SQL> alter database recover managed standby database disconnect from session;

 select name,open_mode,database_role,protection_mode from v$database;

* Check the archive location in DR and change accordingly

No comments:

Post a Comment