Re: Resource to rollback DDL and DML applied in database

  • From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
  • To: Sreejith Nair <sreejithsna@xxxxxxxxx>
  • Date: Sun, 5 Jul 2015 07:23:17 -0300

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@xxxxxxxxx>:

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@xxxxxxxxx>, wrote:

Enabling Flashback might be an option.

Ramniwas
On 5 Jul 2015 01:06, "Eriovaldo Andrietta" <ecandrietta@xxxxxxxxx> 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


Other related posts: