Feb 28

How to delete the incarnations of an Oracle Database

In this article, I will talk about database incarnation and how to clean the old and obsoletes ones. It’s not intended to show you how to clean the incarnations on the recovery catalog, but from the database itself! Let’s start. Sometimes, after performing several database recoveries or “open resetlogs”, you can end up with so …

Continue reading

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