Infrastructure at your Service

RMAN Archives - Page 3 of 4 - Blog dbi services

Oracle Team

Oracle 12c – DB_UNKNOWN in ASM

By | Database Administration & Monitoring | One Comment

By William Sescu Have you ever noticed a DB_UNKNOWN directory in your ASM structure? It usually happens in combination with spfile creation in ASM, or with RMAN spfile restores to ASM. The correct location is +DATA/<SID>/PARAMETERFILE/SPFILE.<#>.<#>, and an ASM alias from +DATA/<SID>/ pointing to it. But sometimes, the spfile ends up in +DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.<#>.<#> Technically no issue. The spfile in the DB_UNKNOWN directory is perfectly ok and can be used. However, you might need to adjust…

Read More
Oracle Team

Oracle 12c – Difference between ‘%F’ #default and ‘%F’

By | Database Administration & Monitoring | One Comment

By William Sescu Do you see any differences between these two RMAN SHOW commands? RMAN> SHOW CONTROLFILE AUTOBACKUP FORMAT; RMAN configuration parameters for database with db_unique_name OCM121 are: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F'; # default and RMAN> SHOW CONTROLFILE AUTOBACKUP FORMAT; RMAN configuration parameters for database with db_unique_name OCM121 are: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F';   They are the same, except that the first output…

Read More
Oracle Team

Oracle 12c – Automatic Control File Backups

By | Database Administration & Monitoring | 2 Comments

By William Sescu By default, automatic control file backups are disabled (even with 12c), maybe for performance reasons. RMAN> SHOW CONTROLFILE AUTOBACKUP; RMAN configuration parameters for database with db_unique_name OCM121 are: CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default And also good to know, the autobackup after structural changes does not occur for databases in NOARCHIVELOG mode. So, if your database is running in NOARCHIVELOG mode, you will never see any impact, independent of controlfile autobackup is…

Read More
Oracle Team

Oracle 12c – When the RMAN Dummy Instance does not start up …

By | Database Administration & Monitoring | No Comments

By William Sescu Not too often, but sometimes you might run into a situation when you lose everything, your DB Files, your Controlfiles and even your spfile. In situations like that, you need to restore first your spfile, then your controlfile and then the rest. For restoring the spfile, RMAN has a chicken/egg issue. To be able to restore the spfile, RMAN needs at least a running instance, but how do we start the instance…

Read More
Oracle Team

Oracle 12c – Managing RMAN persistent settings via SQL

By | Database Administration & Monitoring | No Comments

By William Sescu RMAN persistent settings can be managed in two different ways. Via the RMAN interface – e.g. RMAN> CONFIGURE BACKUP OPTIMIZATION ON; Via SQL – e.g. VARIABLE RECNO NUMBER; EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG(‘BACKUP OPTIMIZATION’,’ON’); There are several scenarios when it might be helpful to use the SQL way. I will show 3 of them: Automation Reset to default Rebuilding the RMAN persistent settings after losing all controlfiles (no catalog) Let’s take a look…

Read More

Windows: Sauvegarde RMAN sur un disque partagé

By | Database Administration & Monitoring | No Comments

Dans ce blog, je vais vous expliquer comment exporter les backups RMAN sur un « share disk » appartenant à un Domaine. Assurer la sécurité des données est l’une des tâches principales de l’administrateur : La mise en œuvre d’une protection des fichiers sensibles de la base : Fichier de contrôle Fichiers de journalisation La mise en place d’une stratégie de sauvegarde/récupération : Adaptée aux contraintes de l’entreprise Testée et documentée. Afin de vous documenter sur les différentes techniques de sauvegarde…

Read More
Olivier Toussaint

How to manage your containers in Oracle Storage Cloud Service ?

By | Database Administration & Monitoring | 5 Comments

Oracle Cloud Storage Service provides secure, scalable and consistent data from any environment. To get a higher flexibility for your backups, I suggest to use a CloudBerry application in Oracle Public Cloud. This application can be used on Cloud Backup and Recovery in PaaS and IaaS infrastructures. We are going to use it for our DbaaS in PaaS infrastructure. However, a user-friendly third party tool can also be used as CloudBerry Explorer for OpenStack as…

Read More
Oracle Team

RMAN 12c Push and Pull duplicate explained

By | Database Administration & Monitoring | 2 Comments

By Franck Pachot . Oracle Database 12c introduced the ‘restore from service’ where you can restore and recover by requesting backupsets from the source. With that feature, the duplicate from active can work in the opposite way: instead of asking the source (target) to send the files to the destination (auxiliary) now the destination can do all the job. Let’s see how it works by comparing the RMAN log of the two methods.

Read More
Pierre Sicot

UKOUG Day 4: Oracle Cloud Control 12c for DBAs

By | Technology Survey | No Comments

Today’s first session was a round table session with Andrew Bullock, Director of Application and systems management at Oracle. The main result of this session was that the main people using Enterprise Manager Cloud Control 12c were DBA and not so much system or Weblogic Administrators. It appears also that not so many DBA have realized in production the upgrade from Grid Control 11g to Cloud Control 12c, because in case of a huge number…

Read More