RMAN - EM

[Roshan]

Hi,

I have scheduled daily backups(incremental 1) on Enterprise Manager. I have also set the recovery window to 5 days. I have noticed the backup sets keep on increasing.
rman1.PNG
rman2.PNG

As seen in the above picture, there are 10 backupsets. The number of backupsets keeps on increasing.

Does RMAN automatically delete the obsolete backups after the 5 day retention policy?

Thanks,
Roshan

[ErmanArslansOracleBlog]

Hi,

You need to use delete obsolete command. "Delete obsolete" command will delete all the obsoleted backup according to the retention policy. Rman does not delete obsolete backups automatically.

9 Tem 2016 19:37 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hi,

I have scheduled daily backups(incremental 1) on Enterprise Manager. I have also set the recovery window to 5 days. I have noticed the backup sets keep on increasing.
rman1.PNG
rman2.PNG

As seen in the above picture, there are 10 backupsets. The number of backupsets keeps on increasing.

Does RMAN automatically delete the obsolete backups after the 5 day retention policy?

Thanks,
Roshan

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/RMAN-EM-tp1138.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Roshan]

Hi,

a full backup was taken on 30/06/2016. When I do report obsolete I see the backupset on 30/06/2016 listed among the obsolete backups. If I do delete obsolete and removes the full backup on 30/06/2016, will the recovery fail?

Thanks,
Roshan

[ErmanArslansOracleBlog]

The recovery window based retention policy works that way. İt will not delete that full backup in your case. In your situation, you need to have at least one more recent backup to make your full backup obsolete.

Please read oracle documentation. İt seems your understanding on rman retention policies, is not clear yet.

10 Tem 2016 14:19 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hi,

a full backup was taken on 30/06/2016. When I do report obsolete I see the backupset on 30/06/2016 listed among the obsolete backups. If I do delete obsolete and removes the full backup on 30/06/2016, will the recovery fail?

Thanks,
Roshan

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/RMAN-EM-tp1138p1140.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[ErmanArslansOracleBlog]

Update,: if it ll delete that backup, then it means you have a more recent full backup that satisfies the retention policy. Please read oracle documentation and get the idea.

10 Tem 2016 14:27 tarihinde "Erman Arslan" <[hidden email]> yazdı:

The recovery window based retention policy works that way. İt will not delete that full backup in your case. In your situation, you need to have at least one more recent backup to make your full backup obsolete.

Please read oracle documentation. İt seems your understanding on rman retention policies, is not clear yet.

10 Tem 2016 14:19 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hi,

a full backup was taken on 30/06/2016. When I do report obsolete I see the backupset on 30/06/2016 listed among the obsolete backups. If I do delete obsolete and removes the full backup on 30/06/2016, will the recovery fail?

Thanks,
Roshan

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/RMAN-EM-tp1138p1140.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML