Netsoftmate

Tag: without spfile

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

    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