Re: rman delete failed - did a force
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: "Bradd Piontek" <piontekdd@xxxxxxxxx>
- Date: Fri, 15 May 2009 10:31:51 -0400
But nightly after the rman backup is done. We use OS utilities to copy to
tape. Backup on disk is then deleted. Crosscheck would state that all backups
are gone.
>>> Bradd Piontek <piontekdd@xxxxxxxxx> 5/15/09 10:07 AM >>>
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@xxxxxxxxx> 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.
---------------------------------------------------------------------
Scanning of this message and addition of this footer is performed
by SurfControl E-mail Filter software in conjunction with
virus detection software.
---------------------------------------------------------------------
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.
Other related posts:
