How do I manage automatic backups with oracle?

2019-02-15 18:44发布

问题:

I'm following the tutorial from oracle docs. And I see that the preferred way to manage the backup/recovery processes is by using RMAN. I've started practicing with it (I mean, by sql*plus cli).

But I really don't see how I can automate the process.

Then I saw that in sql developer dba panel, there are some options for working with RMAN. I really don't understand how to use them (I didn't even create e backup) and I couldn't find any tutorial about that.

So can somebody tell me the way how to manage automatic backups through sql developer? Of course if there is a way how to achieve this. If not, what do you suggest me?

回答1:

If you're looking specifically for something on SQL Dev, than you should know that from version 3.* and up, they have added a DBA panel (just go to View->DBA or DB Navigator). From there, you can schedule RMAN jobs using a pre-configured script: RMAN in Oracle SQL Developer.