Clone an instance using the Oracle DBCA command

Using dbca to clone an instance does not need to be as tedious as restoring a Data Pump. It is similar to rman in terms of table space creation, User Creation, authorization, copy, and restoration. However, there is still a gap between efficiency and rman.

When creating an instance, you can save it as a template. In fact, you can also use the DBCA command to create an instance template and use this function to copy the instance. This feature is rarely noticed.

Here we choose ManageTemplate:

Note the following three types of template creation:

Installing Oracle Database and Creating aDatabase

Http://docs.oracle.com/cd/E11882_01/server.112/e10897/install.htm#ADMQS023

(1) From an existing template

Using anexisting template, you can create a new template based on the predefinedtemplate settings. You can add or change any template settings such asinitialization parameters, storage parameters, or whether to use customscripts.

-- Create a new template based on an existing template. On this basis, you can modify the parameters of the old template.

(2) From an existing database (structure only)

You can create anew template that contains structural information from an existing database, including database options, tablespaces, data files, and initializationparameters. user-defined schemas and their data will not be part ofthe created template. the source database can be either local or remote. selectthis option when you want the new database to be structurally similar to thesource database, but not contain the same data.

-- Create a template based on an existing database instance. This template only contains structural information, such as database options, tablespaces, datafiles, and initialization parameters. User-Defined schemas and data are not included in the template. Therefore, this template only contains basic architecture information.

1 2 3 Next Page