DBA Hub

📋Steps in this guide1/1

Get database incarnation info

set heading off set feedback off select 'Incarnation Destination Configuration' from dual; select '*************************************' from dual; set heading on set feedback on

oracle configurationintermediate
by OracleDba
11 views
1

Get database incarnation info

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
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;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!