How to use Automation Designer to execute RMAN commands for scheduling daily database backups?

Toad for Oracle - Beta
1

Hi experts,

It's me again. ><
I need some help with this issue.

  1. I use TOAD to generate RMAN backup scripts and save them in the folder C:\RMAN_script\RMANDBHotBackup.rcv.

    001
    0011371×685 219 KB

  2. I opened CMD, connected to RMAN, and manually ran the command to execute the scripts in @C:\RMAN_script\RMANDBHotBackup.rcv, completing the backup.

    002
    0021324×751 23.3 KB

    003
    003937×532 33.9 KB

  3. I want to use Automation Designer to achieve the process mentioned above.
    I have completed the steps to open CMD and connect to RMAN, but I don’t know how to configure Automation Designer to execute the following command in RMAN:
    @C:\RMAN_script\RMANDBHotBackup.rcv

    004
    0041575×685 149 KB

Can you tell me how to set it up?
Or how can I use Automation Designer to complete the daily database backup?

Thank you～

2

First of all, I don't think you should use Toad to run your daily backups. You should make scripts and put them on the DB server, and schedule them there.

To answer your question though, you should be able to use a "Shell Execute" action to run any program and pass parameters to it.

3

Hi John~

I saw this article, but the link is already 'page not found.'

https://toadworld.com/products/toad-for-oracle/i/utilities/full_rman_integration_for_toad_oracle

I was wondering if there is a possibility of integration between RMAN and Automation Designer, which is why I brought up this question.

Or do you have other examples or tutorials where Automation Designer would be suitable?

4

I have a dropbox folder with some documents I've written about Toad and Oracle stuff. A few of them are about automation designer. There are also some tutorials online about Automation Designer - you can google for them.

5

Hi John~

Truly appreciate your help and kindness. :smiling_face_with_three_hearts:

1 Like