Daily Archives: September 7, 2014

ORA-00376 : file 43 cannot be read at this time


connect to Oracle AS SYSDBA sqlplus / as sysdba SQL> select * from v$recover_file; FILE# status 43 OFFLINE SQL> recover datafile 43; ORA-00279: change 271477927444 generated at 15/11/2013 10:30:46 needed for thread 1 ORA-00289: suggestion : /export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arcORA-00280: change 271477927444 for thread 1 is in sequence #170675 Specify log: {=suggested filename AUTO CANCEL} AUTO ORA-00308: cannot […]