Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 9.2.0.7 RMAN blues

Re: 9.2.0.7 RMAN blues

From: Vitalis Jerome <vitalisman_at_gmail.com>
Date: Wed, 21 Sep 2005 16:35:17 +0200
Message-ID: <68b1285505092107357441bcfe@mail.gmail.com>


Apparently you want to restore the db prior to the upgrade, but you've launched a complete recovery.
I guess RMAN have restored an autobackup from after your last backup and it just can't restore datafiles which were created afterwards since you don't have any backup for them (you could recover them with the logs but that's another story.) IMO the problem is not related to the upgrade.

Correct your script to include a point-in-time (according to the time or SCN before your upgrade) before the controlfile restore, and it should work.

HTH
Jerome

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 21 2005 - 09:37:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US