Re: rman delete failed - did a force

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Fri, 15 May 2009 09:07:42 -0500
Message-ID: <e9569ef30905150707p4052ca6evfb5dc09bfe0e2ff1_at_mail.gmail.com>

I'm a little confused. Isn't the CROSSCHECK command used exactly for what you are running in to? In other words: A RMAN backup was removed from the file system and the catalog doesn't know that. In this case, the crosscheck would mark the backup as EXPIRED as it is no longer on the filesystem and the 'delete obsolete' would ignore the records. Maybe I am missing something.
Bradd Piontek
  "Next to doing a good job yourself,

        the greatest joy is in having someone
        else do a first-class job under your
        direction."

• William Feather

On Fri, May 15, 2009 at 8:09 AM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>wrote:

> I changed the command to "delete force obsolete" and then it worked.
> ++++++++++
> Getting following error when doing a delete command. I can not run a
> crosscheck command since we backup the backups via OS to tape and then
> delete the file that rman had created. Therefore, only the most current
> backup is on disk. How do I resolve this error?
>
>
> RMAN> delete noprompt expired backup;
> 2> delete obsolete;
> 3> backup as compressed backupset database plus archivelog delete input;
> 4> exit;
> using target database control file instead of recovery catalog
> allocated channel: ORA_DISK_1
> channel ORA_DISK_1: sid=58 devtype=DISK
>
> RMAN retention policy will be applied to the command
> RMAN retention policy is set to recovery window of 21 days
> using channel ORA_DISK_1
> Deleting the following obsolete backups and copies:
> Type Key Completion Time Filename/Handle
> -------------------- ------ ------------------ --------------------
> Backup Set 1 23-APR-09
> Backup Piece 1 23-APR-09 F:\10G\DATABASE\01KD6Q25_1_1
> Backup Set 2 23-APR-09
> Backup Piece 2 23-APR-09 F:\10G\DATABASE\02KD6Q2E_1_1
> Backup Set 3 23-APR-09
> Backup Piece 3 23-APR-09 F:\10G\DATABASE\03KD6Q2U_1_1
> Backup Set 4 23-APR-09
> Backup Piece 4 23-APR-09 F:\10G\DATABASE\04KD6Q32_1_1
> Backup Set 5 23-APR-09
> Backup Piece 5 23-APR-09
> R:\RMAN_BKUP_CTLG\BACKUP_RMANCTLG_05KD6QMR_1_1
>
> RMAN-06207: WARNING: 5 objects could not be deleted for DISK channel(s) due
> RMAN-06208: to mismatched status. Use CROSSCHECK command to fix
> status
> RMAN-06210: List of Mismatched objects
> RMAN-06211: ==========================
> RMAN-06212: Object Type Filename/Handle
> RMAN-06213: ---------------
> ---------------------------------------------------
> RMAN-06214: Backup Piece F:\10G\DATABASE\01KD6Q25_1_1
> RMAN-06214: Backup Piece F:\10G\DATABASE\02KD6Q2E_1_1
> RMAN-06214: Backup Piece F:\10G\DATABASE\03KD6Q2U_1_1
> RMAN-06214: Backup Piece F:\10G\DATABASE\04KD6Q32_1_1
> RMAN-06214: Backup Piece R:\RMAN_BKUP_CTLG\BACKUP_RMANCTLG_05KD6QMR_1_1
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
> ---------------------------------------------------------------------
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom
> they are addressed.
> If you have received this email in error please notify the
> originator of the message. This footer also confirms that this
> email message has been scanned for the presence of computer viruses.
>
> Any views expressed in this message are those of the individual
> sender, except where the sender specifies and with authority,
> states them to be the views of Greater Cleveland Regional Transit
> Authority (GCRTA)
>
> Scanning of this message and addition of this footer is performed
> by SurfControl E-mail Filter software in conjunction with
> virus detection software.
>
>
>
>

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

Received on Fri May 15 2009 - 09:07:42 CDT