Presentation Title: Automated Oracle E-Business Suite R12.1 Cloning
Speaker: Mr Martyn Baker
Company: Liverpool John Moores University
Presentation abstract: A new project initiative from the Liverpool John Moores University business required a daily copy of the current Production R12.1.3 E-Business Suite environment. The previous strategy for performing a clone of Production was to use the weekly backups taken of the database files, Oracle software and EBS software which meant that the data could be several days old and took around 3.5 hours to complete.

By using the existing logic contained in the master clone script, a new automated cloning script was written that made use of the RMAN "DUPLICATE TARGET DATABASE TO FROM ACTIVE DATABASE" syntax. This not only enabled the cloned database to contain the latest data but also reduced the clone time to around 1.5 hours and could be performed during business hours with minimal impact to user and network performance.

Presentation begins: 07/12/2016 11:30
Presentation duration: 50
Presentation content level: 3 (1 = indepth, 5 = strategic overview)
Audience experience: Intermediate
Audience function: Oracle, Product Expert, Product User
Speaker biography:  I have been an Oracle Database Administrator since version 6 (so for a very long time!) and employed in a wide variety of industry sectors. The Oracle database has evolved greatly over the years and the role of the DBA has changed along the way and it varies from employer to employer. In later years I have worked with E-Business Suite and most recently with PeopleSoft. I have always enjoyed the day-to-day variety and challenges that the DBA role brings.
Related topics: Oracle E-Business Suite - Technology: Other
Hall: Hall 8A

Automated_Oracle_E-Business_Suite_R12.1_Cloning.pdf3.0 MB08/12/2016 11:29:34