Thursday, April 26, 2007

Recovery Manager: 07 Creating compressed backups

Click here to read the previous step

Untill Oracle 9i version you could reduce the size of backups backing up only used blocks and skipping unused blocks: in this way you would reduce only the backup sizes of datafiles that were oversized or had significant free space.

Oracle 10g RMAN has introduced the capability to compress backups: indeed it is possible now to compress backups regardless of the contents of the datafiles, using the new BACKUP AS COMPRESSED command.
Compressed backups work only with backup sets (database, tablespace, and datafile backup sets), so you cannot compress image copies.

The following command will backup an entire database using a compressed backup
RMAN> backup as compressed backupset database;
To configure the default backup type for a compressed backup set use the
following command:
RMAN> configure device type disk backup type to compressed backupset;
Compressed database backup sets are compressed at approximately a 5-to-1
ratio, or 20 percent of the size of a standard backup set.


Coach Factory said...

oakley sunglasses, oakley vault, jordan shoes, polo ralph lauren outlet, burberry outlet online, michael kors outlet online, true religion, christian louboutin shoes, tiffany and co jewelry, louis vuitton outlet, gucci handbags, christian louboutin outlet, nike shoes, michael kors outlet online, longchamp outlet, tory burch outlet, coach outlet, red bottom shoes, louboutin shoes, ray ban sunglasses, coach purses, michael kors outlet store, air max, louis vuitton outlet online, cheap oakley sunglasses, coach outlet store online, coach factory outlet, prada handbags, chanel handbags, ray ban outlet, longchamp outlet online, kate spade outlet online, burberry outlet online, louis vuitton, polo ralph lauren, nike free, prada outlet, louis vuitton handbags, michael kors outlet online, michael kors outlet, michael kors outlet online, louis vuitton outlet, kate spade handbags, longchamp handbags, nike air max

Coach Factory said...

barbour, oakley pas cher, abercrombie and fitch, nike air force, mac cosmetics, ray ban uk, air max, guess pas cher, vans outlet, hermes pas cher, michael kors uk, nike roshe, ralph lauren pas cher, timberland, hollister, longchamp pas cher, sac michael kors, lululemon, sac vanessa bruno, michael kors canada, sac louis vuitton, mulberry, north face pas cher, ray ban pas cher, longchamp, converse pas cher, chaussure louboutin, nike blazer pas cher, longchamp, nike trainers, nike roshe run, lacoste pas cher, louis vuitton uk, scarpe hogan, nike huarache, tn pas cher, louis vuitton, hollister, louis vuitton pas cher, north face, ralph lauren, nike air max, new balance pas cher, vans pas cher, roshe run, abercrombie and fitch, nike free, nike free pas cher, hollister, burberry pas cher

Coach Factory said...

north face outlet, bottega veneta, rolex watches, canada goose, reebok outlet, north face jackets, moncler outlet, beats headphones, ugg boots, nfl jerseys, marc jacobs outlet, chi flat iron, canada goose uk, babyliss pro, insanity workout, timberland shoes, birkin bag, canada goose pas cher, giuseppe zanotti, lululemon outlet, jimmy choo shoes, soccer jerseys, canada goose outlet, new balance outlet, asics shoes, canada goose outlet, celine handbags, moncler, ugg outlet, moncler, mont blanc pens, instyler ionic styler, iphone 6 case, hollister clothing, ghd, p90x workout, ugg soldes, soccer shoes, uggs on sale, nike air max, herve leger, wedding dresses, canada goose outlet, baseball bats, mcm handbags, moncler, ferragamo shoes, valentino shoes, uggs outlet, ugg