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