Hi Yves,
I deploy the RMAN solution at customer sites for all major accounts.
The one 4TB solution was RMAN hot backups.
One full backup to tape a month - which usually ran for 30 hours (Architectural constraints) with DB up and available.
Incremental backups are scheduled twice a week for changing data as well as newly added datafiles (also to tape).
Archives are also sent to tape via RMAN on a regular interval.
It appears that todays Warehouses are partly OLTP / DataMart , a new trend in the industry.
If money is not an object:
You can spice up all the above with a split Disk Copy of the most recent full backup, that way in the event of recovery, you can retreive from disk. This disk copy can also be split to the
mirror for further redundancy.
You will be surprised how many TBSPIT (TableSpace Point-in-Time) recoveries have been requested in a Warehouse. Prepare for this, using a Crash and Burn Server dedicated to restoring P.I.T
tablespaces, as the method to do this is to use an Auxillary database, preferably aside from Production.
Happy implementing.
Nadiem Greeff
RMAN Virtual Team Leader
Oracle Data Protection Police.
Yves wrote:
> Gurus, we are planning the storage and backup requirement for a new system.
>
> The system will accumulate 5TB of data over a 4-5 months period. Now my question is : What kind of backup strategy should we implement? The system can not be down for more than 1 day if
> Something happens. Should we do a mix of cold and hot backups or rely only of hot backup or something else?
>
> I've never been in charge of supporting such a large system, so any help would be appreciated.
>
> Merci / Thanks
> Yves Leonard,
> Chef de Projet / Project Leader,
> DDS / SDD,
> RH Coats, 13-I
> Téléphone / phone : 613-951-3233,
> couriel / email : yves.[Email address protected]
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page