Re: Resource to rollback DDL and DML applied in database

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sun, 5 Jul 2015 07:23:17 -0300
Message-ID: <CAJdDhaONCXrNCVEKd6CjUrM-6yUUFJf1b_h=0=eWLc6RmugS+w_at_mail.gmail.com>

Thanks for answers.
I got the message.
Flashback database is an option.I will take a look at this resource and see if it will solve.

Regards
Eriovaldo

2015-07-05 2:37 GMT-03:00 Sreejith Nair <sreejithsna_at_gmail.com>:

> Hi
>
> You can enable flashback and create guaranteed restore points before the
> changes are made to the database. Restore to this restore point when you
> wish to rollback and it is very fast.
>
>
> Regards
> Sreejith
>
> Sent from my iPhone
>
> On 5 Jul 2015 1:12 AM +0530, Ramnivas Chaurasia <
> ramnivaschaurasia_at_gmail.com>, wrote:
>
> Enabling Flashback might be an option.
>
> Ramniwas
> On 5 Jul 2015 01:06, "Eriovaldo Andrietta" <ecandrietta_at_gmail.com> wrote:
>
>> Hello guys.
>>
>> I am looking for a way to be able to rollback Changes.
>> This rollback must occur in short time a client offered by the window.
>> Let us imagine that the window is not enough to restore backup base via
>> IMP or via RMAN or recover datafile method.
>>
>> The solution I'm looking for is to undo the DDL and DML operations
>> applied on the base.
>>
>> I know that I can develop the rollback for each DDL and DML script.
>>
>> I would like to know if there is a feature in Oracle that does this,
>> fastly.
>>
>> UNDO via recyblebin ?????
>>
>> Thanks
>> Eriovaldo
>>
>

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

Received on Sun Jul 05 2015 - 12:23:17 CEST