run{
restore database UNTIL TIME "TO_DATE('2016-02-03 11:00:00','YYYY-MM-DD hh24:mi:ss')";
recover database UNTIL TIME "TO_DATE('2016-02-03 11:00:00','YYYY-MM-DD hh24:mi:ss')";
alter database open resetlogs;
}

run{
set UNTIL TIME "TO_DATE('2016-02-03 11:00:00','YYYY-MM-DD hh24:mi:ss')";
restore database;
recover database;
alter database open resetlogs;
}

run{
set UNTIL TIME "TO_DATE('2016-02-03 11:00:00','YYYY-MM-DD hh24:mi:ss')";

SET NEWNAME FOR DATAFILE 1 to '/u01/app/oracle/oradata/system01.dbf';
SET NEWNAME FOR DATAFILE 2 to '/u01/app/oracle/oradata/sysaux01.dbf';
SET NEWNAME FOR DATAFILE 3 to '/u01/app/oracle/oradata/undotbs01.dbf';
SET NEWNAME FOR DATAFILE 4 to '/u01/app/oracle/oradata/users01.dbf';
SET NEWNAME FOR DATAFILE 5 to '/u01/app/oracle/oradata/blobs01.dbf';

SET NEWNAME FOR TEMPFILE 1 to '/u01/app/oracle/oradata/temp01.dbf';

restore database;

SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;

recover database;

alter database open resetlogs;
}

ITPub博客

restore、recover到指定时间

最新文章