How to move VMware Workstation 11 virtual machine to ESXI 6.0 Server

Step by Step guide download document here

How to move oracle datafile, redo log files and control file to a new location

# MOVING DATAFILE TO NEW LOCATION

To check the current location login to database as sysdba

SQL> startup mount

SQL> select name from v$datafile;

NAME
————————————————————————————————————————————————
/u01/app/oracle/oradata/DB11G/system01.dbf
/u01/app/oracle/oradata/DB11G/sysaux01.dbf
/u01/app/oracle/oradata/DB11G/undotbs01.dbf
/u01/app/oracle/oradata/DB11G/users01.dbf
/u01/app/oracle/oradata/DB11G/example01.dbf
/u01/app/oracle/oradata/DB11G/mgmt_depot.dbf
/u01/app/oracle/oradata/DB11G/mgmt.dbf
/u01/app/oracle/oradata/DB11G/mgmt_ad4j.dbf

8 rows selected.

Need to move from above location to /u02/oracle/oradata/DB11G/

SQL> shutdown immediate

# Now move the files from source to the required destination

SQL> host mv /u01/app/oracle/oradata/DB11G/users01.dbf /u02/oracle/oradata/DB11G/users01.dbf
SQL> host mv /u01/app/oracle/oradata/DB11G/undotbs01.dbf /u02/oracle/oradata/DB11G/undotbs01.dbf
SQL> host mv /u01/app/oracle/oradata/DB11G/sysaux01.dbf /u02/oracle/oradata/DB11G/sysaux01.dbf
SQL> host mv /u01/app/oracle/oradata/DB11G/system01.dbf /u02/oracle/oradata/DB11G/system01.dbf
SQL> host mv /u01/app/oracle/oradata/DB11G/example01.dbf /u02/oracle/oradata/DB11G/example01.dbf
SQL> host mv /u01/app/oracle/oradata/DB11G/mgmt_depot.dbf /u02/oracle/oradata/DB11G/mgmt_depot.dbf
SQL> host mv /u01/app/oracle/oradata/DB11G/mgmt.dbf /u02/oracle/oradata/DB11G/mgmt.dbf
SQL> host mv /u01/app/oracle/oradata/DB11G/mgmt_ad4j.dbf /u02/oracle/oradata/DB11G/mgmt_ad4j.dbf

alter database rename file ‘/u01/app/oracle/oradata/DB11G/users01.dbf’ to ‘/u02/oracle/oradata/DB11G/users01.dbf’
alter database rename file ‘/u01/app/oracle/oradata/DB11G/undotbs01.dbf’ to ‘/u02/oracle/oradata/DB11G/undotbs01.dbf’
alter database rename file ‘/u01/app/oracle/oradata/DB11G/sysaux01.dbf’ to ‘/u02/oracle/oradata/DB11G/sysaux01.dbf’
alter database rename file ‘/u01/app/oracle/oradata/DB11G/system01.dbf’ to ‘/u02/oracle/oradata/DB11G/system01.dbf’
alter database rename file ‘/u01/app/oracle/oradata/DB11G/mgmt_depot.dbf’ to ‘/u02/oracle/oradata/DB11G/mgmt_depot.dbf’
alter database rename file ‘/u01/app/oracle/oradata/DB11G/mgmt.dbf’ to ‘/u02/oracle/oradata/DB11G/mgmt.dbf’
alter database rename file ‘/u01/app/oracle/oradata/DB11G/mgmt_ad4j.dbf’ to ‘/u02/oracle/oradata/DB11G/mgmt_ad4j.dbf’

MOVING REDOLOG FILE TO NEW LOCATION

host mv /u01/app/oracle/oradata/DB11G/redo01.log /u02/oracle/oradata/DB11G/
host mv /u01/app/oracle/oradata/DB11G/redo02.log /u02/oracle/oradata/DB11G/
host mv /u01/app/oracle/oradata/DB11G/redo03.log /u02/oracle/oradata/DB11G/

alter database rename file ‘/u01/app/oracle/oradata/DB11G/redo01.log’ to ‘/u02/oracle/oradata/DB11G/redo01.log’
alter database rename file ‘/u01/app/oracle/oradata/DB11G/redo02.log’ to ‘/u02/oracle/oradata/DB11G/redo02.log’
alter database rename file ‘/u01/app/oracle/oradata/DB11G/redo03.log’ to ‘/u02/oracle/oradata/DB11G/redo03.log’

MOVING CONTROL FILE TO NEW LOCATION

SQL> select name from v$controlfile;

NAME
——————————————————————————–
/u01/app/oracle/oradata/DB11G/control01.ctl
/u01/app/oracle/flash_recovery_area/DB11G/control02.ctl

or

SQL> show parameter control_file;

NAME TYPE VALUE
———————————— ———– ——————————
control_file_record_keep_time integer 7
control_files string /u01/app/oracle/oradata/DB11G/
control01.ctl, /u01/app/oracle
/flash_recovery_area/DB11G/con
trol02.ctl

SQL> shutdown immediate

SQL> create pfile from spfile;

SQL> host vi /u02/oracle/product/11.2.0.3/db01/dbs/initDB11G.ora

change the control

SQL> host cp /u01/app/oracle/oradata/DB11G/control01.ctl /u02/oracle/oradata/DB11G/control01.ctl
SQL> host cp /u01/app/oracle/flash_recovery_area/DB11G/control02.ctl /u02/oracle/flash_recovery_area/control02.ctl

SQL> create spfile from pfile;

SQL> startup
ORACLE instance started.

Total System Global Area 3223535616 bytes
Fixed Size 2232680 bytes
Variable Size 1795165848 bytes
Database Buffers 1409286144 bytes
Redo Buffers 16850944 bytes
Database mounted.
Database opened.
SQL> show parameter control_file;

NAME TYPE VALUE
———————————— ———– ——————————
control_file_record_keep_time integer 7
control_files string /u02/oracle/oradata/DB11G/cont
rol01.ctl, /u02/oracle/flash_r
ecovery_area/control02.ctl