Scripts for duplicating the database from PROD to QA with RMAN
Duplicate command is used for refresh activity in RMAN , It will create replica of Prod environment with single command. It’s very useful when their is regular demand of refresh activity occurred.
Note: you can used it in Linux also by changing extension bat to shell.
For Configure RMAN command on Window Server, Create following two file one as bat and other as text file.
Step 1: Create a bat file for RMAN duplicate command
create dup.bat file
@echo off
REM
set Stamp=%DATE:~-4%%DATE:~-10,2%%DATE:~-7,2%
set ORACLE_SID=SC7PROD
rman catalog rman/rman@rman target / auxiliary system/password@QA cmdfile dup.rcv log dup_%Stamp%.log
create a new textfile and name it “dup.rcv” file
run {
#Allocate the channel for the duplicate work
set until time "to_date('Oct 06 2012 05:20:00','Mon DD YYYY HH24:MI:SS')";
Allocate auxiliary channel ch1 TYPE 'SBT_TAPE';
#Using TAPE then "SEND" cmd, otherwise mentioned "DISK" instead of "SBT_TAPE"
SEND 'NB_ORA_CLIENT=,NB_ORA_SERV=';
#set the new file names and locations for all datafiles
set newname for datafile 1 to 'G:\ORADATA\QA\SYSTEM01.DBF';
set newname for datafile 2 to 'G:\ORADATA\QA\UNDOTBS01.DBF';
set newname for datafile 3 to 'G:\ORADATA\QA\SYSAUX01.DBF';
set newname for tempfile 1 to 'G:\ORADATA\QA\TEMP01.DBF';
set newname for tempfile 2 to 'G:\ORADATA\QA\TEMP02.DBF';
#Duplicate the database to QA
DUPLICATE TARGET DATABASE TO QA LOGFILE
GROUP 1 ('G:\oradata\QA\REDO01.LOG') SIZE 100M,
GROUP 2 ('G:\oradata\QA\REDO02.LOG') SIZE 100M,
GROUP 3 ('G:\oradata\QA\REDO03.LOG') SIZE 100M;}