Netsoftmate

Rman backup based duplication with different DB name and directory structure without using SPFILE

Written by

Netsoftmate

in

Overview:

Oracle Recovery Manager (RMAN) provides a comprehensive foundation for efficiently backing up and recovering the Oracle databases, it provides a common interface, via command line and Enterprise Manager, for backup tasks across different host operating systems, automates administration of your backup strategies.
In this scenario we have different database name and different directory structure. And we are not using SPFILE.

Target
(source) details:

Database Name
prod
Hostname
NSM-SRC
Ip Address
172.16.110.18
OS
Linux
Version
x86_64
Datafile Location
/data2/prod
Backup Location
/backup/rman_backup
Destination details

Database Name
nospfile
Hostname
NSM-TRG
Ip Address
172.16.110.16
OS
Linux
Version
x86_64
Datafile Location
/data2/nospfile/
Backup Location
/backup/rman_backup
Pre-requisites:

  • Password file from target database.
  • Sqlnet.ora should have correct parameters.
  • Target database should be running through pfile.
  • Auxiliary instance should be start with pfile in nomount stage. 

Steps on source server 

  • Set Oracle sid on which backup will perform.
[oracle@NSM-SRC
dbs]$ hostname

NSM-SRC

[oracle@NSM-SRC
dbs]$ export ORACLE_SID=prod
  • Check database is running from pfile or spfile.
NAME       OPEN_MODE

———-
————–

PROD       READ WRITE

SQL>
select value from v$parameter where name=’spfile’;

VALUE

——————–

or

SQL>
show parameter pfile

NAME                                 TYPE                              VALUE

————————————
——————————— ——————————

spfile                               string

  • Connect to target instance via RMAN.

[oracle@NSM-SRC
dbs]$ rman target sys/oracle

Recovery
Manager: Release 11.2.0.1.0 – Production on Mon Apr 13 10:13:01 2015

Copyright
(c) 1982, 2009, Oracle and/or its affiliates. 
All rights reserved.

connected
to target database: PROD (DBID=284539893)

RMAN>

  • Issue the following command to initiate backup. Before issue the backup command check the backup location is sat correctly.
RMAN>
show all;

using
target database control file instead of recovery catalog

RMAN
configuration parameters for database with db_unique_name PROD are:

CONFIGURE
RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE
BACKUP OPTIMIZATION OFF; # default

CONFIGURE
DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE
CONTROLFILE AUTOBACKUP ON;

CONFIGURE
CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/backup/rman_backup/controlfile_%F’;

CONFIGURE
DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE
ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE
CHANNEL DEVICE TYPE DISK FORMAT  
‘/backup/rman_backup/db_arch_%U.bkp’;

CONFIGURE
MAXSETSIZE TO UNLIMITED; # default

CONFIGURE
ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE
ENCRYPTION ALGORITHM ‘AES128’; # default

CONFIGURE
COMPRESSION ALGORITHM ‘BASIC’ AS OF RELEASE ‘DEFAULT’ OPTIMIZE FOR LOAD TRUE ;
# default

CONFIGURE
ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE
SNAPSHOT CONTROLFILE NAME TO
‘/data2/app/oracle/product/11.2.0/dbs/snapcf_prod.f’; # default
RMAN>
list backup;

specification
does not match any backup in the repository
RMAN>
backup database plus archivelog;

Starting
backup at 13-APR-15

current
log archived

allocated
channel: ORA_DISK_1

channel
ORA_DISK_1: SID=15 device type=DISK

channel
ORA_DISK_1: starting archived log backup set

channel
ORA_DISK_1: specifying archived log(s) in backup set

input
archived log thread=1 sequence=153 RECID=149 STAMP=876910536

channel
ORA_DISK_1: starting piece 1 at 13-APR-15

channel
ORA_DISK_1: finished piece 1 at 13-APR-15

piece
handle=/backup/rman_backup/db_arch_2uq495u9_1_1.bkp tag=TAG20150413T101536
comment=NONE

channel
ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished
backup at 13-APR-15

Starting
backup at 13-APR-15

using
channel ORA_DISK_1

channel
ORA_DISK_1: starting full datafile backup set

channel
ORA_DISK_1: specifying datafile(s) in backup set

