When I first learned that “dump and sweep” is a procedure for backing up Oracle databases I flashed back to the time a vacuum cleaner salesman dumped a bag of dirt on my carpet and demonstrated the vacuum by sweeping it up. As I learned more about “Dump and Sweep” I realized that it is a method cobbled together to accommodate the different tools the Database Administrators (DBA) and the Backup Administrator use.
“Dump and Sweep” is a two-step process. First, the Oracle DBA backs up a database with RMAN (recovery manager), a tool developed by Oracle, and “dumps” the backup files into an intermediate storage area. Next the Backup Administrator “sweeps” the Oracle backup files out of the intermediate storage area into backup storage.
Recovery is just “Dump and Sweep” in reverse. The DBA requests a recovery from the Backup Administrator. The Backup Administrator then “dumps” the database backup files into the intermediate storage area and RMAN “sweeps” them into production storage.
“Dump and Sweep” works and has been in use for years, but has a few inefficiencies:
NetBackup Copilot for Oracle streamlines the “Dump and Sweep” by eliminating the intermediate storage. The “Dump and Sweep” process does not change from the DBA’s perspective. The DBA backs up a database using RMAN and “dumps” the files directly into a NetBackup appliance running Copilot. The database is recovered directly from the NetBackup appliance using RMAN. Data protection is self-service for the DBA, no need to contact the Backup Administrator. The streamlined “Dump and Sweep” saves time and money and a DBA continues to use the tools and processes they are comfortable with.
NetBackup Copilot for Oracle made me wonder why the salesman didn’t demonstrate the vacuum by eliminating the intermediate step of dumping dirt on my carpet. Just sweep it right out of the bag.
Attend the Northern California Oracle User Group (NoCOUG) Spring 2017 Conference at the Veritas Campus in Mountain View on May 18. This is an opportunity to learn how the “cloud” will affect everything you do in the coming years. Ask yourself this question: What are the simple use-cases for which my organization can leverage the cloud immediately? You will learn the answers at this conference.
To register for the conference visit http://www.nocoug.org/rsvp.html
To learn more about NetBackup Copilot for Oracle attend the conference as a guest of Veritas. Get a free pass by registering in the "Veritas Guest" category using the code VELOCITY
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.