如何中途停止RMAN備份任務(wù)

（1）查看RMAN分配的各個通道的進程號

創(chuàng)新互聯(lián)從2013年創(chuàng)立，是專業(yè)互聯(lián)網(wǎng)技術(shù)服務(wù)公司，擁有項目網(wǎng)站設(shè)計制作、網(wǎng)站設(shè)計網(wǎng)站策劃，項目實施與項目整合能力。我們以讓每一個夢想脫穎而出為使命，1280元沿河做網(wǎng)站,已為上家服務(wù),為沿河各地企業(yè)和個人服務(wù),聯(lián)系電話:028-86922220

SQL

SELECT sid, spid, client_info

FROM v$process p, v$session s

WHERE p.addr = s.paddr

AND client_info LIKE '%rman%';

SID SPID CLIENT_INFO

113 15898 rman channel=ORA_DISK_1

119 15899 rman channel=ORA_DISK_2

120 15900 rman channel=ORA_DISK_3

117 15901 rman channel=ORA_DISK_4

（2）根據(jù)第（1）中得到的進程號，終止RMAN備份

注：這里既要kill 掉RMAN備份腳本的PID，?也要kill 掉RMAN中分配的各個通道的PID

[root@asmdb ~]# ps -ef | grep beq

oracle 1918 1 0 Jul10 ? 00:00:09 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 15790 1 0 08:53 ? 00:00:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 15892 15885 1 08:57 ? 00:00:00 oracleasmdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 15897 15885 1 08:57 ? 00:00:00 oracleasmdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 15898 15885 1 08:57 ? 00:00:00 oracleasmdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 15899 15885 2 08:57 ? 00:00:00 oracleasmdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 15900 15885 2 08:57 ? 00:00:00 oracleasmdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle 15901 15885 5 08:57 ? 00:00:00 oracleasmdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

root 15903 15823 0 08:57 pts/3 00:00:00 grep beq

[root@asmdb ~]# kill -9 15898

[root@asmdb ~]# kill -9 15899

[root@asmdb ~]# kill -9 15900

[root@asmdb ~]# kill -9 15901

[root@asmdb ~]# ps -ef | grep rman

oracle 15885 15740 1 08:57 pts/2 00:00:02 rman target /

root 15926 15823 0 09:01 pts/3 00:00:00 grep rman

[root@asmdb ~]# kill -9 15885

rman備份的命令行終端的顯示輸出：

[oracle@asmdb ~]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Mon Jul 29 08:57:22 2013

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ASMDB (DBID=557978363)

RMAN backup database;

Starting backup at 29-JUL-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=113 devtype=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: sid=119 devtype=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: sid=120 devtype=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: sid=117 devtype=DISK

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00002 name=+ASMDG01/asmdb/datafile/undotbs1.261.813779611

input datafile fno=00007 name=+ASMDG01/asmdb/datafile/spottbs.268.821100481

channel ORA_DISK_1: starting piece 1 at 29-JUL-13

channel ORA_DISK_2: starting full datafile backupset

channel ORA_DISK_2: specifying datafile(s) in backupset

input datafile fno=00001 name=+ASMDG01/asmdb/datafile/system.260.813779595

channel ORA_DISK_2: starting piece 1 at 29-JUL-13

channel ORA_DISK_3: starting full datafile backupset

channel ORA_DISK_3: specifying datafile(s) in backupset

input datafile fno=00003 name=+ASMDG01/asmdb/datafile/sysaux.262.813779621

input datafile fno=00004 name=+ASMDG01/asmdb/datafile/users.264.813779629

channel ORA_DISK_3: starting piece 1 at 29-JUL-13

channel ORA_DISK_4: starting full datafile backupset

channel ORA_DISK_4: specifying datafile(s) in backupset

input datafile fno=00005 name=+ASMDG01/asmdb/datafile/luroutest01.dbf

input datafile fno=00006 name=+ASMDG01/asmdb/datafile/spot01.dbf

channel ORA_DISK_4: starting piece 1 at 29-JUL-13

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/29/2013 08:58:20

RMAN-10038: database session for channel ORA_DISK_1 terminated unexpectedly

channel ORA_DISK_1 disabled, job failed on it will be run on another channel

RMAN-03009: failure of backup command on ORA_DISK_2 channel at 07/29/2013 08:58:20

RMAN-10038: database session for channel ORA_DISK_2 terminated unexpectedly

channel ORA_DISK_2 disabled, job failed on it will be run on another channel

RMAN-03009: failure of backup command on ORA_DISK_3 channel at 07/29/2013 08:58:20

RMAN-10038: database session for channel ORA_DISK_3 terminated unexpectedly

channel ORA_DISK_3 disabled, job failed on it will be run on another channel

Killed

[oracle@asmdb ~]$

[oracle@asmdb ~]$

（3）核實進程是否還存在

此時RMAN備份操作已經(jīng)被終止。查看（1）中的SQL語句時，結(jié)果為空。

如何停止ORACLE數(shù)據(jù)庫Expdp與impdp備份任務(wù)的后臺進程

終止進程并不能結(jié)束備份，需要結(jié)束備份對應(yīng)的job；

1、查看備份job

select job_name,state from dba_datapump_jobs;

2、在退出導(dǎo)出監(jiān)視界面后，可以通過下面語句重新打開expdp界面

Expdp system/test ATTACH=system.export_job10 --第一步查出的job名稱

3、結(jié)束job

Export kill_job

怎樣關(guān)閉ORACLE，進行冷備份

關(guān)閉所有服務(wù)可以，但是通常來說不需要關(guān)閉所有服務(wù)，只需要數(shù)據(jù)庫不是open狀態(tài)就可以了

一般做法是，用sqlplus sys/password@servicename as sysdba

sqlshutdown immediate

然后就可以進行冷備了

備份結(jié)束后

sqlstartup

網(wǎng)站欄目：如何停止oracle備份,oracle恢復(fù)備份
新聞來源：http://chinadenli.net/article47/dsgsohj.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供App開發(fā)、網(wǎng)站設(shè)計公司、面包屑導(dǎo)航、Google、虛擬主機、移動網(wǎng)站建設(shè)

廣告

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