Troubleshooting RMAN
Run the following command to find if RMAN sessions exist in the database instance (format the output for readability):
SELECT p.SPID,
s.EVENT,
s.SECONDS_IN_WAIT AS SEC_WAIT,
sw.STATE,
s.CLIENT_INFO
FROM V$SESSION_WAIT sw,
V$SESSION s,
V$PROCESS p
WHERE sw.EVENT LIKE ‘?ckup%’
AND s.SID=sw.SID
AND s.PADDR=p.ADDR;
If the sessions are “WAITING” for resources, then kill the sessions using OS command “kill -9” at OS level (prompt).
Some platforms include a command-line utility called orakill that enables you to terminate a specific thread. From a command prompt, run the following command, where sid identifies the database instance to target, and the thread_id is the SPID value from the query.
orakill sid thread_id
And restart the backup process.