oracle rman恢復到時間點

1. SQLPlus中確保數(shù)據(jù)庫在歸檔模式,RMAN中備份數(shù)據(jù)庫

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創(chuàng)建測試表,插入數(shù)據(jù)并刪除測試表

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數(shù)據(jù)庫使用RMAN備份,需要把數(shù)據(jù)庫的非歸檔模式改成歸檔模式:

2.restore時數(shù)據(jù)庫需要在mount狀態(tài)下

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數(shù)據(jù)庫的備份與恢復

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