input
datafile file number=00001 name=/data2/prod/system01.dbf

input
datafile file number=00002 name=/data2/prod/sysaux01.dbf

input
datafile file number=00005 name=/data2/prod/example01.dbf

input
datafile file number=00003 name=/data2/prod/undotbs01.dbf

input
datafile file number=00006 name=/data2/prod/data01.dbf

input
datafile file number=00004 name=/data2/prod/users01.dbf

input
datafile file number=00007 name=/data2/prod/test01.dbf

input
datafile file number=00008 name=/data2/prod/tools01.dbf

channel
ORA_DISK_1: starting piece 1 at 13-APR-15

channel
ORA_DISK_1: finished piece 1 at 13-APR-15

piece
handle=/backup/rman_backup/db_arch_2vq495ua_1_1.bkp tag=TAG20150413T101538 comment=NONE

channel
ORA_DISK_1: backup set complete, elapsed time: 00:00:55

Finished
backup at 13-APR-15

Starting
backup at 13-APR-15

current
log archived

using
channel ORA_DISK_1

channel
ORA_DISK_1: starting archived log backup set

channel
ORA_DISK_1: specifying archived log(s) in backup set

input
archived log thread=1 sequence=154 RECID=150 STAMP=876910594

channel
ORA_DISK_1: starting piece 1 at 13-APR-15

channel
ORA_DISK_1: finished piece 1 at 13-APR-15

piece
handle=/backup/rman_backup/db_arch_30q49603_1_1.bkp tag=TAG20150413T101635
comment=NONE

channel
ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished
backup at 13-APR-15

Starting
Control File Autobackup at 13-APR-15

piece
handle=/backup/rman_backup/controlfile_c-284539893-20150413-00 comment=NONE

Finished
Control File Autobackup at 13-APR-15

RMAN>
list backup;

List of
Backup Sets

===================

BS
Key  Size       Device Type Elapsed Time Completion Time

——-
———- ———– ———— —————

32      3.36M   
  DISK        00:00:00     13-APR-15

        BP Key: 32   Status: AVAILABLE  Compressed: NO  Tag: TAG20150413T101536

        Piece Name:
/backup/rman_backup/db_arch_2uq495u9_1_1.bkp

  List of Archived Logs in backup set 32

  Thrd Seq    
Low SCN    Low Time  Next SCN  
Next Time

  —- ——- ———- ——— ———-
———

  1   
153     5172938    13-APR-15 5176490    13-APR-15

BS
Key  Type LV Size       Device Type Elapsed Time Completion Time

——-
—- — ———- ———– ———— —————

33      Full   
1.11G      DISK        00:00:54     13-APR-15

        BP Key: 33   Status: AVAILABLE  Compressed: NO  Tag: TAG20150413T101538

        Piece Name:
/backup/rman_backup/db_arch_2vq495ua_1_1.bkp

  List of Datafiles in backup set 33

  File LV Type Ckp SCN    Ckp Time 
Name

  —- — —- ———- ——— —-

  1      
Full 5176498    13-APR-15
/data2/prod/system01.dbf

  2      
Full 5176498    13-APR-15
/data2/prod/sysaux01.dbf

  3      
Full 5176498    13-APR-15 /data2/prod/undotbs01.dbf

  4      
Full 5176498    13-APR-15
/data2/prod/users01.dbf

  5      
Full 5176498    13-APR-15
/data2/prod/example01.dbf

  6      
Full 5176498    13-APR-15
/data2/prod/data01.dbf

  7      
Full 5176498    13-APR-15
/data2/prod/test01.dbf

  8      
Full 5176498    13-APR-15
/data2/prod/tools01.dbf

BS
Key  Size       Device Type Elapsed Time Completion Time

——-
———- ———– ———— —————

34      9.00K     
DISK        00:00:00     13-APR-15

        BP Key: 34   Status: AVAILABLE  Compressed: NO  Tag: TAG20150413T101635

        Piece Name:
/backup/rman_backup/db_arch_30q49603_1_1.bkp

  List of Archived Logs in backup set 34

  Thrd Seq    
Low SCN    Low Time  Next SCN  
Next Time

  —- ——- ———- ——— ———-
———

  1   
154     5176490    13-APR-15 5176531    13-APR-15

