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';
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:
Post a Comment