I want to create an automated backup for my company's database. We have Oracle 9i Enterprise. The thing is that I don't really now how to do it. In addition, I want to save the backup files on another machine, not the one on which Oracle is installed (the server).

    Requires Free Membership to View

    Login

I highly recommend reading this document that discusses the basics of Oracle backup and recovery.

At this point, you have two decisions to make. Do you perform user-managed backups (UMBs) or use Recovery Manager (RMAN) to do your backups? I prefer RMAN as it has many more options for both backup and recovery. But RMAN is more complex than UMBs. For information on UMBs, I highly recommend reading this UMB manual. If you choose to use RMAN instead, then read this RMAN guide.

I do prefer RMAN. And when you upgrade your database to Oracle 10g, you'll enjoy all of the great new features available only in RMAN.

To automate your backups in Oracle 9i, you will use your server's automated scheduling routine. On Unix, you can use cron to run your backup script. In Windows, you can use 'at' to run your backup script. Oracle 10g lets you easily schedule backups in Enterprise Manager, but for 9i, I stick with my server's script scheduling routine.

This was first published in August 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top