CON_ID NAME OPEN_MODE
—— ——— ———-
2 PDB$SEED READ ONLY
3 SALESPDB READ WRITE
4 HRPDB READ WRITE
5 APP_ROOT READ WRITE
6 APP_PDB1 READ WRITE

# 切换到CDB
SQL> ALTER SESSION SET CONTAINER = cdb$root;

Session altered.

# 查看闪回恢复区配置
SQL> SHOW PARAMETER db_recovery_file_dest;

NAME TYPE VALUE
———————————— ———– ——————————
db_recovery_file_dest string /oracle/app/oracle/fast_recovery_area
db_recovery_file_dest_size big integer 10G

SQL> SHOW PARAMETER db_flashback_retention_target;

NAME TYPE VALUE
———————————— ———– ——————————
db_flashback_retention_target integer 1440

# 配置闪回恢复区
SQL> ALTER SYSTEM SET db_recovery_file_dest = ‘/oracle/app/oracle/fast_recovery_area’ SCOPE = BOTH;

System altered.

SQL> ALTER SYSTEM SET db_recovery_file_dest_size = 20G SCOPE = BOTH;

System altered.

SQL> ALTER SYSTEM SET db_flashback_retention_target = 2880 SCOPE = BOTH;

System altered.

# 验证闪回恢复区配置
SQL> SHOW PARAMETER db_recovery_file_dest;

NAME TYPE VALUE
———————————— ———– ——————————
db_recovery_file_dest string /oracle/app/oracle/fast_recovery_area
db_recovery_file_dest_size big integer 20G

SQL> SHOW PARAMETER db_flashback_retention_target;

NAME TYPE VALUE
———————————— ———– ——————————
db_flashback_retention_target integer 2880

# 验证闪回恢复区配置成功

Session altered.

# 查看闪回数据库状态
SQL> SELECT flashback_on FROM v$database;

FLASHBACK_ON
——————
NO

# 配置归档模式
SQL> SHUTDOWN IMMEDIATE;

Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> STARTUP MOUNT;

ORACLE instance started.

Total System Global Area 838860800 bytes
Fixed Size 9140416 bytes
Variable Size 503316480 bytes
Database Buffers 318767104 bytes
Redo Buffers 7737600 bytes
Database mounted.

SQL> ALTER DATABASE ARCHIVELOG;

Database altered.

SQL> ALTER DATABASE OPEN;

Database altered.

SQL> ARCHIVE LOG LIST;

Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2

# 启用闪回数据库
SQL> ALTER DATABASE FLASHBACK ON;

Database altered.

# 验证闪回数据库状态
SQL> SELECT flashback_on FROM v$database;

FLASHBACK_ON
——————
YES

# 验证闪回数据库启用成功

Session altered.

# 查看PDB闪回状态
SQL> SELECT con_id, name, open_mode, flashback_on FROM v$pdbs ORDER BY con_id;

CON_ID NAME OPEN_MODE FLASHBACK_ON
—— ——— ————– ————–
2 PDB$SEED READ ONLY NO
3 SALESPDB READ WRITE YES
4 HRPDB READ WRITE YES
5 APP_ROOT READ WRITE YES
6 APP_PDB1 READ WRITE YES

# 创建测试表
SQL> CREATE TABLE test_flashback (
id NUMBER,
name VARCHAR2(100),
created_date DATE DEFAULT SYSDATE
);

Table created.

SQL> INSERT INTO test_flashback (id, name) VALUES (1, ‘Test 1’);

1 row created.

SQL> INSERT INTO test_flashback (id, name) VALUES (2, ‘Test 2’);

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SELECT * FROM test_flashback;

ID NAME CREATED_DATE
———- ———– ————-
1 Test 1 31-MAR-26
2 Test 2 31-MAR-26

# 记录当前时间
SQL> SELECT TO_CHAR(SYSDATE, ‘YYYY-MM-DD HH24:MI:SS’) AS current_time FROM dual;

CURRENT_TIME
——————-
2026-03-31 10:00:00

# 删除数据
SQL> DELETE FROM test_flashback WHERE id = 1;

1 row deleted.

SQL> COMMIT;

Commit complete.

SQL> SELECT * FROM test_flashback;

ID NAME CREATED_DATE
———- ———– ————-
2 Test 2 31-MAR-26

# 验证PDB闪回配置成功

Session altered.

# 关闭PDB
SQL> ALTER PLUGGABLE DATABASE fgfgfgsalespdb CLOSE;

