Oracle Recovery: differenze tra le versioni
Jump to navigation
Jump to search
(Creata pagina con '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...') |
(Nessuna differenza)
|
Versione delle 12:06, 9 set 2014
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;