Database Backup and Recovery (MOSC)

MOSC Banner

How to delete backup of control file

edited Aug 27, 2015 12:13AM in Database Backup and Recovery (MOSC) 12 commentsAnswered

Hi all,

I have assigned redundancy as 1 for my RMAN backup due to space issue.  But I want that the archivelogs should be deleted after two days or after getting backed up two times.

As the redundancy is set to 1, archive log deletion policy for two times will not work. I have used below script which is working fine-

run{

allocate channel ch1 type Disk maxpiecesize = 1024M;

crosscheck archivelog all;

delete noprompt archivelog until time 'SYSDATE-2';

release channel ch1;

}

But the problem is that, we are deleting the backup with 'delete noprompt backup of database' before the actual backup starts.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center