February 2015 archive

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