RMAN - ORA-00210: cannot open the specified control file

Recovery from the Loss of Subset of the Control Files

Scenario:

Control files deleted at OS level.  We got the error while executing queries it will through error.

One of the scenario solution is shutdown database and copy control file  and rename it or remove control from pfile and start database with pfile

Error:

ORA-00210: cannot open the specified control file

ORA-00202: control file: 'C:\APP\VARUNYADAV\ORADATA\SMRPLM\CONTROL02.CTL'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

ORA-205 signalled during: alter database mount exclusive...

• 2 Control file present on location we will remove control02.ctl at OS level

SQL> sho parameter control_files

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

control_files                        string      C:\APP\VARUNYADAV\ORADATA\SMRP

                                                 LM\CONTROL01.CTL, C:\APP\VARUN

                                                 YADAV\ORADATA\SMRPLM\CONTROL02

                                                 .CTL

SQL>

Remove controlfile from os level C:\APP\VARUNYADAV\ORADATA\SMRPLM\CONTROL02.CTL

• Shutdown and start database it through an error below:

SQL> select name,open_mode,database_role from v$database;

select name,open_mode,database_role from v$database

                                         *

ERROR at line 1:

ORA-01507: database not mounted

SQL>

ORA-00210: cannot open the specified control file

ORA-00202: control file: 'C:\APP\VARUNYADAV\ORADATA\SMRPLM\CONTROL02.CTL'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

ORA-205 signalled during: alter database mount exclusive...

2020-05-18T22:26:50.469919+05:30

• Just copy existing controlfile which CONTROL01.CTL to CONTROL02.CTL at OS level and start database .

C:\Users\varunyadav>sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon May 18 22:34:08 2020

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> shut abort

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 5133828096 bytes

Fixed Size                  8757472 bytes

Variable Size            1207963424 bytes

Database Buffers         3909091328 bytes

Redo Buffers                8015872 bytes

Database mounted.

Database opened.

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

C:\APP\VARUNYADAV\ORADATA\SMRPLM\SYSTEM01.DBF

C:\APP\VARUNYADAV\ORADATA\SMRPLM\SYSAUX01.DBF

C:\APP\VARUNYADAV\ORADATA\SMRPLM\UNDOTBS01.DBF

C:\APP\VARUNYADAV\ORADATA\SMRPLM\USERS01.DBF

C:\APP\VARUNYADAV\ORADATA\SMRPLM\SOETBS01.DBF

SQL>