| RMAN on ORA11gR2 - CONFIGURE RETENTION POLICY TO REDUNDANCY 1 [message #667273] |
Tue, 19 December 2017 03:18  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
