Home » RDBMS Server » Backup & Recovery » archive backup deletion (11g R2 RHEL5.5)
archive backup deletion [message #624209] Fri, 19 September 2014 01:27 Go to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
AOA,
I have set level 0 backup on Saturday. (shell script)
I have set archive log backup on every 4 hours (shell script).
I have set level 1 backup on Sun,Mon,Tue,Wed,Thu,Fri (shell script)

I have redundancy 4 and run delete obsolete. It applies on level 0 and 1 backups But not on archive log backups.

In this situation how I delete archive log backups not needed automatically.
Re: archive backup deletion [message #624245 is a reply to message #624209] Fri, 19 September 2014 07:47 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
DELETE OBSOLETE should do it.
My guess is your concept of when rman should consider when a given backupset is considered to be obsolete is flawed.
Show us the output of LIST BACKUP and and REPORT OBSOLETE, and point out which backupset you think should be considered obsolete.
Re: archive backup deletion [message #624419 is a reply to message #624245] Mon, 22 September 2014 11:18 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
rman>list backup summary;
level 0 12-Sep-2014-1630
Arch 13-Sep-2014-0900
Arch 13-Sep-2014-1100
Arch 13-Sep-2014-1400
level 1 13-Sep-2014-1630
Arch 14-Sep-2014-0900
Arch 14-Sep-2014-1100
Arch 14-Sep-2014-1400
level 1 14-Sep-2014-1630
Arch 15-Sep-2014-0900
Arch 15-Sep-2014-1100
Arch 15-Sep-2014-1400
level 1 15-Sep-2014-1630
Arch 16-Sep-2014-0900
Arch 16-Sep-2014-1100
Arch 16-Sep-2014-1400
Arch 16-Sep-2014-1630

RMAN>rebort obsolete redundancy 1;
It should obsolete Arch backups between Level 1 and 0. But it is not do so.
Re: archive backup deletion [message #624426 is a reply to message #624419] Mon, 22 September 2014 12:09 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Like I said, "your concept of when rman should consider when a given backupset is considered to be obsolete is flawed."

ALL recovery ... I repeat, "ALL recovery" begins with restoring from the level 0 backup. And backups of archivelogs cannot be considered oboslete until such time as they are no longer needed to enforce the recovery window.

Now, suppose you need to recover to 13-Sep-2014-1629. That is still within your recovery window, and the three archivelog backups taken on 23-sep are needed to perform that recovery, so cannot be considered obsolete.


If you have access to MOS, you might want to review notes 462978.1 and 463875.1.

[Updated on: Mon, 22 September 2014 13:29]

Report message to a moderator

Re: archive backup deletion [message #624451 is a reply to message #624426] Mon, 22 September 2014 23:48 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
I am using Redundancy 4 Not recovery window.
I understand recovery window.
But I think redundancy 4 is different.
Re: archive backup deletion [message #624546 is a reply to message #624451] Tue, 23 September 2014 08:03 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
smunir362 wrote on Mon, 22 September 2014 23:48

But I think redundancy 4 is different.



Not really. It's just that your "window" is based on the number of backups rather than specific time frames. The same principle still applies. If you have a 'redundancy 4' then your 'window' is back to the point of the 4th full or level 0 backup. And oracle needs to keep everything that would be needed to recover to any point in time since that backup. And to achieve that, it needs the archive logs.
Re: archive backup deletion [message #624605 is a reply to message #624546] Tue, 23 September 2014 23:45 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
So,
You say redundancy or recovery window are the same.
Re: archive backup deletion [message #624622 is a reply to message #624605] Wed, 24 September 2014 03:36 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
No. From the documentation, REDUNDANCY "specifies how many full or level 0 backups of each data file and control file that RMAN should keep. If the number of full or level 0 backups for a specific data file or control file exceeds the REDUNDANCY setting, then RMAN considers the extra backups as obsolete."

RECOVERY WINDOW "specifies the number of days between the current time and the earliest point of recoverability. RMAN does not consider any full or level 0 incremental backup as obsolete if it falls within the recovery window. Additionally, RMAN retains all archived logs and level 1 incremental backups that are needed to recover to a random point within the window."
Re: archive backup deletion [message #624650 is a reply to message #624605] Wed, 24 September 2014 08:01 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
smunir362 wrote on Tue, 23 September 2014 23:45
So,
You say redundancy or recovery window are the same.


No, I'm not saying they are the same. I'm saying that rules of obsolescence/retention of backups apply equally to both. You start with the oldest level 0 or full backup that meets your retention policy, whether it be time based or redundancy based. Archivelogs and level 1 backups newer than that are not going to be considered obsolete because they will be needed for a point in time recovery.
Re: archive backup deletion [message #624716 is a reply to message #624650] Thu, 25 September 2014 00:00 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
Ok.
I am confusing.
While using redundancy.
I restore 0 level backup. then all avaliable level 1 backups. Now I did not required archived backups that are between the level0 and level1 backups.
It is my point
Re: archive backup deletion [message #624774 is a reply to message #624716] Thu, 25 September 2014 08:58 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
smunir362 wrote on Thu, 25 September 2014 00:00
Ok.
I am confusing.
While using redundancy.
I restore 0 level backup. then all avaliable level 1 backups. Now I did not required archived backups that are between the level0 and level1 backups.
It is my point


Go back to my diagram. What if you need to restore to a point in time BETWEEN any incremental backup?

YOU may think YOU don't need to recover to those points in time, but Oracle has to cover all bases.

And even if you think you are recovering to an incremental backup, there will most likely be a need to include at least one archivelog to get everything to a consistent SCN.
Re: archive backup deletion [message #624932 is a reply to message #624774] Sun, 28 September 2014 23:34 Go to previous message
smunir362
Messages: 310
Registered: September 2007
Senior Member
AOA,
Thanks I uderstand.
Previous Topic: Can not delete obsolete !
Next Topic: Comments in RMAN Log file
Goto Forum:
  


Current Time: Thu Mar 28 09:50:21 CDT 2024