Q

Create automated backup for Oracle 9i database

I want to create an automated backup for my company's database. We have Oracle 9i Enterprise. I also want to save the backup files on another machine, not the one on which Oracle is installed (the server).

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).
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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close