Oracle 9i Database Movement Process
Author: Unknown database move in the project implementation process, often occur, for experienced DBA, a database move is very easy. But for some people who only understand the system, the data is not very understanding, Oracle's move is not that capacity. For example, when the system installation is complete, the storage space expands, and it is necessary to move the original to Oracle, and data movement is required. Previously, it can be moved in Oracle8i for Windows 2000. What is the movement of Oracle9i FOR AIX 5L now? ? ? In fact, through various platforms, the operation process is exactly the same. I. Copy the mobile data file 1), get the database related information first to view the file content: SQLPLUS "/ as sysdba"? SQLPLUS "/ as sysdba"? SQLPLUS "/ as sysdba"? SELECT * from V $ datafile? SELECT * FROM V $ controlfile? SELECT * FROM V $ logfile 2), mobile application data files shutdown immediate Turn off the database, copy the data file to another directory. The files that need COPY are: system01.dbf index01.dbf temp01.dbf users01.dbf application data file 3), modify the location of the database file Start Mount mode? Startup Mount;? Alter Database Rename File '/ Oracle / ORADATA / OCP / SYSTEM01 .dbf 'to' /oradata/ocp/system01.dbf "? Alter Database Rename File '/oracle/roadata/ocp/indx01.dbf' to '/oradata/ocp/indx01.dbf'; pay only changes to change Database file, does not include control files and log files, Temp files. 2. Mobile control file (1) Backup SPFILE:? Startup;? Crete pfile = 'c: /init.ora' from SPFILE ; (2) Modify the content in the init.ora file: * .control_files = '/ oradata / OCP / Control01.ctl', '/ ORADATA / OCP / Control02.ctl', '/ ORADATA / OCP / Control03.ctl' Change the replicated directory location. SHUTDOWN Database (3) Copy the control file in the past, move the three control files to the directory you modified above. (4) Pour the parameter file Start in the init.ora parameter:? Startup Pfile = '/ ORACLE / INIT.ORA';? CREATE SPFILE from Pfile = '/ ORACLE / INIT.ORA';? Shutdown Immediate;? STARTUP; starts from spfile. This control file is over. Third, There are two ways to reconstruct or relocate the log file to resolve the log file. One is another way to recreate. (1) Moving log files Renovated database files with mobile system database files , Just ask the database must be "startup mount" mode.
