How to Keep Oracle Archive Logs for 24 Hours Without “delete input” in RMAN Script?

Question

I have an Oracle 12.1 environment and need to keep the archive logs for 24 hours. I tried multiple configurations:

Subclients (Default and ArchiveLog): Tested with “Archive Delete” enabled and disabled.
Schedule: Tried “Delete Archive Log” with:
- Older than 1 day and Backed up 2 times.
- Also tested with these options disabled.

Results: The only change occurred when using Older than 1 day and Backed up 2 times, which added the following line:

delete noprompt archivelog until time = 'sysdate-1' backed up 2 times to sbt;

However, the line:

(archivelog all delete input);

remains in the script, and I don’t know how to remove it.

I will try a custom script, but I prefer a Commvault solution. During my research, I found a possible approach using three subclients:

Default: Full backup + archive logs without deleting.
Archivelogs: Hourly backups of archive logs without deleting.
DeleteArchive: Daily deletion of archive logs.

For now, this option is not possible because even with every delete flag disabled, the delete input line remains in the script.

J Victor · Accepted Answer

So my problem was solved.I want to add that the archivelog schedule did not have the “Custom RMAN Script” tab, only the full database schedule had this tab. And when we ran manually was good.As workaround we made a custom rman script on server and schedule on crontab, then deleted the archivelog schedule on Commvault.During support assistance we did create another schedule and IT WORKED!Even the “Custom RMAN Script” showed up.SOLUTION:Delete and create a new schedule.The first schedule was created with command center, the second schedule was created with comcell console.

CV_GK · Answer

Hi ​@J VictorWhat is the CV version on CS and Client?

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded