如何在给定时间点使用RMAN进行恢复?

How to recover with RMAN at a given point in time?

提问人:Tony92 提问时间:11/17/2023 最后编辑:Tony92 更新时间:11/18/2023 访问量:26

问:


我在 Oracle 12c 数据库上使用 RMAN 执行备份。
我正在尝试恢复在 2023 年 11 月 17 日 09:44 删除的表,但在应用命令

时收到错误消息 以下是我使用的过程:
alter database open resetlogs;

$ rman target=/ 
RMAN> shutdown immediate;
RMAN> startup mount;
RMAN> run {
set until time "to_date('17/11/2023 09:40:00', 'DD/MM/YYYY HH24:MI:SS')";
restore database;
recover database;
}


打开数据库并重置日志

RMAN> alter database open resetlogs; 

Oracle 错误消息如下:

RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 11/17/2023 09:55:53
ORA-03113: end-of-file on communication channel
Process ID: 116719
Session ID: 1339 Serial number: 7632
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-03114: not connected to ORACLE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 11/17/2023 09:55:53
ORA-03113: end-of-file on communication channel
Process ID: 116719
Session ID: 1339 Serial number: 7632

有人有想法吗?

谢谢!

恢复 恢复 RMAN

评论


答:

0赞 Duong 11/18/2023 #1

假设备份(controlfile 和 datafile)在删除表操作之前存在。然后:

  • 首先:恢复控制文件
  • 第二:使用时间点恢复还原数据库 然后打开数据库 Resetlogs