The background of database migration to the same machine is explained in detail. to free up the disk space occupied by the principle database/hypdata, the Information Department adds another disk to it, the directory is/hypdata47. We need to port the current/hypdata to/hypdata47. 1. Back up the shutdown immedaite oracle database and back up the control file to trace cd/hypdata/tar-cvf cd/hypdata47/app20130526.rar app to back up the database user orahyp. profile file, cp. profile. profile20130526 2. Restore 1 and set. change/hypdata to/hypdata47 cd/hypdata47 2 tar-xvf cd/hypdata47/app20130526.rar 3 modify pfile parameter cd $ ORACLE_HOME [orahyp @ bi01 dbs] $ pwd/hypdata/ app/oracle/product/10.2.0/dbhome_1/dbs [orahyp @ bi01 dbs] $ ls-l total 920-rw-r ----- 1 orahyp dba 412404 May 26 01 alert_HYP.log-rw ---- 1 orahyp dba 1552 May 26 hc_HYP.dat-rw-r ----- 1 orahyp dba 8385 Sep 11 1998 init. ora-rw-r -- 1 orahyp dba 1185 Jul 25 2011 initHYP. ora-rw-r -- 1 orahyp dba 1077 Dec 12 2010 initHYP. ora. bak-rw-r -- 1 orahyp dba 1185 May 26 initHYP. ora20130526-rw-r -- 1 orahyp dba 12920 May 03 2001 initdw. ora-rw-r ----- 1 orahyp dba 24 Aug 27 2010 lkHYP-rw-r ----- 1 orahyp dba 1536 Nov 13 2012 orapwHYP-rw-r ----- 1 orahyp dba 3584 Aug 31 2010 spfileHYP. orabck 4. recreate the control file su-orahyp sqlplus "/as sysdba" SQL> @ recon. SQL [orahyp @ bi01 HYP] $ vi recon. SQL "recon. SQL "30 lines, 1500 characters startup nomount create controlfile set database "HYP" RESETLOGS allow MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 logfile group 1'/hypdata47/app/oracle/product/10.2.0/db_data/ HYP/logHYP01a. log 'size 200 M, GROUP 2'/hypdata47/app/oracle/product/10.2.0/db_data/HYP/logHYP02a. log 'size 200 M, GROUP 3'/hypdata47/app/oracle/product/10.2.0/db_data/HYP/logHYP03a. log'size 200 M, GROUP 4'/hypdata47/app/oracle/product/10.2.0/db_data/HYP/logHYP04a. log 'size 200 M, GROUP 5'/hypdata47/app/oracle/product/10.2.0/db_data/HYP/logHYP05a. log 'size 200 M, GROUP 6'/hypdata47/app/oracle/product/10.2.0/db_data/HYP/logHYP06a. log'size 200 M, GROUP 7'/hypdata47/app/oracle/product/10.2.0/db_data/HYP/logHYP07a. log 'size 200 M -- standby logfile datafile'/hypdata47/app/oracle/product/10.2.0/db_data/HYP/system01.dbf ', '/hypdata47/app/oracle/product/10.2.0/db_data/HYP/undotbs01.dbf','/hypdata47/app/oracle/product/10.2.0/db_data/HYP/sysaux01.dbf ', '/hypdata47/app/oracle/product/10.2.0/db_data/HYP/users01.dbf','/hypdata47/app/oracle/product/10.2.0/db_data/HYP/hfm. dbf', '/hypdata47/app/oracle/product/10.2.0/db_data/HYP/undotbs02.dbf ', '/hypdata47/app/oracle/product/10.2.0/db_data/HYP/infa01.dbf' character set UTF8; alter database open resetlogs; alter tablespace temp add tempfile '/hypdata47/app/oracle/product/10.2.0/db_data/HYP/temp01.dbf 'size 1024 m reuse autoextend on next 655360 MAXSIZE 32767 M;