11grac添加一個控制文件

一、環(huán)境

成都創(chuàng)新互聯(lián)公司是一家專業(yè)提供安陽企業(yè)網(wǎng)站建設(shè),專注與成都做網(wǎng)站、成都網(wǎng)站建設(shè)、H5頁面制作、小程序制作等業(yè)務(wù)。10年已為安陽眾多企業(yè)、政府機(jī)構(gòu)等服務(wù)。創(chuàng)新互聯(lián)專業(yè)網(wǎng)站建設(shè)公司優(yōu)惠進(jìn)行中。

11g rac

二、演示步驟

1. 查看控制文件路徑

SYS@ysdb1>show parameter control_files

NAME TYPE VALUE

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

control_files string +DATA1/ysdb/control01.ctl

2. 關(guān)閉所有實(shí)例，啟動一個實(shí)例到nomount狀態(tài)，恢復(fù)一個控制文件

[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下，修改參數(shù)文件，重啟數(shù)據(jù)庫

[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>

當(dāng)前名稱：11grac添加一個控制文件
文章位置：http://bm7419.com/article40/goeseo.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供關(guān)鍵詞優(yōu)化、App開發(fā)、網(wǎng)站收錄、Google、搜索引擎優(yōu)化、企業(yè)網(wǎng)站制作

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容