添加删除controfile (spfile)

最新推荐文章于 2026-05-12 09:06:09 发布

原创最新推荐文章于 2026-05-12 09:06:09 发布 · 328 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

oracle入门专栏收录该内容

43 篇文章

订阅专栏

本文介绍如何在Oracle数据库中添加和删除控制文件。通过修改参数文件(spfile)来更新控制文件的位置，并展示了创建新控制文件的具体步骤。

学习笔记：添加删除controfile (spfile)

SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /home/oracle/app/product/11.2.
0/db_1/dbs/spfileorcl.ora

SQL> select * from v$controlfile;

STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- ------------------------------------------------------------ --- ---------- --------------
/home/oracle/app/oradata/orcl/control01.ctl NO 16384 594
/home/oracle/app/fast_recovery_area/orcl/control02.ctl NO 16384 594

SQL> show parameter control

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string /home/oracle/app/oradata/orcl/
control01.ctl, /home/oracle/ap
p/fast_recovery_area/orcl/cont
rol02.ctl
control_management_pack_access string DIAGNOSTIC+TUNING

SQL> alter system set control_files='/home/oracle/app/oradata/orcl/control01.ctl','/home/oracle/app/fast_recovery_area/orcl/control02.ctl','/home/oracle/app/oradata/orcl/control03.ctl' scope=spfile;

SQL> shutdown immediate

[oracle@localhost ~]$ cd /home/oracle/app/oradata/orcl/
[oracle@localhost orcl]$ ls
control01.ctl redo01.log redo02.log redo03.log sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf
[oracle@localhost orcl]$
[oracle@localhost orcl]$ cp control01.ctl control03.ctl

SQL> startup