Host-based backup of VMware vSphere VMs.
Post Reply
yihwang
Influencer
Posts: 13
Liked: 1 time
Joined: Aug 23, 2017 8:57 am
Full Name: Yeongil Hwang
Contact:

Oracle Archive log did not delete(hidden log files)

Post by yihwang »

Hello,
My customer uses Veeam server to backup windows oracle(11gr2) VM. The number of databases in the oracle vm is two.
Backup job was set with application-aware and archive logs over 15 GB option was set.
But, archive logs did not deleted even though the partition of the log was almost full(50GB).

So, I opened support case.
After remote session, Veeam Support told me that there are around 1,000 archived logs file in the partition.
But, in veeam logs, Veeam Found only around 400 archived logs by executing query.
The query is below.
Exec oracle query: SELECT FIRST_CHANGE#, BLOCK_SIZE, RECID, STAMP, NAME, THREAD#, SEQUENCE#, RESETLOGS_CHANGE#, BLOCKS*BLOCK_SIZE, TO_CHAR(SYS_EXTRACT_UTC(CAST(FIRST_TIME AS TIMESTAMP)), 'yyyy/mm/dd hh24:mi:ss'), TO_CHAR(SYS_EXTRACT_UTC(CAST(NEXT_TIME AS TIMESTAMP)), 'yyyy/mm/dd hh24:mi:ss') FROM V$ARCHIVED_LOG WHERE STATUS != 'D' AND CREATOR != 'LGWR'
Has anyone experienced this hidden archived log files?
HannesK
Product Manager
Posts: 14287
Liked: 2877 times
Joined: Sep 01, 2014 11:46 am
Full Name: Hannes Kasparick
Location: Austria
Contact:

Re: Oracle Archive log did not delete(hidden log files)

Post by HannesK »

Hello,
could you add the support case number here that we can have a closer look?

Thanks,
Hannes
yihwang
Influencer
Posts: 13
Liked: 1 time
Joined: Aug 23, 2017 8:57 am
Full Name: Yeongil Hwang
Contact:

Re: Oracle Archive log did not delete(hidden log files)

Post by yihwang »

Hello.

Case Number is 03311604.

Thanks
yihwang
Influencer
Posts: 13
Liked: 1 time
Joined: Aug 23, 2017 8:57 am
Full Name: Yeongil Hwang
Contact:

Re: Oracle Archive log did not delete(hidden log files)

Post by yihwang »

Hello.

I saw the release notes and what's new for veeam update 4.
In the What's new, I saw the contents related to the oracle redo logs as below.

Oracle redo logs backup retention policy will now analyze the logs being removed in order to preserve Guaranteed Restore Points
(part of Oracle Flashback feature).

Is the above patch relevant to my issue?

Thanks in advances,
Gostev
Chief Product Officer
Posts: 31460
Liked: 6648 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Oracle Archive log did not delete(hidden log files)

Post by Gostev »

No, not really... completely unrelated.
yihwang
Influencer
Posts: 13
Liked: 1 time
Joined: Aug 23, 2017 8:57 am
Full Name: Yeongil Hwang
Contact:

Re: Oracle Archive log did not delete(hidden log files)

Post by yihwang »

Hello HannesK,

Is any update for this issue more?

Thanks,
Young
HannesK
Product Manager
Posts: 14287
Liked: 2877 times
Joined: Sep 01, 2014 11:46 am
Full Name: Hannes Kasparick
Location: Austria
Contact:

Re: Oracle Archive log did not delete(hidden log files)

Post by HannesK »

Hello Young,
I followed the case and support was waiting for an answer from your side. Maybe something was lost in translation.

The U4 feature you mention is only relevant if you are using Oracle Flashback.

Upgrading to U4 is probably a good idea anyway as there were many other bug-fixes which are not mentioned in the "what's new" document.

Best regards,
Hannes
Post Reply

Who is online

Users browsing this forum: No registered users and 102 guests