Netsoftmate

Tag: auxiliary

  • Rman Targetless duplication with same DB name and same directory structure

    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.
    Backup-based duplication uses an RMAN backup of the target (source) database as its source to create the data files in the auxiliary (destination) environment.
    No connection to the target database is required. This is referred to as targetless duplication. This technique only requires a connection to the auxiliary database. Targetless duplication is available in Oracle 11g release 2 and higher.
    The big advantage to backup based duplication is that if you work in an environment where it’s not possible to have a simultaneous connection to both the target and the auxiliary database you can still duplicate a database provided you can copy an RMAN backup to the auxiliary database
    Server (or provided the backup is on network-mounted storage readable from the auxiliary server). In many environments, due to security rules, there is no network connectivity allowed from test environments to the production server.
    In this scenario we have same database name and same directory structure.

    Environment Details

    Target (source) details:

    Database Name
    prod
    Hostname
    Nsmprod
    Ip Address
    172.16.110.18
    OS
    Linux
    Version
    x86_64
    Datafile Location
    /data2/prod
    Backup Location
    /backup/rman_backup

     

    Destination details:


    Database Name
    prod
    Hostname
    Nsmstg
    Ip Address
    172.16.110.16
    OS
    Linux
    Version
    x86_64
    Datafile Location
    /data2/prod
    Backup Location
    /backup/rman_backup

     
     Pre-requisites: 

    • Password file from target database. 
    • Sqlnet.ora should have correct parameters. 
    • Target database should be running through spfile.

     Steps on target (source) server:
    1.    export Oracle sid. 

    [oracle@Nsmprod dbs]$
    hostname

    Nsmprod

    [oracle@Nsmprod dbs]$ export
    ORACLE_SID=prod

     2.    Connect to target database via RMAN.

    [oracle@Nsmprod dbs]$ rman
    target sys/oracle

    Recovery Manager: Release
    11.2.0.1.0 – Production on Thu Apr 9 10:47:41 2015
    Copyright (c) 1982, 2009,
    Oracle and/or its affiliates.  All rights
    reserved.
    connected to target
    database: PROD (DBID=284539893)
    RMAN>

    3.    Issue the following command to initiate backup. Before issue the backup command check the backup location is sat correctly.

    RMAN> show all;

    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>
    RMAN> list backup;
    specification does not match
    any backup in the repository
    RMAN>
    backup database plus archivelog;
    Starting backup at 10-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=90 RECID=86 STAMP=875202890
    input archived log thread=1
    sequence=91 RECID=87 STAMP=875225400
    input archived log thread=1
    sequence=92 RECID=88 STAMP=875253619
    input archived log thread=1
    sequence=93 RECID=89 STAMP=875287426
    input archived log thread=1
    sequence=94 RECID=90 STAMP=875311887
    input archived log thread=1
    sequence=95 RECID=91 STAMP=875338210
    input archived log thread=1
    sequence=96 RECID=92 STAMP=875371700
    input archived log thread=1
    sequence=97 RECID=93 STAMP=875398375
    input archived log thread=1
    sequence=98 RECID=94 STAMP=875422534
    input archived log thread=1
    sequence=99 RECID=95 STAMP=875455916
    input archived log thread=1
    sequence=100 RECID=96 STAMP=875489442
    input archived log thread=1
    sequence=101 RECID=97 STAMP=875511892
    input archived log thread=1
    sequence=102 RECID=98 STAMP=875532973
    input archived log thread=1
    sequence=103 RECID=99 STAMP=875566589
    input archived log thread=1
    sequence=104 RECID=100 STAMP=875598381
    input archived log thread=1
    sequence=105 RECID=101 STAMP=875617253
    input archived log thread=1
    sequence=106 RECID=102 STAMP=875650222
    input archived log thread=1
    sequence=107 RECID=103 STAMP=875683804
    input archived log thread=1
    sequence=108 RECID=104 STAMP=875692844
    input archived log thread=1
    sequence=109 RECID=105 STAMP=875726521
    input archived log thread=1
    sequence=110 RECID=106 STAMP=875759423
    input archived log thread=1
    sequence=111 RECID=107 STAMP=875771364
    input archived log thread=1
    sequence=112 RECID=108 STAMP=875804400
    input archived log thread=1
    sequence=113 RECID=109 STAMP=875809288
    input archived log thread=1
    sequence=114 RECID=110 STAMP=875842252
    input archived log thread=1
    sequence=115 RECID=111 STAMP=875857844
    input archived log thread=1
    sequence=116 RECID=112 STAMP=875883160
    input archived log thread=1
    sequence=117 RECID=113 STAMP=875939543
    input archived log thread=1
    sequence=118 RECID=114 STAMP=875955632
    input archived log thread=1
    sequence=119 RECID=115 STAMP=875960595
    input archived log thread=1
    sequence=120 RECID=116 STAMP=876018651
    input archived log thread=1
    sequence=121 RECID=117 STAMP=876036137
    input archived log thread=1
    sequence=122 RECID=118 STAMP=876094207
    input archived log thread=1
    sequence=123 RECID=119 STAMP=876117455
    input archived log thread=1
    sequence=124 RECID=120 STAMP=876173429
    input archived log thread=1
    sequence=125 RECID=121 STAMP=876203937
    input archived log thread=1
    sequence=126 RECID=122 STAMP=876259857
    input archived log thread=1
    sequence=127 RECID=123 STAMP=876288622
    input archived log thread=1
    sequence=128 RECID=124 STAMP=876308432
    input archived log thread=1
    sequence=129 RECID=125 STAMP=876364250
    input archived log thread=1
    sequence=130 RECID=126 STAMP=876378605
    input archived log thread=1
    sequence=131 RECID=127 STAMP=876398550
    input archived log thread=1
    sequence=132 RECID=128 STAMP=876399532
    input archived log thread=1
    sequence=133 RECID=129 STAMP=876419413
    input archived log thread=1
    sequence=134 RECID=130 STAMP=876421079
    input archived log thread=1
    sequence=135 RECID=131 STAMP=876461598
    input archived log thread=1
    sequence=136 RECID=132 STAMP=876504610
    input archived log thread=1
    sequence=137 RECID=133 STAMP=876548085
    input archived log thread=1
    sequence=138 RECID=134 STAMP=876567056
    input archived log thread=1
    sequence=139 RECID=135 STAMP=876567230
    input archived log thread=1
    sequence=140 RECID=136 STAMP=876583581
    input archived log thread=1
    sequence=141 RECID=137 STAMP=876583754
    input archived log thread=1
    sequence=142 RECID=138 STAMP=876586722
    input archived log thread=1
    sequence=143 RECID=139 STAMP=876586874
    input archived log thread=1
    sequence=144 RECID=140 STAMP=876641790
    input archived log thread=1
    sequence=145 RECID=141 STAMP=876670700
    channel ORA_DISK_1: starting
    piece 1 at 10-APR-15
    channel ORA_DISK_1: finished
    piece 1 at 10-APR-15
    piece
    handle=/backup/rman_backup/db_arch_2qq41rnc_1_1.bkp tag=TAG20150410T153820
    comment=NONE
    channel ORA_DISK_1: backup
    set complete, elapsed time: 00:01:35
    Finished backup at 10-APR-15
    Starting backup at 10-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 10-APR-15
    channel ORA_DISK_1: finished
    piece 1 at 10-APR-15
    piece handle=/backup/rman_backup/db_arch_2rq41rqd_1_1.bkp
    tag=TAG20150410T153956 comment=NONE
    channel ORA_DISK_1: backup
    set complete, elapsed time: 00:01:05
    Finished backup at 10-APR-15
    Starting backup at 10-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=146 RECID=142 STAMP=876670863
    channel ORA_DISK_1: starting
    piece 1 at 10-APR-15
    channel ORA_DISK_1: finished
    piece 1 at 10-APR-15
    piece
    handle=/backup/rman_backup/db_arch_2sq41rsf_1_1.bkp tag=TAG20150410T154103
    comment=NONE
    channel ORA_DISK_1: backup
    set complete, elapsed time: 00:00:01
    Finished backup at 10-APR-15
    Starting Control File and
    SPFILE Autobackup at 10-APR-15
    piece
    handle=/backup/rman_backup/controlfile_c-284539893-20150410-00 comment=NONE
    Finished Control File and
    SPFILE Autobackup at 10-APR-15
    RMAN>

    4.    Create pfile and copy to destination server.

    SQL> create
    pfile=’/backup/rman_backup/initprod.ora’ from spfile;


    File created.

    [oracle@Nsmprod
    rman_backup]$ scp initprod.ora 
    oracle@172.16.110.16:/data1/oracle11g/product/dbs/

    oracle@172.16.110.16’s
    password:

    initprod.ora                                                                                   
                                                      

                     100% 1169     1.1KB/s  
    00:00

    create directory structure to accommodate rman backup pieces on destination server and start copy.

    [oracle@Nsmstg prod]$ mkdir
    -p /backup/rman_backup/


    5.    Copy rman backup from target to destination server.

    RMAN> exit

    Recovery Manager complete.
    [oracle@Nsmprod
    rman_backup]$ ls -lrth
    total 2.8G
    -rw-r—–. 1 oracle dba
    1.7G Apr 10 15:39 db_arch_2qq41rnc_1_1.bkp
    -rw-r—–. 1 oracle dba 1.2G
    Apr 10 15:40 db_arch_2rq41rqd_1_1.bkp
    -rw-r—–. 1 oracle
    dba  24K Apr 10 15:41
    db_arch_2sq41rsf_1_1.bkp
    -rw-r—–. 1 oracle dba
    9.6M Apr 10 15:41 controlfile_c-284539893-20150410-00

    [oracle@Nsmprod
    rman_backup]$ scp * oracle@172.16.110.16:/backup/rman_backup/
    oracle@172.16.110.16’s
    password:
    controlfile_c-284539893-20150410-00                                                                                                              
                     100% 9792KB   9.6MB/s  
    00:01
    db_arch_2qq41rnc_1_1.bkp                                                                                                                         
                     100% 1668MB  11.2MB/s  
    02:29
    db_arch_2rq41rqd_1_1.bkp                                                   
                                                                          
                     100% 1135MB  11.2MB/s  
    01:41
    db_arch_2sq41rsf_1_1.bkp                                                                                                                
             
                     100%   24KB 
    23.5KB/s   00:00

     
    Steps on destination server
    6.    Create directory structure same as target (source) database.

    [oracle@Nsmstg prod]$ mkdir
    -p /data2/prod

    [oracle@Nsmstg prod]$ mkdir
    -p /backup/archive/

    7.    Start the instance in nomount stage.

    [oracle@Nsmstg dbs]$ export
    ORACLE_SID=prod

    [oracle@Nsmstg dbs]$ sqlplus
    SQL*Plus: Release 11.2.0.1.0
    Production on Fri Apr 10 15:58:10 2015
    Copyright (c) 1982, 2009,
    Oracle.  All rights reserved.
    Enter user-name: sys as
    sysdba
    Enter password:
    Connected to an idle
    instance.
    SQL>
    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> 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@Nsmstg dbs]$

    8.    Connect to auxiliary instance via RMAN

    [oracle@Nsmstg dbs]$ rman
    auxiliary sys/oracle

    Recovery Manager: Release
    11.2.0.1.0 – Production on Fri Apr 10 15:59:22 2015
    Copyright (c) 1982, 2009,
    Oracle and/or its affiliates.  All rights
    reserved.
    connected to auxiliary
    database: PROD (not mounted)
    RMAN>

    9.    Issue the following command to duplicate database with same name and same directory structure.

    RMAN>
    duplicate database to prod backup location ‘/backup/rman_backup’ nofilenamecheck;

    Starting Duplicate Db at
    10-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 =
     ”PROD” 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-20150410-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 =  ”PROD” 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
    10-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/prod/control01.ctl
    output file
    name=/data2/prod/control02.ctl
    Finished restore at
    10-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  5022379;
       set newname for datafile  1 to
     “/data2/prod/system01.dbf”;
       set newname for datafile  2 to
     “/data2/prod/sysaux01.dbf”;
       set newname for datafile  3 to
     “/data2/prod/undotbs01.dbf”;
       set newname for datafile  4 to
     “/data2/prod/users01.dbf”;
       set newname for datafile  5 to
     “/data2/prod/example01.dbf”;
       set newname for datafile  6 to
     “/data2/prod/data01.dbf”;
       set newname for datafile  7 to
     “/data2/prod/test01.dbf”;
       set newname for datafile  8 to
     “/data2/prod/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
    10-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/prod/system01.dbf
    channel ORA_AUX_DISK_1:
    restoring datafile 00002 to /data2/prod/sysaux01.dbf
    channel ORA_AUX_DISK_1:
    restoring datafile 00003 to /data2/prod/undotbs01.dbf
    channel ORA_AUX_DISK_1:
    restoring datafile 00004 to /data2/prod/users01.dbf
    channel ORA_AUX_DISK_1:
    restoring datafile 00005 to /data2/prod/example01.dbf
    channel ORA_AUX_DISK_1:
    restoring datafile 00006 to /data2/prod/data01.dbf
    channel ORA_AUX_DISK_1:
    restoring datafile 00007 to /data2/prod/test01.dbf
    channel ORA_AUX_DISK_1:
    restoring datafile 00008 to /data2/prod/tools01.dbf
    channel ORA_AUX_DISK_1:
    reading from backup piece /backup/rman_backup/db_arch_2rq41rqd_1_1.bkp
    channel ORA_AUX_DISK_1:
    piece handle=/backup/rman_backup/db_arch_2rq41rqd_1_1.bkp
    tag=TAG20150410T153956
    channel ORA_AUX_DISK_1:
    restored backup piece 1
    channel ORA_AUX_DISK_1:
    restore complete, elapsed time: 00:00:35
    Finished restore at
    10-APR-15
    contents of Memory Script:
    {
       switch clone datafile all;
    }
    executing Memory Script
    datafile 1 switched to
    datafile copy
    input datafile copy RECID=1
    STAMP=876672089 file name=/data2/prod/system01.dbf
    datafile 2 switched to
    datafile copy
    input datafile copy RECID=2
    STAMP=876672089 file name=/data2/prod/sysaux01.dbf
    datafile 3 switched to
    datafile copy
    input datafile copy RECID=3
    STAMP=876672090 file name=/data2/prod/undotbs01.dbf
    datafile 4 switched to
    datafile copy
    input datafile copy RECID=4
    STAMP=876672090 file name=/data2/prod/users01.dbf
    datafile 5 switched to
    datafile copy
    input datafile copy RECID=5
    STAMP=876672090 file name=/data2/prod/example01.dbf
    datafile 6 switched to
    datafile copy
    input datafile copy RECID=6
    STAMP=876672091 file name=/data2/prod/data01.dbf
    datafile 7 switched to
    datafile copy
    input datafile copy RECID=7
    STAMP=876672091 file name=/data2/prod/test01.dbf
    datafile 8 switched to
    datafile copy
    input datafile copy RECID=8
    STAMP=876672091 file name=/data2/prod/tools01.dbf
    contents of Memory Script:
    {
       set until scn  5022379;
       recover
       clone database
        delete archivelog
       ;
    }
    executing Memory Script
    executing command: SET until
    clause
    Starting recover at
    10-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=146
    channel ORA_AUX_DISK_1:
    reading from backup piece /backup/rman_backup/db_arch_2sq41rsf_1_1.bkp
    channel ORA_AUX_DISK_1:
    piece handle=/backup/rman_backup/db_arch_2sq41rsf_1_1.bkp
    tag=TAG20150410T154103
    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_146_872701561.dbf thread=1 sequence=146
    channel clone_default:
    deleting archived log(s)
    archived log file
    name=/backup/archive/1_146_872701561.dbf RECID=1 STAMP=876672098
    media recovery complete,
    elapsed time: 00:00:04
    Finished recover at
    10-APR-15
    contents of Memory Script:
    {
       shutdown clone immediate;
       startup clone nomount;
       sql clone “alter system set  db_name =
     ”PROD” 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 =  ”PROD” 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 “PROD” RESETLOGS ARCHIVELOG
      MAXLOGFILES     16
      MAXLOGMEMBERS      3
      MAXDATAFILES      100
      MAXINSTANCES     8
      MAXLOGHISTORY      292
     LOGFILE
      GROUP 
    1 ( ‘/data2/prod/redo01.log’ ) SIZE 50 M 
    REUSE,
      GROUP 
    2 ( ‘/data2/prod/redo02.log’ ) SIZE 50 M 
    REUSE,
      GROUP 
    3 ( ‘/data2/prod/redo03.log’ ) SIZE 50 M 
    REUSE
     DATAFILE
      ‘/data2/prod/system01.dbf’
     CHARACTER SET WE8MSWIN1252
    contents of Memory Script:
    {
       set newname for tempfile  1 to
     “/data2/prod/temp01.dbf”;
       switch clone tempfile all;
       catalog clone datafilecopy  “/data2/prod/sysaux01.dbf”,
     “/data2/prod/undotbs01.dbf”,
     “/data2/prod/users01.dbf”,
     “/data2/prod/example01.dbf”,
     “/data2/prod/data01.dbf”,
     “/data2/prod/test01.dbf”,
     “/data2/prod/tools01.dbf”;
       switch clone datafile all;
    }
    executing Memory Script
    executing command: SET
    NEWNAME
    renamed tempfile 1 to
    /data2/prod/temp01.dbf in control file
    cataloged datafile copy
    datafile copy file
    name=/data2/prod/sysaux01.dbf RECID=1 STAMP=876672123
    cataloged datafile copy
    datafile copy file name=/data2/prod/undotbs01.dbf
    RECID=2 STAMP=876672123
    cataloged datafile copy
    datafile copy file
    name=/data2/prod/users01.dbf RECID=3 STAMP=876672124
    cataloged datafile copy
    datafile copy file
    name=/data2/prod/example01.dbf RECID=4 STAMP=876672124
    cataloged datafile copy
    datafile copy file
    name=/data2/prod/data01.dbf RECID=5 STAMP=876672125
    cataloged datafile copy
    datafile copy file
    name=/data2/prod/test01.dbf RECID=6 STAMP=876672125
    cataloged datafile copy
    datafile copy file
    name=/data2/prod/tools01.dbf RECID=7 STAMP=876672125
    datafile 2 switched to
    datafile copy
    input datafile copy RECID=1
    STAMP=876672123 file name=/data2/prod/sysaux01.dbf
    datafile 3 switched to
    datafile copy
    input datafile copy RECID=2
    STAMP=876672123 file name=/data2/prod/undotbs01.dbf
    datafile 4 switched to
    datafile copy
    input datafile copy RECID=3
    STAMP=876672124 file name=/data2/prod/users01.dbf
    datafile 5 switched to
    datafile copy
    input datafile copy RECID=4
    STAMP=876672124 file name=/data2/prod/example01.dbf
    datafile 6 switched to
    datafile copy
    input datafile copy RECID=5
    STAMP=876672125 file name=/data2/prod/data01.dbf
    datafile 7 switched to
    datafile copy
    input datafile copy RECID=6
    STAMP=876672125 file name=/data2/prod/test01.dbf
    datafile 8 switched to
    datafile copy
    input datafile copy RECID=7
    STAMP=876672125 file name=/data2/prod/tools01.dbf
    contents of Memory Script:
    {
       Alter clone database open resetlogs;
    }
    executing Memory Script
    database opened
    Finished Duplicate Db at
    10-APR-15


    RMAN>
    RMAN> exit
    Recovery Manager complete.
    [oracle@Nsmstg dbs]$ sqlplus
    SQL*Plus: Release 11.2.0.1.0
    Production on Fri Apr 10 16:04:05 2015
    Copyright (c) 1982, 2009,
    Oracle.  All rights reserved.
    Enter user-name: sys as
    sysdba
    Enter password:
    Connected to:
    Oracle Database 11g
    Enterprise Edition Release 11.2.0.1.0 – 64bit Production
    With the Partitioning, OLAP,
    Data Mining and Real Application Testing options
    SQL> select
    name,open_mode from v$database;
    NAME      OPEN_MODE
    ———
    ——————–
    PROD      READ WRITE
    SQL> select host_name from
    v$instance;
    HOST_NAME
    —————————————————————-
    Nsmstg

    SQL> select
    tablespace_name,status from dba_tablespaces;
    TABLESPACE_NAME                STATUS
    ——————————
    ———
    SYSTEM                         ONLINE
    SYSAUX                         ONLINE
    UNDOTBS1                       ONLINE
    TEMP                           ONLINE
    USERS                          ONLINE
    EXAMPLE                        ONLINE
    DATA                           ONLINE
    TEST                           ONLINE
    TOOLS                          ONLINE
    9 rows selected.

     
    Conclusion
    In the above article, we have learned that backup based duplication using Rman utility with same database name and same directory structure, we can refer this as targetless duplication, where no connectivity between target and auxiliary instance is required.

    BY
    Name: Omer
    Designation: Senior Database Engineer
    Organization: Netsoftmate IT Solutions.
    Contact us: info@netsoftmate.com