Re: rman backup is failing after a restore - entire script

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Mon, 27 Apr 2009 13:51:40 -0700 (PDT)
Message-ID: <540476.35074.qm_at_web38905.mail.mud.yahoo.com>

RMAN-03002: failure of delete command at 04/27/2009 14:23:41 RMAN-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time

The first line may be the clue. Remove these lines:

delete noprompt expired backup;
delete obsolete;

Does it work now? My guess is that it's trying to delete old backup set pieces, and failing on that since they belong to a previous incarnation. Not the way it should work I don't think.

RF

 Robert G. Freeman
Author:
OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press)
Other various titles out of print now... Blog: http://robertgfreeman.blogspot.com The LDS Church is looking for DBA's. You do have to be a Church member in good standing. A lot of kind people write me, concerned I may be breaking the law by saying you have to be a Church member. It's legal I promise! :-)

---

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> To: oracle-l-freelists <oracle-l_at_freelists.org>; oracle-db-l <oracle-db-l_at_Groups.ITtoolbox.com> Sent: Monday, April 27, 2009 12:27:55 PM Subject: rman backup is failing after a restore - entire script

Last week I was testing my first rman backup.  

I did a restore and it worked fine.  

Today I try to backup the restored database and get the following error: Here is my entire script. Do I have to drop and re-add the database to the catalog?  

RMAN> delete noprompt expired backup;

2> delete obsolete;
3> backup as compressed backupset database plus archivelog delete input;
4> exit;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=68 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

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of delete command at 04/27/2009 14:23:41 RMAN-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time  

Recovery Manager complete.  

 Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

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

Received on Mon Apr 27 2009 - 15:51:40 CDT