Re: What is the basic backup/reco strategy for db>500gb

John

Hot backup is fine in this configuration. What's more important is putting as much data in read only tablespaces as possible. Then (in theory at least) you can back them up once and ignore them from them on.

Pete

duraisingh wrote:

> Hellow Gurus:
> We have planned to do a backup plan for D/W olap database of size >500gb
> in Hp 10.20.
> I want to know , if any one already had the exposure about this subject.
>
> What is the backup method?,
> which tool you are using ?,
> What is the duration of the cold bakup?.
> I know normally datawarehousing databases will be considered for cold
> backup only. What about exports?
> Have you ever taken export ? what is the size of the compressed export
> for a 500gb DB.
> Since our database is hooked up with internet reporting applications.
> So we can not give a very big downtime for cold backups.
>
> If you gurus can enlighten me in this matter, I will be greatful.
>
> John B Durai

Received on Wed Oct 20 1999 - 13:58:31 CDT