BS
Key  Type LV Size       Device Type Elapsed Time Completion Time

——-
—- — ———- ———– ———— —————

35      Full   
9.52M      DISK        00:00:02    
13-APR-15

        BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: TAG20150413T101636

        Piece Name:
/backup/rman_backup/controlfile_c-284539893-20150413-00

  Control File Included: Ckp SCN: 5176543      Ckp time: 13-APR-15

RMAN>

  • Create pfile and copy to destination server
SQL> create
pfile=’/backup/rman_backup/initprod.ora’ from spfile;

File created.

[oracle@NSM-SRC
dbs]$ scp initprod.ora
oracle@172.16.110.16:/data1/oracle11g/product/dbs/initnospfile.ora

oracle@172.16.110.16’s
password:

initprod.ora                                                                                                                                     

                 100% 1169     1.1KB/s  
00:00
 Before start scp/ftp to destination server create directory structure to accommodate rman backup on destination server.

[oracle@NSM-TRG
prod]$ mkdir -p /backup/rman_backup/
  •  

    Copy rman backup from target to destination server.

RMAN>
exit

Recovery
Manager complete.

[oracle@NSM-SRC
dbs]$ cd /backup/rman_backup/

[oracle@NSM-SRC
rman_backup]$ ls -lrt

total
1176020

-rw-r—–.
1 oracle dba    3526656 Apr 13 10:15
db_arch_2uq495u9_1_1.bkp

-rw-r—–.
1 oracle dba 1190690816 Apr 13 10:16 db_arch_2vq495ua_1_1.bkp

-rw-r—–.
1 oracle dba       9728 Apr 13 10:16
db_arch_30q49603_1_1.bkp

-rw-r—–.
1 oracle dba    9994240 Apr 13 10:16
controlfile_c-284539893-20150413-00

[oracle@NSM-SRC
rman_backup]$ scp * oracle@172.16.110.16:/backup/rman_backup/

oracle@172.16.110.16’s
password:

controlfile_c-284539893-20150413-00                                                                                                              

                 100% 9760KB   9.5MB/s  
00:01

db_arch_2uq495u9_1_1.bkp                                                                   
                                                      

                 100% 3444KB   3.4MB/s  
00:00

db_arch_2vq495ua_1_1.bkp                                                                                                                         

                 100% 1136MB  11.1MB/s  
01:42

db_arch_30q49603_1_1.bkp                                                                                                                         

                 100% 9728     9.5KB/s  
00:00

Steps on destination server:

  • Create new directory structure.
[oracle@NSM-TRG
dbs]$ mkdir -p /data2/nospfile/
  •  

    Edit the pfile which we have copied from source server.

/data1/oracle11g/product/dbs

[oracle@NSM-TRG
dbs]$ vi initnospfile.ora
Here we have modified new controlfile location and db_name parameters

*.control_files=’/data2/nospfile/control01.ctl’,’/data2/nospfile/control02.ctl’

*.db_name=’nospfile’

  • Create password file

[oracle@NSM-TRG
dbs]$ orapwd file=orapwnospfile password=oracle


 

  • Start the instance in no mount stage.
[oracle@NSM-TRG
dbs]$ export ORACLE_SID=nospfile

[oracle@NSM-TRG
dbs]$ sqlplus

SQL*Plus:
Release 11.2.0.1.0 Production on Mon Apr 13 10:42:46 2015

Copyright
(c) 1982, 2009, Oracle.  All rights
reserved.

Enter
user-name: sys as sysdba

Enter password:

Connected
to an idle instance.

SQL>
startup nomount

ORACLE
instance started.

Total
System Global Area 1152450560 bytes

Fixed
Size                  2212696 bytes

Variable
Size             352324776 bytes

Database
Buffers          788529152 bytes

Redo
Buffers                9383936 bytes

SQL>

SQL>
exit

Disconnected
from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit
Production

With the
Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@NSM-TRG
dbs]$

  • Connect to auxiliary instance via RMAN and issue the duplicate command.
[oracle@NSM-TRG
dbs]$ rman auxiliary sys/oracle

Recovery
Manager: Release 11.2.0.1.0 – Production on Mon Apr 13 10:47:05 2015

Copyright
(c) 1982, 2009, Oracle and/or its affiliates. 
All rights reserved.

