File

How to Resolve ORA-01523: cannot rename data file to

by Ed Chen
February 9, 2023January 10, 2023

ORA-01523 Tried to rename a data file, but it failed with ORA-01523. SQL> alter database rename file '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB/data_file_02.dbf' to '/oradata/ORCLCDB/ORCLPDB/data_file_01.dbf'; alter database rename file '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB/data_file_02.dbf'… Read More »

How to Resolve ORA-32001: write to SPFILE requested but no SPFILE is in use

by Ed Chen
December 23, 2022November 17, 2022

ORA-32001 ORA-32001 means that it cannot write the server parameter file at this moment, you should make sure SPFILE is being used by the instance.… Read More »

How to Resolve ORA-32589: unable to drop minimal supplemental logging

by Ed Chen
December 9, 2022November 7, 2022

ORA-32589 Tried to drop the minimal supplemental logging from the database, but it failed with ORA-32589. SQL> alter database drop supplemental log data; alter database… Read More »

How to Resolve ORA-31541: Supplemental logging is not enabled in CDB$ROOT.

by Ed Chen
December 8, 2022November 7, 2022

ORA-31541 Tried to enable flashback transaction query starting from adding minimal supplemental logs, but it failed with ORA-31541. SQL> alter database add supplemental log data;… Read More »

How to Resolve ORA-00946: missing TO keyword

by Ed Chen
November 30, 2022October 26, 2022

ORA-00946 Tried to rename a file of database, but it failed with ORA-00946. SQL> alter database rename file '/oradata/ORCLCDB/ORCLPDB/example01.dbf' '/oradata/TESTCDB/ORCLPDB/example01.dbf'; alter database rename file '/oradata/ORCLCDB/ORCLPDB/example01.dbf'… Read More »

Alter Database Move Tempfile?

by Ed Chen
November 25, 2022October 26, 2022

Move Temp File Online? We have talked about moving a data file online in the previous post and we're thinking about moving a temp file… Read More »

How to Resolve ORA-01135: file accessed for DML/query is offline

by Ed Chen
November 23, 2022December 12, 2022

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 Oracle Rename TempFile

by Ed Chen
October 21, 2022December 28, 2022

Rename TempFile Earlier, we have talked about how to rename a datafile, now how about tempfile? How to rename it? The procedure of renaming an… Read More »

How Oracle Rename DataFile

by Ed Chen
October 18, 2022November 17, 2022

Rename DataFile The procedure of renaming an Oracle datafile is actually the same as the procedure of moving datafile with a different file name. Let's… Read More »

ORA-01187: cannot read from file because it failed verification tests

How to Resolve ORA-01187: cannot read from file

by Ed Chen
September 12, 2022March 20, 2023

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 »