Saturday, September 18, 2010

RMAN BACKUP FAILURE AFTER CLONING:

Rman target /
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORQ4 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F’; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
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 ‘/u2490/app/oracle/product/11.1.0/db_1/dbs/snapcf_orq41.f’; # default
Configure  as :
RMAN configuration parameters for database with db_unique_name ORQ4 are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO ‘SBT_TAPE’;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE ‘SBT_TAPE’ TO ‘%F’;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F’;
CONFIGURE DEVICE TYPE ‘SBT_TAPE’ PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 5 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE ‘SBT_TAPE’ TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE ‘SBT_TAPE’ TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL DEVICE TYPE ‘SBT_TAPE’ PARMS  ‘BLKSIZE=262144,ENV=(CvClientName=qmnalx1109,CvInstanceName=Instance001,CvOraSID=orq41)’; ()
CONFIGURE MAXSETSIZE TO 30 G;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM ‘AES128′;
CONFIGURE COMPRESSION ALGORITHM ‘BZIP2′;
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u2490/app/oracle/product/11.1.0/db_1/dbs/snapcf_orq41.f’; # default
export TNS_ADMIN=/home/oracle/sqlnet
rman target / catalog rmanapps/rmanapps@RCVCAT
RMAN>list incarnation of database orq4;
RMAN>register database;
RMAN>exit
Check for the scheduled backup using crontab –l
#ORQ4 BACKUP
00 23 * * 2 /home/oracle/scripts_v2/backup_db_cvault.sh -d orq41 -c rmanapps -l 0 -f 0
00 23 * * 0,1,3,4,5,6 /home/oracle/scripts_v2/backup_db_cvault.sh -d orq41 -c rmanapps -l 1 -f 1
16 10 09 07 * /home/oracle/scripts_v2/backup_db_cvault.sh -d orq41 -c rmanapps -l 1 -f 1
Invoke the Backup
Sh  /home/oracle/scripts_v2/backup_db_cvault.sh -d orq41 -c rmanapps -l 0 -f 0

No comments:

Post a Comment