RMAN [Oracle Recovery Manager]

В cmd:
   >rman target /
   >CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
   >CONFIGURE DEFAULT DEVICE TYPE TO DISK;
   >CONFIGURE CONTROLFILE AUTOBACKUP ON;
   >CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT /backups/MYSID/%d_DB_%u_%s_%p;

   >BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
   >BACKUP AS COMPRESSED BACKUPSET DATAFILE;
   >CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
   >BACKUP DATABASE PLUS ARCHIVELOG;
 

Configure channel

Использование нескольких дисков для параллельного бэкапа (OracleEE):
 скрипт:
 run {
 ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/u01/disk1/%U';
 ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/u01/disk2/%U';
 backup database;
 }
 через настройку rman:
 CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
 CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/u01/disk1/%U';
 CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/u01/disk2/%U';
 бэкап можно делать одной командой:
 backup database;