Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ABC of Hot Backup
If you are overwriting your backup tape every 48 hours, what would you do
if you have a catastrophic failure while you are taking a backup? Not only
would you lose the database, but you'd have to backup to use for recovery.
Venkatesh Kumar wrote:
>
> Hi guys,
> Iam new to this Oracle Back up stuff. We have an Oracle 8.x database running
> in Archive Mode. The ARchive logs are created in a sepearet DISK. As part of my
> back up strategy how often do I back up the log files. Some recommendations I
> have heard is that you can back up every 48 hrs depending on how much space you
> have one the Disk where the files are being logged. Here is my question. When I
> back up every 48 hrs, can i use the same tape and overwite data every 48 hrs and
> still be able to recover or recovery is always from the time when I first
> started the database, in which case we have to keep a really big stack of tapes.
> Iam thinking I an overwrite the files evrey 48 hrs, but I just want to confirm
> that is true. Also We are doing hotbackup every night. In case of a database
> crash, how do you recover ? Do I have to take a cold back before I stare doing
> hot back or is it not necessary. I konw these are lots of questions, butI think
> this has been done plenty of times by the experts. What is a typical backup and
> recovery strategy and how do you start implementing it.
>
> Thanks
> Venkatesh Kumar
Received on Mon Oct 04 1999 - 12:14:20 CDT