connected to auxiliary database:
NOSPFILE (not mounted)
RMAN>

RMAN> DUPLICATE TARGET DATABASE TO
nospfile BACKUP LOCATION ‘/backup/rman_backup’

DB_FILE_NAME_CONVERT
‘/data2/prod’,’/data2/nospfile’

LOGFILE GROUP 1(‘/data2/nospfile/redo01.log’)
SIZE 50m,

GROUP 2(‘/data2/nospfile/redo02.log’)
SIZE 50m;

Starting
Duplicate Db at 13-APR-15

contents
of Memory Script:

{

   sql clone “create spfile from
memory”;

}

executing
Memory Script

sql
statement: create spfile from memory

contents
of Memory Script:

{

   shutdown clone immediate;

   startup clone nomount;

}

executing
Memory Script

Oracle
instance shut down

connected
to auxiliary database (not started)

Oracle
instance started

Total
System Global Area    1152450560 bytes

Fixed
Size                     2212696 bytes

Variable
Size                335547560 bytes

Database
Buffers             805306368 bytes

Redo
Buffers                   9383936 bytes

contents
of Memory Script:

{

   sql clone “alter system set  db_name =

 ”PROD” comment=

 ”Modified by RMAN duplicate”
scope=spfile”;

   sql clone “alter system set  db_unique_name =

 ”NOSPFILE” comment=

 ”Modified by RMAN duplicate”
scope=spfile”;

   shutdown clone immediate;

   startup clone force nomount

   restore clone primary controlfile from 
‘/backup/rman_backup/controlfile_c-284539893-20150413-00’;

   alter clone database mount;

}

executing
Memory Script

sql
statement: alter system set  db_name
=  ”PROD” comment= ”Modified by RMAN
duplicate” scope=spfile

sql
statement: alter system set 
db_unique_name =  ”NOSPFILE”
comment= ”Modified by RMAN duplicate” scope=spfile

Oracle
instance shut down

Oracle
instance started

Total
System Global Area    1152450560 bytes

Fixed
Size                     2212696 bytes

Variable
Size                335547560 bytes

Database
Buffers             805306368 bytes

Redo
Buffers                   9383936 bytes

Starting
restore at 13-APR-15

allocated
channel: ORA_AUX_DISK_1

channel
ORA_AUX_DISK_1: SID=63 device type=DISK

channel
ORA_AUX_DISK_1: restoring control file

channel
ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03

output
file name=/data2/nospfile/control01.ctl

output
file name=/data2/nospfile/control02.ctl

Finished
restore at 13-APR-15

database
mounted

released
channel: ORA_AUX_DISK_1

allocated
channel: ORA_AUX_DISK_1

channel
ORA_AUX_DISK_1: SID=63 device type=DISK

contents
of Memory Script:

{

   set until scn  5176531;

   set newname for datafile  1 to

 “/data2/nospfile/system01.dbf”;

   set newname for datafile  2 to

 “/data2/nospfile/sysaux01.dbf”;

   set newname for datafile  3 to

 “/data2/nospfile/undotbs01.dbf”;

   set newname for datafile  4 to

 “/data2/nospfile/users01.dbf”;

   set newname for datafile  5 to

 “/data2/nospfile/example01.dbf”;

   set newname for datafile  6 to

 “/data2/nospfile/data01.dbf”;

   set newname for datafile  7 to

 “/data2/nospfile/test01.dbf”;

   set newname for datafile  8 to

 “/data2/nospfile/tools01.dbf”;

   restore

   clone database

   ;

}

executing
Memory Script

executing
command: SET until clause

executing
command: SET NEWNAME

executing
command: SET NEWNAME

executing
command: SET NEWNAME

executing
command: SET NEWNAME

executing
command: SET NEWNAME

executing
command: SET NEWNAME

executing
command: SET NEWNAME

executing
command: SET NEWNAME

Starting
restore at 13-APR-15

using
channel ORA_AUX_DISK_1

channel
ORA_AUX_DISK_1: starting datafile backup set restore

channel
ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel
ORA_AUX_DISK_1: restoring datafile 00001 to /data2/nospfile/system01.dbf

channel
ORA_AUX_DISK_1: restoring datafile 00002 to /data2/nospfile/sysaux01.dbf

