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

ORA-38760: This database instance failed to turn on flashback database Error solution process problem phenomenon: Get up early in the morning to open the database, originally wanted to do a test, the result is not expected to pop up the ORA-38760: this database instance failed to turn on flashback database error. This error is obviously caused by flashback. Www.2cto.com Error Analysis: First of all, from the error phenomenon, it is because flashback is opened, because the flashback file is lost and cannot be used, thus triggering this error. Under normal circumstances, no error is reported.
Alter log error message: Errors in file c: \ oracle \ product \ 10.2.0 \ admin \ wwl \ bdump \ wwl_rvwr_5416.trc: ORA-38701? 7 rows across partitions 1: "C: \ ORACLE \ PRODUCT \ 10.2.0 \ FLASH_BACK \ WWL \ FLASHBACK \ O1_MF_7T7O9TKT_.FLB" ORA-27041: the specified path cannot be found by the system: unable to open fileO/S-Error: (OS 3. Solution: Because the flashback file is deleted, turning on flashback database fails when the database is open. Therefore, set the flashback attribute to off and Open the database, retrun on flashback and the database will be opened. the process is as follows: SQL> startupORACLE instance started. total System Global Area 1610612736 bytesFixed Size 2066080 bytesVariable Size 419432800 bytesDatabase Buffers 1174405120 bytesRedo Buffers 14708736 bytesDatabase mounted. ORA-38760: This database instance failed to turn on flash Back database www.2cto.com temporarily closes flashbak to start the database. SQL> alter database flashback off; Database altered. SQL> alter database open; Database altered. Enable flashbak again and then start the database. SQL> shutdown immediateDatabase closed. database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. total System Global Area 1610612736 bytesFixed Size 2066080 bytesVariable Size 419432800 bytesDatabase Buffers 1174405120 bytesRedo Buffers 14708736 bytesDatabase mounted. www.2cto.com SQL> alter database flashback on; Database altered. SQL> alter database open; Database altered. SQL> see Metalink article: Cannot Start Database ORA-38760 [ID 274569.1] author wuweilong