Oracle Tips by Burleson

Explanation of RMAN Terminology

• DORECOVER – When the DUPLICATE command is specified with the DORECOVER option, it starts recovery after restoration. The recovery is performed using all available archived redo logs and incremental backups. This is the recommended option while creating standby databases using recovery manager. This will save the extra step of recovering the RAC Grid once it is created.
   

• NOFILENAMECHECK – It is an option for the DUPLICATE command. When NOFILENAMECHECK is used with the DUPLICATE command, RMAN does not validate the filenames during restoration. If the primary database and the RAC Grid are on the same host, this option should not be used.

Creating Physical Standby Databases using RMAN

In this section, the details of creating physical standby databases using Recovery Manager will be presented. It will cover the backup requirements and the step-by-step guide to creating physical standby databases. RAC Grid creation cannot be completely automated using RMAN as it can by using Data Guard Broker.

Before the creation of the RAC Grid using RMAN can be started, the server parameter file and Oracle net configuration files will have to be modified manually to suit the Data Guard configuration.

Need an Oracle Health Check? Do you have bad performance after an upgrade?   Need to certify that your database follows best practices? BC Oracle performance gurus can quickly certify every aspect of your Oracle database and provide a complete verification that your database is fully optimized.