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"

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

OEM agent Installation using agentDownload script

Method  - agentDownload script

Summary

1. login as oracle

2. download agentDownload

3. change the permissions on the file

4. Install

5. run root.sh

6. update /etc/oratab

7. check agent status

8. configure databases, ASM using OEM Grid

OEM GRID 10.2.0.5 - false alarm - CPU 100% Utilization on OMS server

As per Metalink note 566711.1, this is bug and fixed by
applying Patch 6455908.

FLASHBACK QUERY

# flashback query as of timestamp

# flashback query as of scn

FLASHBACK TABLE

# flashback to SCN

# flashback table to timestamp

# flashback to restore point