ORA-38765: Flashed back database cannot be opened read-only. ORACLE 报错 故障修复 远程处理

文档解释

ORA-38765: Flashed back database cannot be opened read-only.

Cause: A complete recovery was performed after a database flashback but the database was not opened for read-write access, or a FLASHBACK DATABASE command failed.

Action: If a complete recovery was performed after a database flashback, open the database for read-write access. If a FLASHBACK DATABASE command failed, fix what caused the command to fail and retry the command, or recover and open the database for read-write access.

这个Oracle数据库错误信息 ORA-38765: “Flashed back database cannot be opened read-only” 表明，当您试图将flashback database以只读模式打开时发生了一个错误。

官方解释

常见案例

一般处理方法及步骤

（1）关掉警告： ALTER SYSTEM SET flashback_debug=’NOLOGGING’ SCOPE=SPFILE;

（2）检查Flashback log配置：SELECT Status, Flashback_Log_files FROM v$flashback_database_log;

（3）确保恢复文件路径(rman)：RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

（4）确保对应参数有效：_flashback_database_rollback_segments &_flashback_database_guarantee_timestamp &_flashback_database_high_recovery_availability;

（5）确保目录存在：ALTER DATABASE CREATE DATAFILE;

（6）检查所有文件：SELECT Log_mode, open_mode FROM V$DATABASE;

（7）尝试重新开启数据库：ALTER DATABASE OPEN READ WRITE;

（8）检查 Flashback 日志空间：SELECT * FROM V$FLASHBACK_DATABASE_LOG;

（9）打开一个新的数据库：ALTER DATABASE OPEN;

（10）启动 Flashback Database 功能：ALTER DATABASE FLASHBACK ON;