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;