Forgot to backup REDO files for a NOARCHIVELOG database

1. startup database after restore from cold backup but failed.

testdb05d:/oradata/dmdb> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 2 11:21:54 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SYS@dmdb> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area  638947328 bytes
Fixed Size                  2224008 bytes
Variable Size             515899512 bytes
Database Buffers          104857600 bytes
Redo Buffers               15966208 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 30933094
Session ID: 254 Serial number: 3


SYS@dmdb> exit



ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1b_spda.log'
ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1a_spda.log'
Errors in file /oradump/diag/rdbms/dmdb/dmdb/trace/dmdb_lgwr_23199918.trc:
ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1b_spda.log'
ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1a_spda.log'
Errors in file /oradump/diag/rdbms/dmdb/dmdb/trace/dmdb_ora_30933094.trc:
ORA-00338: log 1 of thread  is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1a_spda.log'
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1b_spda.log'
USER (ospid: 30933094): terminating the instance due to error 338
System state dump requested by (instance=1, osid=30933094), summary=[abnormal instance termination].
System State dumped to trace file /oradump/diag/rdbms/dmdb/dmdb/trace/dmdb_diag_9502970.trc
Dumping diagnostic data in directory=[cdmp_20131002112203], requested by (instance=1, osid=30933094), summary=[abnormal insta
nce termination].
Instance terminated by USER, pid = 30933094



2. investigate and realized the cold backup set didn't include REDO files

testdb05d:/oralog/redo/dmdb> ls -l
total 2457696
-rw-rw----    1 oracle8  dba       209715712 Oct 02 10:48 redo_1a_spda.log
-rw-rw----    1 oracle8  dba       209715712 Oct 02 10:48 redo_1b_spda.log
-rw-rw----    1 oracle8  dba       209715712 Oct 02 10:55 redo_2a_spda.log
-rw-rw----    1 oracle8  dba       209715712 Oct 02 10:55 redo_2b_spda.log
-rw-rw----    1 oracle8  dba       209715712 Oct 02 10:33 redo_3a_spda.log
-rw-rw----    1 oracle8  dba       209715712 Oct 02 10:33 redo_3b_spda.log
testdb05d:/oralog/redo/dmdb> ps -fe |grep dmdb
 oracle8 21758072  5505062   0 11:26:53  pts/0  0:00 grep dmdb
testdb05d:/oralog/redo/dmdb> df -k  ./
Filesystem    1024-blocks      Free %Used    Iused %Iused Mounted on
/dev/oralog       5242880   4012868   24%       25     1% /oralog


3. continue to clear REDO files and succeeded.

testdb05d:/oralog/redo/dmdb> cd ..
testdb05d:/oralog/redo> ls
dmdb
testdb05d:/oralog/redo> mv dmdb dmdb_1002
testdb05d:/oralog/redo> mkdir dmdb
testdb05d:/oralog/redo> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 2 11:28:54 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option

SYS@blus> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option
testdb05d:/oralog/redo> dmdb
testdb05d:/oralog/redo> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 2 11:29:00 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SYS@dmdb> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area  638947328 bytes
Fixed Size                  2224008 bytes
Variable Size             515899512 bytes
Database Buffers          104857600 bytes
Redo Buffers               15966208 bytes
Database mounted.
SYS@dmdb> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery


SYS@dmdb> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS           FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE#
---------------- ------------- ------------------- ------------
NEXT_TIME
-------------------
         1          1       6070  209715200        512          2 NO
INACTIVE               3703950 2013-09-27 22:18:32      3704357
2013-09-27 22:33:33

         3          1       6072  209715200        512          2 NO
CURRENT                3704765 2013-09-27 22:48:34   2.8147E+14


         2          1       6071  209715200        512          2 NO
INACTIVE               3704357 2013-09-27 22:33:33      3704765
2013-09-27 22:48:34


SYS@dmdb> alter database clear logfile group 1;

Database altered.

SYS@dmdb> alter database clear logfile group 2;

Database altered.

SYS@dmdb> alter database clear logfile group 3;

Database altered.

SYS@dmdb> select member from V$logfile;

MEMBER
--------------------------------------------------------------------------------
/oralog/redo/dmdb/redo_1a_spda.log
/oralog/redo/dmdb/redo_1b_spda.log
/oralog/redo/dmdb/redo_2a_spda.log
/oralog/redo/dmdb/redo_2b_spda.log
/oralog/redo/dmdb/redo_3a_spda.log
/oralog/redo/dmdb/redo_3b_spda.log

6 rows selected.

SYS@dmdb> alter database open;

Database altered.

SYS@dmdb> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@dmdb> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area  638947328 bytes
Fixed Size                  2224008 bytes
Variable Size             515899512 bytes
Database Buffers          104857600 bytes
Redo Buffers               15966208 bytes
Database mounted.
Database opened.
SYS@dmdb> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option
testdb05d:/oralog/redo> df -k  /oralog
Filesystem    1024-blocks      Free %Used    Iused %Iused Mounted on
/dev/oralog       5242880   2784004   47%       32     1% /oralog



MMNL started with pid=16, OS id=24379452
ORACLE_BASE from environment = /oracle/product
Wed Oct 02 11:37:59 2013
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2345657111
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Wed Oct 02 11:38:03 2013
ALTER DATABASE OPEN
Block change tracking file is current.
Thread 1 opened at log sequence 6074
  Current log# 2 seq# 6074 mem# 0: /oralog/redo/dmdb/redo_2a_spda.log
  Current log# 2 seq# 6074 mem# 1: /oralog/redo/dmdb/redo_2b_spda.log
Successful open of redo thread 1
Starting background process CTWR
Wed Oct 02 11:38:03 2013
CTWR started with pid=18, OS id=30933216
Block change tracking service is active.
SMON: enabling cache recovery
[13893792] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:3198839111 end:3198839153 diff:42 (0 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is UTF8
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Wed Oct 02 11:38:04 2013
QMNC started with pid=19, OS id=8323112
Completed: ALTER DATABASE OPEN
Starting background process CJQ0
Wed Oct 02 11:38:04 2013
CJQ0 started with pid=22, OS id=19988686
Incremental checkpoint up to RBA [0x17ba.f88e.0], current log tail at RBA [0x17ba.f8e2.0]
Wed Oct 02 11:38:34 2013
Thread 1 cannot allocate new log, sequence 6075
Private strand flush not complete
  Current log# 2 seq# 6074 mem# 0: /oralog/redo/dmdb/redo_2a_spda.log
  Current log# 2 seq# 6074 mem# 1: /oralog/redo/dmdb/redo_2b_spda.log
Beginning log switch checkpoint up to RBA [0x17bb.2.10], SCN: 3718854
Thread 1 advanced to log sequence 6075 (LGWR switch)
  Current log# 3 seq# 6075 mem# 0: /oralog/redo/dmdb/redo_3a_spda.log
  Current log# 3 seq# 6075 mem# 1: /oralog/redo/dmdb/redo_3b_spda.log