channel
ORA_AUX_DISK_1: restoring datafile 00003 to /data2/nospfile/undotbs01.dbf

channel
ORA_AUX_DISK_1: restoring datafile 00004 to /data2/nospfile/users01.dbf

channel
ORA_AUX_DISK_1: restoring datafile 00005 to /data2/nospfile/example01.dbf

channel
ORA_AUX_DISK_1: restoring datafile 00006 to /data2/nospfile/data01.dbf

channel
ORA_AUX_DISK_1: restoring datafile 00007 to /data2/nospfile/test01.dbf

channel
ORA_AUX_DISK_1: restoring datafile 00008 to /data2/nospfile/tools01.dbf

channel
ORA_AUX_DISK_1: reading from backup piece
/backup/rman_backup/db_arch_2vq495ua_1_1.bkp

channel
ORA_AUX_DISK_1: piece handle=/backup/rman_backup/db_arch_2vq495ua_1_1.bkp
tag=TAG20150413T101538

channel
ORA_AUX_DISK_1: restored backup piece 1

channel
ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:45

Finished
restore at 13-APR-15

contents
of Memory Script:

{

   switch clone datafile all;

}

executing
Memory Script

datafile 1
switched to datafile copy

input
datafile copy RECID=9 STAMP=876912854 file name=/data2/nospfile/system01.dbf

datafile 2
switched to datafile copy

input
datafile copy RECID=10 STAMP=876912855 file name=/data2/nospfile/sysaux01.dbf

datafile 3
switched to datafile copy

input
datafile copy RECID=11 STAMP=876912856 file name=/data2/nospfile/undotbs01.dbf

datafile 4
switched to datafile copy

input
datafile copy RECID=12 STAMP=876912857 file name=/data2/nospfile/users01.dbf

datafile 5
switched to datafile copy

input
datafile copy RECID=13 STAMP=876912857 file name=/data2/nospfile/example01.dbf

datafile 6
switched to datafile copy

input
datafile copy RECID=14 STAMP=876912858 file name=/data2/nospfile/data01.dbf

datafile 7
switched to datafile copy

input
datafile copy RECID=15 STAMP=876912859 file name=/data2/nospfile/test01.dbf

datafile 8
switched to datafile copy

input
datafile copy RECID=16 STAMP=876912860 file name=/data2/nospfile/tools01.dbf

contents
of Memory Script:

{

   set until scn  5176531;

  
recover

   clone database

    delete archivelog

   ;

}

executing
Memory Script

executing
command: SET until clause

Starting
recover at 13-APR-15

using
channel ORA_AUX_DISK_1

starting
media recovery

channel
ORA_AUX_DISK_1: starting archived log restore to default destination

channel
ORA_AUX_DISK_1: restoring archived log

archived
log thread=1 sequence=154

channel
ORA_AUX_DISK_1: reading from backup piece
/backup/rman_backup/db_arch_30q49603_1_1.bkp

channel
ORA_AUX_DISK_1: piece handle=/backup/rman_backup/db_arch_30q49603_1_1.bkp
tag=TAG20150413T101635

channel
ORA_AUX_DISK_1: restored backup piece 1

channel
ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

archived
log file name=/backup/archive/1_154_872701561.dbf thread=1 sequence=154

channel
clone_default: deleting archived log(s)

archived
log file name=/backup/archive/1_154_872701561.dbf RECID=1 STAMP=876912867

media
recovery complete, elapsed time: 00:00:04

Finished
recover at 13-APR-15

contents
of Memory Script:

{

   shutdown clone immediate;

   startup clone nomount;

   sql clone “alter system set  db_name =

 ”NOSPFILE” comment=

 ”Reset to original value by RMAN”
scope=spfile”;

   sql clone “alter system reset  db_unique_name scope=spfile”;

   shutdown clone immediate;

   startup clone nomount;

}

executing
Memory Script

database
dismounted

Oracle
instance shut down

connected
to auxiliary database (not started)

Oracle
instance started

Total
System Global Area    1152450560 bytes

Fixed
Size                     2212696 bytes

Variable
Size                335547560 bytes

Database
Buffers             805306368 bytes

Redo
Buffers                   9383936 bytes

