Re: RMAN Error
From: John Schaeffer <amerar_at_iwc.net>
Date: Wed, 25 Mar 2009 08:41:56 -0700 (PDT)
Message-ID: <757d3b3d-f3a4-44d6-a078-2b8d86af8811_at_k2g2000yql.googlegroups.com>
On Mar 25, 10:27 am, johnbhur..._at_sbcglobal.net wrote:
> On Mar 25, 9:58 am, John Schaeffer <ame..._at_iwc.net> wrote:
>
> snip
>
>
>
> > > > We've started receiving this error. I'm trying to track to see if it
> > > > is related to anything, as we did need to run a CROSSCHECK this
> > > > morning, but, is this serious? It causes the backup not to run:
>
> > > > RMAN-03002: failure of delete command at 03/25/2009 04:11:33
> > > > ORA-04068: existing state of packages has been discarded
> > > > ORA-04061: existing state of package body "SYS.DBMS_RCVMAN" has been
> > > > invalidated
> > > > ORA-04065: not executed, altered or dropped package body
> > > > "SYS.DBMS_RCVMAN"
> > > > ORA-06508: PL/SQL: could not find program unit being called:
> > > > "SYS.DBMS_RCVMAN"
>
> > > Oracle version?
>
> > > Anyway, it looks like something has changed in your data dictionary.
> > > Has anybody been running any database upgrade scripts, for example?
>
> > > -g
>
> > We're running Oracle 10gR2. And, the scripts have not changed since
> > like December 08.......this is only the second time we've received
> > this. I'm wondering if this has to do with anything when the
> > controlfile is out of sync for what RMAN expects?
>
> Do you have appropriate cross checking in place before the deletes?
Date: Wed, 25 Mar 2009 08:41:56 -0700 (PDT)
Message-ID: <757d3b3d-f3a4-44d6-a078-2b8d86af8811_at_k2g2000yql.googlegroups.com>
On Mar 25, 10:27 am, johnbhur..._at_sbcglobal.net wrote:
> On Mar 25, 9:58 am, John Schaeffer <ame..._at_iwc.net> wrote:
>
> snip
>
>
>
> > > > We've started receiving this error. I'm trying to track to see if it
> > > > is related to anything, as we did need to run a CROSSCHECK this
> > > > morning, but, is this serious? It causes the backup not to run:
>
> > > > RMAN-03002: failure of delete command at 03/25/2009 04:11:33
> > > > ORA-04068: existing state of packages has been discarded
> > > > ORA-04061: existing state of package body "SYS.DBMS_RCVMAN" has been
> > > > invalidated
> > > > ORA-04065: not executed, altered or dropped package body
> > > > "SYS.DBMS_RCVMAN"
> > > > ORA-06508: PL/SQL: could not find program unit being called:
> > > > "SYS.DBMS_RCVMAN"
>
> > > Oracle version?
>
> > > Anyway, it looks like something has changed in your data dictionary.
> > > Has anybody been running any database upgrade scripts, for example?
>
> > > -g
>
> > We're running Oracle 10gR2. And, the scripts have not changed since
> > like December 08.......this is only the second time we've received
> > this. I'm wondering if this has to do with anything when the
> > controlfile is out of sync for what RMAN expects?
>
> Do you have appropriate cross checking in place before the deletes?
Hmm....maybe not?
run {
allocate channel d1 type disk;
backup validate database archivelog all;
backup incremental level 1 cumulative database
format '/backup/oracle/daily/ora_%M%D%Y_NI00_%p%s'
tag daily_backup
plus archivelog format '/backup/oracle/daily/archive/arc_%M%D%Y_NI00_%p
%s' delete input;
restore database validate;
delete noprompt obsolete;
delete noprompt expired backup;
}
Received on Wed Mar 25 2009 - 10:41:56 CDT