Re: Total Recall License - but out of compliance - what?

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Thu, 9 Apr 2015 12:57:47 -0500
Message-ID: <CAEueRAVYwNc36bUyCX5uxLsOCk1dKvNz+LxvU_=hP1M5Liqs5w_at_mail.gmail.com>

If you are running 11.2.0.2, it's an easy answer. You definitely need to have advanced compression to use FDA (Total Recall).

http://docs.oracle.com/cd/E11882_01/license.112/e47877/options.htm#DBLIC143

   -

   *Flashback Data Archive (formerly known as Total Recall)*

   *For releases earlier than Oracle Database 11g Release 2 (11.2.0.4): You    must license the Oracle Advanced Compression option to use Flashback Data    Archive.*

   *Beginning with Oracle Database 11g Release 2 (11.2.0.4): Flashback Data    Archive—without history table optimization—is available in all editions.*

Seth Miller

On Thu, Apr 9, 2015 at 12:51 PM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> Not sure what you mean about FDA optimized. I'd have to research that as
> I haven't done anything with FDA.
>
> No it was on an 11.2.0.2 db.
>
> Chris
>
>
> On Thu, Apr 9, 2015 at 12:41 PM, Seth Miller <sethmiller.sm_at_gmail.com>
> wrote:
>
>> Is that FDA optimized?
>>
>> Is this 11.2.0.4? (hint: the licensing requirements changed from 11.2.0.3
>> to 11.2.0.4)
>>
>> Seth Miller
>>
>> On Thu, Apr 9, 2015 at 12:27 PM, Chris Taylor <
>> christopherdtaylor1994_at_gmail.com> wrote:
>>
>>> Now I'm confused. We got dinged on this for an 11.2 database in the
>>> Advanced Compression checks:
>>>
>>>
>>> * Checking for "Flashback Data Archive (Total Recall)" feature usage
>>> FLASHBACK_ARCHIVE_NAME TABLESPACE_NAME
>>> QUOTA_IN_MB RETENTION_IN_DAYS CREATE_TIME LAST_PURGE_TIME
>>> STATUS
>>> ------------------------------ ------------------------------
>>> ------------ ----------------- --------------------- ---------------------
>>> --------
>>> ORION_FL_ARCHIVE ORION_FLASHBACK_ARCHIVE
>>> 90 2014-11-05_12:24:27
>>> 1 row selected.
>>> no rows selected
>>> *If any rows are returned then ADVANCED COMPRESSION OPTION is in use *
>>>
>>>
>>>
>>> On Thu, Apr 9, 2015 at 12:17 PM, Seth Miller <sethmiller.sm_at_gmail.com>
>>> wrote:
>>>
>>>> Chris,
>>>>
>>>> Total Recall is not part of Advanced Compression. The Total Recall
>>>> feature consisted in part of Flashback Data Archive (FDA). In Database 12c,
>>>> Total Recall is now called "Temporal" which includes "Temporal History" and
>>>> "Temporal Validity" and is an included feature. 12c continues to feature
>>>> FDA to support a number of the flashback technologies including a number of
>>>> new features.
>>>>
>>>> In 11g, the FDA's were "optimized" -- compressed with advanced
>>>> compression and deduplicated with SecureFiles. In 12c, this optimization is
>>>> optional and has to be explicitly defined. You also have the option of how
>>>> much and what kind of optimization (advanced row compression, advanced LOB
>>>> compression and ADO) you want to use per FDA. In order to use these, you
>>>> need to be licensed for advanced compression.
>>>>
>>>> Seth Miller
>>>>
>>>> On Thu, Apr 9, 2015 at 11:12 AM, Hans Forbrich <
>>>> fuzzy.graybeard_at_gmail.com> wrote:
>>>>
>>>>> You will need to discuss this with your purchasing department, who
>>>>> should have the original contract, and with Oracle, who need to provide the
>>>>> information about the exact date and terms under which the options were
>>>>> merged.
>>>>>
>>>>> In the past, Oracle would usually document the merge of options, would
>>>>> generally provide a 'restricted use' license of the surviving option, and
>>>>> would document which capabilities in the new license are included (and
>>>>> sometime which are NOT to be used) in the restricted use license.
>>>>>
>>>>> However, please verify that you are using only the original Total
>>>>> Recall and not the compressed version. The original became free. I'm not
>>>>> sure the compressed actually existed before being folded into Adv.
>>>>> Compression, but I have no proof either way.
>>>>>
>>>>> /Hans
>>>>>
>>>>>
>>>>> On 09/04/2015 6:37 AM, Chris Taylor wrote:
>>>>>
>>>>> Guys,
>>>>>
>>>>> I know this touches on a licensing discussion but my questions are a
>>>>> little different.
>>>>>
>>>>> We have 2 Total Recall Licenses:
>>>>> 1 - 8 Proc Full Use - expires 10/12/2015
>>>>> 1 - 200 Named User Plus full use - expires 10/12/2015
>>>>>
>>>>> However, Total Recall "went away" at some point and was rolled into
>>>>> Advanced Compression.
>>>>>
>>>>> Question #1:
>>>>> Does anyone know when Total Recall was no longer an option *outside *of
>>>>> Advanced Compression?
>>>>>
>>>>> Second part - we are getting dinged by Oracle for not having
>>>>> Advanced Compression licensed because we were using flashback data logs
>>>>> (Total Recall).
>>>>>
>>>>> Question #2:
>>>>> Anyone have any input on how we can have a support agreement for Total
>>>>> Recall (part of Advanced Compression) and not have Advanced Compression -
>>>>> thereby getting dinged on the audit for non-compliance?
>>>>>
>>>>> Regards,
>>>>> Chris Taylor
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 09 2015 - 19:57:47 CEST