Listing the current files shows the move is complete.Ĩ 3277 SOE *** /u01/app/oracle/oradata/DB11G/soe.dbf Switch to the new datafile copy(s) and recover the tablespace. RMAN> SQL 'ALTER TABLESPACE soe OFFLINE'
#Rename samples flowjo 10 Offline
We could have turned the tablespace offline before the copy, removing the need for a recovery, but the tablespace would have been offline longer using that method. RMAN> COPY DATAFILE 8 TO '/u01/app/oracle/oradata/DB11G/soe.dbf' Report of database schema for database with db_unique_name DB11Gįile Size(MB) Tablespace RB segs Datafile Nameġ 750 SYSTEM *** /u01/app/oracle/oradata/DB11G/system01.dbfĢ 1150 SYSAUX *** /u01/app/oracle/oradata/DB11G/sysaux01.dbfģ 444 UNDOTBS1 *** /u01/app/oracle/oradata/DB11G/undotbs01.dbfĤ 120 USERS *** /u01/app/oracle/oradata/DB11G/users01.dbfĥ 345 EXAMPLE *** /u01/app/oracle/oradata/DB11G/example01.dbfĨ 3277 SOE *** /u01/app/oracle/product/11.2.0.2/db_1/dbs/soe.dbfįile Size(MB) Tablespace Maxsize(MB) Tempfile Nameġ 370 TEMP 32767 /u01/app/oracle/oradata/DB11G/temp01.dbf First, log in to RMAN and list the current files. RMAN can be used to move files with less downtime by copying them in advance of the move, then recovering them as part of the move itself. SQL> ALTER DATABASE MOVE DATAFILE '/u01/app/oracle/oradata/cdb1/system01.dbf' TO '/tmp/system01.dbf' Oracle 12c includes the ALTER DATABASE MOVE DATAFILE command, which performs an online move of a datafile. Repeating the initial query shows that the the logfile has been renamed in the data dictionary.Ĭ:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\RENAME_REDO01.LOG SQL> ALTER DATABASE RENAME FILE 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\REDO01.LOG'. The following SQL*Plus output shows how this is done. Issue the ALTER DATABASE RENAME FILE command to rename the file within the Oracle dictionary.To move or rename a logfile do the following. The current location of the logfiles can be queried from the V$LOGFILE view, as shown below.Ĭ:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\REDO03.LOGĬ:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\REDO02.LOGĬ:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\REDO01.LOG 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
0 kommentar(er)
