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

经典word整理文档，仅参考，双击此处可删除页眉页脚。本资料属于网络整理，如有侵权，请联系删除，谢谢！Oracle更改数据文件、控制文件、redo位置实验一、实验环境操作系统：虚拟机solaris10数据库：10gR2数据库环境：.bash_profileORACLE_SID=orclORACLE_BASE=/u01ORACLE_HOME=$ORACLE_BASE/oraclePATH=$ORACLE_HOME/bin:$PATH原数据文件位置：/u02/orcldata/orcl包括：control01.ctlcontrol03.ctlredo02.logsysaux01.dbftemp01.dbfusers01.dbfcontrol02.ctlredo01.logredo03.logsystem01.dbfundotbs01.dbf二、实验目标创建新文件夹/u03/orcldata将数据文件从原位置/u02/orcldata/orcl，迁移到新位置/u03/orcldata将控制文件以及redo更改到新位置三、实验步骤1、-bash-3.00#mkdir-p/u03/orcldata2、-bash-3.00#su-oracleSunMicrosystemsInc.SunOS5.10GenericJanuary2005-bash-3.00$sqlplus/assysdbaSQL>alterdatabasebackupcontrolfiletotrace;Databasealtered.SQL>selectgroup#,statusfromv$log;GROUP#STATUS--------------------------1INACTIVE2CURRENT3INACTIVESQL>select*fromv$logfile;GROUP#STATUSTYPE------------------------MEMBER--------------------------------------------------------------------------------IS_---1ONLINE/u02/orcldata/orcl/redo01.logNO2ONLINE/u02/orcldata/orcl/redo02.logNOGROUP#STATUSTYPE------------------------MEMBER--------------------------------------------------------------------------------IS_---3ONLINE/u02/orcldata/orcl/redo03.logNOSQL>altersystemswitchlogfile;Systemaltered.SQL>createpfile='$ORACLE_HOME/dbs/initorcl.ora'fromspfile;Filecreated.SQL>shutdownimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.bash-3.00$cd$ORACLE_HOME/dbsbash-3.00$viinitorcl.ora将控制文件路径从/u02/orcldata/orcl更改为新路径：*.control_files='/u03/orcldata/control01.ctl','/u03/orcldata/control02.ctl','/u03/orcldata/control03.ctl'Move数据文件、控制文件到新位置/u03/orcldata修改权限为oracle:dba-bash-3.00#chown-Roracle:dba/u03-bash-3.00$sqlplus/assysdbaSQL*Plus:Release10.2.0.2.0-ProductiononMonOct2512:50:222010Copyright(c)1982,2005,Oracle.AllRightsReserved.Connectedtoanidleinstance.SQL>startupmountpfile='$ORACLE_HOME/dbs/initorcl.ora';ORACLEinstancestarted.SQL>alterdatabaserenamefile'/u02/orcldata/orcl/sysaux01.dbf'to'/u03/orcldata/sysaux01.dbf';Databasealtered.SQL>alterdatabaserenamefile'/u02/orcldata/orcl/undotbs01.dbf'to'/u03/orcldata/undotbs01.dbf';Databasealtered.SQL>alterdatabaserenamefile'/u02/orcldata/orcl/system01.dbf'to'/u03/orcldata/system01.dbf';Databasealtered.SQL>alterdatabaserenamefile'/u02/orcldata/orcl/users01.dbf'to'/u03/orcldata/users01.dbf';Databasealtered.SQL>alterdatabaserenamefile'/u02/orcldata/orcl/temp01.dbf'to'/u03/orcldata/temp01.dbf';Databasealtered.SQL>alterdatabaseopen;Databasealtered.SQL>alterdatabaseaddlogfilemember'/u03/orcldata/redo01_b.log'togroup1;Databasealtered.SQL>alterdatabaseaddlogfilemember'/u03/orcldata/redo02_b.log'togroup2;Databasealtered.SQL>alterdatabaseaddlogfilemember'/u03/orcldata/redo03_b.log'togroup3;Databasealtered.SQL>altersystemswitchlogfile;Systemaltered.SQL>/Systemaltered.SQL>selectgroup#,statusfromv$Logfile;GROUP#STATUS-----------------123123SQL>alterdatabasedroplogfilemember'/u02/orcldata/orcl/redo01.log';Databasealtered.SQL>alterdatabasedroplogfilemember'/u02/orcldata/orcl/redo02.log';Databasealtered.SQL>alterdatabasedroplogfilemember'/u02/orcldata/orcl/redo03.log';alterdatabasedroplogfilemember'/u02/orcldata/orcl/redo03.log'*ERRORatline1:ORA-01609:log3isthecurrentlogforthread1-cannotdropmembersORA-00312:onlinelog3thread1:'/u02/orcldata/orcl/redo03.log'ORA-00312:onlinelog3thread1:'/u03/orcldata/redo03_b.log'SQL>altersystemswitchlogfile;Systemaltered.SQL>alterdatabasedroplogfilemember'/u02/orcldata/orcl/redo03.log';Databasealtered.SQL>selectgroup#,statusfromv$Logfile;GROUP#STATUS-----------------123SQL>select*fromv$logfile;GROUP#STATUSTYPE------------------------MEMBER--------------------------------------------------------------------------------IS_---1ONLINE/u03/orcldata/redo01_b.logNO2ONLINE/u03/orcldata/redo02_b.logNOGROUP#STATUSTYPE------------------------MEMBER-------