Wednesday, March 16, 2011

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

Wednesday, March 09, 2011

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

Tuesday, March 08, 2011

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.




Monday, March 07, 2011

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