Start! Time stamp: 2015-11-02 13:01:09 Let's search for valid ControlFile on +DB1DATA Time stamp: 2015-11-02 13:01:13 Valid ControlFile: "+DB1DATA/TESTDB1/CONTROLFILE/Current.260.893849157" Database Recovery and Start ... Time stamp: 2015-11-02 13:01:13 SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 2 13:01:13 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance. ORACLE instance started. Total System Global Area 855638016 bytes Fixed Size 2930128 bytes Variable Size 327158320 bytes Database Buffers 520093696 bytes Redo Buffers 5455872 bytes Recovery Step 1: new Control File old 1: alter system set control_files='&1' scope=spfile new 1: alter system set control_files='+DB1DATA/TESTDB1/CONTROLFILE/Current.260.893849157' scope=spfile System altered. ORA-01507: database not mounted ORACLE instance shut down. Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options Time stamp: 2015-11-02 13:01:41 SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 2 13:01:41 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance. ORACLE instance started. Total System Global Area 855638016 bytes Fixed Size 2930128 bytes Variable Size 327158320 bytes Database Buffers 520093696 bytes Redo Buffers 5455872 bytes Database mounted. Recovery Step 2: DB Recovery from archive log ORA-00279: change 1945127 generated at 10/29/2015 15:08:17 needed for thread 1 ORA-00289: suggestion : +DB1FRA/TESTDB1/ARCHIVELOG/2015_10_29/thread_1_seq_27.276.894380913 ORA-00280: change 1945127 for thread 1 is in sequence #27 ORA-00279: change 1945150 generated at 10/29/2015 15:08:32 needed for thread 1 ORA-00289: suggestion : +DB1FRA ORA-00280: change 1945150 for thread 1 is in sequence #28 ORA-00278: log file '+DB1FRA/TESTDB1/ARCHIVELOG/2015_10_29/thread_1_seq_27.276.894380913' no longer needed for this recovery ORA-00308: cannot open archived log '+DB1FRA' ORA-17503: ksfdopn:2 Failed to open file +DB1FRA ORA-15045: ASM file name '+DB1FRA' is not in reference form Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options Time stamp: 2015-11-02 13:01:54 SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 2 13:01:54 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options Recovery Step 3: Open DB and reset logs Database altered. Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options Time stamp: 2015-11-02 13:02:06 Finish!