RE: What am I missing with my RMAN archivelog backups
Date: Fri, 02 May 2014 20:44:02 +0100
Message-ID: <w22gkb260mnsucoxf544dkh8.1399059842963_at_email.android.com>
Greetings,
An archive log crosshead does not mark files as obsolete, it marks them as expired.
List expired archive log all; will show them.
You can see them in the catalog view RC_ARCHIVE_LOG. Before the cross check they most likely have STATUS='A' and after, the files that no longer exist on disc will be changed to have STATUS='X'.
HTH
Cheers,
Norm.
Sent from my Samsung Galaxy Note III - powered by Three
<div>-------- Original message --------</div><div>From: Michael Schmitt <mschmitt_at_uchicago.edu> </div><div>Date:02/05/2014 18:22 (GMT+00:00) </div><div>To: Alfredo Abate <alfredo.abate_at_gmail.com> </div><div>Cc: ORACLE-L <oracle-l_at_freelists.org> </div><div>Subject: RE: What am I missing with my RMAN archivelog backups </div><div> </div>Hi Alfredo,
I only run the following crosscheck commands on a schedule as part of the script:
crosscheck archivelog all;
crosscheck backup device type disk;
I just ran a manual "crosscheck backup device type sbt_tape;" now. Everything came back as available and it didn't change the obsolete info at all.
Thanks,
Mike
From: Alfredo Abate [mailto:alfredo.abate_at_gmail.com]
Sent: Friday, May 02, 2014 12:01 PM
To: Michael Schmitt
Cc: ORACLE-L
Subject: Re: What am I missing with my RMAN archivelog backups
Are you performing a crosscheck at any point?
Alfredo
On Fri, May 2, 2014 at 11:57 AM, Michael Schmitt <mschmitt_at_uchicago.edu> wrote: Hello,
I am trying to figure out why my rman archivelog backups to tape are not getting removed. This worked correctly at some point, so I am not sure if it was when we changed scripts or version changes with oracle that I did not catch at the time. This example is for an 11.1.0.7 instance which was created recently, but we are running all versions from 10g to 11204. I have not looked into it enough to tie the behavior to a certain version yet. I am listing output of most of the information that I think is relevant.
RMAN> report obsolete; <--- This is showing nothing found as obsolete. I would expect my archivelog backups to show as obsolete based on the information below
RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 7 days no obsolete backups found
RMAN> list backup summary; <------ We have archivelog backups that are older than our oldest database backup. I would expect these to report as obsolete, or to at least get caught in the delete obsolete
List of Backups
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- --- 131 B A A SBT_TAPE 06-MAR-14 1 1 NO TAG20140306T132627 132 B A A SBT_TAPE 06-MAR-14 1 1 NO TAG20140306T132627 175 B A A SBT_TAPE 07-MAR-14 1 1 NO TAG20140307T000012 283 B A A SBT_TAPE 07-MAR-14 1 1 NO TAG20140307T080324 284 B A A SBT_TAPE 07-MAR-14 1 1 NO TAG20140307T080324 335 B A A SBT_TAPE 07-MAR-14 1 1 NO TAG20140307T090010 375 B A A SBT_TAPE 08-MAR-14 1 1 NO TAG20140308T000013 ...........................
RMAN> show all; <---- Retention is set to 7 days and default device type is tape
RMAN configuration parameters for database with db_unique_name XXXX are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE'; CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default ........
- All of the database backups are full level 0 backups.
- Archivelogs are backed up with the following command " backup format 'XXXX_ARCH_%M%D_%u.bkp' archivelog all not backed up 3 times;"
Thanks in advance for any help
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 02 2014 - 21:44:02 CEST