My Learning

Data refreshing on e-business was queit challenging to do, our developers needed an instance with fresh data (ie: previous day data). As rapid clone needs manual intervention we had to find a way to do it everyday with an automated way. This is one of the methods used. This method assumes already a cloned instance is running for which only data has to be refreshed. The method requires the source database to be down for the database backup.   On the source server connect to sqlplus and issue "alter database backup controlfile to trace", This step has to be done whenever database undergoes some structural changes like adding datafile/logfile. Shutdown the source database and make a backup of datafiles. Move the generated trace file and backed up data files to the destination.  Modify the generated trace file to to match the destination database Clear everything up to "Set #2. RESETLOGS case" Change " CREATE CONTROLFILE REUSE DATABAS

Oracle R12 12.1.3 Office 2013 To create document successfully do the following steps Add the site in trusted sites on explorer (Tools > Internet Options > Security > Sites) Open excel File > Options > Trust center                Click on Trust Center settings Select Disable all macros with notification Check Trust access to the VBA project object model Click Ok Now the document will get created but add in tab will be missing with oracle options Right Click on the Ribbon area and click customize ribbon Select Main Tabs from “Choose command from List” Create a New Tab Select Macro and select BneCreateOracleMenu and Click Add Click on the New Tab > BneCreateOracleMenu This will Display addin with oracle options Save the file as macro enabled work book. Use this file for future upload