Wednesday, 31 May 2017

alter database backup controlfile ORA-01110 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 '/tmp/controltxt.trxt';
alter database backup controlfile to trace as '/tmp/controltxt.trxt'
*
ERROR at line 1:
ORA-01187: cannot read from file  because it failed verification tests
ORA-01110: data file 201: '/oradata/test/temp01.dbf'


Solution:
Drop and recreate the tempfile 'temp01.dbf'

alter database tempfile  '/oradata/test/temp01.dbf' drop;
alter tablespace temp add tempfile /oradata/test/temp01.dbf' size 4g reuse;

Then 
alter database backup controlfile to trace as '/tmp/controltxt.trxt';

No comments: