01,ORA-38760: This database instance failed to turn on flashback
02,问题处理思路
第一步:查看日志文件
查看这次启动的时候alter日志对其的描述,查看报错信息
日志文件地址:
SQL> show parameter BACKGROUND_DUMP_DEST; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ background_dump_dest string /u01/app/oracle/diag/rdbms/oracle01_oracle01/oracle01/trace
可能:空间不足出现的闪回去问题
报错中出现: ORA-19815: WARNING: db_recovery_file_dest_size of 4039114752 bytes is 99.92% used, and has 3282432
查看空间剩余: SQL> col file_type format A20; SQL> set linesize 120 pagesize 100; SQL> select * from v$flash_recovery_area_usage; FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES -------------------- ------------------ ------------------------- --------------- CONTROL FILE 0 0 0 REDO LOG 0 0 0 ARCHIVED LOG 0 0 0 BACKUP PIECE 0 0 0 IMAGE COPY 0 0 0 FLASHBACK LOG 17.58 7.81 18 FOREIGN ARCHIVED LOG 0 0 0 7 rows selected.
空间 SQL> select * from v$flashback_database_log ; OLDEST_FLASHBACK_SCN OLDEST_FL RETENTION_TARGET FLASHBACK_SIZE ESTIMATED_FLASHBACK_SIZE -------------------- --------- ---------------- -------------- ------------------------ 21263778 05-JUL-19 2880 943718400 421134336
当 PERCENT_SPACE_RECLAIMABL 和 ESTIMATED_FLASHBACK_SIZE 为零就不足啦
解决方法:
关闭闪回点 alter database flashback off; 再次启动数据库 SQL> alter database open; 假如还是报错: alter database open * ERROR at line 1: ORA-38760: 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 ---------- --------------------- --- ------------ ----------------------------------- ------------------------- --- -------------------- 1187867 2 YES 3056812032 04-OCT-14 02.41.43.000000000 AM YES MACLEAN_ROLLBACK 然后直接删除闪回点 SQL> drop restore point MACLEAN_ROLLBACK;
01,ORA-38760: This database instance failed to turn on flashback
01,ORA-38760:此数据库实例无法启用闪回