sql
alter session set container=pdb11;
drop user test cascade;
create user test identified by test default tablespace users;
grant FLASHBACK ANY TABLE to test;
grant dba to test;
exit
sqlplus test/test@pdb11
drop table tab1 purge;
create table tab1(col1 int);
ALTER TABLE test.tab1 ENABLE ROW MOVEMENT;
insert into tab1 values(1);
commit;
select * from tab1;
select current_scn from v$database;
insert into tab1 values(1);
commit;
select * from tab1;
FLASHBACK TABLE test.tab1
TO SCN 11807792;
select * from tab1;
フラッシュバックドロップ 元の名前で復元する場合
https://docs.oracle.com/cd/F19136_01/bradv/rman-performing-flashback-dbpitr.html#GUID-55EA5EB0-89E2-4561-A9D0-01A6242A2A87
show recyclebin;
drop table tab1;
show recyclebin;
flashback table tab1 to before drop;
フラッシュバックドロップ 名前を変更する場合
show recyclebin;
drop table tab1;
show recyclebin;
flashback table "BIN$LWY4AqQVRsbgY2+JqMBUPw==$0" to before drop rename to tab2;
desc tab2
フラッシュバックデータベース CDB
https://docs.oracle.com/cd/F19136_01/bradv/rman-performing-flashback-dbpitr.html#GUID-953FA30D-BED2-4DBA-8361-9DA1B8FF073F
show parameter reco
alter system set db_recovery_file_dest_size = 10G;
alter system set db_recovery_file_dest = '/home/oracle';
show parameter reco
select flashback_on from v$database;
alter database flashback on;
select flashback_on from v$database;
SELECT OLDEST_FLASHBACK_SCN, OLDEST_FLASHBACK_TIME
FROM V$FLASHBACK_DATABASE_LOG;
exit
rman target /
shutdown immediate;
startup mount;
FLASHBACK DATABASE TO SCN 11824024;
alter database open resetlogs;
exit
フラッシュバックデータベース PDB
https://docs.oracle.com/cd/F19136_01/bradv/rman-performing-flashback-dbpitr.html#GUID-C1215E86-9A7B-4EC9-9777-2A18BD627394
rman target /
SELECT OLDEST_FLASHBACK_SCN, OLDEST_FLASHBACK_TIME
FROM V$FLASHBACK_DATABASE_LOG;
ALTER PLUGGABLE DATABASE pdb11 CLOSE IMMEDIATE;
flashback pluggable database pdb11 TO SCN 11824024;
ALTER PLUGGABLE DATABASE pdb11 OPEN RESETLOGS;
exit