Pluggable database altered.

SQL> SELECT con_id, name, open_mode FROM v$pdbs ORDER BY con_id;

CON_ID NAME OPEN_MODE
—— ——— ———-
2 PDB$SEED READ ONLY
3 SALESPDB MOUNTED
4 HRPDB READ WRITE
5 APP_ROOT READ WRITE
6 APP_PDB1 READ WRITE

# 闪回PDB到指定时间点
SQL> ALTER PLUGGABLE DATABASE fgfgfgsalespdb FLASHBACK TO TIMESTAMP TO_TIMESTAMP(‘2026-03-31 10:00:00’, ‘YYYY-MM-DD HH24:MI:SS’);

Pluggable database altered.

# 打开PDB
SQL> ALTER PLUGGABLE DATABASE fgfgfgsalespdb OPEN;

Pluggable database altered.

SQL> SELECT con_id, name, open_mode FROM v$pdbs ORDER BY con_id;

CON_ID NAME OPEN_MODE
—— ——— ———-
2 PDB$SEED READ ONLY
3 SALESPDB READ WRITE
4 HRPDB READ WRITE
5 APP_ROOT READ WRITE
6 APP_PDB1 READ WRITE

# 验证数据恢复
SQL> SELECT * FROM test_flashback;

ID NAME CREATED_DATE
———- ———– ————-
1 Test 1 31-MAR-26
2 Test 2 31-MAR-26

# 验证PDB闪回成功

Session altered.

# 查看闪回数据库状态
SQL> SELECT flashback_on FROM v$database;

FLASHBACK_ON
——————
YES

# 查看闪回恢复区使用情况
SQL> SELECT name,
space_limit/1024/1024/1024 AS space_limit_gb,
space_used/1024/1024/1024 AS space_used_gb,
space_reclaimable/1024/1024/1024 AS space_reclaimable_gb,
number_of_files
FROM v$recovery_file_dest;

NAME SPACE_LIMIT_GB SPACE_USED_GB SPACE_RECLAIMABLE_GB NUMBER_OF_FILES
———————————— ————- ————– ——————– —————
/oracle/app/oracle/fast_recovery_area 20.00 2.50 0.50 150

# 查看闪回日志
SQL> SELECT name,
bytes/1024/1024/1024 AS size_gb,
first_change#,
next_change#,
threads
FROM v$flashback_database_logfile
ORDER BY first_change# DESC
FETCH FIRST 5 ROWS ONLY;

NAME SIZE_GB FIRST_CHANGE# NEXT_CHANGE# THREADS
——————————————————- ———- ————- ———— ———-
/oracle/app/oracle/fast_recovery_area/ORCLCDB/flashback/o1_mf_ 0.50 1234567 1234568 1
/oracle/app/oracle/fast_recovery_area/ORCLCDB/flashback/o1_mf_ 0.50 1234566 1234567 1
/oracle/app/oracle/fast_recovery_area/ORCLCDB/flashback/o1_mf_ 0.50 1234565 1234566 1
/oracle/app/oracle/fast_recovery_area/ORCLCDB/flashback/o1_mf_ 0.50 1234564 1234565 1
/oracle/app/oracle/fast_recovery_area/ORCLCDB/flashback/o1_mf_ 0.50 1234563 1234564 1

# 验证PDB闪回状态成功

Session altered.

# 创建测试表
SQL> CREATE TABLE test_verify (
id NUMBER,
name VARCHAR2(100),
created_date DATE DEFAULT SYSDATE
);

Table created.

SQL> INSERT INTO test_verify (id, name) VALUES (1, ‘Verify 1’);

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SELECT * FROM test_verify;

ID NAME CREATED_DATE
———- ———– ————-
1 Verify 1 31-MAR-26

# 记录SCN
SQL> SELECT current_scn FROM v$database;

CURRENT_SCN
———–
12345678

# 删除数据
SQL> DELETE FROM test_verify WHERE id = 1;

1 row deleted.

SQL> COMMIT;

Commit complete.

SQL> SELECT * FROM test_verify;

no rows selected

# 闪回表到指定SCN
SQL> FLASHBACK TABLE test_verify TO SCN 12345678;

Flashback complete.

SQL> SELECT * FROM test_verify;

ID NAME CREATED_DATE
———- ———– ————-
1 Verify 1 31-MAR-26

# 验证PDB闪回功能成功