Oracle in a Nutshell

Name

SET

Synopsis

Oracle9i syntax:

SET { setRmanOption [;] | setRunOption; }

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

setRunOption :=
{ NEWNAME FOR DATAFILE datafileSpec TO { 'filename' | NEW }
| MAXCORRUPT FOR DATAFILE datafileSpec 
   [, datafileSpec ...] TO integer
| ARCHIVELOG DESTINATION TO 'log_archive_dest'
| until
| BACKUP COPIES [=] integer
| COMMAND ID TO 'string'
| AUTOLOCATE { ON | OFF }
| CONTROLFILE AUTOBACKUP 
   FORMAT FOR DEVICE TYPE deviceSpecifier TO 
       'format_string'
}

Oracle8i syntax:

SET { setRmanOption [;] | setRunOption;}

setRmanOption :=
 {{ AUXNAME FOR DATAFILE datafileSpec TO { 'filename' | NULL }
    | DBID [=] integer
    | SNAPSHOT CONTROLFILE NAME TO 'filename'
    }
  | ECHO { ON | OFF }
  };

setRunOption :=
{ { NEWNAME FOR DATAFILE datafileSpec TO 'filename'
  | MAXCORRUPT FOR DATAFILE datafileSpec 
      [, datafileSpec ...]
    TO integer
  | ARCHIVELOG DESTINATION TO 'log_archive_dest'
  | until
  | DUPLEX [=] { ON | OFF | integer }
  | COMMAND ID TO 'string'
  | AUTOLOCATE { ON | OFF }
  }
| LIMIT CHANNEL [']channel_id['] 
  limitOptions [limitOptions ...]
}

limitOptions :=
{ KBYTES [=] integer
| READRATE [=] integer
| MAXOPENFILES [=] integer
}

Establishes values for settings for the current RMAN session.

Keywords

ECHO

Controls whether RMAN commands are echoed in the message log. By default, commands entered at the prompt are not echoed, while script commands are.

DBID

Specifies a unique 32-bit identification ...