troubleshooting Question

Oracle 10g Database deleted the Archive Logs itself Not considering the RMAN Retention Policy

Avatar of sodummy
sodummy asked on
Oracle Database
12 Comments2 Solutions2045 ViewsLast Modified:
1. I am at Orale 10g on Linux redhet  4.
2. RMAN backup is used for Backup and Archive log Deletion
3. We have to keep the archive logs for 7 days to the disk .Archive log NOT to be deleted before 7 days (sysdate-7 ) but the archive logs are actually deleted by itself. ON Dec 02nd Archive logs Deleted which are created on the same Day( i.e DEC 02  See the Alert log Entry). Why the archive logs deleted where it is consdered to keep for sydate-7 Days as per RMAN configuration ???
4. I checked the RMAN backup logs and it is not deleted from the RMAN backup and it appears that it is getting deleted by itself. I am using the flashback destination for archive logs as well as flash back recovery.

Here is the RMAN retension Policy:-
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/backup/rman_backup/hcmpro/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 5;
run {
BACKUP format '/u01/backup/rman_backup/hcmpro/DB_%d_%T_%U'
database plus archivelog format '/u01/backup/rman_backup/hcmpro/arc_%d_%s_%p_%t';
BACKUP as copy device type DISK TAG = 'hcmpro_spfile' FORMAT '/u01/backup/rman_backup/hcmpro/spfile_%d_t%t_s%s_p%p' spfile;
restore database validate;
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt archivelog until time "sysdate-7";
delete noprompt obsolete;
-----------------------------------------------------------------------------------------
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST

SQL>desc db_recovery_file
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/backup/flash_recovery_area
db_recovery_file_dest_size           big integer 400G
SQL>
-----------------------------------------------------------------------------
RMAN BACKUP LOGS:-

channel ORA_DISK_2: starting piece 1 at 02-DEC-11
channel ORA_DISK_3: starting compressed archive log backupset
channel ORA_DISK_4: specifying archive log(s) in backup set
input archive log thread=1 sequence=39238 recid=70250 stamp=964807728
input archive log thread=1 sequence=39239 recid=70253 stamp=964809039
input archive log thread=1 sequence=39240 recid=70257 stamp=964809527
input archive log thread=1 sequence=39241 recid=70258 stamp=964809528
input archive log thread=1 sequence=39242 recid=70260 stamp=964811331
input archive log thread=1 sequence=39243 recid=70262 stamp=964811457

Alert Log:--
-------------------------------------------------------------------------------------------------------
Thread 1 cannot allocate new log, sequence 42015
Checkpoint not complete
  Current log# 3 seq# 42014 mem# 0: /u01/oracle/oradata/hcmpro/redo03.log
Fri Dec  2 20:05:30 2011
Thread 1 advanced to log sequence 42015 (LGWR switch)
  Current log# 1 seq# 42015 mem# 0: /u01/oracle/oradata/hcmpro/redo01.log
Fri Dec  2 20:05:31 2011
Deleted Oracle managed file /u01/backup/flash_recovery_area/hcmpro/archivelog/2011_12_02/o1_mf_1_39240_7fkdn7qh_.arc
Deleted Oracle managed file /u01/backup/flash_recovery_area/hcmpro/archivelog/2011_12_02/o1_mf_1_39241_7fkdn81m_.arc
Deleted Oracle managed file /u01/backup/flash_recovery_area/hcmpro/archivelog/2011_12_02/o1_mf_1_39242_7fkgdm70_.arc
Deleted Oracle managed file /u01/backup/flash_recovery_area/hcmpro/archivelog/2011_12_02/o1_mf_1_39243_7fkgjkob_.arc
Deleted Oracle managed file /u01/backup/flash_recovery_area/hcmpro/archivelog/2011_12_02/o1_mf_1_39244_7fkj8tjv_.arc
Fri Dec  2 20:05:31 2011


ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros