QUERY TO CHECK THE INSTANCE STARTUP TIME IN RAC

set lines 1000

col STARTUP_TIME for a25

col platform for a30

select DBID, INSTANCE_NUMBER INST_NU,STARTUP_TIME,PARALLEL RAC, VERSION, DB_NAME, INSTANCE_NAME,HOST_NAME ,LAST_ASH_SAMPLE_ID ASH_ID,PLATFORM_NAME PLATFORM from dba_hist_database_instance where instance_number=&N order by STARTUP_TIME;