Recovery Manager (RMAN)
Oct 03
This article will show how can you access the data that oracle stores in the internal hidden buckets, mainly used for "*aaS" backups. Update: Oracle has now an official tool for that: MV2BUCKET. It's fully supported and available in the MOS note below. Consider using it instead of the manual approach:(OCI) mv2bucket - Oracle Managed …
Jan 04
In this article I will show how to change the RMAN configuration when you are connect inside an Oracle DB, using the package DBMS_BACKUP_RESTORE and its procedures. Modifying those RMAN attributes is an easy task when you are connected via Oracle RMAN utility. You can simply use the CONFIGURE syntax to change it. However, what a few people know …
Feb 01
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 …
Jan 09
A time ago, the problem that I used to face was the failure of the recovery part of the duplicate script for any problems (like forgetting to set the db_recovery_area_dest_size big enough to hold the archives that will come from duplicate) and I ended up having to start the DUPLICATE command all over again. The recovery …
Sep 13
These days, I needed to register a new database that was running at 12c on my RMAN catalog. The procedure that I tried was the same as I had done before hundreds of times with DBs in all versions. When I connected, RMAN complained that the version of the catalog was outdated, as expected: [oracle@brocbddtrj001 …
Rodrigo Jorge
Oracle OCM Database 11g & 12c
Oracle OCM MAA & Cloud
Oracle OCE Data Guard 12c
Oracle OCE RAC and Grid 11gR2 & 12c
Oracle OCE Performance Tuning 11g & 12c
Oracle OCS Security 11g
Oracle OCS Data Warehousing 11g
