Oracle Recovery
Jump to navigation
Jump to search
UNTIL TIME Recovery
SQL> shutdown immediate;
SQL> startup mount;
—No restore b/c OS or other means are used to restore necessary files—
SQL> recover database UNTIL TIME '2006-08-15:14:07:00'
The time format must be in the format YYYY-MM-DD:HH24:MM:SS irrespective of NLS_DATE_FORMAT
SQL> alter database open resetlogs;