SYS@ertpqa1> @query_restore_point.sql INSTANCE_NAME STATUS STARTUP_TIME ------------------------------------------------ ------------------------------------ --------------- ertpqa1 OPEN 01-APR-16 ertpqa3 OPEN 01-APR-16 ertpqa2 OPEN 01-APR-16 ertpqa4 OPEN 01-APR-16 OPEN_MODE ------------------------------------------------------------ READ WRITE Session altered. NAME SCN TO_CHAR(TIME,'MM/DD/YYYYHH24:MI:SS') DATABASE_INCARNATION# GUARANTEE STORAGE_SIZE ------------ ---------------- --------------------------------------------------------- --------------------- --------- ---------------- GOLD 23238178620 04/01/2016 13:39:25 5 YES 1073741824 GOLD 23238178620 04/01/2016 13:39:25 5 YES 1073741824 GOLD 23238178620 04/01/2016 13:39:25 5 YES 1073741824 GOLD 23238178620 04/01/2016 13:39:25 5 YES 1073741824 FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES ------------------------------------------------------------ ------------------ ------------------------- ---------------- CONTROL FILE 0 0 1 REDO LOG 0 0 0 ARCHIVED LOG 0 0 0 BACKUP PIECE 0 0 0 IMAGE COPY 0 0 0 FLASHBACK LOG 2 0 8 FOREIGN ARCHIVED LOG 0 0 0 7 rows selected. SYS@ertpqa1> spool off