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)?

  • what is a .bfull backup? – Andrew Brennan Sep 29 '16 at 8:53
  • @AndrewBrennan see my reply to JSapkota below their answer. – Jules Sep 29 '16 at 14:13

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

  • 4
    • This has been hugely helpful already, but I'm looking to restore a database from a .BFULL file which I already have on hand, rather than from a backup of the database I have access to via SQL Developer. (This is part of an extremely awkward migration, which is unfortunately mostly out of my control). As a side note, I'd upvote this if I had the local rep to do so. – Jules Sep 29 '16 at 5:55
    • 1
      @Jules: What is .BFULL file? Is that file a Data Pump file? Sorry I couldn't find its meaning. I thought you have full RMAN backup. Its Oracle Backup type or else? – atokpas Sep 29 '16 at 6:20
    • it's the extension of the file given to me by a client; I'm an extreme Oracle SQL novice, and the only documentation I found online pointed to this being a "full file backup" of an Oracle database. I hadn't heard of this extension before a few days ago myself. – Jules Sep 29 '16 at 14:00
    • The only docs I've found that even contain "bfull" on Oracle's website are for the impdp tool, for what it's worth. – Jules Sep 29 '16 at 14:15

    Your Answer

    By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

    Not the answer you're looking for? Browse other questions tagged or ask your own question.