Windows 平台oracle11g修改控制文件路径

折耳根做羹

于 2023-02-23 17:54:31 发布

阅读量824

点赞数

分类专栏： oracle 文章标签：数据库 sql

本文链接：https://blog.csdn.net/y1988123/article/details/129186722

版权

oracle 专栏收录该内容

5 篇文章 1 订阅

订阅专栏

1.查看路径

select status,name from v$controlfile;
show parameter control_files;

D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL, D:\APP\ADMINISTRATOR\FAST_RECOV
ERY_AREA\ORCL\CONTROL02.CTL

2.修改参数文件

alter system set control_files='E:\app\oradata\orcl\CONTROL01.CTL','E:\app\oradata\orcl\CONTROL02.CTL'scope=spfile;

3.重启数据库

SQL> shutdown immediate;
SQL> startup
ORACLE instance started.

Total System Global Area 5094195200 bytes
Fixed Size                  2290056 bytes
Variable Size            1006636664 bytes
Database Buffers         4076863488 bytes
Redo Buffers                8404992 bytes
Database mounted.
Database opened.

4.验证

SQL> show parameter control_files;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_files                        string      E:\APP\ORADATA\ORCL\CONTROL01.
                                                 CTL, E:\APP\ORADATA\ORCL\CONTR
                                                 OL02.CTL