11grac添加一个控制文件

一、环境

成都创新互联公司是一家专业提供安阳企业网站建设,专注与成都做网站、成都网站建设、H5页面制作、小程序制作等业务。10年已为安阳众多企业、政府机构等服务。创新互联专业网站建设公司优惠进行中。

11g rac

二、演示步骤

1. 查看控制文件路径

SYS@ysdb1>show parameter control_files

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

control_files string +DATA1/ysdb/control01.ctl

2. 关闭所有实例，启动一个实例到nomount状态，恢复一个控制文件

[oracle@ysdb1 dbs]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jun 28 11:10:03 2017

connected to target database: YSDB (DBID=3762312883)

RMAN> shutdown immediate;

using target database control file instead of recovery catalog

database closed

database dismounted

Oracle instance shut down

RMAN>

RMAN> startup nomount;

connected to target database (not started)

Oracle instance started

Total System Global Area 647204864 bytes

Fixed Size 2256032 bytes

Variable Size 536871776 bytes

Database Buffers 104857600 bytes

Redo Buffers 3219456 bytes

RMAN> restore controlfile to '+data1/ysdb/control03.ctl' from '+data1/ysdb/control01.ctl';

Starting restore at 28-JUN-17

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=34 instance=ysdb1 device type=DISK

channel ORA_DISK_1: copied control file copy

Finished restore at 28-JUN-17

RMAN>

3. 在nomount下，修改参数文件，重启数据库

[oracle@ysdb1 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 28 11:14:08 2017

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SYS@ysdb1>select status from v$instance;

STATUS

------------

STARTED

SYS@ysdb1>alter system set control_files='+data1/ysdb/control01.ctl','+data1/ysdb/control03.ctl' scope=spfile sid='*';

System altered.

SYS@ysdb1>shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SYS@ysdb1>startup

ORACLE instance started.

Total System Global Area 647204864 bytes

Fixed Size 2256032 bytes

Variable Size 536871776 bytes

Database Buffers 104857600 bytes

Redo Buffers 3219456 bytes

Database mounted.

Database opened.

SYS@ysdb1>show parameter control_files

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

control_files string +DATA1/ysdb/control01.ctl, +DA TA1/ysdb/control03.ctl

SYS@ysdb1>

文章名称：11grac添加一个控制文件
文章来源：http://ybzwz.com/article/goeseo.html

11grac添加一个控制文件

其他资讯