Oracle Database Migration to Exadata – Case Study

Objective:

This report will show the detailed steps that we followed to migrate a real client production database from its current production server to the Exadata machine.

Environment:

 SourceTarget
Server Nameprod-n-214exa-db-101
Database NamePRODPROD
Oracle version11.2.0.311.2.0.3
O.SLinux OEL 6.5Exadata OEL 6.8
Character setWE8ISO8859P1WE8ISO8859P1
Clustered:Single InstanceSingle Instance

Migration High Level Plan:

  • Migration Preparation.
  • Backup the production database.
  • Duplicate the production database to Exadata.
  • Post Migration steps
  • Validate the migration.
  • Application specific setup.

Migration Preparation: Source Database Preparation:

  • Review the current production database PROD’s alert.log file for any issues.
  • Collect detailed information about PROD (Tablespaces, Users, Tables, Segments, Database Links, etc.)
  • Compile invalid objects (if any).
  • Decide the media/location that will be used to hold the Production database backup.{Database will be duplicated from the latest production backup on the EMC storage}

Migration Preparation: Exadata Preparation

  • Ensure that Oracle 11.2.0.3 binaries were already installed and that it uses RDS protocol (Note that in our case 11.2.0.3 is an additional home that was installed after the standard ACS installation).

/u01/app/oracle/product/11.2.0.4/dbhome/bin/skgxpinfo -v

You should get ==> Oracle RDS/IP (generic)

If you get ==>  Oracle RDS/IP (generic) , then you have to relink the home as        follows:

          make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ipc_rds ioracle

  • It is recommended to use RDS on Exadata as it uses IB network which provides greater bandwidth

{There is a bug between 12c GI & 11.2.0.3 with RDS (Bug: 16844086)}

Pre-Migration Preparation:

The following steps should be followed during the Go-Live (not the test migration):

  • <CUSTOMER> should submit a request to the firewall team to open the any required ports (ports: 1521, 8081 & 1648) è This should be done early enough before the Go-Live date
  • Agree with all the stakeholders on the Go-Live Date/Time.
  • <CUSTOMER> to inform all concerned parties with the Go-Live Date/Time (Network, Backup, Security, Application teams).

Migration Approach:

We are going to use a physical migration approach (database duplicate), as the logical migration approach (export/Import) has some limitations with the Oracle XML database. PROD application is heavily using the Oracle XML database.

Backup the Production database

rman target /

shutdown immediate;

startup mount;

sql ‘alter system enable restricted session’;

alter database open;

sql ‘alter system checkpoint’;

sql ‘alter system switch logfile’;

sql ‘alter system archive log current’;

shutdown immediate;

startup mount;

{Leave the database in the mount mode (to prevent any new transactions while migrating the database}

RUN {

ALLOCATE CHANNEL CH1  TYPE ‘SBT_TAPE’ MAXOPENFILES=1;

ALLOCATE CHANNEL CH2  TYPE ‘SBT_TAPE’ MAXOPENFILES=1;

ALLOCATE CHANNEL CH3  TYPE ‘SBT_TAPE’ MAXOPENFILES=1;

ALLOCATE CHANNEL CH4  TYPE ‘SBT_TAPE’ MAXOPENFILES=1;

BACKUP INCREMENTAL  LEVEL 0

FILESPERSET 10

FORMAT ‘%d_%u_%s_%p

DATABASE

INCLUDE CURRENT CONTROLFILE;

BACKUP filesperset 10 archivelog all;

BACKUP CURRENT CONTROLFILE;

}

Duplicate the production database to Exadata

Preparation: Listener Configuration

Add the following static entry to the listener.ora file (so as we can to connect to the database from rman while being in the shutdown mode):

Login as “grid” user.

Set the environment for the grid user

. oraenv

+ASM1

As grid user edit the Listener.ora on the new Exadata server:

1

$ lsnrctl reload

$ lsnrctl stat

Preparation: tnsnames.ora Configuration

Add the following TNS entry for both the source database and new database (Edit the  tnsnames.ora on the new Exadata server)

As “oracle” user go to $ORACLE_HOME/network/admin on the target server and edit tnsnames.ora   as follows (PROD214.world is the source entry, PROD.worls is the Exadata entry):

2

Preparation: init.ora

Create a parameter file for the target database under $ORACLE_HOME/dbs with the name initPROD.ora and add the following lines ,save and exit:

*.audit_file_dest=’/u01/app/oracle/admin/PROD/adump’

*.audit_trail=’DB’

*.compatible=’11.2.0.3.0′

*.control_files=’+DATA_ED01/PROD/CONTROLFILE/ctl1.ctl’,’+RECO_ED01/PROD/CONTROLFILE/ctl2.ctl’

*.db_block_size=8192

*.db_create_file_dest=’+DATA_ED01′

*.db_domain=’WORLD’

*.db_name=’PROD’

*.db_recovery_file_dest=’+RECO_ED01′

*.db_recovery_file_dest_size=322122547200

*.diagnostic_dest=’/u01/app/oracle’

*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRODXDB)’

