connect target /

--set dbid 2564640337;
shutdown immediate;
startup nomount;

run {
       set controlfile autobackup format for device type disk to '/dumps/XE/%F';
       restore spfile from autobackup maxdays=65;
}

run {
       set controlfile autobackup format for device type disk to '/dumps/XE/%F';
       restore controlfile from autobackup maxdays=65;
}

alter database mount;
reset database to incarnation 2;

catalog start with '/dumps/XE/';

run {
        set until time="to_date('Aug 15 2010 18:00:00', 'Mon DD YYYY HH24:MI:SS')";
        restore database;
        recover database;
}

alter database open resetlogs;
sql " create user tmh identified by tmh";
sql "grant dba to tmh";
