Restore a .bmp file of full database backup to an Oracle 12c EE instance running on RDS

backuporacleoracle-12crecoveryremote

I've got an Oracle 12c EE database set up on an RDS box with no SSH access. I do, however, have SQL Developer and SQL PLUS tools.

Is there any way I can restore a full backup into this database using these tools (or any other remote management utility)?

Best Answer

After exchanging several comments I came to know that you have Data Pump file of full database. Anyway you can use the SQL Developer to import export database objects. Just follow the steps:

1) Launch the SQL Developer and go to View menu and click on DBA.

enter image description here

2) Then add database connection to perform Data Pump operations.

enter image description here

3) Click on Data Pump and select the appropriate job wizard. enter image description here

4) Right click on Data Pump and Data Pump import wizard. enter image description here

enter image description here Useful link:

  • Using DBA Features in SQL Develope