提问人:Tony92 提问时间:11/17/2023 最后编辑:Tony92 更新时间:11/18/2023 访问量:26
如何在给定时间点使用RMAN进行恢复?
How to recover with RMAN at a given point in time?
问:
我在 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
有人有想法吗?
谢谢!
答:
0赞
Duong
11/18/2023
#1
假设备份(controlfile 和 datafile)在删除表操作之前存在。然后:
- 首先:恢复控制文件
- 第二:使用时间点恢复还原数据库 然后打开数据库 Resetlogs
评论