By William Sescu I am planning to backup my 12R2 container database, because a huge application change is coming up, and I want to be sure that I have a good RMAN backup beforehand. For that particular DB, I want to do it with a cold backup in combination with RMAN tags. Unfortunately I don’t have any backups at the…
By William Sescu From the RMAN point of view, you have generally two possibilities to store your backups, on Disk or on Tape. In case of a single instance, it doesn’t really matter from the accessible or inaccessible point of view. However, in a DataGuard environment it makes a huge difference. Per default, backups to Tape are always accessible and…
By Franck Pachot . In a previous post I explained how to use transportable tablespace from a standby database. Here I’m showing an alternative where you can transport from a backup instead of a standby database. RMAN can do that since 10gR2. Transportable Tablespace is a beautiful feature: the performance of physical copy and the flexibility of logical export/import. But…
By William Sescu The DBID is a very important part for Oracle databases. It is an internal, uniquely generated number that differentiates databases. Oracle creates this number automatically as soon as you create the database. During normal operation, it is quite easy to find your DBID. Whenever you start your RMAN session, it displays the DBID. oracle@oel001:/home/oracle/ [OCM121] rman target…
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…
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…
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…
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…
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…
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…
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,…
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…