*.open_cursors=500

*.processes=500

*.remote_login_passwordfile=’EXCLUSIVE’

*.sga_target=10737418240

*.pga_aggregate_target=5368709120

*.undo_management=’AUTO’

*.undo_tablespace=’UNDOTBS1′

Preparation: dump directories

mkdir –p /u01/app/oracle/admin/PROD/adump

Preparation: password file

Under directory ($ORACLE_HOME\dbs) on target Exadata server , create password file via orapwd utility (or you may copy the source password file):

Login to the source server prod-n-214

cd $ORACLE_HOME/dbs

scp orapwPROD oracle@exa-db-101:/u01/app/oracle/product/11.2.0.3/dbhome_1/dbs

Preparation: Startup the new Database

Startup the new database in nomount state on target Exadata server (101):

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1

export ORACLE_SID=PROD

export PATH=$PATH:$ORACLE_HOME/bin

sqlplus / as sysdba

sql> startup nomount;

3

Database Duplication

Run RMAN connecting to both source database (PROD214) as a target and new database (PROD) as auxiliary

export NLS_DATE_FORMAT=”DD-MON-YYYY HH24:MI:SS”

rman target orabkup/xxxx@PROD214.world auxiliary orabkup/xxxx@PROD.world

4

On the source system (mounted database):

sqlplus / as sysdba

ALTER SESSION SET nls_date_format=’DD-MON-YYYY HH24:MI:SS’;

select * from (

select NEXT_CHANGE#,FIRST_TIME,NEXT_TIME from v$archived_log order by 1 desc )

where rownum <2;

On the Exadata server, run the duplicate command as follows and set until time clause in case you need to set duplicate to a specific point in time (Make sure no spaces in parms syntax):

run {

set until scn 423041993;

allocate auxiliary channel ch1 type ‘sbt_tapeparms ‘ENV=(NSR_SERVER=bkp-emc-100.corp,NSR_CLIENT=prod-n-214)’;

allocate auxiliary channel ch2 type ‘sbt_tapeparms ‘ENV=(NSR_SERVER=bkp-emc-100.corp,NSR_CLIENT=prod-n-214)’;

allocate auxiliary channel ch3 type ‘sbt_tapeparms ‘ENV=(NSR_SERVER=bkp-emc-100.corp,NSR_CLIENT=prod-n-214)’;

allocate auxiliary channel ch4 type ‘sbt_tapeparms ‘ENV=(NSR_SERVER=bkp-emc-100.corp,NSR_CLIENT=prod-n-214)’;

duplicate target database to PROD pfile ‘/u01/app/oracle/product/11.2.0.3/dbhome_1/dbs/initPROD.oranofilenamecheck; }

Make sure RMAN finished the Duplicate command with no errors

Once RMAN finished, the new database PROD should be up and running.

Post Migration Steps

Create spfile

Exit RMAN and create spfile for the duplicated database:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1
export ORACLE_SID=PROD
export PATH=$PATH:$ORACLE_HOME/bin

sqlplus / as sysdba
sql> create spfile='+DATA_ED01' from pfile;

This will create spfile at:
+DATA_ED01/PROD/PARAMETERFILE/spfile.527.938200795

now :
cd $ORACLE_HOME/dbs
mv initPROD.ora initPROD.ora.org
vi initPROD.ora
   spfile='+DATA_ED02/DTSDEV/PARAMETERFILE/spfile.527.938200795'

Register database with the cluster

On the terminal issue the following to add database to Oracle Restart

$ srvctl add database -d PROD -n PROD -o /u01/app/oracle/product/11.2.0.3/dbhome_1 -c SINGLE -a DATA_ED01,RECO_ED01 -p '+DATA_ED01/PROD/PARAMETERFILE/spfile.527.938200795' -i PROD -x exa-dbadm-101
$ srvctl stop database -d PROD
$ srvctl start database -d PROD
$ srvctl status database -d PROD
$ srvctl config database -d PROD

Full Database Backup

Ask the backup team to take a full cold backup for the newly migrated database before going live.

Distribute the new client TNS Entry

Below is the TNS entry that should be used by the clients:
PROD.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = exa-dbvip-101)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PROD.WORLD)
    )
  )

