Re: RMAN, v$session_longops and Ora-03113

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: Tim Onions <att755@xxxxxxxxxxx>
  • Date: Wed, 18 May 2005 10:29:04 -0700

Ah, thanks, I didn't know that.
Or, if I ever did, I forgot. :)

On 5/18/05, Tim Onions <att755@xxxxxxxxxxx> wrote:
> Jared
> RMAN uses v$session_longops to record it's progress. After each backup set
> it uses the DBMS package to update "progress" in the V$ view, having first
> queried out of the view to find some relevant data within . So when the 
> view
> goes "bad" RMAN does its initial backup set/piece, trys to update
> v$session_longops and subsequently gets an Ora-03113 error and dies. 
> Hence,
> the backup "fails" inasmuch as it did not run to completion. I reality we
> get less than 10% of our Db backed-up when this problem is in force.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


Other related posts: