Earlier we use to take weekly cold backup but from the last year client
wanted to reduce it cost. So corporated decision
was taken to reduce the cost on backup as the data is not much crucial and
warehoused finally in Teradata instance ( meant for dataware house).

We have told the implication about their backup plan of taking cold backups
on monthly basis. That there might be situation if any archives
is missed during backup or is unavailable during recovery process then you
database cannot be brought till the time of Failure. In that case we have
to
bring the data from Teradata (RDBMS) to Oracle using certain utilities..
which is definitely a tedious task. But its very hard to convince the
client for this issue we have tried very hard on this, but they want to
stick to their plan.

Anyway thanks for the concern Ganesh. What could be better backup plan as
per your experience in such scenairo. Please fo tell us

Actually client has to pay $ 5 for every GB of data. And we have atleast
15 instances in oracle and 1 instance on Teradata.
Each Oracle instance occupies around 300GB of database and Teradata
instance is around 1000GB. So a huge amount is spent on Backups
thats why they are not agreeing..




Vijay,

As the client how important his data is ... Since ... Even if you loose One
Archive Log u cannot bring the data to the Currentr State u may need to do
a Resetlogs ...

You are having too many hooles in your backup plan.. Pls rethink...



Best Regards,
Ganesh R
Everest Reporting Team
DID: +65-6215-8413
Tel: 215-8413
HP : +65-9067-8474








Oracle LazyDBA home page