Active Data Guard Configuration

When Active Data guard is configured.You can use stand by site in Read only mode.By enabling Reporting on Stand by node It may reduce the weight on Primary site.Keep in remember You may required additional license to  configure this and .Bothe side as to be licensed according to same metrics.

On Primary Database

select status,instance_name,database_role from v$instance,v$database;

select max(sequence#) from v$archived_log;

 On Stand by database

select status,instance_name,database_role from v$database,v$instance;

select max(sequence#) from v$archived_log where applied='YES';

 

select process,status,sequence# from v$managed_standby;

 alter database recover managed standby database cancel;

 alter database open;

select status,instance_name,database_role,open_mode from v$database,v$instance;

alter database recover managed standby database disconnect from session;

select process,status,sequence# from v$managed_standby;

Now your database is configured with Active Data guard.

MRP process is Continue running  while stand by database is on read only mode.
Redo logs will be applied real time.