Hot Backup questions

[marist89]

Originally posted by antilles
I just have a few questions about Hot backups. Ok Here goes.

1. How does a DBA backup or deal with Online redologs in a Hot backup scheme.

http://www.dbasupport.com/oracle/scr...ckup_Recovery/

2. Do I need to ever incorporate a Cold backup during the weekend and Hot backups during the week. Deleteing arch logs after each successfull cold backup.

IMHO, there's no need to do a cold backup when you have a hot backup in place. Why empty out your cache when you don't have to? Delete the n+1 archived logs after your backup is complete.

3. If I have a complete Hot backup of the database, can I restore that HOT backup to a different machine using "backup controlfile to trace" procedure. If not then how do I do so.

sure.

4. Here is my tentative plan for backups
Monday: Hot backup of DDrive TS
Tuesday: Hot backup of EDrive TS
Wednesday: Hot backup of FDrive TS
Thursday: Hot backup of GDrive TS
Friday: Hot backup of HDrive TS
Saturday: Logical export of database during the day
Sunday: Full Cold backup

thanks

Why not backup everything with a hot backup on Saturday/Sunday and do incrementals on M-F?

IMHO, a logical backup once a week is worthless. What do you hope to gain with an export only once a week?

If you are looking at a complex backup schedule with multi-level backups and partial backups, I would look into using RMAN. It will simplify your tasks many-fold. You can also automate the cleaning of your log_archive_dest with RMAN.