Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help on deleting rman backups (delete everything on repository)

myluismOct 19 2015 — edited Oct 20 2015

Hi all.

I will soon be administering a few Oracle databases (11g Rel2). Currently these DBs area in archive log mode with a rman backup policy in place.


I don't like this policy and want to use my own, based on incremental updadateable backups, so, this is the plan i have in mind.


1) Disable archive mode.


2) Do a clean shutdown and take a cold backup.


3) Since after disabling archive, ALL RMAN backups will be unusable, i want to delete them (including archive logs and backup sets).


4) After proper deletion, configure some RMAN persitent parameters, like retention policy, controlfile autobackup and optimization on.


5) Enable archiving


6) Configure new backup policy based on incremental updateable backups with duplex location for archive logs.


Help is requested on best way to clean all backups (3).


I can manually delete backups and do a crosscheck, but according to Oracle Documentation "Delete Backup" will Delete all backups for this database recorded in the RMAN repository.


So, which is the best easiest and quickest way? Will delete backup include archive logs?


Thanks in advance. Luis!!!


This post has been answered by Dude! on Oct 19 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2015
Added on Oct 19 2015
17 comments
2,569 views