Posts

Showing posts from December, 2021

RMAN Duplicate Failed - ORA - 38862: Flashback database logs are in use.

Problem Statement: While doing a RMAN based duplication for database running on version 19.10 encountered a strange error " ORA - 38862: Flashback database logs are in use ". Though at first instance one would think about why would the database  be using flashback logs as it's a RMAN based restore.  Error Stack: RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of sql command on clone_default channel at <timestamp> RMAN-11003: failure during parse/execution of SQL statement: alter database flashback off ORA - 38862: Flashback database logs are in use Command: run  {                    allocate auxiliary channel ch1 device type disk;                     allocate auxiliary channel ch1 device type disk;                     allocate auxiliary channel ch1 device type disk;                     allocate auxiliary channel ch1 device type disk;                    duplicate database <source db