RMAN Backup Setup

Modify/Change any relevant RMAN settings:

RMAN> Show all;

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

SQL> alter system set control_file_record_keep_time=31 scope=both;

Migration Validation

  • Ensure that there is no errors reported out from the “Duplicate” operation.
  • Make sure new Database become registered with Listener (lsnrctl status).
  • Ensure that you can connect to the database and it is in the “Read Write” mode:
5
6
  • Ensure that all datafiles are online:

Select name, status from v$datafile;

  • Review the new database alert.log file for any errors:

  /u01/app/oracle/diag/rdbms/PROD/PROD/trace/alert_PROD.log

  • Check Invalid objects
  • Restart the database
  • Test database connection from server and from clients

Appendix A: Duplicate Command Output

[oracle@exa-dbadm-101 dbs]$ rman target sys/xxxx@PROD202.world auxiliary sys/xxxx@PROD.world

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Mar 9 18:53:05 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PROD (DBID=3964826197, not open)
connected to auxiliary database: PROD (not mounted)

RMAN> run {
set until scn 423041993;
allocate auxiliary channel ch1 type 'sbt_tape' parms 'ENV=(NSR_SERVER=bkp-emc-100.corp,NSR_CLIENT=exa-db-101)';
allocate auxiliary channel ch2 type 'sbt_tape' parms 'ENV=(NSR_SERVER=bkp-emc-100.corp,NSR_CLIENT=exa-db-101)';
allocate auxiliary channel ch3 type 'sbt_tape' parms 'ENV=(NSR_SERVER=bkp-emc-100.corp,NSR_CLIENT=exa-db-101)';
allocate auxiliary channel ch4 type 'sbt_tape' parms 'ENV=(NSR_SERVER=bkp-emc-100.corp,NSR_CLIENT=exa-db-101)';
duplicate target database to PROD pfile '/u01/app/oracle/product/11.2.0.3/dbhome_1/dbs/initPROD.ora' nofilenamecheck;
}

2> 3> 4> 5> 6> 7> 8>

executing command: SET until clause
using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: SID=685 device type=SBT_TAPE
channel ch1: NMDA Oracle v8.2.4
allocated channel: ch2
channel ch2: SID=703 device type=SBT_TAPE
channel ch2: NMDA Oracle v8.2.4
allocated channel: ch3
channel ch3: SID=721 device type=SBT_TAPE
channel ch3: NMDA Oracle v8.2.4
allocated channel: ch4
channel ch4: SID=739 device type=SBT_TAPE
channel ch4: NMDA Oracle v8.2.4

Starting Duplicate Db at 09-MAR-17
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   10689474560 bytes

Fixed Size                     2237776 bytes
Variable Size               1644169904 bytes
Database Buffers            9026142208 bytes
Redo Buffers                  16924672 bytes

