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).
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.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments