RE: rman backup is failing after a restore - entire script
- From: "Weatherman, John" <John.Weatherman@xxxxxxxxxxx>
- To: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- Date: Tue, 28 Apr 2009 08:05:41 -0500
Just curious, is there a reason you did a PIT and not a full restore? A
full would have avoided the need for the resetlogs that looks like the
root of the problem.
________________________________
From: Jeffrey Beckstrom [mailto:JBECKSTROM@xxxxxxxxx]
Sent: Tuesday, April 28, 2009 6:42 AM
To: Weatherman, John
Cc: oracle-l-freelists
Subject: RE: rman backup is failing after a restore - entire script
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.
Other related posts:
