SQL> startup
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.
ORA-38760: This database instance failed to turn on flashback database
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
Copyright (c) 1982, 2013, Oracle. All rights reserved.
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> 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> 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
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: 没有足够的空间可用于第一个闪回数据库日志文件
在节点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;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +dgrecovery
db_recovery_file_dest_size big integer 1G
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>