河北pc端网站开发,网站配置域名,凡科网怎么做网站,腾讯网页游戏平台如果可以关闭数据库#xff0c;可以采用下述步骤。如果不能关闭数据库#xff0c;只能采用新建redo log files的方式来实现修改该redo 的路径了。一、shutdown the database二、拷贝redo log 文件到新的位置三、mount database四、重命名redo五、open database--1 .shutdown…如果可以关闭数据库可以采用下述步骤。如果不能关闭数据库只能采用新建redo log files的方式来实现修改该redo 的路径了。一、shutdown the database二、拷贝redo log 文件到新的位置三、mount database四、重命名redo五、open database--1 .shutdown the databaseSQL shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL exit-- 2.拷贝redo log 文件到新的位置[oracleoradb01 orcl]$ mv /opt/ora11g/oradata/orcl/redo01.log /opt/ora11g/oradata/orcl/ctl/redo01.rdo[oracleoradb01 orcl]$mv /opt/ora11g/oradata/orcl/redo02.log /opt/ora11g/oradata/orcl/ctl/redo02.rdo[oracleoradb01 orcl]$ mv /opt/ora11g/oradata/orcl/redo03.log /opt/ora11g/oradata/orcl/ctl/redo03.rdo[oracleoradb01 orcl]$ cd ctl[oracleoradb01 ctl]$ lsredo01.rdo redo02.rdo redo03.rdo[oracleoradb01 ctl]$ lltotal 153792-rw-r----- 1 oracle dba 52429312 Nov 14 10:43 redo01.rdo-rw-r----- 1 oracle dba 52429312 Nov 14 10:43 redo02.rdo-rw-r----- 1 oracle dba 52429312 Nov 14 11:00 redo03.rdo[oracleoradb01 ctl]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 14 11:08:58 2011Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to an idle instance.--3 mount databaseSQL startup mountORACLE instance started.Total System Global Area 3273641984 bytesFixed Size 2232800 bytesVariable Size 721423904 bytesDatabase Buffers 2533359616 bytesRedo Buffers 16625664 bytesDatabase mounted.--4 重命名redo log filesSQL ALTER DATABASE RENAME FILE /opt/ora11g/oradata/orcl/redo01.log ,/opt/ora11g/oradata/orcl/redo02.log,/opt/ora11g/oradata/orcl/redo03.log 2 to /opt/ora11g/oradata/orcl/ctl/redo01.rdo,/opt/ora11g/oradata/orcl/ctl/redo02.rdo,/opt/ora11g/oradata/orcl/ctl/redo03.rdo 3 ;Database altered.-- 5. open databaseSQL alter database open;Database altered.
