1_323_1013795224.dbf 100% 1024 1.0KB/s 00:00
1_324_1013795224.dbf 100% 3343KB 3.3MB/s 00:00
1_325_1013795224.dbf 100% 18KB 18.0KB/s 00:00
1_326_1013795224.dbf 100% 12KB 12.0KB/s 00:00
1_327_1013795224.dbf
把最近的归档传给目的地,然后告诉rman备份文件以及最近的归档在哪里:
RMAN> catalog start with '/data/backup/oracle';
具体恢复,基于时间的恢复,选择一个比较大的时间,就是肯定在备份时间之后的时间!
run {
set until time "to_date('2019-08-28 20:30:13','yyyy-mm-dd hh24:mi:ss')";
restore database;
recover database;
}
3.3打开数据库:
SQL> alter database open resetlogs;
Database altered.
发现最近的归档下已经应用了:发现1010101这条数据已经存在了,
SQL> select * from liuwenhe.test;
ID
----------
100
100
1
2
22
1010101
6 rows selected.
至此完成了增量备份的恢复!
RMAN不完全恢复的主要操作命令!
a、基于TIME 参数不完全恢复
run {
shutdown immediate;
startup mount;
set until time "to_date('2019-04-28 20:30:13','yyyy-mm-dd hh24:mi:ss')";
restore database;
recover database;
alter database open resetlogs;
}
b、基于SCN 参数不完全恢复
run {
shutdown immediate;
startup mount;
set until scn 3400;
restore database;
recover database;
alter database open resetlogs;
}
c、基于SEQUENCE 参数不完全恢复:
run {
shutdown immediate;
startup mount;
set until sequence 12903;
restore database;
recover database;
alter database open resetlogs;