Oracle 10g减少和增加控制文件个数

一 .减少控制文件，有一个控制文件损坏，我们要将损坏的控制文件剔除。步骤：
1.修改参数文件，并验证
2.停止数据库
3.启动数据库
4.验证,查看v$controlfile下面是实际操作过程。
1 . 用sysdba用户登录数据库。 [Oracle@oracle ~]$ sqlplus oracle/oracle as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 3 01:24:57 2012Copyright （c） 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> show user
USER is "SYS"
SQL> 2 . 先查看一下，控制文件. SQL> select * from v$controlfile;STATUS NAME                                               IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- -------------------------------------------------- --- ---------- --------------
        /fantlam/oradata/fantlam/control01.ctl             NO       16384            430
        /fantlam/oradata/fantlam/control02.ctl             NO       16384            430
        /fantlam/oradata/fantlam/control03.ctl             NO       16384            430 3. 修改参数文件 SQL> alter system set control_files=
2 "/fantlam/oradata/fantlam/control01.ctl","/fantlam/oradata/fantlam/control02.ctl" scope=spfile;System altered. 这个时候查看控制文件并没有改变。 SQL> select * from v$controlfile;STATUS NAME                                               IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- -------------------------------------------------- --- ---------- --------------
        /fantlam/oradata/fantlam/control01.ctl             NO       16384            430
        /fantlam/oradata/fantlam/control02.ctl             NO       16384            430
        /fantlam/oradata/fantlam/control03.ctl             NO       16384            430
4. 关闭数据库 SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down. 5. 启动数据库 SQL> startup
ORACLE instance started.Total System Global Area 268435456 bytes
Fixed Size                  1218868 bytes
Variable Size              79693516 bytes
Database Buffers          180355072 bytes
Redo Buffers                7168000 bytes
Database mounted.
Database opened. 6. 查看控制文件是否改变 SQL> select * from v$controlfile;STATUS NAME                                               IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- -------------------------------------------------- --- ---------- --------------
        /fantlam/oradata/fantlam/control01.ctl             NO       16384            430
        /fantlam/oradata/fantlam/control02.ctl             NO       16384            430 已经由原来的三个变成了两个。二. 增加控制文件的个数主要操作步骤：1.修改参数文件
2.停止数据库
3.复制控制文件
4.启动数据库
5.验证,查看v$controlfile下面是实际操作步骤：1. 修改参数文件 SQL> alter system set control_files=
2 "/fantlam/oradata/fantlam/control01.ctl",
3 "/fantlam/oradata/fantlam/control02.ctl",
4 "/fantlam/oradata/fantlam/controlfile/control03.ctl"
5 scope=spfile;System altered. 2. 关闭数据库 SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down. 3. 复制控制文件到刚才指定的位置 host cp /fantlam/oradata/fantlam/control02.ctl /fantlam/oradata/fantlam/controlfile/control03.ctl 4. 启动数据库 SQL> startup
ORACLE instance started.Total System Global Area 268435456 bytes
Fixed Size                  1218868 bytes
Variable Size              79693516 bytes
Database Buffers          180355072 bytes
Redo Buffers                7168000 bytes
Database mounted.
Database opened. 5. 查看v$controlfile视图验证 SQL> select * from v$controlfile;STATUS NAME                                               IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- -------------------------------------------------- --- ---------- --------------
        /fantlam/oradata/fantlam/control01.ctl             NO       16384            430
        /fantlam/oradata/fantlam/control02.ctl             NO       16384            430
        /fantlam/oradata/fantlam/controlfile/control03.ctl NO       16384            430 Oracle重做日志文件版本不一致问题处理MySQL服务无法启动（1067）问题相关资讯 ORACLE 10G

Oracle 10g（10.2.0.4）升级到10.2.0 （04月10日）
Oracle 10g 一主多备的搭建技巧（07/31/2015 15:31:51）
多平台下的32位和64位Oracle 10g下（02/18/2015 10:38:21）

Oracle 10g实现只读表的N种方法（08/05/2015 10:54:35）
Oracle 10g中约束与列属性NULLABLE （03/07/2015 19:22:46）
Oracle 10g Clusterware Votedisk （01/16/2015 14:09:54）

本文评论查看全部评论（0）

表情：姓名：匿名字数

</t        </div>
                <div style="text-align: center;padding:20px;">
            <button class="layui-btn layui-bg-purple" id="dofav">收藏该网址</button>
        </div>
    </div>
</div>
<div class="copyright">
    <div id="footbar">
        版权所有©石家庄振强科技有限公司2024 <a href="https://beian.miit.gov.cn" target="_blank">冀ICP备08103738号-5</a> <a href="/storage/sitemap.xml">网站地图</a>
    </div>
</div>
<script> var _mtj = _mtj || [];
(function () {
    var mtj = document.createElement("script");
    mtj.src = "https://node12.aizhantj.com:21233/tjjs/?k=p2tceukth5c";
    var s = document.getElementsByTagName("script")[0];
    s.parentNode.insertBefore(mtj, s);
})(); </script>
<script src="/static/lib/layui/layui.js"></script>
<script src="/static/lib/jquery/jquery.js"></script>
<script src="/static/lib/ajax.js"></script>
<script>
    layui.use(function () {
        var layer = layui.layer;
        var $ = layui.jquery;
        $("#dofav").click(function () {
            var artid = $(".article").attr("artid");
            var params={
                artid:artid,
                addtype:'escdns_article',
                t:Math.random()
            };
            if(artid>0){
                ajax.request({
                    method: "/index/article/addfavorite", type: "post", callback: function (res) {
                        layer.msg(res.msg);
                    }
                },params);
            }
        })
    })
</script>
</body>
</html>