10g ASM下修改control file的位置

最新推荐文章于 2025-08-08 11:12:28 发布

weixin_30664615

最新推荐文章于 2025-08-08 11:12:28 发布

阅读量68

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/nazeebodan/p/3820098.html

本文详细介绍了数据库备份、恢复及管理的关键步骤，包括关闭数据库、备份控制文件、修改控制文件位置、启动数据库并验证备份的有效性。

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

1.查看位置以及name是否正确

SQL> sho parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string
db_name                              string      orcl
db_unique_name                       string      orcl
global_names                         boolean     FALSE
instance_name                        string      orcl
lock_name_space                      string
log_file_name_convert                string
service_names                        string      orcl
SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      +DG1/orcl/controlfile/current.
                                                 261.851893233, +DG1/orcl/contr
                                                 olfile/current.260.851893233

2.关闭数据库，关闭数据库之前一定做好备份哦

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

3.启动数据库到mount状态

SQL> startup mount
ORACLE instance started.

Total System Global Area 1610612736 bytes
Fixed Size                  2084296 bytes
Variable Size             385876536 bytes
Database Buffers         1207959552 bytes
Redo Buffers               14692352 bytes
Database mounted.

4.备份一个新的control file，并修改control file的位置

SQL> alter database backup controlfile to '+DG1/orcl/controlfile/controlfile03';

Database altered.

SQL> alter system set control_files='+DG1/orcl/controlfile/current.261.851893233','+DG1/orcl/controlfile/controlfile03' scope=spfile;

System altered.

5.关闭数据库，再启动，再检查

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1610612736 bytes
Fixed Size                  2084296 bytes
Variable Size             385876536 bytes
Database Buffers         1207959552 bytes
Redo Buffers               14692352 bytes
Database mounted.
Database opened.
SQL> show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string
db_name                              string      orcl
db_unique_name                       string      orcl
global_names                         boolean     FALSE
instance_name                        string      orcl
lock_name_space                      string
log_file_name_convert                string
service_names                        string      orcl
SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      +DG1/orcl/controlfile/current.
                                                 261.851893233, +DG1/orcl/contr
                                                 olfile/controlfile03