Oracle Database 11g New Feature - Backup-Based Duplication Without a Target Connection

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.

 

1. Check log_mode of Target Database. Target must be in archivelog mode. Otherwise put the database in archivelog mode.

	select log_mode from v$database;
	shutdown immediate
	startup mount
	alter database archivelog;
	alter database open;
	select log_mode from v$database;

view raw log_mode_switch.sql hosted with ❤ by GitHub
2. 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.

	set ORACLE_SID=catdb
	sqlplus / as sysdba
	create tablespace rman_cat_ts datafile 'c:\rman_cat_ts.dbf' size 15m;
	create user rc_owner identified by rc_owner default tablespace rman_cat_ts quota unlimited on rman_cat_ts;
	grant recovery_catalog_owner to rc_owner;
	exit

view raw create_catalog.sql hosted with ❤ by GitHub
3. Connect to the newly created Recovery Catalog Via RMAN

	rman catalog rc_owner/rc_owner@catdb
	create catalog;
	exit

view raw connect_catalog.sql hosted with ❤ by GitHub
4. Now register your target database (tech) with newly created recovery catalog database (catdb)

	set ORACLE_SID=tech
	rman target / catalog rc_owner/rc_owner@catdb
	register database;
	backup database plus archivelog;
	exit

view raw Register_and_Backup.sql hosted with ❤ by GitHub
5. On Windows Platform You need to Create a new Instance for auxdb which also creates a password file for the same

oradim -new -sid auxdb -syspwd admin

view raw oradim.sql hosted with ❤ by GitHub
6. Create All the folders in Oracle Folder Structures.

	mkdir C:\app\akash\oradata\auxdb
	mkdir C:\app\akash\flash_recovery_area\auxdb
	mkdir C:\app\akash\admin\auxdb
	mkdir C:\app\akash\admin\auxdb\adump
	mkdir C:\app\akash\admin\auxdb\dpdump
	mkdir C:\app\akash\admin\auxdb\pfile

view raw directory.bat hosted with ❤ by GitHub
7. To create a pfile to start the database. You need to open a Notepad and Type db_name=auxdb and save in ORACLE_HOME\database folder and start the instance at nomount stage.

	notepad C:\app\Akash\product\11.2.0\dbhome_1\database\initauxdb.ora
	sqlplus / as sysdba
	startup nomount
	exit

view raw create_pfile_and_start.sql hosted with ❤ by GitHub
8. Now run the below command to Duplicate Database without target connection but using Recovery Catalog.

	--Duplicating Database without target connection but using Recovery Catalog.
	rman auxiliary sys/admin@auxdb catalog rc_owner/rc_owner@catdb
	duplicate database tech to auxdb
	spfile
	parameter_value_convert 'tech','auxdb'
	set db_file_name_convert 'tech','auxdb'
	set log_file_name_convert 'tech','auxdb';

view raw duplicate.sql hosted with ❤ by GitHub
9. If all steps are done correctly you will have a new database clone created successfully without any connection made to target. But you need recovery manager backup for this scenario and connection to recovery catalog database.