RMAN - Database Cloning

Target Database : TSTP

Test Database : TSTRMN

1. Backup the Target DB:

Login to target database ( TSTP ) and run backup through rman

c:\rman
rman> backup database; ( if DB is in noarchive log mode then make sure it should not be open mode - MOUNT stage only)

2. Startup nomount (auxiliary database) - set ORACLE_SID=TSTRMN

SQL> startup nomount
ORACLE instance started.

Total System Global Area 97589952 bytes
Fixed Size 453312 bytes
Variable Size 46137344 bytes
Database Buffers 50331648 bytes
Redo Buffers 667648 bytes
SQL> exit

3. Start the Cloning Process

3. Run Rman clone process
C:\>rman

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN> connect target system/manager@tstp

connected to target database: TSTP (DBID=422537837)

RMAN> CONNECT AUXILIARY SYS/tstrmn

connected to auxiliary database: tstrmn (not mounted)

RMAN> connect target system/manager@tstp

connected to target database: TSTP (DBID=422537837)

RMAN> CONNECT AUXILIARY SYS/tstrmn

connected to auxiliary database: tstrmn (not mounted)

RMAN> CONFIGURE CHANNEL DEVICE TYPE disk CLEAR;

using target database controlfile instead of recovery catalog
old RMAN configuration parameters are successfully deleted

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored

RMAN> run
2> {
3> SET NEWNAME FOR DATAFILE 1 TO 'c:\tstrmn\system01.dbf';
4> DUPLICATE TARGET DATABASE TO tstrmn
5> LOGFILE
6> GROUP 1 ('c:\tstrmn\redo01a.log',
7> 'c:\tstrmn\redo01b.log') SIZE 200K REUSE,
8> GROUP 2 ('c:\tstrmn\redo02a.log',
9> 'c:\tstrmn\redo02b.log') SIZE 200K REUSE;
10> }

executing command: SET NEWNAME

Starting Duplicate Db at 16-JAN-06

allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=10 devtype=DISK

printing stored script: Memory Script
{
set newname for datafile 1 to
"C:\TSTRMN\SYSTEM01.DBF";
restore
check readonly
clone database
;
}
executing script: Memory Script

executing command: SET NEWNAME

Starting restore at 16-JAN-06

using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\TSTRMN\SYSTEM01.DBF
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=C:\ORACLE\ORA92\DATABASE\02H90PPG_1_1 tag=TAG20060116T161544 params
=NULL
channel ORA_AUX_DISK_1: restore complete
Finished restore at 16-JAN-06
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "tstrmn" RESETLOGS NOARCHIV
ELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 1048
MAXINSTANCES 1
MAXLOGHISTORY 907
LOGFILE
GROUP 1 ( 'c:\tstrmn\redo01a.log', 'c:\tstrmn\redo01b.log' ) SIZE 204800
REUSE,
GROUP 2 ( 'c:\tstrmn\redo02a.log', 'c:\tstrmn\redo02b.log' ) SIZE 204800
REUSE
DATAFILE
'C:\TSTRMN\SYSTEM01.DBF'
CHARACTER SET US7ASCII

printing stored script: Memory Script
{
switch clone datafile all;
}
executing script: Memory Script

printing stored script: Memory Script
{
recover
clone database
noredo
,
delete archivelog
;
}
executing script: Memory Script

Starting recover at 16-JAN-06
using channel ORA_AUX_DISK_1
Finished recover at 16-JAN-06

printing stored script: Memory Script
{
shutdown clone;
startup clone nomount ;
}
executing script: Memory Script

database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 97589952 bytes

Fixed Size 453312 bytes
Variable Size 46137344 bytes
Database Buffers 50331648 bytes
Redo Buffers 667648 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "tstrmn" RESETLOGS NOARCHIV
ELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 1048
MAXINSTANCES 1
MAXLOGHISTORY 907
LOGFILE
GROUP 1 ( 'c:\tstrmn\redo01a.log', 'c:\tstrmn\redo01b.log' ) SIZE 204800
REUSE,
GROUP 2 ( 'c:\tstrmn\redo02a.log', 'c:\tstrmn\redo02b.log' ) SIZE 204800
REUSE
DATAFILE
'C:\TSTRMN\SYSTEM01.DBF'
CHARACTER SET US7ASCII

printing stored script: Memory Script
{
Alter clone database open resetlogs;
}
executing script: Memory Script

database opened
Finished Duplicate Db at 16-JAN-06