Friday 31 March 2017

Configure default device type to disk

Configure default device type to disk

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK;
Configure default device type to tape

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
Configure channel device type disk

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT
‘/u01/app/oracle/flash_recovery_area/ANARDB/DB_%U’;

Configure Controlfile auto backup on and controlfile auto backup format

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK

TO

‘/u01/app/oracle/flash_recovery_area/ANARDB/cf_%F’;
Configure backup Optimization on. Optimization does not back up a file to a device type if the
identical file already backed up on the device type. For two files to be identical, their content must be
the same.

RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
Configure Retention Policy to redundancy

RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
Configure Retention Policy to recovery window.
You should keep the recovery window time period less than or equal to the value of the control files
parameter CONTROL_FILE_RECORD_KEEP_TIME to prevent the record of older backups from being
overwritten in the control file.


RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
Configure auto allocation of channel and parallel backups sets


RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 3;
Manual allocation of channel


RMAN> run {allocate channel c1 device type disk;
backup datafile 1 ;}
Show all RMAN current configuration parameters

RMAN> show all;

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO ‘SBT_TAPE’;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/u01/app/oracle/
flash_recovery_area/ANARDB/cf_%F’;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO ‘%F’; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET;


# default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

No comments:

Post a Comment