RAC Backup : Copy 1 set of backup at FLASH & other to ext3 Disk

Posted By Sagar Patil

RMAN> show all;
RMAN configuration parameters for database with db_unique_name MILLPROD are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘D:\Backup\%F’;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘D:\Backup\%U.rman’ MAXPIECESIZE 5120 M;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM ‘AES128’; # default
CONFIGURE COMPRESSION ALGORITHM ‘BZIP2’; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘D:\ORACLE\PRODUCT\11.1.0\MILLPROD\DATABASE\SNCFMILLPROD2.ORA
‘; # default

== NEW database_backup.rman
run{
set command id to ‘rman_hot’;
Allocate channel ch1 TYPE DISK FORMAT ‘+FLASH’ MAXPIECESIZE 5120 M;
backup full tag ‘FULL_HOT_DATABASE’ database;
sql “alter database backup controlfile to trace”;
release channel ch1;
}
run{
set command id to ‘rman_hot’;
Allocate channel ch2 TYPE DISK FORMAT ‘D:\Backup\%U.rman’ MAXPIECESIZE 5120 M;
backup full tag ‘FULL_HOT_DATABASE’ database;
sql “alter database backup controlfile to trace”;
release channel ch2;
}

Leave a Reply

You must be logged in to post a comment.

Top of Page

Top menu