Home » RDBMS Server » Backup & Recovery » RMAN on ORA11gR2 - CONFIGURE RETENTION POLICY TO REDUNDANCY 1
RMAN on ORA11gR2 - CONFIGURE RETENTION POLICY TO REDUNDANCY 1 [message #667273] Tue, 19 December 2017 03:18 Go to previous message
Rumak18
Messages: 20
Registered: April 2009
Location: Germany
Junior Member
Hello,
i've got a rman backup configuration for my db :


CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'd:\BACKUP\MY_CONTROLFILE_BACKUP_%F.ORA';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'D:\BACKUP\MY_BACKUP_%U' MAXPIECESIZE 2 G;
CONFIGURE MAXSETSIZE TO UNLIMITED;
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
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\BACKUP\MY_SNAPCONTROL.ORA';


My backup script on monday looks like this:
backup AS COMPRESSED BACKUPSET incremental level 1 cumulative database;
delete obsolete;
delete archivelog all;
sql'purge dba_recyclebin';
crosscheck backup;
crosscheck archivelog all;


My backup script on tuesday to friday looks like this:
backup AS COMPRESSED BACKUPSET incremental level 0 cumulative database;
delete obsolete;
delete archivelog all;
sql'purge dba_recyclebin';
crosscheck backup;
crosscheck archivelog all;


Unfortunately , rman does not delete "obsolete" backups on monday after . This happens often in last time and i don't know why.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: ORA-19504 - "failed to create file"
Next Topic: transportable database windows to linux
Goto Forum:
  


Current Time: Mon Sep 28 08:25:43 CDT 2020