Steps for migrating data from the Rational ClearQuest background database to the ex300array in the mobile development management system

Step 1 of ORACLE data migration from the CQ back-end database of the mobile development management system to the ex300array objective: Oracle programs are stored on the local hard disk (disk D) and data is stored on the ex300disk array (Disk Y ), you must manually switch the disk array to run the same oracle database on the two servers (10.25.4.162 and 10.25.4.163. Database Backup: Use exp export to back up data to the local hard disk. 2. Procedure: Set 10.25.4.162 to machine A, and set 10.25.4.163 to machine B. The Oracle program has been installed on machine A. The installation location is D:/Oracle, the data location is D:/Oracle/oradata, And the dump file is located under D:/Oracle/admin, sid is oradev. 2.1 install the Oracle program on drive B, generate the oradev database, stop Oracle services, set services to manual start, and delete D:/Oracle/admin and D: /Oracle/oradata directory. 2.2 query the Oracle Data File Location on server a SQL> Conn/As sysdba; connected. SQL> SELECT FILE #, name from V $ datafile; file # name ---------- Release 1 D:/Oracle/oradata/oradev/system01.dbf 2 D: /Oracle/oradata/oradev/undotbs01.dbf 3 D:/Oracle/oradata/oradev/cwmlite01.dbf 4 D:/Oracle/oradata/oradev/drsys01.dbf 5 D: /Oracle/oradata/oradev/example01.dbf 6 D:/o Racle/oradata/oradev/indx01.dbf 7 d:/Oracle/oradata/oradev/odm01.dbf 8 d:/Oracle/oradata/oradev/tools01.dbf 9 D: /Oracle/oradata/oradev/users01.dbf 10 D:/Oracle/oradata/oradev/xdb01.dbf 10 rows selected. SQL> select file #, name from V $ tempfile; file # name ---------- limit 1 D:/Oracle/oradata/oradev/temp01.dbf SQL> SQL> Select group #, member from V $ logfile; group # member ---------- Release 3 D:/Oracle/oradata/oradev/redo03.log 2 D: /Oracle/oradata/oradev/redo02.log 1 D:/Oracle/oradata/oradev/redo01.log 2.3 create pfile and stop the database, modify the locations of related dump and control file from disk D to disk y SQL> Create pfile from spfile; file created. 2.4 create the Y:/Oracle directory on disk y, cut the D:/Oracle/admin and D :/Oracle/oradata to Y:/oracle. Modify Oracle settings. SQL> Conn/As sysdba; connected to an idle instance. SQL> startup Mount pfile = D:/Oracle/ora92/database/initoradev. oraoracle instance started. total system global area 126950220 bytesfixed size 453452 bytesvariable size 109051904 bytesdatabase buffers 16777216 bytesredo buffers 667648 bytesdatabase mounted. SQL> alter database rename file 'd:/Oracle/oradata/oradev/system01.dbf 'to 'y:/Oracle/ora Data/oradev/system01.dbf '; database altered. SQL> alter database rename file 'd:/Oracle/oradata/oradev/undotbs01.dbf 'to 'y:/Oracle/oradata/oradev/undotbs01.dbf'; database altered. SQL> alter database rename file 'd:/Oracle/oradata/oradev/cwmlite01.dbf 'to 'y:/Oracle/oradata/oradev/cwmlite01.dbf'; database altered. SQL> alter database rename file 'd:/Oracle/oradata/oradev/drsys01.dbf 'to 'y:/oracl E/oradata/oradev/drsys01.dbf '; database altered. SQL> alter database rename file 'd:/Oracle/oradata/oradev/example01.dbf 'to 'y:/Oracle/oradata/oradev/example01.dbf'; database altered. SQL> alter database rename file 'd:/Oracle/oradata/oradev/indx01.dbf 'to 'y:/Oracle/oradata/oradev/indx01.dbf'; database altered. SQL> alter database rename file 'd:/Oracle/oradata/oradev/odm01.dbf 'to 'y:/Oracle/or AData/oradev/odm01.dbf '; database altered. SQL> alter database rename file 'd:/Oracle/oradata/oradev/tools01.dbf 'to 'y:/Oracle/oradata/oradev/tools01.dbf'; database altered. SQL> alter database rename file 'd:/Oracle/oradata/oradev/users01.dbf 'to 'y:/Oracle/oradata/oradev/users01.dbf'; database altered. SQL> alter database rename file 'd:/Oracle/oradata/oradev/xdb01.dbf 'to 'y:/Oracle/oradata/or Adev/xdb01.dbf '; database altered. SQL> alter database rename file 'd:/Oracle/oradata/oradev/redo01.log 'to 'y:/Oracle/oradata/oradev/redo01.log'; database altered. SQL> alter database rename file 'd:/Oracle/oradata/oradev/redo02.log 'to 'y:/Oracle/oradata/oradev/redo02.log'; database altered. SQL> alter database rename file 'd:/Oracle/oradata/oradev/redo03.log 'to 'y:/Oracle/oradata/oradev/redo03. Log'; database altered. SQL> alter database open; database altered. SQL> alter tablespace temp add tempfile 'y:/Oracle/oradata/oradev/temp01.dbf'; tablespace altered. SQL> startup pfile = D:/Oracle/ora92/database/initoradev. oraoracle instance started. total system global area 126950220 bytesfixed size 453452 bytesvariable size 109051904 bytesdatabase buffers 16777216 bytesredo buffers 667648 bytesd Atabase mounted. database opened. SQL> Create spfile from pfile; file created. SQL> shutdown immediate; database closed. database dismounted. oracle instance shut down. SQL> startup; Oracle instance started. total system global area 126950220 bytesfixed size 453452 bytesvariable size 109051904 bytesdatabase buffers 16777216 bytesredo buffers 667648 bytesdatabase mounted. database opened. 2.5. Verify the database file path. SQL> SELECT FILE #, name from V $ datafile; file # name ---------- running 1 y:/Oracle/oradata/oradev/system01.dbf 2 Y: /Oracle/oradata/oradev/undotbs01.dbf 3 Y:/Oracle/oradata/oradev/cwmlite01.dbf 4 Y:/Oracle/oradata/oradev/drsys01.dbf 5 Y: /Oracle/oradata/oradev/example01.dbf 6 Y:/Oracle/oradata/oradev/indx01.dbf 7 Y:/Orac Le/oradata/oradev/odm01.dbf 8 Y:/Oracle/oradata/oradev/tools01.dbf 9 y:/Oracle/oradata/oradev/users01.dbf 10 y: /Oracle/oradata/oradev/xdb01.dbf 10 rows selected. SQL> select group #, member from V $ logfile; group # member ---------- running 3 Y:/Oracle/oradata/oradev/redo03.log 2 Y: /Oracle/oradata/oradev/redo02.log 1 y:/o Racle/oradata/oradev/redo01.log SQL> SELECT FILE #, name from V $ tempfile; file # name ---------- limit 1 Y: /Oracle/oradata/oradev/temp01.dbf SQL> 2.6. copy a file D:/Oracle/ora92/database/spfileoradev. ora and pwdoradev. the ora file overwrites files of the same name to the same location on the machine B. 2.7 manually switch the disk and stop Oracle service. It is verified that Oracle can run normally on the two servers. 2.8 create a backup directory on drive a and an orabackup file under the root directory. CMD exp system/password @ oradev full = y file = D:/backup/oradata _ % Date :~ 0, 4% % Date :~ 5, 2% % Date :~ 8, 2%. dmp log = D:/backup/oradata _ % Date :~ 0, 4% % Date :~ 5, 2% % Date :~ 8, 2.9. log. Create a backup database for the running plan in the scheduled system task.