Dear Experts,
We done Database upgrade from 12.2 to 19c.
This is test database. 2 node RAC.
Now again i am trying to bring back the database to 12.2 version but getting some error.
SQL> select NAME,SCN,TIME from v$restore_point;
NAME SCN TIME
---------------------- ---------- -----------------------------------
PRE_UPGRADE 1.5181E+13 19-AUG-20 06.33.11.000000000 PM
SQL> show parameter compatible
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 12.2.0
noncdb_compatible boolean FALSE
>>
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
BANNER_FULL
------------------------------------------------------------------------------------------------------------------------
BANNER_LEGACY CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production 0
>>
SQL> set lines 120 pages 100
SQL> select * FROM v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
----------------------- ------------------ ------------------------- --------------- ----------
FLASHBACK LOG 1.03 0 42 0
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 2.4696E+10 bytes
Fixed Size 23065936 bytes
Variable Size 9462349824 bytes
Database Buffers 1.1945E+10 bytes
Redo Buffers 44040192 bytes
In-Memory Area 3221225472 bytes
Database mounted.
>>
SQL> FLASHBACK DATABASE TO RESTORE POINT PRE_UPGRADE;
FLASHBACK DATABASE TO RESTORE POINT PRE_UPGRADE
*
ERROR at line 1:
ORA-38748: cannot flashback data file 1 - file is in use or recovery
ORA-01110: data file 1: '+DATAPRHDB/PRODRHDB/DATAFILE/system.529.1048648879'
SQL> alter database open;
Database altered.
SQL> select * from v$recover_file;
no rows selected