资讯教程

oracle rman恢复到时间点

1. SQLPlus中确保数据库在归档模式,RMAN中备份数据库

su oracle

sqlplus / as sysdba

SQL> archive log list;

SQL> exit

su

rman target sys/sys@ORCLCDB

RMAN> show controlfile autobackup;

RMAN> BACKUP DATABASE;

RMAN> exit

2. SQLPlus创建测试表,插入数据并删除测试表

su oracle

sqlplus / as sysdba

SQL> SET TIME ON;

20:07:11 SQL> CREATE TABLE test(id NUMBER(2),name VARCHAR(20));

20:07:28 SQL> INSERT INTO test VALUES(1,'justdb');

20:07:39 SQL> COMMIT;

20:07:46 SQL> SELECT * FROM test;

20:07:53 SQL> DROP TABLE test PURGE;

20:08:00 SQL> SHUTDOWN IMMEDIATE;

20:08:35 SQL> STARTUP MOUNT;

20:08:43 SQL> exit

3. RMAN恢复到时间点

su

rman target sys/sys@ORCLCDB

RMAN> LIST INCARNATION;

RMAN> RUN {

SET UNTIL TIME "to_date('2021-10-18 20:07:53','yyyy-mm-dd hh24:mi:ss')";

RESTORE DATABASE;

RECOVER DATABASE;

}

RMAN> ALTER DATABASE OPEN RESETLOGS;

RMAN> SELECT * FROM test;

注意:

1.Oracle数据库使用RMAN备份,需要把数据库的非归档模式改成归档模式:

2.restore时数据库需要在mount状态下

RMAN备份与恢复之基于时间点的不完全恢复

https://www.linuxidc.com/Linux/2014-01/95336.htm

Oracle 12cR2 RMAN 新特性：直到可用重做

https://blog.toadworld.com/2017/06/02/oracle-12cr2-rman-new-feature-until-available-redo

Oracle数据库的备份与恢复

https://www.toutiao.com/i6974332477255172644

Oracle Database 19c : Install from RPM Package https://www.server-world.info/en/note?os=CentOS_7&p=oracle19c&f=6

Oracle sql教程

https://www.yiibai.com/oracle