My Oracle Support Banner

RMAN backup of physical standby fails RMAN-10006 querying v$session_longops (Doc ID 1080134.1)

Last updated on OCTOBER 11, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2 - Release: 10.2
Information in this document applies to any platform.

Symptoms

RMAN backup of physical standby database returns error after backup completion:

RMAN-10006: error running SQL statement: select sofar, context, start_time from v$session_lon
gops where (start_time > nvl(:1, sysdate-100) or start_time = nvl(:2, sysdate+100)
) and sid = :3 and serial# = :4 and opname like 'RMAN:%' order by s
tart_time desc, context desc
RMAN-10002: ORACLE error: ORA-00000: normal, successful completion

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.