RE: rman backup is failing after a restore - entire script
- From: "Weatherman, John" <John.Weatherman@xxxxxxxxxxx>
- To: <JBECKSTROM@xxxxxxxxx>
- Date: Mon, 27 Apr 2009 14:31:23 -0500
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
Other related posts:
