Best Practices for Migrating SAP Systems to Oracle Infrastructure--Part 3: SAP Database Migration Method 1--Oracle RMAN DUPLICATE

Version 3

    by Victor Galis and Pierre Reynes

     

    This article, Part 3 of the series, provides a practical guide to migrating Oracle Database instances as a part of an SAP migration using Oracle Recovery Manager (Oracle RMAN) DUPLICATE. The Oracle RMAN "duplicate from active database" method is used to clone a source Oracle Database instance from file systems to Oracle Exadata Storage Servers (storage cells) in Oracle SuperCluster or to an Oracle Automatic Storage Management destination.

     

    Introduction

     

    This article is Part 3 of a six-part series that provides best practices and recommendations for migrating a complete SAP system to an Oracle platform (in this example, to Oracle SuperCluster M7). A team of Oracle engineers and SAP experts worked together to test and tune different migration methods, compiling the step-by-step procedures and guidance given in these articles.

     

    The articles in this "Best Practices for Migrating SAP Systems to Oracle Infrastructure" series are located here:

    OOS_Logo_small125.png
    in collaboration with
    OSC_Logo_small125.png
    Oracle Optimized Solutions provide tested and proven best practices for how to run software products on Oracle systems. Learn more.

     

     

    Migrating an Oracle Database Instance Using Oracle RMAN DUPLICATE

     

    This article series covers several methods that can be used to migrate the database in an SAP environment. In this article, the Oracle Recovery Manager (Oracle RMAN) "duplicate from active database" approach is used to clone the source database to a target Oracle SuperCluster system. This approach provides an easy and simple method to create an independently functioning copy of a complete Oracle Database instance.

     

    The Oracle RMAN "duplicate from active database" approach can be used offline or online with the source database in an open state and operating during the copy process. An offline duplication process makes sure that both databases are exactly the same, while an online process restores the database to the status it had at the beginning of the duplication process and subsequent changes are lost. This makes the offline process the best choice for migrations, while the online process is best for copying a busy system with high availability requirements.

     

    The Oracle RMAN "duplicate from active database" approach is limited to specific platforms that share the same underlying hardware architecture with the same byte-endian format and the same version and patch level of Oracle Database. Generally, the Oracle RMAN "duplicate from active database" command is used to create the database copy. Oracle Database parameter settings influence the copy that is created and can define a new storage structure, such as an Oracle Automatic Storage Management (Oracle ASM) destination. Thus, this approach can be used to migrate from file system–based database storage into Oracle ASM on Oracle SuperCluster, as described in this article.

     

    In this article's example migration, the source (target) database has ORACLE_SID PR1 and is available through epr1-scan. The destination (auxiliary) database has ORACLE_SID PR2. For more details on the architecture of the systems used in this migration exercise, refer to Oracle Optimized Solution for SAP.

     

    Oracle RMAN Preparation Steps

     

    All of the migration preparation steps provided in Article 2 ("SAP Environment Migration—Pre-Database-Migration Tasks") must be performed before executing the steps below.

     

    Step 1. Create the initialization parameter file for the destination database (initPR2.ora).

     

    Create a token parameter file called initPR2.ora in $ORACLE_HOME/dbs. This file is used only for the purpose of database duplication.

     

    oracle@sapm7zdbadm1c1:/$ cd $ORACLE_HOME/dbs

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ cat > initPR2.ora << EOF

    *.db_name='PR2'

    *.db_block_size=8192

    *.compatible= 12.1.0.2.0

    *.AUDIT_TRAIL=NONE

    *.audit_sys_operations=FALSE

    *.db_unique_name='PR2'

    *.db_create_file_dest='+DATAC1'

    *.control_files='+DATAC1/PR2/CONTROLFILE/cntrl1.dbf','+RECOC1/PR2/CONTROLFILE/cntrl2.dbf'

    *.db_recovery_file_dest='+RECOC1'

    *.db_recovery_file_dest_size=12G

    *.listener_networks='((NAME=network2)(LOCAL_LISTENER=LISTENER_IBLOCAL)(REMOTE_LISTENER=LISTENER_IBREMOTE))','((NAME=network1)(LOCAL_LISTENER=LISTENER_IPLOCAL)(REMOTE_LISTENER=sapm7-c1-scan:1521))'

    *.filesystemio_options='SETALL'

    *.timed_statistics=true

    sga_max_size=10G

    *.log_file_name_convert=

    '/oracle/PR1/mirrlogA','+RECOC1/PR2',

    '/oracle/PR1/mirrlogB','+RECOC1/PR2',

    '/oracle/PR1/origlogA','+DATAC1/PR2',

    '/oracle/PR1/origlogB','+DATAC1/PR2'

    EOF

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$

    Listing 1: Creating the initialization parameter file.

     

    For large databases, the number of database files needs to be increased to reflect what is currently in use.

     

    Step 2. Create the password file for PR2 (orapwPR2).

     

    Add the password file orapw<SID>, either by copying it from the source $ORACLE_HOME/dbs directory or by creating a new one using the utility orapwd. The password needs to be the same for both the source and destination databases.

     

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ orapwd FILE=orapwPR2 ENTRIES=10 password=<password>

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ ls -l orapwPR2

    -rw-r-----   1 oracle   oinstall    7680 May 13 10:49 orapwPR2

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$

    Listing 2: Creating the password file for PR2.

     

    Step 3. Validate the destination database using SQL*Plus.

     

    Validate that the destination database can be started and that the network is set up properly. Start the auxiliary instance without mounting the database by using the STARTUP command with the NOMOUNT clause.

     

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ sqlplus / as sysdba

     

    SQL*Plus: Release 12.1.0.2.0 Production on Fri May 13 10:53:50 2016

     

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

     

    Connected to:

    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics

    and Real Application Testing options

     

    SQL> startup nomount

    ORACLE instance started.

     

    Total System Global Area 1.0737E+10 bytes

    Fixed Size                  2925344 bytes

    Variable Size            1.0469E+10 bytes

    Database Buffers          234881024 bytes

    Redo Buffers               30621696 bytes

    SQL>

    Listing 3: Validating the destination database by connecting and starting an instance.

     

    Verify the network parameters, making sure that the database registers with the correct listener upon startup. Note that REMOTE_LISTENER is set to be the Single Client Access Name (SCAN) Listener to allow the use of either a SCAN IP address or SCAN VIP address.

     

    SQL> show parameter network

     

    NAME                                 TYPE        VALUE

    ------------------------------------ ----------- ------------------------------

    fileio_network_adapters              string

    listener_networks                    string      ((NAME=network2)(LOCAL_LISTENE

                                                     R=LISTENER_IBLOCAL)(REMOTE_LIS

                                                     TENER=LISTENER_IBREMOTE)), ((N

                                                     AME=network1)(LOCAL_LISTENER=L

                                                     ISTENER_IPLOCAL)(REMOTE_LISTEN

                                                     ER=sapm7-c1-scan:1521))

    SQL>

    Listing 4: Validating database network parameters.

     

    The database registers with the local 10 GbE listener defined in tnsnames.ora as well as with the local and remote InfiniBand (IB) listener. The definitions for LISTENER_IBLOCAL and LISTENER_IB_REMOTE are created in the process of enabling the IB listener.

     

    Step 4. Modify the Oracle Net listener parameters (listener.ora)

     

    In the Oracle Grid Infrastructure network/admin directory, modify the Oracle Net Listener parameters in listener.ora to create a static SID_LIST service, because Oracle RMAN will need to restart the auxiliary database instance. After modifying listener.ora, restart the Oracle Net Listener service using the srvctl stop and srvctl start commands.

     

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ vi /u01/app/12.1.0.2/grid/network/admin/listener.ora

    SID_LIST_LISTENER_IB=

       (SID_LIST =

          (SID_DESC =

              (SID_NAME = PR2)

              (ORACLE_HOME = /oracle/PR2/121)

           )

        )

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ srvctl stop listener -l LISTENER_IB

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ srvctl start listener -l LISTENER_IB

    Listing 5: Modifying the Oracle Net Listener configuration and restarting the listener.

     

    For the example migration exercise, we chose LISTENER_IB, but the default LISTENER or any other listener that is configured will work. LISTENER_IB provides optimal performance because the InfiniBand network in Oracle SuperCluster allows much higher transfer rates.

     

    Step 5. Add the destination database to the Local Naming parameter file (tnsnames.ora).

     

    In the $ORACLE_HOME/network/admin directory, edit the Local Naming parameter file, tnsnames.ora, to add the auxiliary database (PR2) information, as shown in Listing 6. This will allow the migration to run from the Oracle SuperCluster DATABASE domain and connect to the source DATABASE using the external 10 GbE network. The connection to the auxiliary database is over the internal InfiniBand network for optimal performance.

     

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ vi $ORACLE_HOME/network/admin/tnsnames.ora

    PR2 =

      (DESCRIPTION =

        (ADDRESS = (PROTOCOL = TCP)(HOST = sapm7zdb1c1-ib-vip)(PORT = 1521))

        (CONNECT_DATA =

          (SERVER = DEDICATED)

          (SERVICE_NAME = PR2)

          ( UR = A )

        )

      )

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$

    Listing 6: Adding the destination database PR2 to tnsnames.ora.

     

    Notice the ( UR = A ) option. It allows connecting remotely to a database that is not started or in restricted mode.

     

    Step 6. Validate the connection to the destination database using SQL*Plus.

     

    Connect to the destination database PR2 using SQL*Plus and start the auxiliary Instance.

     

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ sqlplus sys/<password>@PR2 as sysdba

    SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 29 11:35:55 2016

     

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

     

    Connected to:

    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics

    and Real Application Testing options

     

    SQL> startup nomount

    ORACLE instance started.

     

    Total System Global Area 1.0737E+10 bytes

    Fixed Size                  2925344 bytes

    Variable Size            1.0469E+10 bytes

    Database Buffers          234881024 bytes

    Redo Buffers               30621696 bytes

    SQL>

    Listing 7: Connecting to PR2 with SQL*Plus and starting an instance.

     

    Step 7. Add the source (target) database to the Local Naming parameter file (tnsnames.ora).

     

    Prepare the connection to the target database by adding the source database information to the tnsnames.ora file.

     

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ vi $ORACLE_HOME/network/admin/tnsnames.ora

    PR1 =

      (DESCRIPTION =

        (ADDRESS = (PROTOCOL = TCP)(HOST = epr1-scan)(PORT = 1521))

        (CONNECT_DATA =

          (SERVER = DEDICATED)

          (SERVICE_NAME = PR1001)

        )

      )

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$

    Listing 8: Adding the target database PR1 to tnsnames.ora.

     

    Step 8. Validate the connection to the source database using SQL*Plus.

     

    Connect to the source database PR1 using SQL*Plus.

     

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ sqlplus sys/<password>@PR1 as sysdba

    SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 29 11:28:53 2016

     

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

     

    Connected to:

    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

    With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics

    and Real Application Testing options

     

    SQL> quit

    Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics

    and Real Application Testing options

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$

    Listing 9: Connecting to PR1 with SQL*Plus.

     

    Step 9. Validate that Oracle RMAN can connect to both databases.

     

    Create a working directory and verify that Oracle RMAN can connect to both the target (PR1) and auxiliary (PR2) database instances.

     

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ cd

    oracle@sapm7zdbadm1c1:~$ pwd

    /export/home/oracle

    oracle@sapm7zdbadm1c1:~$ mkdir dup

    oracle@sapm7zdbadm1c1:~$ cd dup

    oracle@sapm7zdbadm1c1:~/dup$

    oracle@sapm7zdbadm1c1:~/dup$ rman

    RMAN>connect target sys/<password>@PR1

     

    connected to target database: PR1 (DBID=994759330)

     

    RMAN>connect auxiliary sys/<password>@PR2

     

    connected to auxiliary database: PR2 (not mounted)

    Listing 10: Connecting to PR1 and PR2 with Oracle RMAN.

     

    Migrate the Database with Oracle RMAN DUPLICATE

     

    At this point, the environment is ready to begin the migration process using Oracle RMAN DUPLICATE.

     

    Step 1. Create a script for the Oracle RMAN duplication process.

     

    Because the duplication steps might need to be repeated multiple times while adjusting configuration parameters, it is a good practice to script the process so that it can be executed quickly. Listing 11 displays an example script called dupPR2 that performs Oracle RMAN duplication.

     

    oracle@sapm7zdbadm1c1:~/dup$ cat dupPR2

    connect target sys/<password>@PR1

    connect auxiliary sys/<password>@PR2

     

    CONFIGURE DEVICE TYPE DISK PARALLELISM 16 BACKUP TYPE TO BACKUPSET;

     

    show all;

     

    run {

      allocate channel t0 device type disk;

      allocate channel t1 device type disk;

      allocate channel t2 device type disk;

      allocate channel t3 device type disk;

      allocate channel t4 device type disk;

      allocate channel t5 device type disk;

      allocate channel t6 device type disk;

      allocate channel t7 device type disk;

      allocate channel t8 device type disk;

      allocate channel t9 device type disk;

      allocate channel t10 device type disk;

      allocate channel t11 device type disk;

      allocate channel t12 device type disk;

      allocate channel t13 device type disk;

      allocate channel t14 device type disk;

      allocate channel t15 device type disk;

      allocate auxiliary channel c0 device type disk;

     

    duplicate target database to PR2 from active database;

    }

    oracle@sapm7zdbadm1c1:~/dup$

    Listing 11: Example Oracle RMAN duplication script.

     

    Note: In the script, the level of parallelism might need to be adjusted depending on the infrastructure. We found PARALLELISM 16 to provide the best performance with our setup. Factors to consider to determine the level of parallelism include:

     

    • The target-side I/O system (to get the data)
    • The target-side workload (if you are migrating a live system)
    • The bandwidth of the interconnect
    • The auxiliary side I/O system (to write data into the new file system)

     

    Step 2. Run the Oracle RMAN script.

     

    Execute the Oracle RMAN script to duplicate the database, specifying the log file and the script name.

     

    oracle@sapm7zdbadm1c1:~/dup$ rman log pr2DUP.log cmdfile dupPR2

    Listing 12: Executing the script.

     

    Open a separate terminal window and monitor log file output. ("Appendix A: Example Oracle RMAN Log File" contains a listing of the complete log file, pr2DUP.log.)

     

    oracle@sapm7zdbadm1c1:~/dup$ tail -f pr2DUP.log

    Listing 13: Monitoring the log output during duplication.

     

    Step 2.1. In the event of failure, fix errors and remove files before rerunning the script.

     

    If the script fails, it is necessary to correct configuration errors and start the script again. A few files must be removed between each script execution attempt:

     

    • The file spfile<SID>.ora, in this case spfilePR2.ora in directory $ORACLE_HOME/dbs
    • The Oracle RMAN log file, in this case pr2DUP.log
    • All Oracle ASM files created on disk group DATA under the <ORACLE_SID> directory
    • All Oracle ASM files created on disk group RECO under the <ORACLE_SID> directory

     

    Oracle RMAN creates files in both the DATA and RECO disk groups for the database destination. Remove these files before attempting a new migration. Use asmcmd to manage Oracle ASM instances, disk groups, file access control for disk groups, files and directories within disk groups, templates for disk groups, and volumes.

     

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ . oraenv

    ORACLE_SID = [PR2] ? +ASM1

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ asmcmd

    ASMCMD> ls

    DATAC1/

    RECOC1/

    ASMCMD> ls *

     

    +DATAC1/:

    ...

    PR2/

    ...

     

    +RECOC1/:

    ...

    PR2/

    ...

     

    ASMCMD> rm */PR2/*/*

    Listing 14: Using asmcmd to show files created in disk groups DATA and RECO.

     

    Post-Duplication Tasks

     

    Step 1. Modify the PFILE initPR2.ora.

     

    The initialization parameter file (PFILE) init<SID>.ora on the destination system should adhere to SAP-specific requirements and recommended performance optimizations. For example, the PFILE initPR2.ora should be modified to reflect the Oracle SuperCluster configuration (including Oracle ASM data storage on Oracle Exadata Storage Servers). In addition, the PFILE should include parameter settings from the source environment as well as SAP-recommended parameters. The example PFILE in Listing 15 shows several optimizations commonly defined for SAP environments.

     

    PR2.__db_cache_size=4362076160

    PR2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

    PR2.__shared_io_pool_size=301989888

    *._B_TREE_BITMAP_PLANS=FALSE

    *._fix_control='5099019:ON','5705630:ON','6055658:OFF','6120483:OFF','6399597:ON','6430500:ON'

    ,'6440977:ON','6626018:ON','6972291:ON','7168184:OFF','7658097:ON','8937971:ON','9196440:ON','

    9495669:ON','13077335:ON','13627489:ON','14255600:ON','14595273:ON','18405517:2'#SAP_121022_20

    1503 RECOMMENDED SETTINGS

    *._IN_MEMORY_UNDO=FALSE

    *._INDEX_JOIN_ENABLED=FALSE

    *._OPTIM_PEEK_USER_BINDS=FALSE

    *._OPTIMIZER_MJC_ENABLED=FALSE

    *._SORT_ELIMINATION_COST_RATIO=10

    *._TABLE_LOOKUP_PREFETCH_SIZE=0

    *.audit_file_dest='/oracle/PR2/saptrace/audit'

    *.cluster_database=FALSE

    *.compatible='12.1.0.2.0'

    *.control_file_record_keep_time=30

    *.control_files='+DATAC1/PR2/CONTROLFILE/cntrl1.dbf','+RECOC1/PR2/CONTROLFILE/cntrl2.dbf'

    *.db_block_size=8192

    *.db_cache_size=4638564679

    *.db_name='PR2'

    *.DB_RECOVERY_FILE_DEST='+RECOC1'

    *.db_recovery_file_dest_size=30000M

    *.db_unique_name='PR2'

    *.diagnostic_dest='/oracle/PR2/saptrace'

    *.event='10027','10028','10142','10183','10191','10995 level 2','38068 level

    100','38085','38087','44951 level 1024'#SAP_121022_201503 RECOMMENDED SETTINGS

    *.FILESYSTEMIO_OPTIONS='setall'

    *.listener_networks='((NAME=network2)(LOCAL_LISTENER=LISTENER_IBLOCAL)(REMOTE_LISTENER=LISTENE

    R_IBREMOTE))','((NAME=network1)(LOCAL_LISTENER=LISTENER_IPLOCAL)(REMOTE_LISTENER=sapm7-c1-

    scan:1521))'

    *.log_archive_dest_1='LOCATION=+RECOC1'

    *.log_archive_format='%t_%s_%r.dbf'

    *.log_checkpoints_to_alert=true

    *.max_dump_file_size='20000'

    *.open_cursors=2000

    *.parallel_execution_message_size=16384

    *.parallel_threads_per_cpu=1

    *.pga_aggregate_target=6184752906

    *.processes=1390

    *.query_rewrite_enabled='false'

    *.recyclebin='off'

    *.remote_listener='sapm7zdb2c1-vip:1521'

    *.remote_login_passwordfile='exclusive'

    *.replication_dependency_tracking=false

    *.sessions=2780

    *.shared_pool_size=4638564679

    *.star_transformation_enabled='true'

    Listing 15: Example PFILE initPR2.ora.

     

    This PFILE includes SAP-recommended settings specified in SAP Note 188848 that help in optimizing performance for Oracle Database 12.1.0.2 (SAP Note 188848 is specific to Oracle Database 12.1.0.2). Modify the PFILE according to SAP recommendations for the specific database version being migrated.

     

    Step 2. Re-create the SPFILE.

     

    An SPFILE file called spfilePR2.ora is created on the target during the Oracle RMAN duplication process. If it is not removed, its settings will be used instead of those in the PFILE initPR2.ora, negating the impact of updated PFILE changes and optimizations. The following steps delete the SPFILE in $ORACLE_HOME/dbs and re-create it in ASM DATA disk group('+DATAC1/PR2/spfilePR2.ora' ). It is done using the PFILE initPR2.ora, which has been modified to reflect appropriate SAP and customer specific optimizations.

     

    Step 2.1. Remove the file spfilePR2.ora from the $ORACLE_HOME/dbs directory.

     

    oracle@sapm7zdbadm1c1:~/dup$ rm $ORACLE_HOME/dbs/spfilePR2.ora

    Listing 16: Removing the SPFILE spfilePR2.ora.

     

    Step 2.2. Create a new SPFILE on the target system.

     

    Using the PFILE initPR2.ora, create a new version of spfilePR2.ora on the target system in the Oracle ASM disk group +DATAC1.

     

    oracle@sapm7zdbadm1c1:~/dup$ sqlplus / as sysdba

    SQL*Plus: Release 12.1.0.2.0 Production on Fri May 13 11:40:46 2016

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

    Connected to:

    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics

    and Real Application Testing options

    SQL> create spfile = '+DATAC1/PR2/spfilePR2.ora' from pfile;

    SQL> quit

    Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics

    and Real Application Testing options

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$

    Listing 17: Creating a new SPFILE in the Oracle ASM disk group.

     

    Step 2.3. Modify initPR2.ora to point to the new SPFILE.

     

    Modify the PFILE initPR2.ora to point to +DATAC1/PR2/spfilePR2.ora.

     

    oracle@sapm7zdbadm1c1:~/dup$ cat $ORACLE_HOME/dbs/initPR2.ora

    spfile = (+DATAC1/PR2/spfilePR2.ora)

    Listing 18: Modifying initPR2.ora to point to the new SPFILE.

     

    Step 2.4. Restart the database and validate the SPFILE parameter.

     

    Stop and restart the database to refresh the database initialization parameters. Verify that the SPFILE parameter is set correctly.

     

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/dbs$ sqlplus / as sysdba

    SQL*Plus: Release 12.1.0.2.0 Production on Fri May 13 11:53:50 2016

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

    Connected to:

    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

    With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics

    and Real Application Testing options

    SQL> shutdown abort

    ORACLE instance shut down.

    SQL> startup

    ORACLE instance started.

    Total System Global Area 9495904256 bytes

    Fixed Size                  5282808 bytes

    Variable Size            4798284808 bytes

    Database Buffers         4664066048 bytes

    Redo Buffers               28270592 bytes

    Database mounted.

    Database opened.

    SQL> show parameter spfile

     

    NAME                                 TYPE        VALUE

    ------------------------------------ ----------- ------------------------------

    spfile                               string      +DATAC1/PR2/spfilepr2.ora

    SQL>

    Listing 19: Restarting the database to verify the SPFILE setting.

     

    Step 3. Apply the latest SAP bundle patch.

     

    Best practice is to install the latest SAP Bundle Patch (SBP) available. Apply the latest SBP to the newly created database. In the test environment, ORACLE_HOME was patched before starting the migration. Listing 20 shows how to query the database to determine the last patch bundle that has been applied to the source database.

     

    SQL> select * from dba_registry_history;

     

    ACTION_TIME

    ---------------------------------------------------------------------------

    ACTION                         NAMESPACE

    ------------------------------ ------------------------------

    VERSION                                ID BUNDLE_SERIES

    ------------------------------ ---------- ------------------------------

    COMMENTS

    --------------------------------------------------------------------------------

    30-SEP-15 05.28.41.006139 AM

    APPLY                          SERVER

    12.1.0.2                           201508 SGR

    SBP 12.1.0.2.4 201508 containing CPUJul2015

    Listing 20: Find the current Oracle Patch Set and SAP Bundle Patch levels.

     

    In our example the SAP bundle patch was already applied to the Oracle Home. We needed to perform only the database-specific step from the README of the SBP. For Oracle Database 12.1 and later, apply the SBP to the database using the catsbp script provided with the SBP (for Oracle Database 11.2, use the script catsbp.sql).

     

    oracle@sapm7zdbadm1c1:/oracle/PR2/121/sapbundle/SBP_121025_201511$ ./catsbp

    catsbp - Post-process Installation of SBP 12.1.0.2.5 201511 for Exadata.

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

     

    Log file: $ORACLE_BASE/cfgtoollogs/sqlpatch/SXD201511_APPLY_PR2_2016_04_15-01-44-53.log

     

    Connecting to database...

    Connecting to database...done.

     

    Executing Datapatch...

    Executing Datapatch...done.

     

    Loading style sheets...

    Loading style sheets...skipped.

    Reason: Style sheets already loaded

     

    Recompiling objects with utlrp...

    Recompiling objects with utlrp...done.

     

    Log file: $ORACLE_BASE/cfgtoollogs/sqlpatch/SXD201511_APPLY_PR2_2016_04_15-01-44-53.log

     

    catsbp completed successfully.

     

    Overall Status: COMPLETE

    Listing 21: Applying the latest SAP Bundle Patch to a new database (in a directory that was patched before).

     

    If the current SAP Bundle Patch requires rolling back some patches, this procedure might fail if the rollback files have not been copied over. Check the log file, as shown in Listing 22. Copy over relevant directories from the source database server and restart the procedure.

     

    SQL> select comments,action, to_char(action_time,'DD-MON-YYYY HH24:MM') from dba_registry_history;

     

    COMMENTS

    --------------------------------------------------------------------------------

    ACTION                         TO_CHAR(ACTION_TIME,'DD

    ------------------------------ -----------------------

    SBP 12.1.0.2.4 201508 containing CPUJul2015

    APPLY                          30-SEP-2015 05:09

     

    SBP 12.1.0.2.5 201511 containing CPUOct2015

    INCOMPLAPL                     15-APR-2016 01:04

     

    SBP 12.1.0.2.5 201511 containing CPUOct2015

    APPLY           

    Listing 22: Checking the log for missing patches.

     

    Note: For troubleshooting issues with catsbp, see SAP Note 2184669.

     

    Step 4. Perform the post-database migration steps.

     

    The Oracle Database migration is now complete and the database instance is usable. There are, however, additional tasks that are necessary to finalize the migration of the SAP system. Part 6 of this article series, "SAP Environment Migration—Post-Database-Migration Tasks" describes these requirements.

     

    See Also

     

    For more information about the Oracle RMAN DUPLICATE command, refer to the Oracle Database Backup and Recovery User's Guide (for Oracle Database 11g) or Oracle Database Backup and Recovery User's Guide (for Oracle Database 12c). See also the Oracle Recovery Manager page on Oracle Technology Network. Other references include the white papers "Moving your SAP Database to Oracle Automatic Storage Management 11g Release 2: A Best Practices Guide" and "SAP NetWeaver and Oracle Exadata Database Machine."

     

    About the Authors

     

    Victor Galis is a master sales consultant, part of the global Oracle Solution Center organization. He supports customers and sales teams architecting SAP environments based on Oracle hardware and technology. He works with SAP Basis and DBA teams, systems and storage administrators, as well as business owners and executives. His role is to understand current environments, business requirements, and pain points as well as future growth and map them to SAP landscapes that meet both performance and high availability expectations. He has been involved with many "SAP on Oracle SuperCluster" customer environments as an architect and has provided deployment and go-live assistance. Galis is an SAP-certified consultant and Oracle Database administrator.

     

    Pierre Reynes is a solution manager for Oracle Optimized Solution for SAP and Oracle Optimized Solution for PeopleSoft. He is responsible for driving the strategy and efforts to help raise customer and market awareness for Oracle Optimized Solutions in these areas. Reynes has over 25 years of experience in the computer and networking industries.

     

    Appendix A: Example Oracle RMAN Log File

     

    Recovery Manager: Release 12.1.0.2.0 - Production on Thu Jul 28 13:56:57 2016

     

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

     

    RMAN> connect target *

    2> connect auxiliary *

    3>

    4> CONFIGURE DEVICE TYPE DISK PARALLELISM 16 BACKUP TYPE TO BACKUPSET;

    5>

    6> show all;

    7>

    8> run {

    9>   allocate channel t0 device type disk;

    10>   allocate channel t1 device type disk;

    11>   allocate channel t2 device type disk;

    12>   allocate channel t3 device type disk;

    13>   allocate channel t4 device type disk;

    14>   allocate channel t5 device type disk;

    15>   allocate channel t6 device type disk;

    16>   allocate channel t7 device type disk;

    17>   allocate channel t8 device type disk;

    18>   allocate channel t9 device type disk;

    19>   allocate channel t10 device type disk;

    20>   allocate channel t11 device type disk;

    21>   allocate channel t12 device type disk;

    22>   allocate channel t13 device type disk;

    23>   allocate channel t14 device type disk;

    24>   allocate channel t15 device type disk;

    25>   allocate auxiliary channel c0 device type disk;

    26>

    27> duplicate target database to PR2 from active database;

    28> }

    29>

    30>

    connected to target database: PR1 (DBID=994759330)

     

    connected to auxiliary database: PR2 (not mounted)

     

    using target database control file instead of recovery catalog

    old RMAN configuration parameters:

    CONFIGURE DEVICE TYPE DISK PARALLELISM 16 BACKUP TYPE TO BACKUPSET;

    new RMAN configuration parameters:

    CONFIGURE DEVICE TYPE DISK PARALLELISM 16 BACKUP TYPE TO BACKUPSET;

    new RMAN configuration parameters are successfully stored

     

    RMAN configuration parameters for database with db_unique_name PR1 are:

    CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

    CONFIGURE BACKUP OPTIMIZATION OFF; # default

    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

    CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

    CONFIGURE DEVICE TYPE DISK PARALLELISM 16 BACKUP TYPE TO BACKUPSET;

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

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

    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 RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/PR1/121/dbs/snapcf_PR1001.f'; # default

     

    allocated channel: t0

    channel t0: SID=1873 instance=PR1001 device type=DISK

     

    allocated channel: t1

    channel t1: SID=2106 instance=PR1001 device type=DISK

     

    allocated channel: t2

    channel t2: SID=2324 instance=PR1001 device type=DISK

     

    allocated channel: t3

    channel t3: SID=2567 instance=PR1001 device type=DISK

     

    allocated channel: t4

    channel t4: SID=18 instance=PR1001 device type=DISK

     

    allocated channel: t5

    channel t5: SID=235 instance=PR1001 device type=DISK

     

    allocated channel: t6

    channel t6: SID=483 instance=PR1001 device type=DISK

     

    allocated channel: t7

    channel t7: SID=717 instance=PR1001 device type=DISK

     

    allocated channel: t8

    channel t8: SID=946 instance=PR1001 device type=DISK

     

    allocated channel: t9

    channel t9: SID=1180 instance=PR1001 device type=DISK

     

    allocated channel: t10

    channel t10: SID=1408 instance=PR1001 device type=DISK

     

    allocated channel: t11

    channel t11: SID=1642 instance=PR1001 device type=DISK

     

    allocated channel: t12

    channel t12: SID=1872 instance=PR1001 device type=DISK

     

    allocated channel: t13

    channel t13: SID=2093 instance=PR1001 device type=DISK

     

    allocated channel: t14

    channel t14: SID=2335 instance=PR1001 device type=DISK

     

    allocated channel: t15

    channel t15: SID=2566 instance=PR1001 device type=DISK

     

    allocated channel: c0

    channel c0: SID=1345 device type=DISK

     

    Starting Duplicate Db at 28-JUL-16

    current log archived

     

    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   10737418240 bytes

     

    Fixed Size                     2925344 bytes

    Variable Size              10468990176 bytes

    Database Buffers             234881024 bytes

    Redo Buffers                  30621696 bytes

    allocated channel: c0

    channel c0: SID=1345 device type=DISK

     

    contents of Memory Script:

    {

       sql clone "alter system set  db_name =

    ''PR1'' comment=

    ''Modified by RMAN duplicate'' scope=spfile";

       sql clone "alter system set  db_unique_name =

    ''PR2'' comment=

    ''Modified by RMAN duplicate'' scope=spfile";

       shutdown clone immediate;

       startup clone force nomount

       backup as copy current controlfile auxiliary format  '+DATAC1/PR2/CONTROLFILE/cntrl1.dbf';

       restore clone primary controlfile to  '+RECOC1/PR2/CONTROLFILE/cntrl2.dbf' from

    '+DATAC1/PR2/CONTROLFILE/cntrl1.dbf';

       alter clone database mount;

    }

    executing Memory Script

     

    sql statement: alter system set  db_name =  ''PR1'' comment= ''Modified by RMAN duplicate'' scope=spfile

     

    sql statement: alter system set  db_unique_name =  ''PR2'' comment= ''Modified by RMAN duplicate'' scope=spfile

     

    Oracle instance shut down

     

    Oracle instance started

     

    Total System Global Area   10737418240 bytes

     

    Fixed Size                     2925344 bytes

    Variable Size              10468990176 bytes

    Database Buffers             234881024 bytes

    Redo Buffers                  30621696 bytes

    allocated channel: c0

    channel c0: SID=1345 device type=DISK

     

    Starting backup at 28-JUL-16

    channel t0: starting datafile copy

    copying current control file

    output file name=+DATAC1/PR2/CONTROLFILE/cntrl1.dbf tag=TAG20160728T140003

    channel t0: datafile copy complete, elapsed time: 00:00:03

    Finished backup at 28-JUL-16

     

    Starting restore at 28-JUL-16

     

    channel c0: copied control file copy

    Finished restore at 28-JUL-16

     

    database mounted

     

    contents of Memory Script:

    {

       set newname for clone datafile  1 to new;

       set newname for clone datafile  2 to new;

       set newname for clone datafile  3 to new;

       set newname for clone datafile  4 to new;

       set newname for clone datafile  5 to new;

       set newname for clone datafile  6 to new;

       set newname for clone datafile  7 to new;

       set newname for clone datafile  8 to new;

       set newname for clone datafile  9 to new;

       set newname for clone datafile  10 to new;

       set newname for clone datafile  11 to new;

       set newname for clone datafile  12 to new;

       set newname for clone datafile  13 to new;

       set newname for clone datafile  14 to new;

       set newname for clone datafile  15 to new;

       set newname for clone datafile  16 to new;

       set newname for clone datafile  17 to new;

       set newname for clone datafile  18 to new;

       set newname for clone datafile  19 to new;

       set newname for clone datafile  20 to new;

       set newname for clone datafile  21 to new;

       set newname for clone datafile  22 to new;

       set newname for clone datafile  23 to new;

       set newname for clone datafile  24 to new;

       set newname for clone datafile  25 to new;

       set newname for clone datafile  26 to new;

       set newname for clone datafile  27 to new;

       set newname for clone datafile  28 to new;

       set newname for clone datafile  29 to new;

       set newname for clone datafile  30 to new;

       set newname for clone datafile  31 to new;

       set newname for clone datafile  32 to new;

       set newname for clone datafile  33 to new;

       set newname for clone datafile  34 to new;

       set newname for clone datafile  35 to new;

       set newname for clone datafile  36 to new;

       set newname for clone datafile  37 to new;

       set newname for clone datafile  38 to new;

       set newname for clone datafile  39 to new;

       set newname for clone datafile  40 to new;

       set newname for clone datafile  41 to new;

       set newname for clone datafile  42 to new;

       set newname for clone datafile  43 to new;

       set newname for clone datafile  44 to new;

       set newname for clone datafile  45 to new;

       set newname for clone datafile  46 to new;

       set newname for clone datafile  47 to new;

       set newname for clone datafile  48 to new;

       set newname for clone datafile  49 to new;

       set newname for clone datafile  50 to new;

       backup as copy reuse

       datafile  1 auxiliary format new

       datafile  2 auxiliary format new

       datafile  3 auxiliary format new

       datafile  4 auxiliary format new

       datafile  5 auxiliary format new

       datafile  6 auxiliary format new

       datafile  7 auxiliary format new

       datafile  8 auxiliary format new

       datafile  9 auxiliary format new

       datafile  10 auxiliary format new

       datafile  11 auxiliary format new

       datafile  12 auxiliary format new

       datafile  13 auxiliary format new

       datafile  14 auxiliary format new

       datafile  15 auxiliary format new

       datafile  16 auxiliary format new

       datafile  17 auxiliary format new

       datafile  18 auxiliary format new

       datafile  19 auxiliary format new

       datafile  20 auxiliary format new

       datafile  21 auxiliary format new

       datafile  22 auxiliary format new

       datafile  23 auxiliary format new

       datafile  24 auxiliary format new

       datafile  25 auxiliary format new

       datafile  26 auxiliary format new

       datafile  27 auxiliary format new

       datafile  28 auxiliary format new

       datafile  29 auxiliary format new

       datafile  30 auxiliary format new

       datafile  31 auxiliary format new

       datafile  32 auxiliary format new

       datafile  33 auxiliary format new

       datafile  34 auxiliary format new

       datafile  35 auxiliary format new

       datafile  36 auxiliary format new

       datafile  37 auxiliary format new

       datafile  38 auxiliary format new

       datafile  39 auxiliary format new

       datafile  40 auxiliary format new

       datafile  41 auxiliary format new

       datafile  42 auxiliary format new

       datafile  43 auxiliary format new

       datafile  44 auxiliary format new

       datafile  45 auxiliary format new

       datafile  46 auxiliary format new

       datafile  47 auxiliary format new

       datafile  48 auxiliary format new

       datafile  49 auxiliary format new

       datafile  50 auxiliary format new

       ;

       sql 'alter system archive log current';

    }

    executing Memory Script

     

    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

     

    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

     

    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

     

    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

     

    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

     

    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

     

    executing command: SET NEWNAME

     

    executing command: SET NEWNAME

     

    Starting backup at 28-JUL-16

    channel t0: starting datafile copy

    input datafile file number=00040 name=/oracle/PR1/sapdata1/undo002_1/undo002.data1

    channel t1: starting datafile copy

    input datafile file number=00003 name=/oracle/PR1/sapdata1/undo_1/undo.data1

    channel t2: starting datafile copy

    input datafile file number=00050 name=/oracle/PR1/sapdata1/undo_2/undo.data2

    channel t3: starting datafile copy

    input datafile file number=00014 name=/oracle/PR1/sapdata3/sr3_11/sr3.data11

    channel t4: starting datafile copy

    input datafile file number=00008 name=/oracle/PR1/sapdata3/sr3_5/sr3.data5

    channel t5: starting datafile copy

    input datafile file number=00010 name=/oracle/PR1/sapdata3/sr3_7/sr3.data7

    channel t6: starting datafile copy

    input datafile file number=00004 name=/oracle/PR1/sapdata3/sr3_1/sr3.data1

    channel t7: starting datafile copy

    input datafile file number=00005 name=/oracle/PR1/sapdata3/sr3_2/sr3.data2

    channel t8: starting datafile copy

    input datafile file number=00006 name=/oracle/PR1/sapdata3/sr3_3/sr3.data3

    channel t9: starting datafile copy

    input datafile file number=00007 name=/oracle/PR1/sapdata3/sr3_4/sr3.data4

    channel t10: starting datafile copy

    input datafile file number=00009 name=/oracle/PR1/sapdata3/sr3_6/sr3.data6

    channel t11: starting datafile copy

    input datafile file number=00011 name=/oracle/PR1/sapdata3/sr3_8/sr3.data8

    channel t12: starting datafile copy

    input datafile file number=00012 name=/oracle/PR1/sapdata3/sr3_9/sr3.data9

    channel t13: starting datafile copy

    input datafile file number=00013 name=/oracle/PR1/sapdata3/sr3_10/sr3.data10

    channel t14: starting datafile copy

    input datafile file number=00015 name=/oracle/PR1/sapdata3/sr3_12/sr3.data12

    channel t15: starting datafile copy

    input datafile file number=00016 name=/oracle/PR1/sapdata3/sr3_13/sr3.data13

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.340.918396025 tag=TAG20160728T140017

    channel t9: datafile copy complete, elapsed time: 00:06:06

    channel t9: starting datafile copy

    input datafile file number=00017 name=/oracle/PR1/sapdata3/sr3_14/sr3.data14

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.338.918396025 tag=TAG20160728T140017

    channel t10: datafile copy complete, elapsed time: 00:06:13

    channel t10: starting datafile copy

    input datafile file number=00018 name=/oracle/PR1/sapdata3/sr3_15/sr3.data15

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.333.918396025 tag=TAG20160728T140017

    channel t15: datafile copy complete, elapsed time: 00:06:59

    channel t15: starting datafile copy

    input datafile file number=00019 name=/oracle/PR1/sapdata3/sr3_16/sr3.data16

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.334.918396025 tag=TAG20160728T140017

    channel t14: datafile copy complete, elapsed time: 00:07:14

    channel t14: starting datafile copy

    input datafile file number=00041 name=/oracle/PR1/sapdata3/sr3_18/sr3.data18

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.337.918396025 tag=TAG20160728T140017

    channel t11: datafile copy complete, elapsed time: 00:07:40

    channel t11: starting datafile copy

    input datafile file number=00020 name=/oracle/PR1/sapdata3/sr3_17/sr3.data17

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.336.918396025 tag=TAG20160728T140017

    channel t12: datafile copy complete, elapsed time: 00:07:40

    channel t12: starting datafile copy

    input datafile file number=00042 name=/oracle/PR1/sapdata3/sr3_19/sr3.data19

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.344.918396023 tag=TAG20160728T140017

    channel t4: datafile copy complete, elapsed time: 00:07:57

    channel t4: starting datafile copy

    input datafile file number=00045 name=/oracle/PR1/sapdata3/sr3_21/sr3.data21

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.339.918396025 tag=TAG20160728T140017

    channel t8: datafile copy complete, elapsed time: 00:07:56

    channel t8: starting datafile copy

    input datafile file number=00046 name=/oracle/PR1/sapdata3/sr3_22/sr3.data22

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.341.918396023 tag=TAG20160728T140017

    channel t5: datafile copy complete, elapsed time: 00:08:23

    channel t5: starting datafile copy

    input datafile file number=00043 name=/oracle/PR1/sapdata3/sr3_20/sr3.data20

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.345.918396023 tag=TAG20160728T140017

    channel t3: datafile copy complete, elapsed time: 00:08:38

    channel t3: starting datafile copy

    input datafile file number=00001 name=/oracle/PR1/sapdata1/system_1/system.data1

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.343.918396023 tag=TAG20160728T140017

    channel t6: datafile copy complete, elapsed time: 00:08:38

    channel t6: starting datafile copy

    input datafile file number=00047 name=/oracle/PR1/sapdata3/sr3_23/sr3.data23

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.342.918396023 tag=TAG20160728T140017

    channel t7: datafile copy complete, elapsed time: 00:09:03

    channel t7: starting datafile copy

    input datafile file number=00048 name=/oracle/PR1/sapdata3/sr3_24/sr3.data24

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.335.918396025 tag=TAG20160728T140017

    channel t13: datafile copy complete, elapsed time: 00:09:29

    channel t13: starting datafile copy

    input datafile file number=00049 name=/oracle/PR1/sapdata3/sr3_25/sr3.data25

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.329.918396459 tag=TAG20160728T140017

    channel t14: datafile copy complete, elapsed time: 00:03:59

    channel t14: starting datafile copy

    input datafile file number=00021 name=/oracle/PR1/sapdata2/sr3740_1/sr3740.data1

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.325.918396501 tag=TAG20160728T140017

    channel t8: datafile copy complete, elapsed time: 00:03:43

    channel t8: starting datafile copy

    input datafile file number=00022 name=/oracle/PR1/sapdata2/sr3740_2/sr3740.data2

    output file name=+DATAC1/PR2/DATAFILE/system.323.918396541 tag=TAG20160728T140017

    channel t3: datafile copy complete, elapsed time: 00:04:27

    channel t3: starting datafile copy

    input datafile file number=00023 name=/oracle/PR1/sapdata2/sr3740_3/sr3740.data3

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.324.918396527 tag=TAG20160728T140017

    channel t5: datafile copy complete, elapsed time: 00:04:44

    channel t5: starting datafile copy

    input datafile file number=00024 name=/oracle/PR1/sapdata2/sr3740_4/sr3740.data4

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.328.918396485 tag=TAG20160728T140017

    channel t11: datafile copy complete, elapsed time: 00:05:33

    channel t11: starting datafile copy

    input datafile file number=00025 name=/oracle/PR1/sapdata2/sr3740_5/sr3740.data5

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.330.918396443 tag=TAG20160728T140017

    channel t15: datafile copy complete, elapsed time: 00:06:30

    channel t15: starting datafile copy

    input datafile file number=00026 name=/oracle/PR1/sapdata2/sr3740_6/sr3740.data6

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.332.918396391 tag=TAG20160728T140017

    channel t9: datafile copy complete, elapsed time: 00:07:38

    channel t9: starting datafile copy

    input datafile file number=00027 name=/oracle/PR1/sapdata2/sr3740_7/sr3740.data7

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.320.918396593 tag=TAG20160728T140017

    channel t13: datafile copy complete, elapsed time: 00:04:19

    channel t13: starting datafile copy

    input datafile file number=00028 name=/oracle/PR1/sapdata2/sr3740_8/sr3740.data8

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.326.918396501 tag=TAG20160728T140017

    channel t4: datafile copy complete, elapsed time: 00:06:17

    channel t4: starting datafile copy

    input datafile file number=00029 name=/oracle/PR1/sapdata2/sr3740_9/sr3740.data9

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.327.918396485 tag=TAG20160728T140017

    channel t12: datafile copy complete, elapsed time: 00:06:48

    channel t12: starting datafile copy

    input datafile file number=00030 name=/oracle/PR1/sapdata2/sr3740_10/sr3740.data10

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.331.918396397 tag=TAG20160728T140017

    channel t10: datafile copy complete, elapsed time: 00:08:16

    channel t10: starting datafile copy

    input datafile file number=00031 name=/oracle/PR1/sapdata2/sr3740_11/sr3740.data11

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.318.918396725 tag=TAG20160728T140017

    channel t8: datafile copy complete, elapsed time: 00:02:58

    channel t8: starting datafile copy

    input datafile file number=00032 name=/oracle/PR1/sapdata2/sr3740_12/sr3740.data12

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.322.918396543 tag=TAG20160728T140017

    channel t6: datafile copy complete, elapsed time: 00:06:25

    channel t6: starting datafile copy

    input datafile file number=00033 name=/oracle/PR1/sapdata2/sr3740_13/sr3740.data13

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.319.918396699 tag=TAG20160728T140017

    channel t14: datafile copy complete, elapsed time: 00:05:14

    channel t14: starting datafile copy

    input datafile file number=00034 name=/oracle/PR1/sapdata2/sr3740_14/sr3740.data14

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.427.918396811 tag=TAG20160728T140017

    channel t5: datafile copy complete, elapsed time: 00:04:19

    channel t5: starting datafile copy

    input datafile file number=00035 name=/oracle/PR1/sapdata2/sr3740_15/sr3740.data15

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.316.918396817 tag=TAG20160728T140017

    channel t11: datafile copy complete, elapsed time: 00:04:12

    channel t11: starting datafile copy

    input datafile file number=00036 name=/oracle/PR1/sapdata2/sr3740_16/sr3740.data16

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.315.918396833 tag=TAG20160728T140017

    channel t15: datafile copy complete, elapsed time: 00:04:52

    channel t15: starting datafile copy

    input datafile file number=00037 name=/oracle/PR1/sapdata2/sr3740_17/sr3740.data17

    output file name=+DATAC1/PR2/DATAFILE/psapsr3.321.918396567 tag=TAG20160728T140017

    channel t7: datafile copy complete, elapsed time: 00:09:21

    channel t7: starting datafile copy

    input datafile file number=00044 name=/oracle/PR1/sapdata1/system_2/system.data2

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.309.918396903 tag=TAG20160728T140017

    channel t8: datafile copy complete, elapsed time: 00:04:12

    channel t8: starting datafile copy

    input datafile file number=00002 name=/oracle/PR1/sapdata1/sysaux_1/sysaux.data1

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.312.918396877 tag=TAG20160728T140017

    channel t4: datafile copy complete, elapsed time: 00:05:02

    channel t4: starting datafile copy

    input datafile file number=00038 name=/oracle/PR1/sapdata2/sr3740_18/sr3740.data18

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.313.918396853 tag=TAG20160728T140017

    channel t13: datafile copy complete, elapsed time: 00:05:43

    channel t13: starting datafile copy

    input datafile file number=00039 name=/oracle/PR1/sapdata4/sr3usr_1/sr3usr.data1

    output file name=+DATAC1/PR2/DATAFILE/psapsr3usr.358.918397197 tag=TAG20160728T140017

    channel t13: datafile copy complete, elapsed time: 00:00:03

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.314.918396849 tag=TAG20160728T140017

    channel t9: datafile copy complete, elapsed time: 00:06:02

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.317.918396809 tag=TAG20160728T140017

    channel t3: datafile copy complete, elapsed time: 00:06:51

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.311.918396893 tag=TAG20160728T140017

    channel t12: datafile copy complete, elapsed time: 00:05:28

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.301.918397181 tag=TAG20160728T140017

    channel t4: datafile copy complete, elapsed time: 00:01:41

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.308.918396929 tag=TAG20160728T140017

    channel t6: datafile copy complete, elapsed time: 00:06:03

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.310.918396895 tag=TAG20160728T140017

    channel t10: datafile copy complete, elapsed time: 00:06:47

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.307.918397013 tag=TAG20160728T140017

    channel t14: datafile copy complete, elapsed time: 00:04:49

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.305.918397071 tag=TAG20160728T140017

    channel t11: datafile copy complete, elapsed time: 00:04:02

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.304.918397127 tag=TAG20160728T140017

    channel t15: datafile copy complete, elapsed time: 00:03:06

    output file name=+DATAC1/PR2/DATAFILE/system.303.918397129 tag=TAG20160728T140017

    channel t7: datafile copy complete, elapsed time: 00:03:23

    output file name=+DATAC1/PR2/DATAFILE/sysaux.302.918397155 tag=TAG20160728T140017

    channel t8: datafile copy complete, elapsed time: 00:02:57

    output file name=+DATAC1/PR2/DATAFILE/psapsr3740.306.918397069 tag=TAG20160728T140017

    channel t5: datafile copy complete, elapsed time: 00:04:33

    output file name=+DATAC1/PR2/DATAFILE/psapundo001.347.918396023 tag=TAG20160728T140017

    channel t1: datafile copy complete, elapsed time: 00:22:59

    output file name=+DATAC1/PR2/DATAFILE/psapundo001.346.918396023 tag=TAG20160728T140017

    channel t2: datafile copy complete, elapsed time: 00:22:59

    output file name=+DATAC1/PR2/DATAFILE/psapundo002.348.918396023 tag=TAG20160728T140017

    channel t0: datafile copy complete, elapsed time: 00:23:30

    Finished backup at 28-JUL-16

     

    sql statement: alter system archive log current

    current log archived

     

    contents of Memory Script:

    {

       backup as copy reuse

       archivelog like  "/oracle/PR1/oraarch/PR1arch1_13830_889424610.dbf" auxiliary format

    "+RECOC1"   archivelog like

    "/oracle/PR1/oraarch/PR1arch1_13831_889424610.dbf" auxiliary format

    "+RECOC1"   ;

       catalog clone start with  "+RECOC1";

       switch clone datafile all;

    }

    executing Memory Script

     

    Starting backup at 28-JUL-16

    channel t0: starting archived log copy

    input archived log thread=1 sequence=13830 RECID=26273 STAMP=918397432

    channel t1: starting archived log copy

    input archived log thread=1 sequence=13831 RECID=26274 STAMP=918397433

    output file name=+RECOC1/PR2/ARCHIVELOG/2016_07_28/thread_1_seq_13830.2131.918397459 RECID=0 STAMP=0

    channel t0: archived log copy complete, elapsed time: 00:00:01

    output file name=+RECOC1/PR2/ARCHIVELOG/2016_07_28/thread_1_seq_13831.2257.918397459 RECID=0 STAMP=0

    channel t1: archived log copy complete, elapsed time: 00:00:01

    Finished backup at 28-JUL-16

     

    searching for all files that match the pattern +RECOC1

     

    List of Files Unknown to the Database

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

    File Name: +RECOC1/MXL/ARCHIVELOG/2016_07_28/thread_1_seq_81.2125.918350049

    <...> ###### Lines deleted ... All files under RECOC1

    File Name: +RECOC1/DBM01/CONTROLFILE/current.256.902028571

    cataloging files...

    cataloging done

     

    List of Cataloged Files

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

    File Name: +RECOC1/PR2/ARCHIVELOG/2016_07_28/thread_1_seq_13830.2131.918397459

    File Name: +RECOC1/PR2/ARCHIVELOG/2016_07_28/thread_1_seq_13831.2257.918397459

     

    List of Files Which Were Not Cataloged

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

    File Name: +RECOC1/MXL/ARCHIVELOG/2016_07_28/thread_1_seq_81.2125.918350049

      RMAN-07518: Reason: Foreign database file DBID: 3973507264  Database Name: MXL

    <...> ###### Lines deleted ... Files not related to PR2

    File Name: +RECOC1/DBM01/CONTROLFILE/current.256.902028571

      RMAN-07518: Reason: Foreign database file DBID: 1106373849  Database Name: DBM01

     

    datafile 1 switched to datafile copy

    input datafile copy RECID=12 STAMP=918397494 file name=+DATAC1/PR2/DATAFILE/system.323.918396541

    datafile 2 switched to datafile copy

    input datafile copy RECID=13 STAMP=918397494 file name=+DATAC1/PR2/DATAFILE/sysaux.302.918397155

    datafile 3 switched to datafile copy

    input datafile copy RECID=14 STAMP=918397494 file name=+DATAC1/PR2/DATAFILE/psapundo001.347.918396023

    datafile 4 switched to datafile copy

    input datafile copy RECID=15 STAMP=918397494 file name=+DATAC1/PR2/DATAFILE/psapsr3.343.918396023

    datafile 5 switched to datafile copy

    input datafile copy RECID=16 STAMP=918397494 file name=+DATAC1/PR2/DATAFILE/psapsr3.342.918396023

    datafile 6 switched to datafile copy

    input datafile copy RECID=17 STAMP=918397494 file name=+DATAC1/PR2/DATAFILE/psapsr3.339.918396025

    datafile 7 switched to datafile copy

    input datafile copy RECID=18 STAMP=918397494 file name=+DATAC1/PR2/DATAFILE/psapsr3.340.918396025

    datafile 8 switched to datafile copy

    input datafile copy RECID=19 STAMP=918397495 file name=+DATAC1/PR2/DATAFILE/psapsr3.344.918396023

    datafile 9 switched to datafile copy

    input datafile copy RECID=20 STAMP=918397495 file name=+DATAC1/PR2/DATAFILE/psapsr3.338.918396025

    datafile 10 switched to datafile copy

    input datafile copy RECID=21 STAMP=918397495 file name=+DATAC1/PR2/DATAFILE/psapsr3.341.918396023

    datafile 11 switched to datafile copy

    input datafile copy RECID=22 STAMP=918397495 file name=+DATAC1/PR2/DATAFILE/psapsr3.337.918396025

    datafile 12 switched to datafile copy

    input datafile copy RECID=23 STAMP=918397495 file name=+DATAC1/PR2/DATAFILE/psapsr3.336.918396025

    datafile 13 switched to datafile copy

    input datafile copy RECID=24 STAMP=918397495 file name=+DATAC1/PR2/DATAFILE/psapsr3.335.918396025

    datafile 14 switched to datafile copy

    input datafile copy RECID=25 STAMP=918397495 file name=+DATAC1/PR2/DATAFILE/psapsr3.345.918396023

    datafile 15 switched to datafile copy

    input datafile copy RECID=26 STAMP=918397495 file name=+DATAC1/PR2/DATAFILE/psapsr3.334.918396025

    datafile 16 switched to datafile copy

    input datafile copy RECID=27 STAMP=918397495 file name=+DATAC1/PR2/DATAFILE/psapsr3.333.918396025

    datafile 17 switched to datafile copy

    input datafile copy RECID=28 STAMP=918397496 file name=+DATAC1/PR2/DATAFILE/psapsr3.332.918396391

    datafile 18 switched to datafile copy

    input datafile copy RECID=29 STAMP=918397496 file name=+DATAC1/PR2/DATAFILE/psapsr3.331.918396397

    datafile 19 switched to datafile copy

    input datafile copy RECID=30 STAMP=918397496 file name=+DATAC1/PR2/DATAFILE/psapsr3.330.918396443

    datafile 20 switched to datafile copy

    input datafile copy RECID=31 STAMP=918397496 file name=+DATAC1/PR2/DATAFILE/psapsr3.328.918396485

    datafile 21 switched to datafile copy

    input datafile copy RECID=32 STAMP=918397496 file name=+DATAC1/PR2/DATAFILE/psapsr3740.319.918396699

    datafile 22 switched to datafile copy

    input datafile copy RECID=33 STAMP=918397496 file name=+DATAC1/PR2/DATAFILE/psapsr3740.318.918396725

    datafile 23 switched to datafile copy

    input datafile copy RECID=34 STAMP=918397496 file name=+DATAC1/PR2/DATAFILE/psapsr3740.317.918396809

    datafile 24 switched to datafile copy

    input datafile copy RECID=35 STAMP=918397496 file name=+DATAC1/PR2/DATAFILE/psapsr3740.427.918396811

    datafile 25 switched to datafile copy

    input datafile copy RECID=36 STAMP=918397496 file name=+DATAC1/PR2/DATAFILE/psapsr3740.316.918396817

    datafile 26 switched to datafile copy

    input datafile copy RECID=37 STAMP=918397496 file name=+DATAC1/PR2/DATAFILE/psapsr3740.315.918396833

    datafile 27 switched to datafile copy

    input datafile copy RECID=38 STAMP=918397497 file name=+DATAC1/PR2/DATAFILE/psapsr3740.314.918396849

    datafile 28 switched to datafile copy

    input datafile copy RECID=39 STAMP=918397497 file name=+DATAC1/PR2/DATAFILE/psapsr3740.313.918396853

    datafile 29 switched to datafile copy

    input datafile copy RECID=40 STAMP=918397497 file name=+DATAC1/PR2/DATAFILE/psapsr3740.312.918396877

    datafile 30 switched to datafile copy

    input datafile copy RECID=41 STAMP=918397497 file name=+DATAC1/PR2/DATAFILE/psapsr3740.311.918396893

    datafile 31 switched to datafile copy

    input datafile copy RECID=42 STAMP=918397497 file name=+DATAC1/PR2/DATAFILE/psapsr3740.310.918396895

    datafile 32 switched to datafile copy

    input datafile copy RECID=43 STAMP=918397497 file name=+DATAC1/PR2/DATAFILE/psapsr3740.309.918396903

    datafile 33 switched to datafile copy

    input datafile copy RECID=44 STAMP=918397497 file name=+DATAC1/PR2/DATAFILE/psapsr3740.308.918396929

    datafile 34 switched to datafile copy

    input datafile copy RECID=45 STAMP=918397497 file name=+DATAC1/PR2/DATAFILE/psapsr3740.307.918397013

    datafile 35 switched to datafile copy

    input datafile copy RECID=46 STAMP=918397497 file name=+DATAC1/PR2/DATAFILE/psapsr3740.306.918397069

    datafile 36 switched to datafile copy

    input datafile copy RECID=47 STAMP=918397497 file name=+DATAC1/PR2/DATAFILE/psapsr3740.305.918397071

    datafile 37 switched to datafile copy

    input datafile copy RECID=48 STAMP=918397498 file name=+DATAC1/PR2/DATAFILE/psapsr3740.304.918397127

    datafile 38 switched to datafile copy

    input datafile copy RECID=49 STAMP=918397498 file name=+DATAC1/PR2/DATAFILE/psapsr3740.301.918397181

    datafile 39 switched to datafile copy

    input datafile copy RECID=50 STAMP=918397498 file name=+DATAC1/PR2/DATAFILE/psapsr3usr.358.918397197

    datafile 40 switched to datafile copy

    input datafile copy RECID=51 STAMP=918397498 file name=+DATAC1/PR2/DATAFILE/psapundo002.348.918396023

    datafile 41 switched to datafile copy

    input datafile copy RECID=52 STAMP=918397498 file name=+DATAC1/PR2/DATAFILE/psapsr3.329.918396459

    datafile 42 switched to datafile copy

    input datafile copy RECID=53 STAMP=918397498 file name=+DATAC1/PR2/DATAFILE/psapsr3.327.918396485

    datafile 43 switched to datafile copy

    input datafile copy RECID=54 STAMP=918397498 file name=+DATAC1/PR2/DATAFILE/psapsr3.324.918396527

    datafile 44 switched to datafile copy

    input datafile copy RECID=55 STAMP=918397498 file name=+DATAC1/PR2/DATAFILE/system.303.918397129

    datafile 45 switched to datafile copy

    input datafile copy RECID=56 STAMP=918397498 file name=+DATAC1/PR2/DATAFILE/psapsr3.326.918396501

    datafile 46 switched to datafile copy

    input datafile copy RECID=57 STAMP=918397499 file name=+DATAC1/PR2/DATAFILE/psapsr3.325.918396501

    datafile 47 switched to datafile copy

    input datafile copy RECID=58 STAMP=918397499 file name=+DATAC1/PR2/DATAFILE/psapsr3.322.918396543

    datafile 48 switched to datafile copy

    input datafile copy RECID=59 STAMP=918397499 file name=+DATAC1/PR2/DATAFILE/psapsr3.321.918396567

    datafile 49 switched to datafile copy

    input datafile copy RECID=60 STAMP=918397499 file name=+DATAC1/PR2/DATAFILE/psapsr3.320.918396593

    datafile 50 switched to datafile copy

    input datafile copy RECID=61 STAMP=918397499 file name=+DATAC1/PR2/DATAFILE/psapundo001.346.918396023

     

    contents of Memory Script:

    {

       set until scn  1009006701;

       recover

       clone database

        delete archivelog

       ;

    }

    executing Memory Script

     

    executing command: SET until clause

     

    Starting recover at 28-JUL-16

     

    starting media recovery

     

    archived log for thread 1 with sequence 13830 is already on disk as file +RECOC1/PR2/ARCHIVELOG/2016_07_28/thread_1_seq_13830.2131.918397459

    archived log for thread 1 with sequence 13831 is already on disk as file +RECOC1/PR2/ARCHIVELOG/2016_07_28/thread_1_seq_13831.2257.918397459

    archived log file name=+RECOC1/PR2/ARCHIVELOG/2016_07_28/thread_1_seq_13830.2131.918397459 thread=1 sequence=13830

    archived log file name=+RECOC1/PR2/ARCHIVELOG/2016_07_28/thread_1_seq_13831.2257.918397459 thread=1 sequence=13831

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

    Finished recover at 28-JUL-16

    Oracle instance started

     

    Total System Global Area   10737418240 bytes

     

    Fixed Size                     2925344 bytes

    Variable Size              10468990176 bytes

    Database Buffers             234881024 bytes

    Redo Buffers                  30621696 bytes

     

    contents of Memory Script:

    {

       sql clone "alter system set  db_name =

    ''PR2'' comment=

    ''Reset to original value by RMAN'' scope=spfile";

       sql clone "alter system reset  db_unique_name scope=spfile";

    }

    executing Memory Script

     

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

     

    sql statement: alter system reset  db_unique_name scope=spfile

    Oracle instance started

     

    Total System Global Area   10737418240 bytes

     

    Fixed Size                     2925344 bytes

    Variable Size              10468990176 bytes

    Database Buffers             234881024 bytes

    Redo Buffers                  30621696 bytes

    sql statement: CREATE CONTROLFILE REUSE SET DATABASE "PR2" RESETLOGS ARCHIVELOG

      MAXLOGFILES    255

      MAXLOGMEMBERS      3

      MAXDATAFILES     1000

      MAXINSTANCES    50

      MAXLOGHISTORY    18688

    LOGFILE

      GROUP  11 ( '+DATAC1/PR2/log_g11m1.dbf', '+RECOC1/PR2/log_g11m2.dbf' ) SIZE 200 M  REUSE,

      GROUP  12 ( '+DATAC1/PR2/log_g12m1.dbf', '+RECOC1/PR2/log_g12m2.dbf' ) SIZE 200 M  REUSE,

      GROUP  13 ( '+DATAC1/PR2/log_g13m1.dbf', '+RECOC1/PR2/log_g13m2.dbf' ) SIZE 200 M  REUSE,

      GROUP  14 ( '+DATAC1/PR2/log_g14m1.dbf', '+RECOC1/PR2/log_g14m2.dbf' ) SIZE 200 M  REUSE

    DATAFILE

      '+DATAC1/PR2/DATAFILE/system.323.918396541'

    CHARACTER SET UTF8

     

    sql statement: ALTER DATABASE ADD LOGFILE

     

     

     

      INSTANCE 'i2'

      GROUP  21 ( '+DATAC1/PR2/log_g21m1.dbf', '+RECOC1/PR2/log_g21m2.dbf' ) SIZE 200 M  REUSE,

      GROUP  22 ( '+DATAC1/PR2/log_g22m1.dbf', '+RECOC1/PR2/log_g22m2.dbf' ) SIZE 200 M  REUSE,

      GROUP  23 ( '+DATAC1/PR2/log_g23m1.dbf', '+RECOC1/PR2/log_g23m2.dbf' ) SIZE 200 M  REUSE,

      GROUP  24 ( '+DATAC1/PR2/log_g24m1.dbf', '+RECOC1/PR2/log_g24m2.dbf' ) SIZE 200 M  REUSE

     

    contents of Memory Script:

    {

       set newname for clone tempfile  1 to new;

       set newname for clone tempfile  2 to new;

       switch clone tempfile all;

       catalog clone datafilecopy  "+DATAC1/PR2/DATAFILE/sysaux.302.918397155",

    "+DATAC1/PR2/DATAFILE/psapundo001.347.918396023",

    "+DATAC1/PR2/DATAFILE/psapsr3.343.918396023",

    "+DATAC1/PR2/DATAFILE/psapsr3.342.918396023",

    "+DATAC1/PR2/DATAFILE/psapsr3.339.918396025",

    "+DATAC1/PR2/DATAFILE/psapsr3.340.918396025",

    "+DATAC1/PR2/DATAFILE/psapsr3.344.918396023",

    "+DATAC1/PR2/DATAFILE/psapsr3.338.918396025",

    "+DATAC1/PR2/DATAFILE/psapsr3.341.918396023",

    "+DATAC1/PR2/DATAFILE/psapsr3.337.918396025",

    "+DATAC1/PR2/DATAFILE/psapsr3.336.918396025",

    "+DATAC1/PR2/DATAFILE/psapsr3.335.918396025",

    "+DATAC1/PR2/DATAFILE/psapsr3.345.918396023",

    "+DATAC1/PR2/DATAFILE/psapsr3.334.918396025",

    "+DATAC1/PR2/DATAFILE/psapsr3.333.918396025",

    "+DATAC1/PR2/DATAFILE/psapsr3.332.918396391",

    "+DATAC1/PR2/DATAFILE/psapsr3.331.918396397",

    "+DATAC1/PR2/DATAFILE/psapsr3.330.918396443",

    "+DATAC1/PR2/DATAFILE/psapsr3.328.918396485",

    "+DATAC1/PR2/DATAFILE/psapsr3740.319.918396699",

    "+DATAC1/PR2/DATAFILE/psapsr3740.318.918396725",

    "+DATAC1/PR2/DATAFILE/psapsr3740.317.918396809",

    "+DATAC1/PR2/DATAFILE/psapsr3740.427.918396811",

    "+DATAC1/PR2/DATAFILE/psapsr3740.316.918396817",

    "+DATAC1/PR2/DATAFILE/psapsr3740.315.918396833",

    "+DATAC1/PR2/DATAFILE/psapsr3740.314.918396849",

    "+DATAC1/PR2/DATAFILE/psapsr3740.313.918396853",

    "+DATAC1/PR2/DATAFILE/psapsr3740.312.918396877",

    "+DATAC1/PR2/DATAFILE/psapsr3740.311.918396893",

    "+DATAC1/PR2/DATAFILE/psapsr3740.310.918396895",

    "+DATAC1/PR2/DATAFILE/psapsr3740.309.918396903",

    "+DATAC1/PR2/DATAFILE/psapsr3740.308.918396929",

    "+DATAC1/PR2/DATAFILE/psapsr3740.307.918397013",

    "+DATAC1/PR2/DATAFILE/psapsr3740.306.918397069",

    "+DATAC1/PR2/DATAFILE/psapsr3740.305.918397071",

    "+DATAC1/PR2/DATAFILE/psapsr3740.304.918397127",

    "+DATAC1/PR2/DATAFILE/psapsr3740.301.918397181",

    "+DATAC1/PR2/DATAFILE/psapsr3usr.358.918397197",

    "+DATAC1/PR2/DATAFILE/psapundo002.348.918396023",

    "+DATAC1/PR2/DATAFILE/psapsr3.329.918396459",

    "+DATAC1/PR2/DATAFILE/psapsr3.327.918396485",

    "+DATAC1/PR2/DATAFILE/psapsr3.324.918396527",

    "+DATAC1/PR2/DATAFILE/system.303.918397129",

    "+DATAC1/PR2/DATAFILE/psapsr3.326.918396501",

    "+DATAC1/PR2/DATAFILE/psapsr3.325.918396501",

    "+DATAC1/PR2/DATAFILE/psapsr3.322.918396543",

    "+DATAC1/PR2/DATAFILE/psapsr3.321.918396567",

    "+DATAC1/PR2/DATAFILE/psapsr3.320.918396593",

    "+DATAC1/PR2/DATAFILE/psapundo001.346.918396023";

       switch clone datafile all;

    }

    executing Memory Script

     

    executing command: SET NEWNAME

     

    executing command: SET NEWNAME

     

    renamed tempfile 1 to +DATAC1 in control file

    renamed tempfile 2 to +DATAC1 in control file

     

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/sysaux.302.918397155 RECID=1 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapundo001.347.918396023 RECID=2 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.343.918396023 RECID=3 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.342.918396023 RECID=4 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.339.918396025 RECID=5 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.340.918396025 RECID=6 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.344.918396023 RECID=7 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.338.918396025 RECID=8 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.341.918396023 RECID=9 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.337.918396025 RECID=10 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.336.918396025 RECID=11 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.335.918396025 RECID=12 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.345.918396023 RECID=13 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.334.918396025 RECID=14 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.333.918396025 RECID=15 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.332.918396391 RECID=16 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.331.918396397 RECID=17 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.330.918396443 RECID=18 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.328.918396485 RECID=19 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.319.918396699 RECID=20 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.318.918396725 RECID=21 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.317.918396809 RECID=22 STAMP=918397597

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.427.918396811 RECID=23 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.316.918396817 RECID=24 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.315.918396833 RECID=25 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.314.918396849 RECID=26 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.313.918396853 RECID=27 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.312.918396877 RECID=28 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.311.918396893 RECID=29 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.310.918396895 RECID=30 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.309.918396903 RECID=31 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.308.918396929 RECID=32 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.307.918397013 RECID=33 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.306.918397069 RECID=34 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.305.918397071 RECID=35 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.304.918397127 RECID=36 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3740.301.918397181 RECID=37 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3usr.358.918397197 RECID=38 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapundo002.348.918396023 RECID=39 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.329.918396459 RECID=40 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.327.918396485 RECID=41 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.324.918396527 RECID=42 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/system.303.918397129 RECID=43 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.326.918396501 RECID=44 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.325.918396501 RECID=45 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.322.918396543 RECID=46 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.321.918396567 RECID=47 STAMP=918397598

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapsr3.320.918396593 RECID=48 STAMP=918397599

    cataloged datafile copy

    datafile copy file name=+DATAC1/PR2/DATAFILE/psapundo001.346.918396023 RECID=49 STAMP=918397599

     

    datafile 2 switched to datafile copy

    input datafile copy RECID=1 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/sysaux.302.918397155

    datafile 3 switched to datafile copy

    input datafile copy RECID=2 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapundo001.347.918396023

    datafile 4 switched to datafile copy

    input datafile copy RECID=3 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.343.918396023

    datafile 5 switched to datafile copy

    input datafile copy RECID=4 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.342.918396023

    datafile 6 switched to datafile copy

    input datafile copy RECID=5 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.339.918396025

    datafile 7 switched to datafile copy

    input datafile copy RECID=6 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.340.918396025

    datafile 8 switched to datafile copy

    input datafile copy RECID=7 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.344.918396023

    datafile 9 switched to datafile copy

    input datafile copy RECID=8 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.338.918396025

    datafile 10 switched to datafile copy

    input datafile copy RECID=9 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.341.918396023

    datafile 11 switched to datafile copy

    input datafile copy RECID=10 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.337.918396025

    datafile 12 switched to datafile copy

    input datafile copy RECID=11 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.336.918396025

    datafile 13 switched to datafile copy

    input datafile copy RECID=12 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.335.918396025

    datafile 14 switched to datafile copy

    input datafile copy RECID=13 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.345.918396023

    datafile 15 switched to datafile copy

    input datafile copy RECID=14 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.334.918396025

    datafile 16 switched to datafile copy

    input datafile copy RECID=15 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.333.918396025

    datafile 17 switched to datafile copy

    input datafile copy RECID=16 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.332.918396391

    datafile 18 switched to datafile copy

    input datafile copy RECID=17 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.331.918396397

    datafile 19 switched to datafile copy

    input datafile copy RECID=18 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.330.918396443

    datafile 20 switched to datafile copy

    input datafile copy RECID=19 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3.328.918396485

    datafile 21 switched to datafile copy

    input datafile copy RECID=20 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3740.319.918396699

    datafile 22 switched to datafile copy

    input datafile copy RECID=21 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3740.318.918396725

    datafile 23 switched to datafile copy

    input datafile copy RECID=22 STAMP=918397597 file name=+DATAC1/PR2/DATAFILE/psapsr3740.317.918396809

    datafile 24 switched to datafile copy

    input datafile copy RECID=23 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.427.918396811

    datafile 25 switched to datafile copy

    input datafile copy RECID=24 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.316.918396817

    datafile 26 switched to datafile copy

    input datafile copy RECID=25 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.315.918396833

    datafile 27 switched to datafile copy

    input datafile copy RECID=26 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.314.918396849

    datafile 28 switched to datafile copy

    input datafile copy RECID=27 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.313.918396853

    datafile 29 switched to datafile copy

    input datafile copy RECID=28 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.312.918396877

    datafile 30 switched to datafile copy

    input datafile copy RECID=29 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.311.918396893

    datafile 31 switched to datafile copy

    input datafile copy RECID=30 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.310.918396895

    datafile 32 switched to datafile copy

    input datafile copy RECID=31 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.309.918396903

    datafile 33 switched to datafile copy

    input datafile copy RECID=32 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.308.918396929

    datafile 34 switched to datafile copy

    input datafile copy RECID=33 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.307.918397013

    datafile 35 switched to datafile copy

    input datafile copy RECID=34 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.306.918397069

    datafile 36 switched to datafile copy

    input datafile copy RECID=35 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.305.918397071

    datafile 37 switched to datafile copy

    input datafile copy RECID=36 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.304.918397127

    datafile 38 switched to datafile copy

    input datafile copy RECID=37 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3740.301.918397181

    datafile 39 switched to datafile copy

    input datafile copy RECID=38 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3usr.358.918397197

    datafile 40 switched to datafile copy

    input datafile copy RECID=39 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapundo002.348.918396023

    datafile 41 switched to datafile copy

    input datafile copy RECID=40 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3.329.918396459

    datafile 42 switched to datafile copy

    input datafile copy RECID=41 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3.327.918396485

    datafile 43 switched to datafile copy

    input datafile copy RECID=42 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3.324.918396527

    datafile 44 switched to datafile copy

    input datafile copy RECID=43 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/system.303.918397129

    datafile 45 switched to datafile copy

    input datafile copy RECID=44 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3.326.918396501

    datafile 46 switched to datafile copy

    input datafile copy RECID=45 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3.325.918396501

    datafile 47 switched to datafile copy

    input datafile copy RECID=46 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3.322.918396543

    datafile 48 switched to datafile copy

    input datafile copy RECID=47 STAMP=918397598 file name=+DATAC1/PR2/DATAFILE/psapsr3.321.918396567

    datafile 49 switched to datafile copy

    input datafile copy RECID=48 STAMP=918397599 file name=+DATAC1/PR2/DATAFILE/psapsr3.320.918396593

    datafile 50 switched to datafile copy

    input datafile copy RECID=49 STAMP=918397599 file name=+DATAC1/PR2/DATAFILE/psapundo001.346.918396023

     

    contents of Memory Script:

    {

       Alter clone database open resetlogs;

    }

    executing Memory Script

     

    database opened

    Cannot remove created server parameter file

    Finished Duplicate Db at 28-JUL-16

    released channel: t0

    released channel: t1

    released channel: t2

    released channel: t3

    released channel: t4

    released channel: t5

    released channel: t6

    released channel: t7

    released channel: t8

    released channel: t9

    released channel: t10

    released channel: t11

    released channel: t12

    released channel: t13

    released channel: t14

    released channel: t15

     

    Recovery Manager complete.