allocated channel: ch1
channel ch1: SID=667 device type=SBT_TAPE
channel ch1: NMDA Oracle v8.2.4
allocated channel: ch2
channel ch2: SID=685 device type=SBT_TAPE
channel ch2: NMDA Oracle v8.2.4
allocated channel: ch3
channel ch3: SID=703 device type=SBT_TAPE
channel ch3: NMDA Oracle v8.2.4
allocated channel: ch4
channel ch4: SID=721 device type=SBT_TAPE
channel ch4: NMDA Oracle v8.2.4

contents of Memory Script:
{
   set until scn  423041993;
   sql clone "alter system set  db_name =
 ''PROD'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name =
 ''PROD'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone primary controlfile;
   alter clone database mount;
}
executing Memory Script
executing command: SET until clause
sql statement: alter system set  db_name =  ''PROD'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set  db_unique_name =  ''PROD'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down
Oracle instance started

Total System Global Area   10689474560 bytes

Fixed Size                     2237776 bytes
Variable Size               1644169904 bytes
Database Buffers            9026142208 bytes
Redo Buffers                  16924672 bytes

allocated channel: ch1
channel ch1: SID=667 device type=SBT_TAPE
channel ch1: NMDA Oracle v8.2.4
allocated channel: ch2
channel ch2: SID=685 device type=SBT_TAPE
channel ch2: NMDA Oracle v8.2.4
allocated channel: ch3
channel ch3: SID=703 device type=SBT_TAPE
channel ch3: NMDA Oracle v8.2.4
allocated channel: ch4
channel ch4: SID=721 device type=SBT_TAPE
channel ch4: NMDA Oracle v8.2.4

Starting restore at 09-MAR-17
channel ch1: starting datafile backup set restore
channel ch1: restoring control file
channel ch1: reading from backup piece PROD_05runeku_5_1
channel ch1: piece handle=PROD_05runeku_5_1 tag=TAG20170309T174708
channel ch1: restored backup piece 1
channel ch1: restore complete, elapsed time: 00:00:07
output file name=+DATA_ED02/PROD/controlfile/ctl1.ctl
output file name=+RECO_ED02/PROD/controlfile/ctl2.ctl
Finished restore at 09-MAR-17

database mounted

