Oracle datafile Special Character processing

1. The data file for the discovery database has special characters:

2. Try to modify the tablespace offline after using the Sqlplus

sql> alter tablespace wst_data rename DataFile'D:\oracle11\oradata\teblespace\WST_DATA. DBF'To'D:\oracle11\oradata\teBlespace\wst_data. Dbf' ;Alter tablespace wst_data rename DataFile'D:\oracle11\oradata\teblespace\WST_DATA. DBF'To'D:\oracle11\oradata\teblespAce\wst_data. Dbf'*ERROR at line1: ORA-01525: ErrorinchRenaming data Filesora-01141: Error Renaming data file6-NewFile'D:\oracle11\oradata\teblespace\WST_DATA. DBF'Not Foundora-01110: Data File6:'D:\ORACLE11\ORADATA\TEBLESPACE\WST_DATA. DBF'ORA-27041: Unable to open fileosd-04002: Unable to open Fileo/s-error: (OS2The system cannot find the file specified. SQL> Alter tablespace wst_data rename DataFile6To'D:\oracle11\oradata\teblespace\WST_DATA. DBF'alter tablespace wst_data rename DataFile6To'D:\oracle11\oradata\teblespace\WST_DATA. DBF'*ERROR at line1: ORA-02236: Invalid file name

3. Using Rman to modify

G:\oraclebackup\InstanceNames>Rman Target/Recovery manager:release10.2.0.1.0 -Production onTue FebTen  -: -: the  -Copyright (c)1982,2005, Oracle. AllRights reserved.connected toTargetDatabase: ORA11 (DBID=723822444) RMAN> shutdownimmediate;using TargetDatabaseControlfileinstead ofRecovery CatalogDatabaseclosedDatabasedismountedoracle instance shut Downrman>Startup mount;connected toTargetDatabase( notstarted) Oracle instance startedDatabasemountedtotal System Global Area1071333376bytesfixed Size1375792bytesvariable Size738197968bytesDatabaseBuffers327155712Bytesredo Buffers4603904Bytesrman>Copy datafile6  to 'D:\oracle11\oradata\teblespace\WST_DATA. DBF'; StartingBackupAtTen-FEB- theAllocated Channel:ora_disk_1channel Ora_disk_1:sid=156Devtype=DISKChannel ora_disk_1:starting datafile copyinput datafile fno=00006Name=D:\ORACLE11\ORADATA\TEBLESPACE\WST_DATA. Dbfoutput filename=D:\ORACLE11\ORADATA\TEBLESPACE\WST_DATA. DBF tag=tag20150210t145554 RecId=1Stamp=871311470channel ora_disk_1:datafile copy complete, elapsed time:xx: on: AboutfinishedBackupAtTen-FEB- theRMAN>run{2> SetNewName forDataFile6  to 'D:\oracle11\oradata\teblespace\WST_DATA. DBF'; 3>Switch datafile6; 4>}executing Command:SETNewnamedatafile6Switched todatafile copyinput datafile copy recid=1Stamp=871311470FileName=D:\ORACLE11\ORADATA\TEBLESPACE\WST_DATA. Dbfrman> Alter Database Open;DatabaseOpenedrman> ExitRecovery Manager complete.

4. View the changes

G:\oraclebackup\InstanceNames>Sqlplus "/ assysdba "SQL*Plus:release10.2.0.1.0 -Production onTue FebTen  the: on: A  -Copyright (c)1982,2005, Oracle. Allrights reserved. Connected to: OracleDatabase11g Enterprise Edition Release11.2.0.1.0 -Production withThe partitioning, OLAP, Data Mining and RealApplication Testing Optionssql>col name format A60; SQL> SetLinesize the; SQL> Select file#,status,name fromV$datafile; FILE# STATUS NAME---------- ------- ------------------------------------------------------------         1SYSTEM D:\ORACLE11\ORADATA\ORA11\SYSTEM01. DBF2ONLINE D:\ORACLE11\ORADATA\ORA11\SYSAUX01. DBF3ONLINE D:\ORACLE11\ORADATA\ORA11\UNDOTBS01. DBF4ONLINE D:\ORACLE11\ORADATA\ORA11\USERS01. DBF5ONLINE D:\ORACLE11\ORADATA\TEBLESPACE\WSTJFX_DATA. DBF6OFFLINE D:\ORACLE11\ORADATA\TEBLESPACE\WST_DATA. DBF7ONLINE D:\ORACLE11\ORADATA\TEBLESPACE\WSXXZB_DATA. DBF8ONLINE D:\ORACLE11\ORADATA\TEBLESPACE\TESTBIRPT. DBF9ONLINE D:\ORACLE11\ORADATA\TEBLESPACE\WFGS. DBFTenONLINE D:\ORACLE11\ORADATA\TEBLESPACE\ZDJWBI. DBF OneONLINE E:\DATA\GYBANK\KHFX. Dbf

Oracle datafile Special Character processing