Common Methods for moving oracle files

Common Methods for moving oracle files-moving tablespace files 1. querying the table space file name SQL> select d. name from v $ datafile d join v $ tablespace t using (ts #) where name = 'xport'; 2. Disable Database SQL> shutdown immediate; 3. Transfer Data File SQL>! Mv/u04/oradata/xport. dbf/u06/oradata; 4. Start Database SQL> startup mount; 5. Change the path reference name in the control file, point to the new path SQL> alter database rename file '/u04/oradata/xport. dbf 'to'/u06/oradata/xport. dbf'; 6. open database SQL> alter database open; 7. Create an updated control file backup copy SQL> alter database backup controlfile to trace; -- Mobile Online log 1. query online log SQL> select group #, member from v $ logfile order by group #, member; 2. Disable Database SQL> shutdown immediate; 3. move text SQL>! Mv/u01/app/oracle/oradata/redo0 [1-3]. log/u04/data SQL> startup mount 4, rename SQL> alter database rename file '/u01/app/oracle/oradata/redo01.log' to '/u04/data/redo01.log '; SQL> alter database rename file '/u01/app/oracle/oradata/redo02.log' to '/u04/data/redo02.log '; SQL> alter database rename file '/u01/app/oracle/oradata/redo03.log' to '/u04/data/redo03.log'; 5. open database SQL> alter databse open; -- SQL> select name, value from v $ spparameter where name = 'control _ files '; SQL> show parameter control_files; SQL> alter system set control_files = '/u02/oradata/control01.ctl', '/u03/oradata/control02.ctl', '/u04/oradata/control03.ctl' scope = spfile; SQL> shutdown immediate; SQL>! Mv/u01/app/oracle/oradata/control01.ctl/u02/oradata; SQL>! Mv/u01/app/oracle/oradata/control02.ctl/u03/oradata; SQL>! Mv/u01/app/oracle/oradata/control03.ctl/u04/oradata; SQL> startup; SQL> select name, value from v $ spparameter where name = 'control _ files '; from the perspective of other books, it seems that currently the mobile dbf file has run without any problems, and others have not been tested.