Files in Support of Backup and Recovery Operations - Oracle RMAN for Absolute Beginners - page 57

Next, edit the /tmp/mv.sql file, and change the names of the directory paths to the new locations. Here is a
CREATE CONTROLFILE statement for this example:
CREATE CONTROLFILE REUSE DATABASE "O12C" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 4
MAXDATAFILES 1024
MAXINSTANCES 1
MAXLOGHISTORY 876
LOGFILE
GROUP 1 (
'/u01/oraredo/O12C/redo01a.rdo',
'/u02/oraredo/O12C/redo01b.rdo'
) SIZE 50M BLOCKSIZE 512,
GROUP 2 (
'/u01/oraredo/O12C/redo02a.rdo',
'/u02/oraredo/O12C/redo02b.rdo'
) SIZE 50M BLOCKSIZE 512,
GROUP 3 (
'/u01/oraredo/O12C/redo03a.rdo',
'/u02/oraredo/O12C/redo03b.rdo'
) SIZE 50M BLOCKSIZE 512
DATAFILE
'/u01/dbfile/O12C/system01.dbf',
'/u01/dbfile/O12C/sysaux01.dbf',
'/u01/dbfile/O12C/undotbs01.dbf',
'/u01/dbfile/O12C/users01.dbf'
CHARACTER SET AL32UTF8;
Now, shut down the database:
SQL> shutdown immediate;
Physically move the files from the OS prompt. This example uses the Linux/Unix mv command to move the files:
$ mv /u02/dbfile/O12C/system01.dbf /u01/dbfile/O12C/system01.dbf
$ mv /u02/dbfile/O12C/sysaux01.dbf /u01/dbfile/O12C/sysaux01.dbf
$ mv /u02/dbfile/O12C/undotbs01.dbf /u01/dbfile/O12C/undotbs01.dbf
$ mv /u02/dbfile/O12C/users01.dbf /u01/dbfile/O12C/users01.dbf
Start up the database in nomount mode:
SQL> startup nomount;
Then, execute the file that contains the CREATE CONTROLFILE statement (in this example, mv.sql ):
SQL> @/tmp/mv.sql