RMAN Set Clause

Settings that apply only to the current RMAN session.

Syntax:

   SET { set_rman_option [;] | set_run_option; }

   set_rman_option::=
     { ECHO { ON | OFF }
     | DBID [=] integer
     | CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE deviceSpecifier TO 
     'frmt_string'

   set_run_option::=
     { NEWNAME FOR DATAFILE datafileSpec TO { 'filename' | NEW }
     | ARCHIVELOG DESTINATION TO 'log_archive_dest'
     | untilClause
     | COMMAND ID TO 'string'
     | CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE deviceSpecifier TO 
     'frmt_string'
     .
     .
     .
     }

Key

ECHO - Controls whether RMAN commands are displayed in the message log.

DBID - A unique 32-bit identification number computed when the database is created. RMAN displays the DBID upon connection to the target database. You can obtain the DBID by querying V$DATABASE or RC_DATABASE.

NEWNAME FOR DATAFILE - The default name for all subsequent RESTORE or SWITCH commands that affect the specified datafile.

MAXCORRUPT FOR DATAFILE - A limit on the number of previously undetected physical block corruptions that Oracle will allow in the datafile(s)

AUTOLOCATE - Force RMAN to automatically discover which nodes of an Oracle Real Application Clusters configuration contain the backups that you want to restore.

Related Oracle Commands:

CHANGE - Update the status of a backup in the RMAN repository.
CONFIGURE - Persistent RMAN settings.
LIST - List backups and copies
REPORT - Report backup status: database, files, backups
SHOW - Display the current configuration