ORA-19838: Cannot use this control file to open database

ORA-19838: Cannot use this control file to open database

Error:

When doing RMAN duplicate I saw it errored with ORA-19838 message when doing alter database open resetlogs

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-19838: Cannot use this control file to open database

Solution

Recreate controlfile. 

SQL> alter database backup controfiel to trace as '/tmp/test_db.cntl';

SQL>! vi @/tmp/test_db.cntl

-- note: modify it to what you need.

SQL> @/tmp/test_db.cntl

Control file created.

SQL> alter database open resetlogs;

Database altered.

If you like please follow and comment