I know the "old" way to make an active data guard database open read-only with log apply, but can you do the same thing with DataGuard broker commands?
Environment:
Oracle 19.3 RAC (two nodes) primary with dataguard replicating to Oracle RAC (two nodes) seondary
primary site db_unique_name xyz1
secondary site db_unique_name xyz2
I want to open the secondary database read only for reports, but still apply logs for active data guard. We have an Active Data Guard license.
"old way"
as user oracle on any of the dataguard RAC nodes
sqlplus /nolog
connect / as sysdba
alter database recover managed standby database cancel ;
alter database open ;
alter database recover managed standby database using current logfile disconnect from session ;
exit
MY QUESTION Is this equivalent to: ("new way" with dataguard broker)
as user oracle on any of the dataguard RAC nodes
dgmrgl
connect / as sysdba
edit database 'xyz2' set state = 'apply-off' ;
exit
sqlplus /nolog
connect / as sysdba
alter database open ;
exit
dgmgrl
connect / as sysdba
edit database 'xyz2' set state = 'apply-on' ;
exit