{16 追加}PDBのフラッシュバックデータベース

 

https://docs.oracle.com/cd/F19136_01/bradv/rman-performing-flashback-dbpitr.html#GUID-C1215E86-9A7B-4EC9-9777-2A18BD627394

sql

SELECT * FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME='LOCAL_UNDO_ENABLED';

select flashback_on from v$database;
alter database flashback on;
select flashback_on from v$database;

alter session set container=pdb11;
alter session set container=pdb21;

insert into tab1 values(1);
commit;
select * from tab1;

select sysdate from dual;

exit

 

     ローカルUNDOの場合

 

rman target /

alter pluggable database pdb11 close immediate;
select * from v$pdbs;

flashback pluggable database pdb11 to time "to_date('2025/02/27 17:21:58','YYYY/MM/DD HH24:MI:SS')";

alter pluggable database pdb11 open RESETLOGS;
select * from v$pdbs;

exit

 

     共有UNDOの場合

※ OMFの場合、AUXILIARY DESTINATION句を指定すると下記エラー
ORA-01261: Parameter db_create_file_dest destination string cannot be translated

※ RMANバックアップ必要

rman target /

alter pluggable database pdb21 close immediate;
select * from v$pdbs;

flashback pluggable database pdb21 to time "to_date('2025/02/27 18:10:33','YYYY/MM/DD HH24:MI:SS')";

alter pluggable database pdb21 open RESETLOGS;
select * from v$pdbs;

exit