Oracle Newbie - backup question 2

[dpu]

I am new to Oracle - mostly work with MS SQL - I am trying to set up a job that would create a nightly backup job of the database. Much in the same way MSSQL creates a .bak file.
Also how many archive logs do I need to keep to restore a database. I only keep 2-3 weeks worth of archive logs in addition to the redo log files.

 

[dbtoo2001]

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/strategy003.htm#sthref124

 

[TheKidd]

dpu,
If your database is running in archive log mode, you can use RMAN to create hotbackups via the following script. I use cron to run it. I'm running Oracle 10G.

DAT=`date +%a`
HOY=`date`
LOGf=/tmp/backuplog.txt
case ${DAT} in
Sun)
echo "Starting backup at ${HOY}" >> ${LOGf}
su - oracle -c "rman target=backup_acct/password log=${LOGf}" <<!
crosscheck backupset;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt expired archivelog all;
delete noprompt obsolete;
backup as compressed backupset incremental level=0 TAG
= WeeklyFull database plus archivelog delete all input;
backup validate database archivelog all;
list backup summary;
exit
!
;;
Wed)
echo "Starting backup at ${HOY}" >> ${LOGf}
su - oracle -c "rman target=backup_acct/password log=${LOGf}" <<!
crosscheck backupset;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt expired archivelog all;
delete noprompt obsolete;
backup as compressed backupset incremental level=1 TAG = DailyL1 database plus archivelog delete all input;
list backup summary;
exit
!
;;
*)
echo "Starting backup at ${HOY}" >> ${LOGf}
su - oracle -c "rman target=backup_acct/password log=${LOGf}" <<!
crosscheck backupset;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt expired archivelog all;
delete noprompt obsolete;
backup as compressed backupset incremental level=2 TAG = DailyL2 database plus archivelog delete all input;
list backup summary;
exit
!
;;
esac

 

[JohnBates]

TheKidd,

I think your script may work for my 10g database.

What is cron and how do you start it?

Thanks, John

 

[TheKidd]

cron is used in UNIX to schedule jobs. If the RMAN script is called backup.sh you could schedule it to run at 4:30AM daily with the following:

30 4 * * * /home/oracle/backup.sh

Use "crontab -e" to add the job.

 

[JohnBates]

Thanks TheKidd. I'm running Oracle10g in a Windows server.

 

[TheKidd]

I assumed UNIX, sorry. You can use the Windows task scheduler or you can use the job scheduler provided by Oracle Enterprise Mgr to schedule a backup job.

 

[TheKidd]

You should be able to create & schedule the entire backup job via Oracle Enterprise Manager. I've never done it that way so I don't know the process.