Jun 12

OCM 11g Preparation – Configure a Fast Recovery Area

Fast Recovery Area (the old Flash Recovery Area) is where you keep by default your local backups, archives, flashback logs, restore points, one redo member and so on. Configuring it is pretty simple. All you need is to understand and set up the following parameters: db_recovery_area_dest db_recovery_area_dest_size Path to Documentation: Backup and Recovery User’s Guide -> 5 …

Continue reading

Jun 11

OCM 11g Preparation – Set Flashback Database parameters

For this topic, we are focusing in flashback database technology. So here, you need to be able how to: Enable / Disable flashback database; Enable / Disable flashback for a tablespace; Alter all the flashback database parameter “db_flashback_retention_target”; One thing that I would strong recommend during the exam is: every time you plan to do some …

Continue reading

Jun 10

OCM 11g Preparation – Create different types of RMAN backups to cater for different performance and retention requirements

Backup is an art. It’s very important to check the SLA and create a total failure recover plan whenever you setup a new DB instance. If you are a OCP, you must already know that. So, in this topic, practice creating backups: Backup full / incremental If Incremental, diferential / cumulative Compressed in different levels Setup …

Continue reading

Jun 10

OCM 11g Preparation – Install the Enterprise Manager Grid Control infrastructure

Funny to see this as one of the last topics of this skillset as everything depend on this. As I’ve already talked in the other topics, deploying the whole infrastructure is the same as: Installing the Grid Control Software Configuring the Repository Deploying the agent on Management Targets So just check if you did everything correct before and …

Continue reading

Jun 09

OCM 11g Preparation – Configure Grid Control for business requirements

This topic is another one that is a little bit generic. What does “configure for business requirements” means? Business requirements can be anything you can ever imagine. In my understandings, your objective in this topic is to be ready if you face something that could be useful in a daily work like like: Alert the …

Continue reading