mark How to bulk update Enterprise Manager Target Properties. Step-by-step guide Login to emcli (login to repository host as the Oracle user, enter the password when prompted) emcli login -username=sysman To extract a list of database targets, run the following (modify the output if required. For example, if you wish to emcli get_targets -noheader -format=’name:script;column_separator:|;’ -targets=’%database%’ … Read more
Step-by-step guide Exporting statistics is a three step process. The result is a single table containing schema statistics (table, index and column) and system statistics (workload and non-workload). The first step creates a physical version of a StatTable. The StatTable is a consolidated table to hold all types of statistics, so the format is very … Read more
Oracle – Fool proof way to restore a database using RMAN Goal This method will ensure a clean restore from tape. Although this is designed to run from ASM to non-ASM, this method can be adapted from NON ASM as well. Solution Step 1. First gather the required information from the source database. This can … Read more
We are looking to migrate some customer data, however we don’t need all the data, but only a subset. The idea was to create a copy of the existing tables using a copy with the relevant rows, then create a series of triggers to keep them up-to-date with the main tables. It goes something like … Read more