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

I got this message when I manually completed a failed RMAN duplicate task.

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-19838: Cannot use this control file to open database

Solution is simple, recreate controlfile, it is like this.

SQL> alter database backup controfiel to trace as '/home/oracle/mydb.ctl.src';

SQL>! vi @/home/oracle/mydb.ctl.src
-- note: modify it to what you need.

SQL> @/home/oracle/mydb.ctl.src

Control file created.

SQL> alter database open resetlogs;

Database altered.

SQL>

 

 

About bigpang

Database Architect, AWS certified database specialist, Oracle certified cloud architect, Perl and Python advocate
This entry was posted in Oracle Database, Oracle RMAN backup and tagged , , . Bookmark the permalink.

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

  1. Flavio says:

    me salvouuuuuuuu porra

Leave a comment