Re: RMAN, v$session_longops and Ora-03113

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

On 5/18/05, Tim Onions <att755_at_hotmail.com> 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

--
http://www.freelists.org/webpage/oracle-l