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;
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;