RMAN Commands , 50 of 59

SET

Purpose

To configure settings that apply only to the current RMAN session. The SET command contrasts with the CONFIGURE command, which configures persistent settings that apply to all RMAN sessions.

You can specify the SET command either at the RMAN prompt or within a RUN block. When you issue SET within a RUN block, the command sets attributes for a RUN command that persist until the end of the job. The specified attributes affect all statements within RUN that follow the SET command.

Use the SET specified at the RMAN prompt to:

Display executed RMAN commands in the message log.
Specify a database's database identifier (DBID).

Use SET specified within a RUN block to:

Specify the filenames for the auxiliary database during TSPITR or database duplication.
Specify a limit for the number of permissible block corruptions.
Override default archived redo log destinations.
Set an end time, SCN, or log sequence number for recovery.
Specify that backups should be duplexed, that is, multiple copies should be created of each backup piece in the backup set.
Determine which server session corresponds to which channel.
Turn RMAN's automatic location feature on or off.
Override the default format for control file autobackups at the session level.

Restrictions and Usage Notes for SET Command Within RUN

The following restrictions apply to SET when issued within a RUN command:

The SET BACKUP COPIES command affects all backups in the RUN block after issuing the command and is in effect until explicitly disabled or changed. The SET BACKUP COPIES command does not affect previous backups.
Include the %F substitution variable in the autobackup format.
You cannot use SET NEWNAME TO NEW when creating a duplicate or standby database or performing RMAN TSPITR.

Restrictions and Usage Notes for the SET DBID Command

You should only run the SET DBID command in the following specialized circumstances:

You are not connected to a recovery catalog and want to restore the control file or server parameter file.
You are connected to a recovery catalog want to restore the control file, but the database name is not unique in the recovery catalog.
The server parameter file is lost and you want to restore it.

See Also:
Table 2-25 for RESTORE CONTROLFILE usage notes.

Keywords and Parameters

Syntax Element	Description
`ECHO` `{ON` `\|` `OFF}`	Controls whether RMAN commands are displayed in the message log. When reading commands from a command file, RMAN automatically echoes those commands to the message log. When reading commands from standard input, RMAN does not echo those commands to the message log unless the `SET` `ECHO` `ON` command is used. The command is useful only when `stdin` and `stdout` have been redirected. For example, in UNIX you can redirect RMAN's input and output in this manner: % rman TARGET sys/sys_pwd@prod1 CATALOG rman/rman@rcat < input_file > output_file By running `SET` `ECHO` `ON`, you enable the commands contained in `input_file` to be visible in `output_file`.
`DBID` `integer`	Specifies the DBID, which is 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 the `V$DATABASE` view or the `RC_DATABASE` and `RC_DATABASE_INCARNATION` recovery catalog views. See Also: "Restrictions and Usage Notes for the SET DBID Command"
`CONTROLFILE` `AUTOBACKUP` `FORMAT` `FOR` `DEVICE` `TYPE` deviceSpecifier `TO` `'``format_string'`	Overrides the default filename format for the control file autobackup on the specified device type. The override occurs at the session level only. You can run this command either in `RUN` or at the RMAN prompt. The order of precedence is as follows: `SET` `CONTROLFILE` `AUTOBACKUP` executed within a `RUN` block `SET` `CONTROLFILE` `AUTOBACKUP` executed at the RMAN prompt `CONFIGURE` `CONTROLFILE` `AUTOBACKUP` `FORMAT` See Also: The `CONFIGURE` command for an explanation of the autobackup format.
`NEWNAME` `FOR` `DATAFILE` datafileSpec `TO`	Sets the default name for all subsequent `RESTORE` or `SWITCH` commands that affect the specified datafile. If you do not issue this command before the datafile restore operation, then RMAN restores the file to its default location. After you restore a datafile to a new location, then you can run `SWITCH` to rename the file in the control file to the `NEWNAME`. If you do not run `SWITCH`, then the restored file functions as a datafile copy and is recorded as such in the repository. See Also: "datafileSpec"
`'``filename``'`	Specifies a user-defined filename for the restored datafile.
`NEW`	Creates an Oracle-managed file in the directory specified in `DB_CREATE_FILE_DEST`. You cannot use this option when using the `DUPLICATE` command or performing RMAN TSPITR. See Also: Oracle9i Database Administrator's Guide for information about Oracle Managed Files
`MAXCORRUPT` `FOR` `DATAFILE` datafileSpec `TO` `integer`	Sets a limit on the number of previously undetected physical block corruptions that Oracle will allow in a specified datafile or list of datafiles. If a `BACKUP` or `COPY` command detects more than the specified number of corruptions, then the command terminates. The default limit is zero, meaning that RMAN tolerates no corrupt blocks. Note: If you specify `CHECK` `LOGICAL`, then the `MAXCORRUPT` limit applies to logical corruptions as well. See Also: "datafileSpec"
`ARCHIVELOG` `DESTINATION` `TO '``log_archive_dest``'`	Overrides the `LOG_ARCHIVE_DEST_1` initialization parameter in the target database when forming names for restored archive logs during subsequent `RESTORE` and `RECOVER` commands. RMAN restores the logs to the destination specified in `'``log_archive_dest``'`. Use this parameter to restore archived redo logs that are not already on disk. Use this command to stage many archived logs to different locations while a database restore is occurring. RMAN knows where to find the newly restored archive logs; it does not require them to be in the destination specified by `LOG_ARCHIVE_DEST_1`. For example, if you specify a different destination from the one in the parameter file and restore archived redo log backups, subsequent restore and recovery operations will detect this new location. RMAN always looks for archived redo logs on disk first before restoring them from backup sets.
untilClause	Specifies an end time, SCN, or log sequence number for a subsequent `RESTORE` or `RECOVER` command. See Also: "untilClause"
`BACKUP` `COPIES` `=` `integer`	Specifies the number of copies of each backup piece that the channels should create: 1, 2, 3, or 4. The `SET` `BACKUP` `COPIES` command, which affects only the `BACKUP` command, affects all channels allocated in the session. The order of precedence is as follows, with settings higher on the list overriding settings lower on the list: `BACKUP` `COPIES` `SET` `BACKUP` `COPIES` `CONFIGURE` `...` `BACKUP` `COPIES` The names of the backup pieces are dependent on the `FORMAT` clause in the `BACKUP` command. You can specify up to four `FORMAT` strings. RMAN uses the second, third, and fourth values only when `BACKUP` `COPIES`, `SET` `BACKUP` `COPIES`, or `CONFIGURE` `...` `BACKUP` `COPIES` is in effect. When choosing which format to use for each backup piece, RMAN uses the first format value for copy 1, the second format value for copy 2, and so on. If the number of format values exceeds the number of copies, then the extra formats are not used. If the number of format values is less than the number of copies, RMAN reuses the format values, starting with the first one. Note: Control file autobackups on disk are a special case and are never duplexed: RMAN always writes one and only copy.
`COMMAND` `ID` `TO` `'``string``'`	Enters the specified string into the `V$SESSION.CLIENT_INFO` column of all channels. Use this information to determine which Oracle server sessions correspond to which RMAN channels. The `SET` `COMMAND` `ID` command applies only to channels that are already allocated. The `V$SESSION.CLIENT_INFO` column contains information for each RMAN server session. The data appears in one of the following formats: `id=``string` `id=``string`, `ch=``channel_id` The first form appears in the RMAN target database connection. The second form appears in all allocated channels. When the current job is complete, the `V$SESSION.CLIENT_INFO` column will be cleared. See Also: Oracle9i Database Reference for more on `V$SESSION.CLIENT_INFO`

