RMAN

Oracle 12c – Automatic Control File Backups

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(…)

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

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(…)

Oracle 12c – Managing RMAN persistent settings via SQL

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(…)

Windows: Sauvegarde RMAN sur un disque partagé

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(…)

How to manage your containers in Oracle Storage Cloud Service ?

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(…)

RMAN 12c Push and Pull duplicate explained

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(…)

Oracle 12c duplicate in cluster fails with ORA-65500

I had to perform a duplicate database between 2 ODAs and was always facing an ORA-65500 at the begin of the RMAN operation. Looking a bit deeper in the log outputs pointed me out that it was due to some(…)

Oracle 12c: Pluggable databases not that isolated

As you probably know, the multitenant databases is the new feature of Oracle 12c to solve the dilema of applications segregation. Thanks to a multitenant container database, it allows to manage many databases as one taking advantage of resources(…)

“ORA-01665: control file is not a standby control file”: what can I do?

You have certainly also received this error once in you Oracle DBA career: “ORA-01665: control file is not a standby control file” while trying to create a standby database with RMAN through a full database backup. In fact, the feature(…)

Block Corruption Oracle 10g vs Oracle 11g

Ayant rencontré récemment des problèmes de blocs corrompus sur des bases Oracle en version Oracle 10g et Oracle 11g, des différences notables sont apparues notamment au niveau de la vue v$database_block_corruption. Je vous livre dans ce post le résultat(…)