SQL> show parameter BACKGROUND_DUMP_DEST;

NAME                     TYPE     VALUE

------------------------------------ ----------- ------------------------------

background_dump_dest             string     /u01/app/oracle/diag/rdbms/oracle01_oracle01/oracle01/trace

报错中出现：

ORA-: WARNING: db_recovery_file_dest_size of  bytes is 99.92% used, and has  

查看空间剩余：

SQL>  col file_type format A20;

SQL> set linesize  pagesize ;

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE         PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

-------------------- ------------------ ------------------------- ---------------

CONTROL FILE

REDO LOG

ARCHIVED LOG

BACKUP PIECE

IMAGE COPY

FLASHBACK LOG                17.58         7.81

FOREIGN ARCHIVED LOG                               

 rows selected.

空间

SQL>  select * from v$flashback_database_log ;

OLDEST_FLASHBACK_SCN OLDEST_FL RETENTION_TARGET FLASHBACK_SIZE ESTIMATED_FLASHBACK_SIZE

-------------------- --------- ---------------- -------------- ------------------------

         -JUL-                               

关闭闪回点

alter database flashback off;

再次启动数据库

SQL> alter database open;

假如还是报错：

alter database open

*

ERROR at line :

ORA-: This database instance failed to turn on flashback database

查看恢复检查点

select * from v$restore_point;

SCN DATABASE_INCARNATION# GUA STORAGE_SIZE TIME                                RESTORE_POINT_TIME        PRE NAME

---------- --------------------- --- ------------ ----------------------------------- ------------------------- --- --------------------

                         YES    -OCT- 02.41.43.000000000 AM                               YES MACLEAN_ROLLBACK

然后直接删除闪回点

SQL> drop restore point MACLEAN_ROLLBACK;