UTL_MAIL

summary

1. create utl_mail package

2. create an ACL and grant privilege

3. add user privilege to ACL

4. assign ACL to network

5. Test configuration

dbms_scheduler

SCHEDULER_ADMIN role for job scheduling

CREATE JOB privilege for creating jobs

Data Guard - How To Check Whether Physical Standby is in Sync with the Primary or Not?

Summary

1. Check for GAP on standby

2. Check redo received on standby

3. Check redo applied on standby

4. Identify missing archive log files

5. Copy archive log files

6. Register archive log files with standby

7. Restart the managed recovery operations

Dataguard a case study - what to do when Primary database is lost ?

# Case Study - Primary Is Lost

Summary

1. managed standbt database finsh

2. activate physical standby database

3. open database

DataGuard switchover

Summary

1. stop/suspend schedule jobs

2. Switchover Primary database role

3. Switchover Standby database role

4. Check Primary and Standby are in sync