ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled ORACLE 报错 故障修复 远程处理

文档解释

ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled

Cause: A CREATE TABLE or CREATE INDEX statement specified RECOVERABLE when the database was running in NOARCHIVELOG mode. Since logs are not being archived, they will be overwritten and the object being created cannot be recovered from a backup taken before the object was created.

Action: Do not specify RECOVERABLE, or restart the database with media recovery enabled.

Oracle报错ORA-01784：RECOVERABLE不能在数据库媒体恢复被禁用时指定。

官方解释

常见案例

RESTORE DATABASE RECOVERABLE;

正常处理方法及步骤

参数 旧值 新值

db_recovery_file_dest_size 0M n/a

fast_start_mttr_target 0 n/a

db_recovery_file_dest None teradata

db_recovery_file_dest_size 0M 1G

db_recovery_file_dest_size_mb 0 1024

db_fast_recovery_file_dest None teradata

SQL> alter system set db_recovery_file_dest=’teradata’;

SQL> alter system set db_recovery_file_dest_size=1G;

SQL> alter system set db_recovery_file_dest_size_mb=1024;

SQL> alter system set fast_start_mttr_target=200;

然后重启服务器。现在您可以运行以下命令来恢复数据库：

RESTORE DATABASE RECOVERABLE;