12c及之前,我们可以通过flashback或TSPITR进行恢复,12c中可以在线恢复table .
Prior to recovering a table or table partition, you must perform a full backup of undo,
SYSTEM, SYSAUX, SYSEXT (if the SYSEXT tablespace exists in your database) and the tablespace
that contains the table or table partition.
这里我们对整个CDB及所有PDB进行备份 。
SQL> alter session set container=plugdb ;
Session altered.
SQL> select to_char(dbms_flashback.get_system_change_number) CURRENT_SCN, to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') CURRENT_TIME FROM DUAL;
CURRENT_SCN CURRENT_TIME
---------------------------------------- -------------------
12138230128883 2014-03-07 12:02:23
SQL> select count(1) from hw.HW_PAY_GROUP_LOG ;
COUNT(1)
----------
330458
备份CDB和所有PDBs :
rman target /
RMAN> backup incremental level 0 database format '/data01/tmp/fullbak2/backup_%d%T%s.bak' plus archivelog format '/data01/tmp/fullbak2/arc_%d%T%s.bak';
假设不小心删除掉了表中的多笔记录
SQL> alter session set container=plugdb ;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PLUGDB
SQL> select count(1) from hw.HW_PAY_GROUP_LOG ;
COUNT(1)
----------
330438
SQL>
查看12c目标数据库处于归档模式
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /data01/oracle12c/oradata/test12/arch
Oldest online log sequence 3
Next log sequence to archive 5
Current log sequence 5
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/35489/viewspace-1107183/ ,如需转载,请注明出处,否则将追究法律责任。