Configuring Channels and Examples

Persistent configuration using CONFIGURE commands:

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 8;
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/rman/%U';

Per-job allocation using ALLOCATE CHANNEL in a RUN block (overrides persistent configuration):

RUN {
  ALLOCATE CHANNEL ch01 DEVICE TYPE DISK FORMAT '/rman/%U';
  ALLOCATE CHANNEL ch02 DEVICE TYPE DISK FORMAT '/rman/%U';
  BACKUP DATABASE;
}

The examples in this paper use persistent configuration for simplicity.

Backups

CONFIGURE DEVICE TYPE DISK PARALLELISM 8;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/rman/%U';
CONFIGURE CONTROLFILE AUTOBACKUP ON;

BACKUP
  SECTION SIZE 64G
  FILESPERSET 2
  DATABASE
  PLUS ARCHIVELOG DELETE INPUT;

Restore

CONFIGURE DEVICE TYPE DISK PARALLELISM 8;
RUN {
  RESTORE CONTROLFILE FROM '/rman/<CONTROLFILE_BACKUP>';
  ALTER DATABASE MOUNT;
  RESTORE DATABASE;
  RECOVER DATABASE;
}
ALTER DATABASE OPEN RESETLOGS;

Monitor

SELECT sid, opname, sofar, totalwork,
       ROUND(sofar/totalwork*100,2) AS pct_complete,
       time_remaining
FROM V$SESSION_LONGOPS
WHERE opname LIKE 'RMAN%'
  AND sofar <> totalwork;