restore、recover到指定时间

最新推荐文章于 2022-11-15 19:56:27 发布

cjh81378066

最新推荐文章于 2022-11-15 19:56:27 发布

阅读量396

点赞数

文章标签：数据库

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博客 ” ，链接：http://blog.itpub.net/30126024/viewspace-2145111/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30126024/viewspace-2145111/