This is an easy one that will save you going through alert logs.

col STARTUP_TIME format a50
SELECT STARTUP_TIME , INSTANCE_NUMBER  
	FROM dba_hist_database_instance 
	where  STARTUP_TIME > sysdate -365
ORDER BY startup_time DESC;
 
  
STARTUP_TIME                                       INSTANCE_NUMBER
-------------------------------------------------- ---------------
15-JUN-21 12.32.08.000 PM                                        2
15-JUN-21 12.01.36.000 PM                                        1

SQL> 

Last modified: 29 July 2021

Author

Comments

Write a Reply or Comment

Your email address will not be published.