sql
statement: alter system set  db_name
=  ”NOSPFILE” comment= ”Reset to
original value by RMAN” scope=spfile

sql
statement: alter system reset 
db_unique_name scope=spfile

Oracle
instance shut down

connected
to auxiliary database (not started)

Oracle
instance started

Total
System Global Area    1152450560 bytes

Fixed
Size                     2212696 bytes

Variable
Size                335547560 bytes

Database
Buffers             805306368 bytes

Redo
Buffers                   9383936 bytes

sql
statement: CREATE CONTROLFILE REUSE SET DATABASE “NOSPFILE” RESETLOGS
ARCHIVELOG

  MAXLOGFILES     16

  MAXLOGMEMBERS      3

  MAXDATAFILES      100

  MAXINSTANCES     8

  MAXLOGHISTORY      292

 LOGFILE

  GROUP 
1 ( ‘/data2/nospfile/redo01.log’ ) SIZE 50 M ,

  GROUP 
2 ( ‘/data2/nospfile/redo02.log’ ) SIZE 50 M

 DATAFILE

  ‘/data2/nospfile/system01.dbf’

 CHARACTER SET WE8MSWIN1252

contents
of Memory Script:

{

   set newname for tempfile  1 to

 “/data2/nospfile/temp01.dbf”;

   switch clone tempfile all;

   catalog clone datafilecopy  “/data2/nospfile/sysaux01.dbf”,

 “/data2/nospfile/undotbs01.dbf”,

 “/data2/nospfile/users01.dbf”,

 “/data2/nospfile/example01.dbf”,

 “/data2/nospfile/data01.dbf”,

 “/data2/nospfile/test01.dbf”,

 “/data2/nospfile/tools01.dbf”;

   switch clone datafile all;

}

executing
Memory Script

executing
command: SET NEWNAME

renamed
tempfile 1 to /data2/nospfile/temp01.dbf in control file

cataloged
datafile copy

datafile
copy file name=/data2/nospfile/sysaux01.dbf RECID=1 STAMP=876912891

cataloged
datafile copy

datafile
copy file name=/data2/nospfile/undotbs01.dbf RECID=2 STAMP=876912892

cataloged
datafile copy

datafile
copy file name=/data2/nospfile/users01.dbf RECID=3 STAMP=876912892

cataloged
datafile copy

datafile
copy file name=/data2/nospfile/example01.dbf RECID=4 STAMP=876912892

cataloged
datafile copy

datafile
copy file name=/data2/nospfile/data01.dbf RECID=5 STAMP=876912893

cataloged
datafile copy

datafile
copy file name=/data2/nospfile/test01.dbf RECID=6 STAMP=876912893

cataloged
datafile copy

datafile
copy file name=/data2/nospfile/tools01.dbf RECID=7 STAMP=876912894

datafile 2
switched to datafile copy

input datafile
copy RECID=1 STAMP=876912891 file name=/data2/nospfile/sysaux01.dbf

datafile 3
switched to datafile copy

input
datafile copy RECID=2 STAMP=876912892 file name=/data2/nospfile/undotbs01.dbf

datafile 4
switched to datafile copy

input
datafile copy RECID=3 STAMP=876912892 file name=/data2/nospfile/users01.dbf

datafile 5
switched to datafile copy

input
datafile copy RECID=4 STAMP=876912892 file name=/data2/nospfile/example01.dbf

datafile 6
switched to datafile copy

input
datafile copy RECID=5 STAMP=876912893 file name=/data2/nospfile/data01.dbf

datafile 7
switched to datafile copy

input
datafile copy RECID=6 STAMP=876912893 file name=/data2/nospfile/test01.dbf

datafile 8
switched to datafile copy

input
datafile copy RECID=7 STAMP=876912894 file name=/data2/nospfile/tools01.dbf

contents
of Memory Script:

{

   Alter clone database open resetlogs;

}

executing
Memory Script

database
opened

Finished
Duplicate Db at 13-APR-15

RMAN>

Conclusion
In the preceding scenario based article, we have learned that backup based duplication using Rman utility with different database name and different directory structure, without using spfile

BY
Name: Mirza Sarmadullah Baig
Designation: Senior Database Engineer
Organization: Netsoftmate IT Solutions.
Email: info@netsoftmate.com 

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

More posts