hiddengugl.blogg.se - Does clearing a logfile rename it oracle

Repeating the initial query shows that the the controlfile has been renamed in the data dictionary.Ĭ:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\RENAME_CONTROL01.CTL SQL> HOST MOVE C:\ORACLE\ORADATA\DB10G\CONTROL01.CTL C:\ORACLE\ORADATA\DB10G\RENAME_CONTROL01.CTL > 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\CONTROL03.CTL' SCOPE=SPFILE SQL> ALTER SYSTEM SET control_files='C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\RENAME_CONTROL01.CTL',. For instances using a pfile replace the spfile manipulation steps with an amendment of the parameter in the init.ora file. The following SQL*Plus output shows how this is done for an instance using an spfile.

Alter the control_files parameter using the ALTER SYSTEM comamnd.

To move or rename a controlfile do the following. In order to rename or move these files we must alter the value of the control_files instance parameter.Ĭontrol_files string C:\ORACLE\ORADATA\DB10G\CONTRO The current location of the controlfiles can be queried from the V$CONTROLFILE view, as shown below.Ĭ:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\CONTROL01.CTLĬ:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\CONTROL02.CTLĬ:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\CONTROL03.CTL

Online Datafile Move in Oracle Database 12c Release 1 (12.1).

The examples are based on a default Oracle 10g installation on Windows, but the method is the same for different versions of Oracle on any platform, with the exception of the host command used to rename the file.

This article presents a brief explanation of how assorted Oracle files can be renamed or moved to a new location. Home » Articles » Misc » Here Renaming or Moving Oracle Files