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

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 28 Apr 2009 07:42:17 -0400
Message-Id: <49F6B358.3406.000B.0_at_gcrta.org>

Restored in place.
Yes to the catalog.
Database is open and useable.

>>> "Weatherman, John" <John.Weatherman_at_asurion.com> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of TESTAJ3_at_nationwide.com Sent: Monday, April 27, 2009 1:31 PM
To: JBECKSTROM_at_gcrta.org
Cc: oracle-db-l; oracle-l-freelists; oracle-l-bounce_at_freelists.org 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_at_gcrta.org>

To:
"oracle-l-freelists" <oracle-l_at_freelists.org>, "oracle-db-l" <oracle-db-l_at_Groups.ITtoolbox.com>

Date:
04/27/2009 02:29 PM

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

Sent by:
oracle-l-bounce_at_freelists.org  

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.

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

Received on Tue Apr 28 2009 - 06:42:17 CDT