I want to install Linux with an Oracle database on it and configure Oracle to make weekly backups.
Please, advice me which distribution I should install. Also, how do I confugure my database to make weekly backups automatically?
I think Red Hat would be better and weekly backups can be configured by EM, right?
since you're only doing this for a test, then CentOS 5 will work just fine. I use cron to run RMAN dumps to local disk...then I have Arkeia set to perform scheduled backups of the file system nightly.
I manage disk space by using the Arkeia "Command After Savepack" feature to delete the old Oracle images.
There are several steps you need to consider:
Choice of backup software/strategy is likely more of an issue than Linux distribution. Oracle has their own distribution which may be appropriate either as the base or a VM. Your software choice may limit your options for Linux distributions.
Backing up a running Oracle database is possible, but requires co-ordination between the backup software and Oracle. Do some research on hot backups and cold backups for Oracle.
Oracle also has its own RMan software to backup the database to tape or disk. This makes it easier to schedule hop backups.