DB version: 11.2.0.4.0
Platform : RHEL 6.5
We have an important 2-Node RAC DB which is 14 TeraBytes in size. This is an Important DB which we can afford to have only 4 hours hours downtime ie. restore+recover needs to be completed in 4 hours.
During Restore test for this DB, we did a Full DB restore+recover from Hot backup in 3.5 hours .
Is a retention policy of REDUNDANCY 1 appropriate for this DB ? Any suggestion/correction , however trivial is welcome
Following is how we backup the DB using RMAN.
Full Backup (L0) ---- > Saturday and Wednesday early morning 1:00AM
Incremental (L1) -----> Remaining days morning 1:00 AM (Sunday, Monday, Tuesday, Thursday and Friday )
Archive Log backup and purge ----> 11AM, 4PM and 10PM everyday
DB size : 14 TB
SHOW ALL output.
$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Aug 19 11:01:35 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: RCASPRD (DBID=9247169542)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name RCASPRD are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO 'RCASCTRLFILE.%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
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
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' TRACE 1 PARMS XXXXXXXXXXXXXX ;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default