We had a database backup from our client in .bkp files and we want to restore it to our server. We installed our Oracle 12c server and created empty database but there are no options in the SQL Developer software to restore from .bkp files. We installed TOAS because we heard it can easily restore data. Anyone can lead me into how can I do this?
Any answer is much appreciated.
I've never heard of this kind of backup before. Toad doesn't do anything with them. What tool did you use to create it? Can you use the same tool to restore?
This is our customer who gave us these backups. I believe they used RMAN to create those .bkp files. I tried many tools and no one recognized this format. Is there a way to restore them or convert them?
If they used RMAN to create them then you need to use RMAN to restore them.
Toad can run RMAN scripts, but you can't just open a backup file with Toad and apply it to the database. You should talk to your customer about that.
Okay. So we have another database backup as .dmp file. Can we restore that using TOAD?
Also, is there anyway I can fully create an Oracle database from TOAD?
If the .dmp file is datapump, and you have Toad professional or DB Admin module, then you can go to main menu -> Database -> Import -> Data Pump Import to import it. In this case, the file needs to be on the server. You really need to know what you are doing to set it up.
If the .dmp file is from the older Oracle EXP utility, you can use main menu -> Database -> Import -> import utility wizard.
There is no way to create a database from Toad.
I tried importing the database from the .dmp file but I'm getting an error:
IMP-00058: ORACLE error 12514 encountered
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
IMP-00000: Import terminated unsuccessfully
Any idea how to solve this?
Appreciate your help.