Unisoft Technologies Nagpur

We have Target Database name as TECH And we are creating a duplicate database using RMAN Auxiliary Instance with name as AUXDB by using the backup location but without making connection to target database but we will be accessing Recovery Catalog DB. Note :- This practical assume you have same directory structures and it is performed on same server. Just the database name is different so we are converting the path with respect to dbname only.   Check log_mode of Target Database. Target must be in archivelog mode. Otherwise put the database in archivelog mode. Now create a new database manually or via DBCA say CATDB. Then run the below command on CATDB to set this as the new Recovery Catalog for our Use. Connect to the newly created Recovery Catalog Via RMAN Now register your target database (tech) with newly created recovery catalog database (catdb) On Windows Platform You need to Create a new Instance for auxdb which also creates a password file for the...

RMAN has the ability to duplicate, or clone, a database from an active database. I t is possible to create a duplicate database on a remote server with the same file structure, a remote server will a different file structure or the local server with a different file structure.

Oracle 11g New Feature - Duplicating a Oracle Database Using 11g RMAN Backup Location Option but Without Connection to Target or  Recovery Catalog We have Target Database name as ORCL And we are creating a duplicate database using RMAN Auxiliary Instance with name as AUXDB by using the backup location but without making connection to target database and recovery catalog database while the duplication process is running. Note :- This practical need same directory structures and it is performed on same server. Just the database name is different so we are converting the path with respect to dbname only.  Image Source - docs.oracle.com Your Target Database can be in any log mode. Take RMAN Backup based on your Database Log Mode. A) Archivelog Mode - Take a Whole Hot Backup C:\set ORACLE_SID=orcl C:\rman target / RMAN> backup database plus archivelog; B) Noarchivelog Mode - Take a Whole Cold Backup C:\set ORACLE_SID=orcl C:\rman targe...

Oracle 11g New Feature - Duplicating a Database Using 11g RMAN From Active Database Option without ANY BACKUP We have Target Database name as ORCL And we are creating a Auxiliary database with name as AUXDB    Image Source - docs.oracle.com Check log_mode of Target Database. Target must be in archivelog mode. Otherwise put the database in archivelog mode. shutdown immediate startup mount alter database archivelog; alter database open; Create Pfile from Target Database Spfile C:\set ORACLE_SID=orcl C:\sqlplus / as sysdba SQL> create pfile='C:\app\Administrator\product\11.2.0\dbhome_1\database\initauxdb.ora' from spfile; Open pfile with notepad and replace (Ctrl + H) all orcl to auxdb except for parameter local_listener. SQL> host notepad C:\app\Administrator\product\11.2.0\dbhome_1\database\initauxdb.ora On Windows Platform You need to Create a new Instance for auxdb which also creates a password file for the same. SQL> hos...

Duplicating Target Database Using RMAN Auxiliary Instance on Oracle 10g                                                   or Creating Duplicate Database on the Same Server Using RMAN Backup. We have Target Database name as ORCL And we are creating a Auxiliary database with name as AUXDB  Fig :- Backup-Based Duplication with a Target Connection Image Source - docs.oracle.com 1.Take Whole Hot/Cold Backup of Target Database RMAN> backup database plus archivelog; 2.Create Pfile from Target Database Spfile SQL> create pfile='C:\ORACLE\PRODUCT\10.2.0\DB_1\Database\initauxdb.ora' from spfile; 3.Open pfile with notepad and replace (Ctrl + H) all orcl to auxdb SQL> host notepad C:\ORACLE\PRODUCT\10.2.0\...