Oracle控制文件多路复用

最新推荐文章于 2023-11-22 17:00:18 发布

ZhongWeicheng

最新推荐文章于 2023-11-22 17:00:18 发布

阅读量1.6k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle 文章标签： oracle Oracle ORACLE

本文链接：https://blog.youkuaiyun.com/staricqxyz/article/details/8314599

Oracle 专栏收录该内容

165 篇文章

订阅专栏

本文介绍如何查询、修改Oracle数据库中的控制文件路径，并通过实例演示了如何将新的控制文件路径设置到SPFILE中，以及如何在关闭数据库后复制控制文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

查询控制文件路径

SYS@zwcdb:~>SELECT name FROM v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/primarydb/control01.ctl
/u01/app/oracle/oradata/primarydb/control02.ctl
/u01/app/oracle/oradata/primarydb/control03.ctl

修改spfile

SYS@zwcdb:~>ALTER system SET control_files=
  2  '/u01/app/oracle/oradata/primarydb/control01.ctl',
  3  '/u01/app/oracle/oradata/primarydb/control02.ctl',
  4  '/u01/app/oracle/oradata/primarydb/control03.ctl',
  5  '/u01/app/control04.ctl' scope=spfile;

System altered.

关闭数据库,复制控制文件至/u01/app下

SYS@zwcdb:~>shutdown immediate
DATABASE closed.
DATABASE dismounted.
ORACLE instance shut down.
SYS@zwcdb:~>exit
Disconnected FROM Oracle DATABASE 10g Enterprise Edition Release 10.2.0.1.0 - Production
WITH the Partitioning, OLAP AND DATA Mining options
[oracle@zwc ~]$ cp /u01/app/oracle/oradata/primarydb/control01.ctl /u01/app/control04.ctl

重新启动数据库并验证

[oracle@zwc ~]$ sqlplus / AS sysdba

SQL*Plus: Release 10.2.0.1.0 - Production ON Fri Jan 6 10:35:05 2012

Copyright (c) 1982, 2005, Oracle.  ALL rights reserved.

Connected TO an idle instance.

SYS@zwcdb:~>startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed SIZE                  1218992 bytes
Variable SIZE              92276304 bytes
DATABASE Buffers          188743680 bytes
Redo Buffers                2973696 bytes
DATABASE mounted.
DATABASE opened.
SYS@zwcdb:~>
SYS@zwcdb:~>SELECT name FROM v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/primarydb/control01.ctl
/u01/app/oracle/oradata/primarydb/control02.ctl
/u01/app/oracle/oradata/primarydb/control03.ctl
/u01/app/control04.ctl

SYS@zwcdb:~>SELECT VALUE FROM v$spparameter WHERE name='control_files';

VALUE
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/primarydb/control01.ctl
/u01/app/oracle/oradata/primarydb/control02.ctl
/u01/app/oracle/oradata/primarydb/control03.ctl
/u01/app/control04.ctl