V$DATAFILE

How to Resolve ORA-00372: file cannot be modified at this time

by Ed Chen
February 2, 2023February 4, 2023

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-00376: file cannot be read at this time

by Ed Chen
July 26, 2022December 12, 2022
2 Comments

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-01113: file needs media recovery

by Ed Chen
July 25, 2022December 12, 2022

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 Check DataFile Creation Date

by Ed Chen
July 15, 2022June 17, 2022

Data File Creation Date To check the creation date time of data files, we should query V$DATAFILE, not DBA_DATA_FILES. First of all, we format the… Read More »

How to Check Tablespace Creation Date

by Ed Chen
May 30, 2022June 10, 2022

Tablespace Create Time There's no direct way to know the creation date of a tablespace, because either DBA_TABLESPACES or V$TABLESPACE doesn't have such information. But… Read More »

How to Resolve ORA-01152: file 1 was not restored from a sufficiently old backup

by Ed Chen
March 18, 2020December 12, 2022
4 Comments

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 Move Temp File Location in Oracle

by Ed Chen
February 19, 2020October 28, 2022
4 Comments

As we have talked about how to move a whole Oracle database, it's an offline operation. Here we introduce how to change temp file location… Read More »

How to Check Oracle Database Size

by Ed Chen
August 30, 2019December 10, 2022

At least two scenarios that you may need to know the database size. Server upgrade or migration You have to plan the size of storage… Read More »

Switch Database To Copy

by Ed Chen
May 16, 2016October 16, 2022

Move Database by RMAN In the previous post, we have talked about how to move data files in a tablespace to another place by RMAN.… Read More »

Switch Datafile To Copy

by Ed Chen
May 16, 2016October 16, 2022

Move Data File by RMAN As usual, we use RMAN to change the location of a data file. Check the file number. SQL> select file#… Read More »