ALTER DATABASE RENAME FILE

How to Resolve RMAN-06094: datafile 1 must be restored

by Ed Chen
February 17, 2023February 19, 2023

RMAN-06094 Tried to recover a database, but it failed with RMAN-06094. RMAN> recover database; ... RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571:… Read More »

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-02231: missing or invalid option to ALTER DATABASE

by Ed Chen
December 22, 2022December 28, 2022

ORA-02231 ORA-02231 means that a keyword is missing from the position where it should be in ALTER DATABASE statement. Most likely, it's a syntax error.… 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 »

How to Resolve ORA-01157: cannot identify/lock data file

by Ed Chen
July 27, 2022December 17, 2022

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-01516 Error Message

by Ed Chen
June 24, 2017March 14, 2023

ORA-01516: nonexistent log file, datafile, or temporary file There're two scenarios that throw ORA-01516 going to be introduced in this post. 1. Rename Tempfile I… Read More »

Alter Database Rename File

by Ed Chen
May 16, 2016October 15, 2022

Move Data File Offline Not like the new released statement ALTER DATABASE MOVE DATAFILE which can move data files online, the old-fashioned file renaming procedure… Read More »

How to Move Data File Location

by Ed Chen
May 15, 2016October 16, 2022

Move Data File After changing SPFILE location, changing control file location and changing redo logs location, we are going to move or rename data files.… Read More »