cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Intelligent Policy archive logs deletion

rafanto
Level 5

Hello,

Please provide your support with this issue, we have configured an Oracle Intelligent Policy, with the option to delete the archive logs after 2 successful backups, but it is not doing so, reviewing the log, it is asking a question, but it is not supposed to Should OIPs automate these tasks?

May 20, 2024 8:33:36 AM - Info bphdb (pid=141569) INF - 1257398 2 3598 A 20-MAY-24
May 20, 2024 8:33:36 AM - Info bphdb (pid=141569) INF - Name: +RECOC1/ORACDB/ARCHIVELOG/2024_05_20/thread_2_seq_3598.926.1169447433
May 20, 2024 8:33:36 AM - Info bphdb (pid=141569) INF - Do you really want to delete the above objects (enter YES or NO)?
May 20, 2024 8:33:36 AM - Info bphdb (pid=141569) INF - Do you really want to delete the above objects (enter YES or NO)?
May 20, 2024 8:33:36 AM - Info bphdb (pid=141569) INF - Error occurred getting response - assuming NO response
May 20, 2024 8:33:38 AM - Info bphdb (pid=141569) INF - released channel: ch00
May 20, 2024 8:33:38 AM - Info bphdb (pid=141569) INF - released channel: ch01
May 20, 2024 8:33:38 AM - Info bphdb (pid=141569) INF - allocated channel: ch00

6 REPLIES 6

Nicolai
Moderator
Moderator
Partner    VIP   

This looks wrong - I would open a support ticket with Veritas.

DPeaco
Moderator
Moderator
   VIP   

I agree with @Nicolai 

I've never seen that response in ANY NBU log file before. I'd be interested in knowing what support says about this and what the solution was.

Thanks,
Dennis

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

its for the support, but Oracle's not Veritas. RMAN command BACKUP ARCHIVELOG DELETE INPUT , which is generated by OIP, should not ask for confirmation.

Regards

M.

Will_Hunting
Level 4

It's a bug, the rman statements miss the keyword "noprompt ". 

The correct statements should like this:

delete noprompt archivelog all completed before 'sysdate-1/6';

jandersen1
Level 4
Partner Accredited

Any updates on this one?
I have the exact same problem in a NetBackup 10.2.0.1 Oracle installation.
Would be nice with a case number, I can refer to.
--jakob;

jandersen1
Level 4
Partner Accredited

An pretty weird that the RMAN behavior is to be prompted when you try to delete after two copies, but not after one copy. Nifty little "feature" :)