文档解释
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;
