Re: Hot Backup
Originally posted by hamhey
Hi all,
I am doing a script to do hot backups (archive mode) every week for my database.
I am not sure about doing things in the right steps. The steps to do things are:
1. Switch logfiles
2. Backup Datafiles
3. Backup control files
4. archive current log
5 switch logfile
Do I need to backup redo logs and where?
Am I missing something
Regrds Hamhey
If you are on version 8 or higher use RMAN.
You can find some scripts (OS as well as RMAN) on this site.
HTH
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"