Re: Purge RECYCLEBIN by *age*

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 19 Feb 2014 17:11:12 +0000
Message-ID: <CABe10sac0bP-ZseSPm8FgUiAAHt0ysD4q-tfMts4zTjTFayyMg_at_mail.gmail.com>

I too would be interested in this, I don't believe I have ever seen this happen.

On Wed, Feb 19, 2014 at 3:35 PM, Maris Elsins <elmaris_at_gmail.com> wrote:

> Hi,
>
> > That allows me to have the datafiles to not autoextend to a very large
> value - in a development environment.
>
> From the same document: "Oracle(R) Database Backup and Recovery Basics 10g
> Release 2 (10.2)"
> http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm#i1019426
>
>> For AUTO EXTEND-able tablespaces, objects are purged from the recycle bin
>> to reclaim space before datafiles are extended.
>
> Do you observe a different behavior in your environment? Which
> version/platform it is?
>
> ---
> Maris Elsins
> _at_MarisElsins <https://twitter.com/MarisElsins>
> www.facebook.com/maris.elsins
>
>
>
>
> On Wed, Feb 19, 2014 at 3:53 AM, Chitale, Hemant K <
> Hemant-K.Chitale_at_sc.com> wrote:
>
>> No, I cannot guarantee that an object will be available from the
>> recylcebin for a week. However, I can assure that no object will persist
>> in the recyclebin for more than a week. That allows me to have the
>> datafiles to not autoextend to a very large value - in a development
>> environment.
>>
>>
>>
>> Hemant K Chitale
>>
>>
>>
>>
>>
>> *From:* Niall Litchfield [mailto:niall.litchfield_at_gmail.com]
>> *Sent:* Tuesday, February 18, 2014 8:36 PM
>> *To:* elmaris_at_gmail.com
>> *Cc:* Chitale, Hemant K; ORACLE-L
>> *Subject:* Re: Purge RECYCLEBIN by *age*
>>
>>
>>
>> Maris
>>
>>
>>
>> I don't believe that to be *always* true, even in the form which I
>> suspect you meant (they will be purged automatically starting with the
>> oldest ones in the tablespace in which you require free space), AFAIK the
>> blocks involved are free to be reused as and when a space allocation
>> occurs, I don't believe there is any mechanism which prioritizes the extent
>> allocation by age.
>>
>>
>>
>> Hemant
>>
>>
>>
>> What are you hoping to achieve with this? A guarantee that an object can
>> be recovered for a week after it is dropped?
>>
>>
>>
>>
>>
>>
>>
>> On Tue, Feb 18, 2014 at 9:28 AM, Maris Elsins <elmaris_at_gmail.com> wrote:
>>
>> Hi,
>>
>>
>>
>> Why would you want to purge them?
>>
>> They will be purged automatically started with the oldest ones when free
>> space is needed.
>>
>>
>>
>> To answer the question, I think it's not possible unless you write a
>> script that queries the objects that you want to be purged from
>> dba_recyclebin and then purging them one by one.
>>
>>
>> ---
>>
>> Maris Elsins
>>
>> _at_MarisElsins <https://twitter.com/MarisElsins>
>>
>> www.facebook.com/maris.elsins
>>
>>
>>
>>
>>
>>
>>
>> On Tue, Feb 18, 2014 at 11:18 AM, Chitale, Hemant K <
>> Hemant-K.Chitale_at_sc.com> wrote:
>>
>> Is it possible to Purge the RECYCLEBIN by age ? --- e.g. remove those
>> objects that were DROPped 7 days ago. That way, a periodic cleanup of the
>> RECYCLEBIN can be done and yet objects may be available for recovery for 7
>> days.
>>
>> Hemant K Chitale
>>
>>
>> This email and any attachments are confidential and may also be
>> privileged. If you are not the intended recipient, please delete all copies
>> and notify the sender immediately. You may wish to refer to the
>> incorporation details of Standard Chartered PLC, Standard Chartered Bank
>> and their subsidiaries at
>> https://www.sc.com/en/incorporation-details.html.
>>
>>
>>
>>
>>
>>
>>
>> --
>> Niall Litchfield
>> Oracle DBA
>> http://www.orawin.info
>>
>> This email and any attachments are confidential and may also be
>> privileged. If you are not the intended recipient, please delete all copies
>> and notify the sender immediately. You may wish to refer to the
>> incorporation details of Standard Chartered PLC, Standard Chartered Bank
>> and their subsidiaries at
>> https://www.sc.com/en/incorporation-details.html.
>>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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

Received on Wed Feb 19 2014 - 18:11:12 CET