Summary of common RMAN commands

RMAN is a required management tool for Oracle Database Backup management. There are many ways to operate it. I sorted out some common operation commands and summarized them to facilitate work.

1. database backup operation commands

Simplified Version

Backup database plus archivelog format '/backup/rman/xx _ % U. % T ';

Regular version

Run {

Allocate channel t1 type disk;

Backup database format '/backup/rman/xx _ % U. % T ';

Backup archivelog all delete input format '/backup/rman/xx _ % U. % T ';

SQL 'alter system archive log current ';

Backup current controlfile format '/backup/rman/xx _ % U. % T ';

Release channel t1;

}

Enhanced Edition

Run

{

Delete noprompt obsolete;

Allocate channel ch01 type disk rate 40 M;

Backup database filesperset 3 format'/backup/servdb_rman/db _ % U. % T ';

SQL 'alter system archive log current ';

Backup archivelog like '+ %' filesperset 20 format'/backup/servdb_rman/archivelog _ % U. % T ';

Delete noprompt archivelog until time 'sysdate-1 ';

Backup current controlfile format '/backup/servdb_rman/ctl _ % U. % T ';

Release channel ch01;

}

1 2 3 Next Page