Oracle uses log recovery and archive mode to modify archive Mode Modify logs // view the archive mode www.2cto.com archive log list; // view the archive parameter show parameter db_recovery // log archive path: F: \ oracle \ product \ 10.2.0 \ oradata \ orcl // modify the log storage path and size alert system set log_archive_dest = '/opt/oracle/archive' scope = spfile sid = '*'; // command to modify F: \ oracle \ product \ 10.2.0 \ db_1 \ dbs \ SPFILEORCL. ORA // modify the parameter file // modify the automatic archiving mode: shutdown immediate; start Up mount; alter database archivelog; // non-archive mode: alter database noarchivelog; alter database open; archive log list; // if the data is not restored, the cause may be: www.2cto.com 1. the redo log is overwritten... ------------------------ Restore database through Logs ------------------------------------------------------------------------ svrmgr> shutdown immediate svrmgr> startup mount... svrmgr> recover database until time '2017-11-23: 18: 00: 00'; svrmgr> alter database open resetlogs; svrmgr> shutdown immediate... svrmgr> startup... the startup status is displayed. ----------------------- View the log file of the log GROUP --------------------------------- alter database add logfile group 1 select * from v $ log;