
	Home > Oracle Database / Applications Tips > Oracle Database Administrator > Oracle RMAN case study: Improving backup and recovery efficiency

Oracle Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

ORACLE DATABASE ADMINISTRATOR

Oracle RMAN case study: Improving backup and recovery efficiency

Rama Balaji
12.19.2007
Rating: -2.88- (out of 5)

Digg This!

StumbleUpon

Del.icio.us

The National Business Center (NBC) provides business services to government agencies in the areas of Financial Management, Human Resources Management, Training, Acquisitions, Information Technology Hosting, Aviation Services, Appraisal Services, and other administrative areas. One of the top priority areas in the Information Technology Hosting unit at NBC is data protection and fast data retrieval in case of disk failure or disaster recovery.

The NBC's data center runs its Oracle databases on multiple platforms (z/OS, Sun Solaris, Linux) and utilizes various applications including SAP, Oracle Federal Financials, and other third party applications. Before the introduction of Oracle Recovery Manager (RMAN) in 2001, all the OLTP databases and data mart databases (total of ~3TB) on the mainframe and other platforms were being backed up using third party tools at the OS level. This case study describes how NBC implemented RMAN on all platforms, from UNIX/Linux to the mainframe, resulting in faster backups and reduced application downtime.

RMAN usage for Oracle Financials databases on Linux

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Oracle Database Administrator
	Understanding SQL string functions
	What is the difference between a database engineer, architect and administrator?
	Import on one table from dump file
	Error during RMAN backup
	Can I drop a column in SYS schema?
	STATSPACK tool: transaction vs. execution measurement
	Should I port from Microsoft Access?
	How can I find statistics on total memory usage and database connections?
	Installing multiple Oracle homes
	Modifying SYS password in a RAC environment

Oracle database backup and recovery

How to export triggers in an Oracle export command

How to precreate Oracle table extents and define extent size

How to trim the Oracle listener log in Unix/Linux

How to avoid invalid objects in Oracle when restoring the database

How to perform an Oracle 9i upgrade with the Database Upgrade Assistant

How to avoid Oracle error ORA-00060 when dropping a datafile in Oracle 10g

How to precreate tablespaces in Oracle before a new database import

How to solve an Oracle import error

How to use Transportable Tablespaces in Oracle to copy files quickly

Exadata: A first look at Oracle's entry into the appliance market

Oracle database backup and recovery Research

Oracle database availability

Firm dumps MySQL on Red Hat for Oracle Database on Oracle Linux

Data modeling tools no substitute for hard work

Oracle and the rise of the virtual machine

Using connection load balancing with Oracle RAC

Grid computing adoption slow amid fears of complexity

DBA 102: Beyond the basics

Difference between Oracle RAC and Data Guard

Author Mike Ault sizes up the new Oracle Database 11g

Oracle UDP protocol or Veritas LLT for interconnect traffic?

Podcast: Oracle Database 11g preview -- New automated features promise to make DBA life easier

Oracle database availability Research

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

>While NBC uses SAP for its large clients, NBC's small clients' accounting operations and IT services are implemented using Oracle Federal Financials 11i (OFF). NBC uses RMAN to backup these databases running on Linux servers. Oracle Federal Financial databases are backed up using daily RMAN online backups via Tivoli Data Protection agents, which are installed on each server. While the backup/restore implementation for OFF is similar to FBMS, RMAN is also used to clone the OFF production databases. Using RMAN for this purpose has been a major time and labor saver versus manual cloning methods. Cloning is used to refresh test and QA servers from production for the purpose of testing patches, especially security-related patches.

The following advantages were realized using RMAN to clone databases versus manual methods:

The following steps are used to clone OFF databases:

Read more about RMAN usage with SAP (Unix), data warehouses (Z/OS), and Data Guard here.

About the author

Rama Balaji is an Oracle Certified Professional and senior Oracle DBA at Infoteknow International, Inc.

Rate this Tip
To rate tips, you must be a member of SearchOracle.com. Register now to start rating these tips. Log in if you are already a member.
Submit a Tip

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Oracle Development Solutions - SQL, J2EE, XML, SOA

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2003 - 2009, TechTarget \| Read our Privacy Policy