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;