Restoring oracle database I come from SQL Server and I need to restore a oracle .bkp file in my database. I'm using RMAN and the path and name for the .bkp file is:

F:\Oracle Back Ups\Back.bkp


The command that I use in RMAN is:

RMAN&gt; restore controlfile: "F:\Oracle Back Ups\Back.bkp"


But it shows an error:

ORA-19870 error while restoring backup piece F:\Oracle Back Ups\Back.bkp
ORA-19690 backup piece release 11.2.0.4.0 incompatible with oracle release 11.2.0.2.0


I need to know the proper commands to successfully complete this operation.

Note: The guy that provided the back up data gave me two files: One with the extension .bkp, and the second with .ctl. I don't know how the .ctl file is supposed to be used.

I'm using Oracle XE 11.0.0.2.0
Can you copy the 11.2.0.4.0 rman executable from your friend or get and perform a second "dummy" installation of Oracle Database on another temporary computer/server? If so, here's how you can solve it:

Let's say you were able to copy the 11.2.0.4.0 ORACLE_HOME folder from your friend, and called it dbhome_2 (do not replace current, otherwise you can mess up things).

Using the 11.2.0.4.0 rman executable:
- startup instance in nomount and restore controlfile from backup
- mount the db
- restore the archivelogs required (recover database until cancel)

Shutdown the database, and using 11.2.0.2.0 executable:
- restore the control file again, from a 11.2.0.2.0 generated backup
- mount the db
- recover database until cancel
- open database with resetlogs

Hope it helps.