Oracle getting started Tutorial: how to kill the RMAN backup process

Source: Internet
Author: User
Question: Recently, a set of database orders by the customer often suffer from high data and business pressure. When RMAN performs full backup or Incremental backup, when there is a large amount of business to be processed, the system resources

Question: Recently, a set of database orders by the customer often suffer from high data and business pressure. When RMAN performs full backup or Incremental backup, when there is a large amount of business to be processed, the system resources

Question: Recently, a set of database orders by customers often suffer from high data and business pressure. When RMAN performs full backup or Incremental backup, a large amount of business needs to be processed at this time, system resources will be exhausted, which will affect the normal business. Therefore, it is often necessary to terminate the RMAN backup first. Here we provide methods in the processing process. I hope you will like it!

The purpose of this article is to immediately terminate the ongoing RMAN backup process in an emergency.

(1) view the process numbers of each channel allocated by RMAN
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
-----------------------------------------------------------
52526244Rman channel = t1
102326245Rman channel = t2
69926246Rman channel = t3

(2) Terminate the RMAN backup according to the process number obtained in (1 ).
Note: kill both the PID of The RMAN backup script and the PID of each channel allocated in RMAN.
Subsdb1 :~ # Ps-ef | grep 26244
Oracle 26244 26224 7? At 00:01:49 oraclesubsdb (DESCRIPTION = (LOCAL = YES) (ADDRESS = (PROTOCOL = beq )))
Root 9877 9603 0 00:00:00 pts/11 grep 26244
Subsdb1 :~ # Kill-926244
Subsdb1 :~ # Ps-ef | grep 26245
Oracle 26245 26224 5? At 00:01:13 oraclesubsdb (DESCRIPTION = (LOCAL = YES) (ADDRESS = (PROTOCOL = beq )))
Root 9968 9603 0 00:00:00 pts/11 grep 26245
Subsdb1 :~ # Kill-926245
Subsdb1 :~ # Ps-ef | grep 26246
Oracle 26246 26224 4? At 00:01:03 oraclesubsdb (DESCRIPTION = (LOCAL = YES) (ADDRESS = (PROTOCOL = beq )))
Root 10009 9603 0 00:00:00 pts/11 grep 26246
Subsdb1 :~ # Kill-926246
Subsdb1 :~ # Ps-ef | grep rman
Oracle 26224 25962 0 00:00:03 pts/3 rman target/nocatalog
Root 10061 9603 0 00:00:00 pts/11 grep rman
Subsdb1 :~ # Kill-926224
Subsdb1 :~ # Ps-ef | grep rman
Root 10102 9603 0 00:00:00 pts/11 grep rman
Subsdb1 :~ # Ps-ef | grep 26246
Root 10213 9603 0 00:00:00 pts/11 grep 26246

At this time, the RMAN backup operation has been terminated. When you view the SQL statement in (1), the result is null.

Note: If the RMAN process number is killed, the RMAN backup is not stopped, but the channel process can be deleted together!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.