-- 10g
select instance_number, to_char(startup_time, 'DD.MM.YYYY HH24:MI'), instance_name from DBA_HIST_DATABASE_INSTANCE order by startup_time