Home » RDBMS Server » Backup & Recovery » RMAN Backup DW enviornment
RMAN Backup DW enviornment [message #214738] Wed, 17 January 2007 18:55 Go to next message
Ksaravan
Messages: 17
Registered: January 2007
Location: Portland
Junior Member

What is the best/standard practice to create RMAN backup for DW environments.

RMAN image copy is better or compressed, because compressed is taking more time than backupset or image copy with multiple channels.

Which is best method on DW database size more than 1 TB

Regards
KSARAVA
Re: RMAN Backup DW enviornment [message #214746 is a reply to message #214738] Wed, 17 January 2007 20:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Is this a partitioned database?
RMAN incremental backup would do.
What version of oracle?
In 10g, make use of block change tracking.
Re: RMAN Backup DW enviornment [message #215004 is a reply to message #214738] Thu, 18 January 2007 21:50 Go to previous messageGo to next message
msiam
Messages: 3
Registered: January 2007
Junior Member
Hi,
HyperBac http://www.hyperbac/oracle will allow you to do on-the-fly compression (and AES encryption) of RMAN Image Copy operations (with compression which is much faster than native RMAN compressed backupsets). This would reduce 1TB RMAN Image Copy files to 300GB or less. Will also cut the time required for these backup operations in half, worth checking out for yourself.
Re: RMAN Backup DW enviornment [message #215524 is a reply to message #214738] Mon, 22 January 2007 13:02 Go to previous messageGo to next message
Ksaravan
Messages: 17
Registered: January 2007
Location: Portland
Junior Member
The results are below from my test db

Sr. No Database Size Option Channel Backup Size Compressed Time taken
1 165 G Oracle Suggested – full backup 1 165 G No 3 Hours 40 Minutes
2 165 G Full –Backup set 5 165 G No 1 hour 20 Minutes
3 165 G Customized 5 21 G yes 2 Hours 40 Minutes
4 165 G Customized – Image copy 5 165 G No 1 Hour 40 Minutes

size wise we are gaining but if you time is a constraint i dont think we are gaining much in fact it is more than normal backup window. 2 TB is my DB size, how can we reduce the backup window as well as disk usage.

Im using 10g rel 1 and soon we are upgrading to 10g Rel2 No partions used

Regards
Saravan.
Re: RMAN Backup DW enviornment [message #215557 is a reply to message #215524] Mon, 22 January 2007 20:48 Go to previous messageGo to next message
msiam
Messages: 3
Registered: January 2007
Junior Member
What OS Platform is this running on?
Re: RMAN Backup DW enviornment [message #215776 is a reply to message #215557] Tue, 23 January 2007 20:49 Go to previous messageGo to next message
Ksaravan
Messages: 17
Registered: January 2007
Location: Portland
Junior Member
it is AIX os.
Re: RMAN Backup DW enviornment [message #215811 is a reply to message #215776] Wed, 24 January 2007 00:03 Go to previous message
msiam
Messages: 3
Registered: January 2007
Junior Member
I understand that AIX support for HyperBac for Oracle is due in March.

Previous Topic: can't invertory lib in osb
Next Topic: Database refresh Steps
Goto Forum:
  


Current Time: Fri Dec 09 15:57:27 CST 2016

Total time taken to generate the page: 0.37988 seconds