Redo Log Loss Repair in ORACLE non-archive mode

First step: Fully prepared Datafile,controlfile,spfile/pfile

Step two: Restore the log. (The original cold log is useless, never use!) ）

sql> select member from v$logfile;                         /ora/app/ oracle/oradata/orcl/redo03.log/ora/app/oracle/oradata/orcl/redo02.log/ora/app/oracle/oradata/orcl/ redo01.logsql> archive log list;database log mode               No Archive ModeAutomatic archival              Disabled        Archive destination             use_db_recovery_file_destoldest online log sequence     10                         current log sequence           12                         sql> ho rm  $ORACLE _base/oradata/orcl/redo*.log   --The analog log file is missing.        SQL> ho ls  $ORACLE _base/oradata/orcl/redo*.logls:  cannot access /ora/app/oracle/oradata/orcl/redo*.log: no such file or  directorysql> startup forceoracle instance started. total system global area 1536602112 bytesfixed size                   2213616 bytesvariable  Size             956303632  Bytesdatabase buffers          570425344 bytesredo buffers                 7659520 bytesDatabase mounted.                          Ora-00313: open failed for members of log group 3 of thread  1ORA-00312: online log 3 thread 1:  '/ora/app/oracle/oradata/orcl/ Redo03.log ' ora-27037: unable to obtain file status                         &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;LINUX-X86_64&NBSP;ERROR:&NBSP;2:  No such file or directory                            additional information: 3   SQL> alter database open resetlogs;         --First Step alter database open resetlogs      *                                    error at line 1:                     ORA-01139: RESETLOGS option only valid after an incomplete  database recoverysql> recover database using backup controlfile; -- Step Two ora-00279: change 1384991 generated at 05/22/2016 20:05:08 needed  for thread 1ora-00289: suggestion : /ora/app/oracle/flash_recovery_area/orcl/archivelog/2016_05_22/o1_mf_1_12_%u_. arcora-00280: change 1384991 for thread 1 is in sequence  #12                                                   specify log: {<ret>= suggested | filename | auto | cancel}                            --Note: Non-archive, do nothing, direct enter. ora-00308: cannot open archived log  '/ora/app/oracle/flash_recovery_area/orcl/ Archivelog/2016_05_22/o1_mf_1_12_%u_.arc ' Ora-27037: unable to obtain file status                                                                                     Linux-x86_64 Error: 2: No such file or  directory                                                                           additional information: 3   sql> alter database open resetlogs;           --Third Step alter database open resetlogs       *                                    ERROR at line 1:                    ORA-01113: file 1 needs media  recoveryora-01110: data file 1:  '/ora/app/oracle/oradata/orcl/system01.dbf ' SQL>  alter system set  "_allow_resetlogs_corruption" =true scope=spfile; system altered.                             --The fourth step, use hidden parameters, do not do consistency check to start the database. sql> startup force mount;                    --The fifth step, reboot to the Mount state. oracle instance started. total system global area 1536602112  bytesfixed size                   2213616 bytesVariable Size              956303632 bytesDatabase Buffers           570425344 bytesRedo Buffers                 7659520 bytesDatabase mounted.                          sql> alter database open;                     --Sixth Step alter database open                       *                                           ERROR at line 1:                          ORA-01589: must  Use resetlogs or noresetlogs option for database opensql> alter  database open resetlogs;          --the seventh step, Normal recovery will normally occur. Error:                              ora-03114: not connected to oracle                                                alter database open resetlogs*                              ERROR at line 1:              ora-01092: oracle instance terminated. &NBSP;DISCONNECTION&NBSP;FORCEDORA-00600:&NBSP;INTERNAL&NBSP;ERROR&NBSP;CODE,&NBSP;ARGUMENTS:&NBSP;[2662], &NBSP;[0],&NBSP;[1384999],&NBSP;[0], [1385016], [4194432], [], [], [], [], [], []process id:  28621                                                                                                        session id: 125 serial number:  5                                                                                                                                     -- The 600 error caused by the hidden parameter. sql> exitdisconnected from oracle database 11g enterprise edition  Release 11.2.0.1.0 - 64bit productionwith the partitioning, olap, data  Mining and Real Application Testing options                  [[email protected] ~]$  Sqlplus / as sysdba                                                             sql*plus: release 11.2.0.1.0 production on sun  May 22 22:56:21 2016Copyright  (c)  1982, 2009, oracle.  all  rights reserved. Connected to an idle instance. sql> select status from v$instance;        -- Check the status and the database is closed. Select status from v$instance*error at line 1:ora-01034: oracle not  availableProcess ID: 0Session ID: 0 Serial number: 0SQL>  Startup mount;                            --start oracle instance started again. total system global area 1536602112 bytesfixed size                   2213616 bytesvariable  Size             956303632  Bytesdatabase buffers          570425344 bytesredo  Buffers                 7659520 bytesdatabase mounted. sql> alter database open;database altered.                                 --KaiThe success of the move. sql> ho ls  $ORACLE _base/oradata/orcl/red*          --log files are automatically generated/ora/app/oracle/oradata/orcl/redo01.log  /ora/app/oracle/oradata/orcl/redo02.log   /ora/app/oracle/oradata/orcl/redo03.logSQL> alter system reset  "_allow_ Resetlogs_corruption " scope=spfile sid= ' *"; system altered.                                 --the eighth step, Restores hidden parameter values. sql> startup force                               --the Nineth step, Restart the database for the parameters to take effect.

Redo Log Loss Repair in ORACLE non-archive mode