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

  • From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
  • To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <robertgfreeman@xxxxxxxxx>
  • Date: Tue, 28 Apr 2009 07:43:38 -0400

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?


Robert G. Freeman
OCP: Oracle Database 11g Administrator Certified Professional Study Guide 
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: ( 
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 
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 
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 
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.

Other related posts: