[#Trouble Shooting] ORA-38760

1.Error : 

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

SQL> 
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup pfile=$ORACLE_HOME/dbs/initcdb1.ora
ORACLE instance started.

Total System Global Area  629145392 bytes
Fixed Size                  9137968 bytes
Variable Size             406847488 bytes
Database Buffers          197132288 bytes
Redo Buffers               16027648 bytes
Database mounted.
ORA-38760: This database instance failed to turn on flashback database


SQL>

2.Bug fix Solution:

SQL> 
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> 
SQL> STARTUP NOMOUNT;
ORACLE instance started.

Total System Global Area  629145392 bytes
Fixed Size                  9137968 bytes
Variable Size             419430400 bytes
Database Buffers          184549376 bytes
Redo Buffers               16027648 bytes
SQL> ALTER DATABASE MOUNT;

Database altered.

SQL> SELECT STATUS FROM V$INSTANCE;

STATUS
------------------------------------
MOUNTED

SQL> select name,open_mode from v$database;

NAME
---------------------------
OPEN_MODE
------------------------------------------------------------
CDB1
MOUNTED


SQL> select name,flashback_on from v$database;

NAME
---------------------------
FLASHBACK_ON
------------------------------------------------------
CDB1
YES


SQL> select name,open_mode from v$database;

NAME
---------------------------
OPEN_MODE
------------------------------------------------------------
CDB1
MOUNTED


SQL> alter database flashback off;

Database altered.

SQL> alter database open;

Database altered.

SQL> select name,flashback_on from v$database;

NAME
---------------------------
FLASHBACK_ON
------------------------------------------------------
CDB1
NO


SQL> 

3. Test it

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> 
SQL> startup pfile=$ORACLE_HOME/dbs/initcdb1.ora
ORACLE instance started.

Total System Global Area  629145392 bytes
Fixed Size                  9137968 bytes
Variable Size             406847488 bytes
Database Buffers          197132288 bytes
Redo Buffers               16027648 bytes
Database mounted.
Database opened.
SQL>

注意：

======================================================================

在Oracle数据库中，可以通过以下步骤将数据库切换到mounted模式下：

1. 连接到数据库实例，使用SYSDBA权限登录。

2. 执行以下命令将数据库关闭：

SHUTDOWN IMMEDIATE;

    3.执行以下命令将数据库启动到nomount模式：

STARTUP NOMOUNT;

   4.执行以下命令将数据库挂载到mounted模式：

ALTER DATABASE MOUNT;

   5.确认数据库已经成功挂载到mounted模式：

SELECT STATUS FROM V$INSTANCE;

如果返回的结果为"MOUNTED"，则表示数据库已经成功切换到mounted模式下。

=====================================================================