oracle 恢复到之前某个时间点

来源:互联网 发布:嵌入式linux启动 编辑:程序博客网 时间:2024/05/17 06:35

--查看备份片的 (TAG20160413T030004)


RMAN>list backupset;

SQL>shutdown immediate;

SQL>startup mount;

RMAN>restore database from tag TAG20160413T030004;

SQL>recover database until time '2016-04-13 08:00:00' using backup controlfile;

SQL>alter database open resetlogs;
1 0
原创粉丝点击