Wednesday, March 23, 2011

crosscheck controlfilecopy




Problem :

while deleting obsolete backup files, following warning is thrown
"RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status"

Tuesday, March 22, 2011

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

Sunday, March 20, 2011

dbms_scheduler


SCHEDULER_ADMIN role for job scheduling
CREATE JOB privilege for creating jobs

Saturday, March 19, 2011

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

Thursday, March 17, 2011

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