Moving the SYSTEM tablespace is possible using a similar method, but the database must be shutdown and mounted before the switch and recover can be done. 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'
#Oracle 10g default database name 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.
![oracle 10g default database name oracle 10g default database name](https://docs.delphix.com/docs52/files/83053584/83053585/1/1512114596694/Delphix_dSource_2Node_Configuration.jpg)
The following SQL*Plus output shows how this is done for an instance using an spfile.
![oracle 10g default database name oracle 10g default database name](http://www.thatjeffsmith.com/wp-content/uploads/2013/11/tables_to_view6.png)
To move or rename a controlfile do the following.
![oracle 10g default database name oracle 10g default database name](https://oracle-base.com/articles/10g/images/DB10gR2-8-SpecifyDatabaseConfigurationOptions.gif)
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
![oracle 10g default database name oracle 10g default database name](https://logic.edchen.org/wp-content/uploads/2/2017/01/db_name_db_unique_name_instance_name.png)
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