5

I am coming from SQL Server background where SQL Server studio has a very easy way of taking database backup and then doing a restore.

I have been using Oracle 11G express edition for past couple of months and I am not sure of doing the backup and restore in oracle.

I can see the option to backup database and restore databse in oracle server menu but I am not sure how does it work, where does it creates the backup file etc.

Please help

8

rman is the way to go for backup and recovery for protection against physical corruption. For documentation check Oracle® Database 2 Day DBA 11g Release 2 (11.2) In the current release of SQLDeveloper backup and recovery is integrated in the GUI. For download of SQLDeveloper see Oracle SQL Developer It is a free product, with active development.

In SQLdeveloper in the View menu select DBA to get access to the dba tools like RMAN and DATAPUMP. Very nice tool. Don't forget that the backup files are written by the Oracle database server processes. This means that the backups are written on the database server, not on your client. Also, currently it just generates a backup script. You should run the generated script using RMAN.

An other way to run and configure the backup is by using dbconsole or grid control.

Using datapump is an other way to protect against data loss. Using this enables you to read back the data as it was during the export. Might be usefull for test sets that have to be refreshed with a specific version of the data. Not really usefull if you want to recover production transactions to the last moment before disaster stroke.

0

User RMAN. Refer to this article

Or you can make use of data pump export/import. Check this article.

  • Thanks for the link. isnt there any simpler UI do this instead of writing some commands? – ashishjmeshram Sep 28 '12 at 4:44
  • Updated my answer to include data pump, simple commands to take backup of database – Anshu Sep 28 '12 at 4:47
  • Highly dangerous advice: data pump and export are not backup and tools. The main reason being, they are not incremental and they lose data (everything since the last time you ran an export). This is because their main purpose is data transfer not recovery. – APC Sep 28 '12 at 12:02
  • Okay then use RMAN, don't think it needed a downvote – Anshu Sep 28 '12 at 12:14

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.