ORA-38760: This database instance failed to turn on flashback database - shanxia

SQL> startup
ORACLE instance started.

SQL> alter database flashback off;

Database altered.

SQL> alter database open;

Database altered.

SQL> set linesize 10000;
SQL> select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
--------------- ---------------- ---------------------------------------------------------------- ----------------- ------------ ------------ --- ---------- ------- --------------- ---------- --- ----------------- ------------------ --------- ---
2 gpnmsdb2 gpnms92 11.2.0.4.0 21-SEP-21 OPEN YES 2 STARTED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1570009088 bytes
Fixed Size 2281592 bytes
Variable Size 637538184 bytes
Database Buffers 922746880 bytes
Redo Buffers 7442432 bytes
Database mounted.
SQL>
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

C:\Users\Administrator>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 21 16:18:27 2021

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38706: 无法启用 FLASHBACK DATABASE 事件记录。
ORA-38708: 没有足够的空间可用于第一个闪回数据库日志文件

SQL> alter system set db_recovery_file_dest="+dgrecovery";

System altered.

SQL> show parameter db_recovery;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +dgrecovery
db_recovery_file_dest_size big integer 500M
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38706: 无法启用 FLASHBACK DATABASE 事件记录。
ORA-38708: 没有足够的空间可用于第一个闪回数据库日志文件

SQL> select log_mode,open_mode,flashback_on from v$database;

LOG_MODE OPEN_MODE FLASHBACK_ON
------------ -------------------- ------------------
ARCHIVELOG MOUNTED NO

在节点1 执行：重新设置db_recovery_file_dest_size 增大空间，问题解决：

SQL> alter system set db_recovery_file_dest_size=1g;

System altered.

SQL> alter database flashback on;

Database altered.

SQL> show parameter db_recovery;

Database altered.

SQL> set linesize 10000;
SQL> select * from v$instance;

SQL>

发表于 2021-09-21 16:55 shanxia 阅读(271) 评论(0) 编辑收藏举报