Oracle Enterprise Manager has a cloning wizard to automate the cloning of Oracle homes, databases, and application server (9.0.4 and up) installations to the same host or multiple hosts. Oracle Enterprise Manager provides a Clone Oracle Home tool that will help you to clone an Oracle home to one or more hosts. Similarly, the Clone Database tool helps in cloning a database to one or more hosts. By default, it clones the database instance to an existing Oracle home. If you want to clone the database instance under a new Oracle home, create a new Oracle home using the Clone Oracle Home tool and then clone the instance to that home using the Clone Database tool. When you use Oracle Database 10g on a host with a lower level of Enterprise Manager Agent (9.2) on it, the cloning of ORACLE_HOME will fail. (This is reported as bug #3164441.) If this happens to you, stop the agent and attempt the cloning again. If you are attempting the database cloning in a RAC clusterenabled installation of Oracle Database 10g Release 1, it will also fail (bug #3319121). Before you clone a database using Oracle Enterprise Manager Release 1, change the ownership of extjob to Oracle user to avoid errors. Cloning of cluster-enabled ORACLE_HOME installations is available only in Oracle Database 10g Release 2.
In a Windows installation, when you use Oracle Enterprise Manager to clone an Oracle home or database, you may get password errors with your OS user account. To resolve this, make sure that the user has Log On as Batch Job privileges. Using Windows administrative tools, under Local Security Policy, Local Policies, User Rights Assignment, add the OS user to Log On as Batch Job (see Figure 2.5). Figure 2.5. Adding privileges to an OS user for cloning on Windows. |