-
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
-
Re: Hot Backup questions
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.
Last edited by marist89; 11-08-2002 at 12:45 PM.
Jeff Hunter
-
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
Jeff Hunter
-
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;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|