Oracle 更改数据文件、控制文件、redo位置实验.docx

Oracle 更改数据文件、控制文件、redo位置实验实验环境操作系统：虚拟机solaris 10数据库：10g R2数据库环境：.bash_profile ORACLE_SID=orclORACLE_BASE=/u01ORACLE_HOME=$ORACLE_BASE/oraclePATH=$ORACLE_HOME/bin:$PATH原数据文件位置：/u02/orcldata/orcl包括：control01.ctl control03.ctl redo02.log sysaux01.dbf temp01.dbf users01.dbfcontrol02.ctl redo01.log redo03.log system01.dbf undotbs01.dbf实验目标创建新文件夹/u03/orcldata将数据文件从原位置/u02/orcldata/orcl，迁移到新位置/u03/orcldata将控制文件以及redo 更改到新位置实验步骤1、-bash-3.00# mkdir -p /u03/orcldata2、-bash-3.00# su - oracleSun Microsystems Inc. SunOS 5.10 Generic January 2005-bash-3.00$ sqlplus / as sysdbaSQL alter database backup controlfile to trace;Database altered.SQL select group#,status from v$log; GROUP# STATUS---------- ---------------- 1 INACTIVE 2 CURRENT 3 INACTIVESQL select * from v$ logfile; GROUP# STATUS TYPE---------- ------- -------MEMBER--------------------------------------------------------------------------------IS_--- 1 ONLINE/u02/orcldata/orcl/redo01.logNO 2 ONLINE/u02/orcldata/orcl/redo02.logNO GROUP# STATUS TYPE---------- ------- -------MEMBER--------------------------------------------------------------------------------IS_--- 3 ONLINE/u02/orcldata/orcl/redo03.logNOSQL alter system switch logfile;System altered.SQL create pfile=$ORACLE_HOME/dbs/initorcl.ora from spfile;File created.SQL shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.bash-3.00$ cd $ORACLE_HOME/dbsbash-3.00$ vi initorcl.ora将控制文件路径从/u02/orcldata/orcl更改为新路径：*.control_files=/u03/orcldata/control01.ctl,/u03/orcldata/control02.ctl,/u03/orcldata/control03.ctlMove 数据文件、控制文件到新位置/u03/orcldata修改权限为oracle:dba -bash-3.00# chown -R oracle:dba /u03-bash-3.00$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.2.0 - Production on Mon Oct 25 12:50:22 2010Copyright (c) 1982, 2005, Oracle. All Rights Reserved.Connected to an idle instance.SQL startup mount pfile=$ORACLE_HOME/dbs/initorcl.ora;ORACLE i