Hello,
I use rman with catalyst plugin on StoreOnce storage. My database is 11.2.0.4 enterprise edition.
I use 4 channels for backup, but yesterday on channels (C2) hangs, so i decided to kill it and the backup continues on others channels:
RMAN-03009: failure of backup command on c2 channel at 09/20/2017 15:56:56
RMAN-10038: database session for channel c2 terminated unexpectedly
channel c2 disabled, job failed on it will be run on another channel
channel c1: starting incremental level 1 datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00212 name=/datas/oradata5/O_BI/undotbs_09.dbf
input datafile file number=00263 name=/datas/oradata2/O_BI/indx_5m_35.dbf
input datafile file number=00332 name=/datas/oradata3/O_BI/data_1m_06.dbf
channel c1: starting piece 1 at 20-SEP-17
channel c1: finished piece 1 at 20-SEP-17
The backup ended, but i still have a background session that do not end. this session is waiting with event Backup: MML write backup piece
| | SID | SERIAL# USERNAME | STATUS PROCESS | PROGRAM | TYPE | LOGON_TIM STATE | EVENT | SECONDS_IN_WAIT WAIT_CLASS | SERVICE_NAME |
---------- ---------- ------------ -------- ---------- ---------- ---------- --------- ------------------- --------------------------------- --------------- ------------------ -----------------
| | 696 | 29343 SYS | ACTIVE | BACKGROUND 19-SEP-17 WAITING | Backup: MML write backup piece | 112768 Administrative | SYS$BACKGROUND |
Can I kill this process? without any risk of crask? (because it's a background process)