contents of Memory Script:
{
   set until scn  423041993;
   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;

   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
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 09-MAR-17
channel ch1: starting datafile backup set restore
channel ch1: specifying datafile(s) to restore from backup set
channel ch1: restoring datafile 00003 to +DATA_ED02
channel ch1: restoring datafile 00006 to +DATA_ED02
channel ch1: restoring datafile 00012 to +DATA_ED02
channel ch1: restoring datafile 00016 to +DATA_ED02
channel ch1: reading from backup piece PROD_02rune8s_2_1
channel ch2: starting datafile backup set restore
channel ch2: specifying datafile(s) to restore from backup set
channel ch2: restoring datafile 00001 to +DATA_ED02
channel ch2: restoring datafile 00009 to +DATA_ED02
channel ch2: restoring datafile 00011 to +DATA_ED02
channel ch2: restoring datafile 00014 to +DATA_ED02
channel ch2: reading from backup piece PROD_03rune8s_3_1
channel ch3: starting datafile backup set restore
channel ch3: specifying datafile(s) to restore from backup set
channel ch3: restoring datafile 00002 to +DATA_ED02
channel ch3: restoring datafile 00007 to +DATA_ED02
channel ch3: restoring datafile 00008 to +DATA_ED02
channel ch3: restoring datafile 00013 to +DATA_ED02
channel ch3: reading from backup piece PROD_01rune8s_1_1
channel ch4: starting datafile backup set restore
channel ch4: specifying datafile(s) to restore from backup set
channel ch4: restoring datafile 00004 to +DATA_ED02
channel ch4: restoring datafile 00005 to +DATA_ED02
channel ch4: restoring datafile 00010 to +DATA_ED02
channel ch4: restoring datafile 00015 to +DATA_ED02
channel ch4: reading from backup piece PROD_04rune8s_4_1
channel ch1: piece handle=PROD_02rune8s_2_1 tag=TAG20170309T174708
channel ch1: restored backup piece 1
channel ch1: restore complete, elapsed time: 00:08:05
channel ch3: piece handle=PROD_01rune8s_1_1 tag=TAG20170309T174708
channel ch3: restored backup piece 1
channel ch3: restore complete, elapsed time: 00:10:25
channel ch2: piece handle=PROD_03rune8s_3_1 tag=TAG20170309T174708
channel ch2: restored backup piece 1
channel ch2: restore complete, elapsed time: 00:11:15
channel ch4: piece handle=PROD_04rune8s_4_1 tag=TAG20170309T174708
channel ch4: restored backup piece 1
channel ch4: restore complete, elapsed time: 00:12:00
Finished restore at 09-MAR-17

contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=32 STAMP=938199954 file name=+DATA_ED02/PROD/datafile/system.534.938199899
datafile 2 switched to datafile copy
input datafile copy RECID=33 STAMP=938199954 file name=+DATA_ED02/PROD/datafile/undotbs1.535.938199843
datafile 3 switched to datafile copy
input datafile copy RECID=34 STAMP=938199954 file name=+DATA_ED02/PROD/datafile/sysaux.538.938199707
datafile 4 switched to datafile copy
input datafile copy RECID=35 STAMP=938199955 file name=+DATA_ED02/PROD/datafile/users.533.938199945
datafile 5 switched to datafile copy
input datafile copy RECID=36 STAMP=938199955 file name=+DATA_ED02/PROD/datafile/proddata.546.938199239
datafile 6 switched to datafile copy
input datafile copy RECID=37 STAMP=938199955 file name=+DATA_ED02/PROD/datafile/proddata.548.938199239
datafile 7 switched to datafile copy
input datafile copy RECID=38 STAMP=938199955 file name=+DATA_ED02/PROD/datafile/proddata.547.938199239
datafile 8 switched to datafile copy
input datafile copy RECID=39 STAMP=938199956 file name=+DATA_ED02/PROD/datafile/proddata.544.938199441
datafile 9 switched to datafile copy
input datafile copy RECID=40 STAMP=938199956 file name=+DATA_ED02/PROD/datafile/proddata.542.938199499
datafile 10 switched to datafile copy
input datafile copy RECID=41 STAMP=938199956 file name=+DATA_ED02/PROD/datafile/proddata.541.938199529
datafile 11 switched to datafile copy
input datafile copy RECID=42 STAMP=938199957 file name=+DATA_ED02/PROD/datafile/proddata.545.938199239
datafile 12 switched to datafile copy
input datafile copy RECID=43 STAMP=938199957 file name=+DATA_ED02/PROD/datafile/proddata.543.938199449
datafile 13 switched to datafile copy
input datafile copy RECID=44 STAMP=938199957 file name=+DATA_ED02/PROD/datafile/proddata.539.938199641
datafile 14 switched to datafile copy
input datafile copy RECID=45 STAMP=938199958 file name=+DATA_ED02/PROD/datafile/proddata.537.938199711
datafile 15 switched to datafile copy
input datafile copy RECID=46 STAMP=938199958 file name=+DATA_ED02/PROD/datafile/proddata.536.938199759
datafile 16 switched to datafile copy
input datafile copy RECID=47 STAMP=938199958 file name=+DATA_ED02/PROD/datafile/proddata.540.938199639

contents of Memory Script:
{
   set until scn  423041993;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script
executing command: SET until clause

Starting recover at 09-MAR-17
starting media recovery
archived log for thread 1 with sequence 131 is already on disk as file +RECO_ED02/PROD/archivelog/2017_03_09/thread_1_seq_131.23318.938197719
archived log for thread 1 with sequence 132 is already on disk as file +RECO_ED02/PROD/archivelog/2017_03_09/thread_1_seq_132.23319.938197719
archived log for thread 1 with sequence 133 is already on disk as file +RECO_ED02/PROD/archivelog/2017_03_09/thread_1_seq_133.23320.938197719
archived log file name=+RECO_ED02/PROD/archivelog/2017_03_09/thread_1_seq_131.23318.938197719 thread=1 sequence=131
archived log file name=+RECO_ED02/PROD/archivelog/2017_03_09/thread_1_seq_132.23319.938197719 thread=1 sequence=132
archived log file name=+RECO_ED02/PROD/archivelog/2017_03_09/thread_1_seq_133.23320.938197719 thread=1 sequence=133
media recovery complete, elapsed time: 00:00:01
Finished recover at 09-MAR-17

Oracle instance started
Total System Global Area   10689474560 bytes

Fixed Size                     2237776 bytes
Variable Size               1610615472 bytes
Database Buffers            9059696640 bytes
Redo Buffers                  16924672 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "PROD" RESETLOGS ARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY     4674
 LOGFILE
  GROUP   1  SIZE 50 M ,
  GROUP   2  SIZE 50 M ,
  GROUP   3  SIZE 50 M
 DATAFILE
  '+DATA_ED02/PROD/datafile/system.534.938199899'
 CHARACTER SET WE8ISO8859P1
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  "+DATA_ED02/PROD/datafile/undotbs1.535.938199843",
 "+DATA_ED02/PROD/datafile/sysaux.538.938199707",
 "+DATA_ED02/PROD/datafile/users.533.938199945",
 "+DATA_ED02/PROD/datafile/proddata.546.938199239",
 "+DATA_ED02/PROD/datafile/proddata.548.938199239",
 "+DATA_ED02/PROD/datafile/proddata.547.938199239",
 "+DATA_ED02/PROD/datafile/proddata.544.938199441",
 "+DATA_ED02/PROD/datafile/proddata.542.938199499",
 "+DATA_ED02/PROD/datafile/proddata.541.938199529",
 "+DATA_ED02/PROD/datafile/proddata.545.938199239",
 "+DATA_ED02/PROD/datafile/proddata.543.938199449",
 "+DATA_ED02/PROD/datafile/proddata.539.938199641",
 "+DATA_ED02/PROD/datafile/proddata.537.938199711",
 "+DATA_ED02/PROD/datafile/proddata.536.938199759",
 "+DATA_ED02/PROD/datafile/proddata.540.938199639";
   switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to +DATA_ED02 in control file
renamed tempfile 2 to +DATA_ED02 in control file

cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/undotbs1.535.938199843 RECID=1 STAMP=938199972
cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/sysaux.538.938199707 RECID=2 STAMP=938199972
cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/users.533.938199945 RECID=3 STAMP=938199972
cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/proddata.546.938199239 RECID=4 STAMP=938199972
cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/proddata.548.938199239 RECID=5 STAMP=938199972
cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/proddata.547.938199239 RECID=6 STAMP=938199972
cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/proddata.544.938199441 RECID=7 STAMP=938199972
cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/proddata.542.938199499 RECID=8 STAMP=938199972
cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/proddata.541.938199529 RECID=9 STAMP=938199972
cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/proddata.545.938199239 RECID=10 STAMP=938199972
cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/proddata.543.938199449 RECID=11 STAMP=938199972
cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/proddata.539.938199641 RECID=12 STAMP=938199972
cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/proddata.537.938199711 RECID=13 STAMP=938199972
cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/proddata.536.938199759 RECID=14 STAMP=938199972
cataloged datafile copy
datafile copy file name=+DATA_ED02/PROD/datafile/proddata.540.938199639 RECID=15 STAMP=938199972

datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/undotbs1.535.938199843
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/sysaux.538.938199707
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/users.533.938199945
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/proddata.546.938199239
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/proddata.548.938199239
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/proddata.547.938199239
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/proddata.544.938199441
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/proddata.542.938199499
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/proddata.541.938199529
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/proddata.545.938199239
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/proddata.543.938199449
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/proddata.539.938199641
datafile 14 switched to datafile copy
input datafile copy RECID=13 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/proddata.537.938199711
datafile 15 switched to datafile copy
input datafile copy RECID=14 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/proddata.536.938199759
datafile 16 switched to datafile copy
input datafile copy RECID=15 STAMP=938199972 file name=+DATA_ED02/PROD/datafile/proddata.540.938199639

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 09-MAR-17



Donate to support our blogging work

$1.00

Thanks
Ahmed

One thought on “Oracle Database Migration to Exadata – Case Study

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s