Re: RMAN

From: Arne Ortlinghaus <Arne.Ortlinghaus_at_acs.it>
Date: Mon, 21 Jun 2010 15:53:06 +0200
Message-ID: <hvnqs2$30s$1_at_news.eternal-september.org>

Hi "Magnet",
in our RMAN scripts we have added the following commands before making a new backup:

delete obsolete;
crosscheck backup;
change archivelog all crosscheck;
delete expired backup;

Arne Ortlinghaus
ACS Data Systems

• Original Message ----- From: "The Magnet" <art_at_unsu.com> Newsgroups: comp.databases.oracle.server Sent: Monday, June 21, 2010 3:15 PM Subject: RMAN

>
> Hi,
>
> We are running RMAN on 10gR2 without a recovery catalog. Everything
> will be running fine, maybe for days or weeks. Then RMAN comes up
> with errors like this:
>
> RMAN-06207: WARNING: 33 objects could not be deleted for DISK
> channel(s) due
> RMAN-06208: to mismatched status. Use CROSSCHECK command to
> fix status
>
> Why randomly does RMAN decide to throw errors? We use the following
> script of select / parse to make a report of results:
>
> SELECT REPLACE(session_recid ||':'|| operation ||':'|| object_type
> ||':'|| status,' ','-') || ':|'
> FROM v$rman_status
> WHERE TRUNC(start_time) = TRUNC(SYSDATE);
>
> Thoughts?
>
Received on Mon Jun 21 2010 - 08:53:06 CDT