Database Solutions

Oracle Cloning -  Conventional Restore method and Rename DB post DB Refresh For DBA  Refreshing Table , Schema and Database are routine activity. You can  refresh/Clone  database using below method: 1.Conventional Restore method and Rename DB post DB Refresh 2. Conventional Duplicate Database method 3.  Active database Cloning  4. Backup Base Cloning We will cover all these methods of cloning in individual blogs. In This blog , We will discuss about how to refresh/Clone Database using Conventional Restore method and Rename DB post DB Refresh.   In this method , We will first restore target database on the auxiliary server as target DB name and post restore , We will change the name of the target database to auxiliary database.  Below are the steps for cloning using this method: 1)  Make the Source Database entry in oratab 2)  Set ORACLE_SID environment variable : ORACLE_SID should be set to the proper SID name (target DB) 3)...

Oracle Cloning - Conventional Duplicate Database method For DBA  Refreshing Table , Schema and Database are routine activity. You can  refresh/Clone  database using below method: 1. Conventional Restore method and Rename DB post DB Refresh 2.Conventional Duplicate Database method 3.  Active database Cloning  4. Backup Base Cloning We will cover all these methods of cloning in individual blogs. In This blog , We will discuss about how to refresh/Clone Database using Conventional Duplicate Method.   In Conventional Duplicate Method, Target database backup needed to be copied to auxiliary DB server same as that of the target database. In Conventional method if cloning , We need to connect to the target and auxiliary db and backup should be placed on auxiliary db server . Below are the step followed to perform database cloning using Conventional Duplicate Database method. 1)  Copy the RMAN backup files to Auxiliary database server Note : Director...

Oracle Active database Cloning  For DBA Refreshing Table , Schema and Database are routine activity. You can refresh/Clone database using below method: 1. Conventional Restore method and Rename DB post DB Refresh 2. Conventional Duplicate Database method 3. Active database Cloning  4. Backup Base Cloning We will cover all these methods of cloning in individual blogs. In This blog , We will discuss about how to refresh/Clone Database from active Database.  In Active database Cloning, Auxiliary Database is cloned from the live target database without the need of the backup to be copied to Auxiliary DB Server. The duplication work is being performed by the auxiliary channel and these channels corresponds to the server session in auxiliary DB instance.  Below are the step followed to perform active database duplication of the RAC Database. 1) Create ASM Directories. alter diskgroup DATA add directory '+DATA/CLONEDB'; alter diskgroup DATA add directory '+D...

 Oracle Backup-Bases database Cloning  For DBA Refreshing Table , Schema and Database are routine activity. You can refresh /Clone database using below method: 1. Conventional Restore method and Rename DB post DB Refresh 2. Conventional Duplicate Database method 3. Active database Cloning  4.Backup Base Cloning We will cover all these methods of cloning in individual blogs. In This blog , We will discuss about how to refresh/Clone Database using Backup-Bases loning.  In Backup-Based, Auxiliary Database is cloned from the backup of the target databases. Backup of the target database must be accessible from the the auxiliary database server . In Case of the Backup-Base Cloning there is no need to connect to the target database.  Below are the step followed to perform Backup-Bases database duplication 1) Create Pfile for auxiliary database auxdb.__data_transfer_cache_size=0 auxdb.__db_cache_size=7952400384 auxdb.__java_pool_size=234881024 auxdb.__large_pool_si...