ORA-00372 Tried to update a table, but it failed with ORA-00372 and ORA-01110. SQL> show user USER is "HR" SQL> update employees set first_name =… Read More »How to Resolve ORA-00372: file cannot be modified at this time
ORA-01110 means that the data file specified in the message is the first met or main source of problem in the course of error stack.
Therefore, ORA-01110 could exists in various situations of data file modification and operations.
ORA-01135 Some user reported an error ORA-01135 when querying the database. ORA-01135: file 1291 accessed for DML/query is offline ORA-01110: data file 1291: '/u01/app/oracle/oradata/orcl/users01.dbf' ORA-01135… Read More »How to Resolve ORA-01135: file accessed for DML/query is offline
ORA-01258 We successfully dropped a temporary tablespace with its all files, but we saw some errors like ORA-01258 in the alert log. SQL> drop tablespace… Read More »How to Resolve ORA-01258: unable to delete temporary file
ORA-01187 Found ORA-01187 and ORA-01110 after activating a standby database. ORA-01187: cannot read from file because it failed verification tests ORA-01110: data file 2003: '+DATA/ORCLCDB/ORCLPDB/temp01.dbf'… Read More »How to Resolve ORA-01187: cannot read from file
ORA-01157 Saw error ORA-01157 when we tried to bring a tablespace online. SQL> alter tablespace example online; alter tablespace example online * ERROR at line… Read More »How to Resolve ORA-01157: cannot identify/lock data file
ORA-00376 ORA-01110 Someone tried to perform a query, but it failed with ORA-00376 and ORA-01110. SQL> select first_name from employees where last_name = 'Chen'; select… Read More »How to Resolve ORA-00376: file cannot be read at this time
ORA-01113 ORA-01110 Tried to bring a data file online, but it failed with ORA-01113 and ORA-01110. SQL> alter database datafile '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB/example01.dbf' online; alter database datafile… Read More »How to Resolve ORA-01113: file needs media recovery
ORA-01149 ORA-01149 means that some data files are in backup mode, so you can't shutdown the database in this moment. SQL> shutdown immediate; ORA-01149: cannot… Read More »How to Resolve ORA-01149: cannot shutdown - file 1 has online backup set
When I tried to open the standby database to READ ONLY for later real-time query of Active Data Guard (ADG), I got this error message.… Read More »How to Resolve ORA-01152: file 1 was not restored from a sufficiently old backup