Bouncing a Standby Dataguard

Shutting down DR:

- ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
- shutdown immediate

Starting up DR:

- startup nomount
- alter database mount standby database
- alter database recover managed standby database disconnect from session;
- alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
- select sequence#, first_time, next_time, archived, applied from v$archived_log order by sequence#;
- do a log switch on primary 'alter system switch logfile'
- run this script again on standby to verify if it was applied 'select sequence#, first_time, next_time, archived, applied from v$archived_log order by sequence#;'