ORA-01187: cannot read from file because it failed verification tests

Error:

When trying to take backup of control file getting below error

SQL> alter database backup controlfile to trace as ‘/home/oracle/control.txt’;
alter database backup controlfile to trace as ‘/home/oracle/control.txt’
*
ERROR at line 1:
ORA-01187: cannot read from file  because it failed verification tests
ORA-01110: data file 201: ‘/u02/data/PROD/temp01.dbf’

Solution:

Drop and recreate the tempfile temp01.dbf to fix this issue.

alter database tempfile  ‘/u02/data/PROD/temp01.dbf’ drop;
alter tablespace temp add tempfile ‘/u02/data/PROD/temp01.dbf’ size 10g reuse;

Then execute the controlfile backup command.

alter database backup controlfile to trace as ‘/home/oracle/control.txt’;

  • September 18, 2018 | 25 views
  • Comments