在Oracle数据库服务器上，通过'ps -ef | grep'命令查找并终止了多个PID为15182, 15183, 15184的进程。这些进程与Oracle数据库连接有关，可能属于RMAN备份操作的一部分。在终止进程后，确认了SQL查询中没有匹配的RMAN会话，并检查了文件系统中/data/目录下备份文件的情况，文件没有新增。最后再次验证没有活动的RMAN进程。
[oracle@test backup]$ ps -ef|grep 15182
oracle 15182 1 72 Aug14 ? 08:41:15 oracleoutdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 31192 15039 0 09:21 pts/0 00:00:00 grep 15182
[oracle@test backup]$ kill -9 15182
[oracle@test backup]$ ps -ef|grep 15183
oracle 15183 1 69 Aug14 ? 08:20:20 oracleoutdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 31234 15039 0 09:22 pts/0 00:00:00 grep 15183
[oracle@test backup]$ kill -9 15183
[oracle@test backup]$ ps -ef|grep 15184
oracle 15184 1 75 Aug14 ? 09:08:47 oracleoutdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 31248 15039 0 09:22 pts/0 00:00:00 grep 15184
[oracle@test backup]$ kill -9 15184
[oracle@test backup]$
[oracle@test backup]$ ls -l ./data/*
-rw-r----- 1 oracle oinstall 7259655680 Aug 14 21:50 ./data/arch_20150814_25
-rw-r----- 1 oracle oinstall 3811864064 Aug 14 21:30 ./data/arch_20150814_26
-rw-r----- 1 oracle oinstall 3586004992 Aug 14 21:32 ./data/arch_20150814_27
-rw-r----- 1 oracle oinstall 214711808 Aug 14 21:31 ./data/arch_20150814_28
-rw-r----- 1 oracle oinstall 53685395456 Aug 15 02:18 ./data/full_20150814_31
-rw-r----- 1 oracle oinstall 32226762752 Aug 15 04:49 ./data/full_20150815_31
-rw-r----- 1 oracle oinstall 32956751872 Aug 15 09:23 ./data/full_20150815_32
[oracle@test backup]$
[oracle@test backup]$ ls -l ./data/*
-rw-r----- 1 oracle oinstall 7259655680 Aug 14 21:50 ./data/arch_20150814_25
-rw-r----- 1 oracle oinstall 3811864064 Aug 14 21:30 ./data/arch_20150814_26
-rw-r----- 1 oracle oinstall 3586004992 Aug 14 21:32 ./data/arch_20150814_27
-rw-r----- 1 oracle oinstall 214711808 Aug 14 21:31 ./data/arch_20150814_28
-rw-r----- 1 oracle oinstall 53685395456 Aug 15 02:18 ./data/full_20150814_31
-rw-r----- 1 oracle oinstall 32226762752 Aug 15 04:49 ./data/full_20150815_31
-rw-r----- 1 oracle oinstall 32956751872 Aug 15 09:23 ./data/full_20150815_32
-------KILL了3个channel进程后，文件不在增加
SQL> SELECT sid, spid, client_info
2 FROM v$process p, v$session s
3 WHERE p.addr = s.paddr
4 AND client_info LIKE '%rman%';
no rows selected
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
[oracle@test backup]$ ps -ef|grep rman
oracle 31258 15039 0 09:23 pts/0 00:00:00 grep rman
扫一扫
5907
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
