This content has been marked as final. Show 8 replies
user12247013 wrote:why are multiple versions involved here?
After many tries of upgrade'ing oracle I decided to make backup of my database and then remove 18.104.22.168 and install 22.214.171.124 to recover db.
what problem are you actually trying to solve?
How do I ask a question on the forums?
SQL and PL/SQL FAQ
Pl post OS details. The upgrade process is pretty straightforward if you follow the documented steps
If you are wanting to restore a RMAN backup as part of the upgrade, pl see this MOS Doc
RMAN Restore of Backups as Part of a Database Upgrade [ID 790559.1]
As I wrote - I had troubles with upgradeing from 126.96.36.199 to 188.8.131.52 on Windows Server 2008 R2 - no matter if I used DBUA or tried to make In-Place upgrade it always finally failed. That's why I decided to uninstall 184.108.40.206, then install the 220.127.116.11 from the beginning and then recover my data from backup files.
The only question I have is how can I recover those data.
I tried to move files from 18.104.22.168 C:\oracle\fast_recovery_area to new fast_recovery_area but unfortuantely it messed up everything and database couldn't even start.
I am trying to, but it tells me that I have to:
Copy the backups to the new host with an operating system utility.While I do not have any dbf files. Is it possible to make it work with the files that I have(bkp and contents of dirs that I mentioned about)?
Enter a command such as the following to copy all datafile copies to the ?/oradata/trgt directory on the new host:
% cp -r /disk1/*dbf /net/new_host/oracle/oradata/trgt
Edited by: user12247013 on 2013-01-03 02:22
Which document are you following ? I do not see any reference to what you have stated in MOS Doc 790559.1
If you only deleted your 22.214.171.124 software, then your dbf files should be intact. Did you delete them separately ? Do you have a backup of those files ?