Restored in place. Yes to the catalog. Database is open and useable. >>> "Weatherman, John" <John.Weatherman@xxxxxxxxxxx> 4/27/09 3:31 PM >>> Also, did you rename the restored database to something else or restore in place and replace the primary? Are you using a RMAN catalog or the controlfile? Did you open the restore? It sounds like RMAN is confused about what it is supposed to back up. From:oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of TESTAJ3@xxxxxxxxxxxxxx Sent: Monday, April 27, 2009 1:31 PM To: JBECKSTROM@xxxxxxxxx Cc: oracle-db-l; oracle-l-freelists; oracle-l-bounce@xxxxxxxxxxxxx Subject: Re: rman backup is failing after a restore - entire script just a shot in the dark but have you switched a logfile since you do resetlogs? joe _______________________________________ Joe Testa, Oracle Certified Professional Senior Consultant Data Engineering and Administration Nationwide Investments (Work) 614-677-1668 (Cell) 614-312-6715 Interested in helping out your marriage? Ask me about "Weekend to Remember" Dec 11-13, 2009 here in Columbus. From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx> To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx> Date: 04/27/2009 02:29 PM Subject: rman backup is failing after a restore - entire script Sent by: oracle-l-bounce@xxxxxxxxxxxxx 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 --------------------------------------------------------------------- Scanning of this message and addition of this footer is performed by SurfControl E-mail Filter software in conjunction with virus detection software.