Hot Backup questions

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.

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.

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.

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

Quote:

---

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/

Quote:

---

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.

Quote:

---

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.

Quote:

---

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.

So what you are saying is that if I have a full HOT backup I can use the create controlfile process on a new machine to restore the database, then rollfoward as far as my arch logs go ??

yes, you can restore to a new server, re-create control file, and apply as many archived redo logs as you wish.

http://metalink.oracle.com/metalink/...T&p_id=69468.1

Hi jeff could u pls explain what this command does....

SVRMGR> alter database recover continue default;

Hi jeff could u pls explain what this command does....

SVRMGR> alter database recover continue default;