Oracle Tips by Burleson

Oracle Dataguard
Chapter 9 - Recovery Manager and Data Guard

Explanation of RMAN Terminology

• DUPLICATE COMMAND – To restore a backup set or image copy, the DUPLICATE command can be used. The duplicate command always performs a complete restoration of the target database. Using this command, a database can be restored on the local host sharing with the target database or on remote host. A recovery catalog is not needed to use the duplicate command.  It can be used with the control file of the target database serving as the repository.
   

• BACKUP SET – Recovery Manager backs up the datafiles, control file, archived log files, and server parameter files in a RMAN specific format called backup pieces. A set of one or more such backup pieces makes up a backup set. A backup set is created using the BACKUP command.
   

• IMAGE COPY – As opposed to the backup set, an image copy is not a RMAN specific format. It is a replica of an actual file. Image copies are created using the COPY command.
   

• SET NEWNAME – This command can be used to rename the data files to be restored to a new location. It is equivalent to the db_file_name_convert parameter of the server initialization parameter file. Combination of the SET NEWNAME and SWITCH command is the equivalent of the ALTER DATABASE RENAME FILE statement.
   

• CONFIGURE AUXNAME – CONFIGURE AUXNAME is equivalent to the SET NEWNAME command, except that the CONFIGURE AUXNAME is persistent, whereas, the SET NEWNAME command must be used every time the DBA wants to rename a data file. It is necessary to connect to the recovery catalog in order to use the CONFIGURE AUXNAME command.

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.