By submitting my Email address I confirm that I have read and accepted the Terms of Use and Declaration of Consent.

By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.

You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

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

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 back up 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:

RMAN restore is faster than using Tivoli tape restore operation at the OS level as RMAN only restores the blocks that have ever been used.

The clone database DBID is automatically changed at the end of the cloning operation.

The new clone database can be immediately registered in the catalog and backed up using RMAN.

The following steps are used to clone OFF databases:

TDPO.OPT file is changed to point to the source node in Tivoli.

Set DB_FILE_NAME_CONVERT, LOG_FILE_NAME_CONVERT parameters in the target database initialization file.

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy