Infrastructure at your Service

RMAN Archives - Page 2 of 3 - Blog dbi services

William Sescu

Oracle 12cR2 – RMAN cold backup with TAG’s

By | Database Administration & Monitoring, Database management | One Comment

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 moment, so I start with a full backup with the TAG ‘DBI_BACKUP’ to be 100% that I restore…

 
Read More
William Sescu

Oracle 12cR2 – DataGuard and Backups to NFS

By | Database Administration & Monitoring, Database management | No Comments

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 backups to disk always inaccessible. But what do you do in case you backup to NFS, and you…

 
Read More
William Sescu

Oracle 12c – Finding the DBID – The last resort

By | Database Administration & Monitoring | No Comments

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 / Recovery Manager: Release 12.1.0.2.0 – Production on Mon Nov 28 10:32:47 2016 Copyright (c) 1982, 2014, Oracle…

 
Read More
William Sescu

Oracle 12c – DB_UNKNOWN in ASM

By | Database Administration & Monitoring | One Comment

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 your init<SID>.ora in…

 
Read More
William Sescu

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

By | Database Administration & Monitoring | No Comments

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 has the “#…

 
Read More
William Sescu

Oracle 12c – Automatic Control File Backups

By | Database Administration & Monitoring | 2 Comments

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 on or off….

 
Read More
William Sescu

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

By | Database Administration & Monitoring | No Comments

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 without having the…

 
Read More
William Sescu

Oracle 12c – Managing RMAN persistent settings via SQL

By | Database Administration & Monitoring | No Comments

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 at the first…

 
Read More
Pierre Ochsenbein

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