Of course, if you already have made backups of the source database, you can skip this step.2.

Ingeniero de Sistemas con énfasis en software y Especialización en Gerencia de Proyectos, Instructor y Especialista Oracle Certificate 10G - 11G, Experiencia Oracle 8I 9I 10G 11G 12C OCA - OCP Experiencia (Real Application Cluster) Cloud Control 12C - (Data Guard) Oracle Web Logic, Certificate ITIL V3, Experiencia en Plataformas Unix-AIX-HPUX-SUN-Linux, Admon (OAS - BEA WEBLOGIC) programación Power Builder Visual Basic C, C , Informix R4gl, Oracle PL/SQL, BI (COGNOS – HYPERION)db_file_name_convert and the log_file_name_convert Once you specify the spfile parameter during the database duplication, you can provide your list of initialization parameters and the values for them through the parameter_value_convert clause and the set clause.

It’s easiest to use the parameter_value_convert clause in the duplicate database command to specify all parameters that specify a directory path.

Furthermore, Oracle strongly recommends the use of Oracle Grid Control for managing sophisticated options like its fully active-active clustered database option, Oracle Real Application Clusters (Oracle RAC).

This is so especially in the area of analyzing cluster performance, which is greatly aided by Oracle Grid Control.

It is not practical to do so, due to the immense complexity of today’s Oracle enterprise database software.

The core database facilities are becoming more and more sophisticated, and it is extremely tedious to use only the command line to manage these complex options.Test/Development teams.* Cloning is nothing but creating a copy of production system in to a test or development environment. Having an exact image of production database in test area.* Cloning is a procedure for preparing and creating a test or development servers with the copy of Oracle production database for testing upgrades, migrating an existing system to new hardware.* A cloning process includes a copy of Oracle Home (Directories and Binaries) backup and Database (Database related files) backup to prepare the instance on another server.* Though, it is possible to clone a database on the same server, Oracle doesn’t suggest to clone a database on the same server, where the production database is running.* Refreshing a database is something like applying the changes or updates of production database to the database where the database is already cloned. let’s say you have cloned a database a month back, and now you are asked for doing refresh of a database, then you will perform the backup of database and prepare the clone the instance again on test server.This is nothing but refreshing.* When an Oracle patch is applied on Production System, or in doubt, you have to prepare and clone the database again with the copy of Oracle Home (Directories and Binaries) Backup and Database (Database related files) Backup to prepare the instance.* Generally production (PROD) database is cloned for various reasons and needs i.e.You can contact me at @ Dear Friends and Blog Readers, I have been asked many times about the Cloning and Refresh process of Oracle Database by emails of blog readers and the users of the Oracle Technology Network (OTN) Forums.Here, in this post, I would like to explain and provide the information on the following Questions about Cloning and Refreshing of a Database with my simple terms.* A database clone is an activity/procedure which is performed by every DBA on regular basis or when there is a requirement or request to do so from the different departments i.e.You can specify all such directory-related parameter values through the parameter_value_convert parameter, except for the db_file_name_convert and log_file_name_convert parameters.