RMAN script for performing a full database backup

advertisements

_____________________________________________________________________________________________________________________

This script performs a full database backup, including data files, control files, and archived logs. It uses a single channel (ch1) for backup and stores the backup as compressed backup sets. The PLUS ARCHIVELOG clause ensures that the archived logs are also included in the backup.

RUN {

  ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;

  BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;

  RELEASE CHANNEL ch1;

advertisements

 

}

Sample Output:

Starting backup at 26-JUN-2023 14:00:00

using channel ORA_DISK_1

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file_number=1 name=/path/to/datafile01.dbf

input datafile file_number=2 name=/path/to/datafile02.dbf

input datafile file_number=3 name=/path/to/datafile03.dbf

...

channel ORA_DISK_1: starting piece 1 at 26-JUN-2023 14:00:05

channel ORA_DISK_1: finished piece 1 at 26-JUN-2023 14:00:10

...

channel ORA_DISK_1: backup set complete, elapsed time: 00:05:00

Finished backup at 26-JUN-2023 14:05:00

Executing this script initiates a full database backup using RMAN. The output displays the progress of the backup, including the data files being backed up and the completion time.

_____________________________________________________________________________________________________________________

Website Stats