Examples

Restoring the Control File When Databases Share the Same Name: Example

The following shell script uses the DBID to restore the control file because multiple target databases share the same DB_NAME in the catalog. After you have restored the target control file, you can mount the database to restore the rest of the database:

#!/usr/bin/tcsh
rman TARGET / CATALOG rman/rman@catdb <<EOF
STARTUP FORCE NOMOUNT;
SET DBID = 862893450; # needed to distinguish target from others with same DB_NAME
RESTORE CONTROLFILE; # assuming catalog has automatic channel allocation information
ALTER DATABASE MOUNT;
EOF

Setting the Command ID: Example

This example sets the command ID, backs up the users tablespace, then archives the online redo logs:

RUN
{
  ALLOCATE CHANNEL t1 DEVICE TYPE DISK FORMAT '/disk1/%U';
  ALLOCATE CHANNEL t2 DEVICE TYPE DISK FORMAT '/disk2/%U';
  SET COMMAND ID TO 'rman';
  BACKUP INCREMENTAL LEVEL 0 FILESPERSET 5 TABLESPACE users;
 SQL 'ALTER SYSTEM ARCHIVE LOG ALL';

}

Duplexing a Backup Set: Example

Assume that you have used the CONFIGURE command to set duplexing as follows:

CONFIGURE ARCHIVELOG COPIES FOR DEVICE TYPE sbt TO 4;
CONFIGURE DATAFILE COPIES FOR DEVICE TYPE sbt TO 3;

The following example overrides these configurations and makes two copies of each datafile and archived log in the backup:

RUN
{
  ALLOCATE CHANNEL dev1 DEVICE TYPE sbt;
  SET BACKUP COPIES = 2;
  BACKUP FILESPERSET 1 DATAFILE 1,2,3,4,5;
  BACKUP FILESPERSET 10 ARCHIVELOG ALL;
}

Overriding the Autobackup Format During a Restore: Example

This example sets the DBID, sets a boundary time for the restore, then restores a control file autobackup with a nondefault format. First start RMAN and then run:

CONNECT TARGET / NOCATALOG
STARTUP FORCE NOMOUNT
SET DBID 676549873;
RUN
{
  SET UNTIL TIME '10/10/2001 13:45:00';
  SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '?/oradata/cf_%F.bak';
  RESTORE CONTROLFILE FROM AUTOBACKUP MAXSEQ 100;
}

Restoring the Server Parameter File: Example

This example restores a lost server parameter file:

CONNECT TARGET / CATALOG rman/rman@catdb
SET DBID 676549873;  # set dbid so rman knows the database name
STARTUP FORCE NOMOUNT # rman starts database with a dummy server parameter file
RESTORE SPFILE;
STARTUP FORCE; # needed so that RMAN restarts database with restored server parameter file

SET

Syntax

set_rman_option::=

set_run_option::=