Troubleshoot fix resolve ORA-01523: cannot rename data file to 'string' - file already part of database

Error Description: During ALTER DATABASE RENAME or ALTER TABLESPACE RENAME, the new name of a file is already present in the control file.
Fix for this error: Rename the file to a name not already being used as part of the database.