This content has been marked as final. Show 10 replies
Thanks msberg for your reply! these links are helpful. I am also thinking of having some snapshot tool. But at the same time was trying to understand if we cold have something good with RMAN.
Does anyone has any idea whether RMAN image copy/fast and/or merege incremental backup's method can resude the RMAN backup time and make it real faster?
Incremental backups should reduce backup time.
It common to do a full backup on Sunday and then Incremental for the rest of the week to reduce backup times.
Another option would be Data Guard and backup from the Standby database.
Common question, these threads my help :
RMAN on large database
DR startegy for Large database
Re: RMAN Backup Strategy for 40TB Data Warehouse Database
Re: How can I speed up 50TB database backup ?
Please consider closing your question when you have a complete answer.
The answer is completely dependent on how much $$$ you want to spend. For most (who don't have endless budgets), doing L0 once a week and a combination of block change tracking and/or just plain archivelog backups more frequently is sufficient. Restoring and applying those archivelog files will depend on the workload and how much data is stored weekly. One of my previous employers added 1TB/day to their DW, others, not so much.
Whatever method you choose make sure you actually TEST, TEST, TEST that you can indeed restore that backupset. You would be amazed (well, maybe not) at how many people never test and don't find out that something was missing in their "plan" until it is too late.
The speed of the backup depends on the technology you have available.
Tell me what you have available and I'll tell you what are your limitations.
In large environments typically we use technology SNAPSHOT feature is safe and does not impact performance of the database, because you take the backup of whole database in seconds.
*Supported Backup, Restore and Recovery Operations using Third Party Snapshot Technologies [ID 604683.1]*
See this example: