Complete restore including control file. I am using a recovery catalog. >>> Robert Freeman <robertgfreeman@xxxxxxxxx> 4/27/09 4:45 PM >>> What kind of a restore did you do? Complete or point-in-time? Did you restore the control file during this restore? 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 ( 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@xxxxxxxxx> To: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>; oracle-db-l <oracle-db-l@xxxxxxxxxxxxxxxxxxxx> 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 --------------------------------------------------------------------- Scanning of this message and addition of this footer is performed by SurfControl E-mail Filter software in conjunction with virus detection software.