Feb 05

OCM 11g Preparation - Configure RMAN

This topic is very generic and have a very similar name with the topic "Configure Recovery Manager". I don't really understand the difference as RMAN is the abbreviation for Recovery Manager. What I would recommend you to study here is the RMAN binary syntax, that can receive many parameters, not only target, auxiliary and catalog: …

Continue reading

Feb 05

OCM 11g Preparation - Configure Recovery Manager

This topic is very generic and have a very similar name with the topic "Configure RMAN". The best thing to study here is all the persistent RMAN configurations that you can set up and their values: Default Device for Backups: Disk or SBT Default Type for Backups: Backup Sets or Copies Channels Control File and …

Continue reading

Feb 01

RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES

Many people still don't get the difference between all that configuration parameters that can be set up during a backup. In this article, I will explain how to use each of them, their differences and the theory behind. First the theory:   Backup Set Logical structure where the backup is stored. It is a logical …

Continue reading

Jan 19

OCM 11g Preparation - Configure Enterprise Manager to modify database availability

In this topic, you must be able to startup and shutdown the database via Grid Control. Do this using the main database screen. Try to startup the database in restricted mode and change it later (only using the EM) to non restricted. This is a good practice! +2

Jan 19

OCM 11g Preparation - Use Enterprise Manager to modify a database configuration

Basically here, everything that you know how to do using SQL*Plus, you must be ready to do using the EM. For example: Everything that is in the "Server" tab of EM Everything that is in the "Schema" tab of EM Sometimes it is not easy to find where is located the link of the object …

Continue reading