Ask the Expert

Create automated backup for Oracle 9i database

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

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: