René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

RMAN commands

allocate channel

Allocates a channel.
The allocate channel command must be placed in a run block along with the commands that use that channel.

configure

Configures the RMAN environment with persistent settings. The stored settings can be displayed with show all.
If CONFIGURE CONTROLFILE AUTOBACKUP is issued, RMAN does a control file autobackup is the automatic backup that RMAN makes either after every
  • BACKUP or COPY command at RMAN's prompt, or
  • BACKUP or COPY command within a run block that is not followed by another BACKUP or COPY command

backup configuration

Setting the retention policy that will apply to all datafiles by default: 
configure retention policy to recovery window of 5 days;
Specify that at least three backup files of a file are on disk. 
configure retention policy to redundancy 3

channel

Configures a channel with persistent settings. They can be overridden with allocate channel.

crosscheck

Checks if backups and copies are readable by RMAN.

delete

obsolete backup files

Delete the obsolete backup files. Obsolete backup files can be listed with report obsolete. 
delete obsolete

exit

exit
Quits the RMAN client.

list

report

obsolete backups

List the backups (on disk) that have become obsolete with the current retention policy. They can be deleted with delete obsolete. 
report obsolete

run

run {
  rman-command-1;
  rman-command-2;
  ...
  rman-command-n;
}

show

show all

Displays persistent settings that were set with configure.