Get database incarnation info - oracle database script

Get database incarnation info - Oracle Database Script.

SET heading OFF
SET feedback OFF
SELECT 'Incarnation Destination Configuration'
FROM dual;

SELECT '*************************************'
FROM dual;


SET heading ON
SET feedback ON
SELECT INCARNATION# INC#,
       RESETLOGS_CHANGE# RS_CHANGE#,
       RESETLOGS_TIME,
       PRIOR_RESETLOGS_CHANGE# PRIOR_RS_CHANGE#,
       STATUS,
       FLASHBACK_DATABASE_ALLOWED FB_OK
FROM v$database_incarnation;