We can restore the database to a specific point in time, for this purpose we turn off and then

Let’s start with the mount mode :

 

SHUTDOWN IMMEDIATE;

STARTUP MOUNT;

 

We give to whom we want to restore the base:

 

run{

set until time “to_timestamp (’12: 00: 00 01-09-2011 ‘,’ hh24-mi-ss dd-mm-yyyy ‘)”;

restore database;

recover database;

}

Then run the database, reset archivelogs:

 

ALTER DATABASE OPEN RESETLOGS;