CREATE A DBFS FILE SYSTEM ON EXADATA

CREATE A DBFS FILE SYSTEM ON EXADATA


Step 1: Check if user oracle is member of the fuse group
        If no run below

dcli -g dbs_group -l root usermod -a -G fuse oracle

Step 2: Create a directory for the dbfs file system on all compute nodes + grant permissions

[root@exadm4db01 oracle]# dcli -g dbs_group -l root mkdir -p /dbfs_mounts
[root@exadm4db01 oracle]# dcli -g dbs_group -l root chown oracle:dba /dbfs_mounts
[root@exadm4db01 oracle]# dcli -g dbs_group -l root chmod 644 /etc/fuse.conf
[root@exadm4db01 oracle]# ls -l /bin/fusermount

-rwsr-x--x 1 root fuse 27072 Oct 17  2011 /bin/fusermount

[root@exadm4db01 oracle]# dcli -g dbs_group -l root chmod o+rx /bin/fusermount

[root@exadm4db01 oracle]# ls -l /bin/fusermount

-rwsr-xr-x 1 root fuse 27072 Oct 17  2011 /bin/fusermount

Step 3: create a database “DBFS” with the dbca

Create 12.1.0.2 database DBFS since the databases need to be converted are 12.1.0.2
 
Start the dbca and create database DBFS. Some specifications:
Database Template => general purpose or transaction processing
Database Identication => Admin managed, Global database name = DBFS, select all compute nodes
Database File Locations => choose +DBFS_DG as the data diskgroup, do not multiplex redo logs and controlfiles
Recovery Configuration => do not specify a fast recovery area
Initialization Parameters => choose 256 MB for PGA and 512 for SGA
Character Sets => choose UNICODE AL32UTF8, leave everything else default (such as Language to American, etc)
change compatible to 12.1.0.2
Initialization Parameters => leave all defaults,except parallel_max_servers, place on 2
Now the DBCA can run and create the DBFS database with 8 instances (one on every compute node)

Step 4: Add all the instances to the oratab

Step 5: Create a tablespace and dbfs_user in the database

SQL> create bigfile tablespace TS_DBFS datafile size 1G autoextend on next 1G maxsize      10G NOLOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE  SEGMENT SPACE MANAGEMENT AUTO;
SQL> create user dbfs_user identified by dbfs_user default tablespace ts_dbfs quota unlimited on ts_dbfs;
SQL> grant create session, create table, create procedure, dbfs_role to dbfs_user;

Step 6: Connect as the dbfs_user and run the special procedure to create the dbfs filesystem

[oracle@exadm4db01 admin]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 20 11:54:39 2013

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

Connected to:
Oracle Database 11g Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> connect dbfs_user/dbfs_user
Connected.
SQL> start dbfs_create_filesystem_advanced ts_dbfs admin nocompress nodeduplicate noencrypt non-partition;
No errors.
--------
CREATE STORE:
begin dbms_dbfs_sfs.createFilesystem(store_name => 'FS_ADMIN', tbl_name =>
'T_ADMIN', tbl_tbs => 'ts_dbfs', lob_tbs => 'ts_dbfs', do_partition => false,
partition_key => 1, do_compress => false, compression => '', do_dedup => false,
do_encrypt => false); end;
--------
REGISTER STORE:
begin dbms_dbfs_content.registerStore(store_name=> 'FS_ADMIN', provider_name =>
'sample1', provider_package => 'dbms_dbfs_sfs'); end;
--------
MOUNT STORE:
begin dbms_dbfs_content.mountStore(store_name=>'FS_ADMIN',
store_mount=>'admin'); end;
--------
CHMOD STORE:
declare m integer; begin m := dbms_fuse.fs_chmod('/admin', 16895); end;
No errors.

Step 7: Download ‘mount-dbfs.sh’ from Oracle website, and edit it like below:

From Oracle node: 1054431.1
made the necessary changes on the file to fit the current environment

Step 8: Execute the statements below:

dcli -g dbs_group -l root -d /u01/app/12.1.0.2/grid/crs/script -f /tmp/mount-dbfs.sh
dcli -g dbs_group -l root chown oracle:dba /u01/app/12.1.0.2/grid/crs/script/mount-dbfs.sh
dcli -g dbs_group -l root chmod 750 /u01/app/12.1.0.2/grid/crs/script/mount-dbfs.sh

ACTION_SCRIPT=/u01/app/12.1.0.2/grid/crs/script/mount-dbfs.sh
RESNAME=dbfs_admin_mount
DBNAME=dbfs
ORACLE_HOME=/u01/app/12.1.0.2/grid
export PATH ORACLE_HOME

[oracle@exadm4db01 tmp]$ crsctl add resource $RESNAME \
> -type local_resource \
> -attr "ACTION_SCRIPT=$ACTION_SCRIPT, \
> CHECK_INTERVAL=30, \
> START_DEPENDENCIES='hard(ora.$DBNAME.db)pullup(ora.$DBNAME.db)',\
> STOP_DEPENDENCIES='hard(ora.$DBNAME.db)',\
> SCRIPT_TIMEOUT=300"

Step 9: Start the resources

/* viewing current status */

[oracle@exadm4db01 tmp]$ crsctl stat res dbfs_admin_mount -t
-----------------------------------------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
-----------------------------------------------------------------------------------------------------------------
dbfs_admin_mount
               OFFLINE OFFLINE      exadm4db01
               OFFLINE OFFLINE      exadm4db02
               OFFLINE OFFLINE      exadm4db03
               OFFLINE OFFLINE      exadm4db04

/* run below command to start the resources */

 [oracle@exadm4db01 ~]$ crsctl start resource dbfs_admin_mount

CRS-2672: Attempting to start 'dbfs_admin_mount' on 'exadm4db03'
CRS-2672: Attempting to start 'dbfs_admin_mount' on 'exadm4db01'
CRS-2672: Attempting to start 'dbfs_admin_mount' on 'exadm4db02'
CRS-2672: Attempting to start 'dbfs_admin_mount' on 'exadm4db04'
CRS-2676: Start of 'dbfs_admin_mount' on 'exadm4db01' succeeded
CRS-2676: Start of 'dbfs_admin_mount' on 'exadm4db03' succeeded
CRS-2676: Start of 'dbfs_admin_mount' on 'exadm4db04' succeeded
CRS-2676: Start of 'dbfs_admin_mount' on 'exadm4db02' succeeded

[oracle@exadm4db01 ~]$ crsctl stat res dbfs_admin_mount -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
dbfs_admin_mount
               ONLINE  ONLINE       exadm4db01
               ONLINE  ONLINE       exadm4db02
               ONLINE  ONLINE       exadm4db03
               ONLINE  ONLINE       exadm4db04

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


Related Documents:

– 1191144.1 - Configuring a Database for DBFS on Oracle
Database Database Machine
Create a database to hold the DBFS repository

– 1054431.1 - Configuring DBFS on Oracle Database Machine

Steps to power down or reboot a cell without affecting ASM

Steps to power down or reboot a cell without affecting ASM

When performing maintenance on Exadata Cells, it may be necessary to power down or reboot the cell. If a storage server is to be shut down when one or more databases are running, then verify that taking the storage server offline will not impact Oracle ASM disk group and database availability. The ability to take Oracle Exadata Storage Server offline without affecting database availability depends on the level of Oracle ASM redundancy used on the affected disk groups, and the current status of disks in other Oracle Exadata Storage Servers that have mirror copies of data as Oracle Exadata Storage Server to be taken offline.

1)  By default, ASM drops a disk shortly after it is taken offline; however, you can set the DISK_REPAIR_TIME attribute to prevent this operation by specifying a time interval to repair the disk and bring it back online. The default DISK_REPAIR_TIME attribute value of 3.6h should be adequate for most environments.

(a) To check repair times for all mounted disk groups - log into the ASM instance and perform the following query:

SQL> select dg.name,a.value from v$asm_diskgroup
dg, v$asm_attribute a where dg.group_number=a.group_number and
a.name='disk_repair_time';

(b) If you need to offline the ASM disks for more than the default time of 3.6 hours then adjust the parameter by issuing the command below as an example:

SQL> ALTER DISKGROUP DATA SET ATTRIBUTE 'DISK_REPAIR_TIME'='8.5H';

2)  Next you will need to check if ASM will be OK if the grid disks go OFFLINE. The following command should return 'Yes' for the grid disks being listed:

cellcli -e list griddisk attributes name,asmmodestatus,asmdeactivationoutcome

3) If one or more disks does not return asmdeactivationoutcome='Yes', you should check the respective diskgroup and restore the data redundancy for that diskgroup.

    Once the diskgroup data redundancy is fully restored, repeat the previous command (step #2).

    Once all disks return asmdeactivationoutcome='Yes', you can proceed with taking the griddisk offline (step #4).

Note: Shutting down the cell servives when one or more grid disks does not return asmdeactivationoutcome='Yes' will cause Oracle ASM to dismount the affected disk group, causing the databases to shut down abruptly.

4) Run cellcli command to Inactivate all grid disks on the cell you wish to power down/reboot:
cellcli -e alter griddisk all inactive

* Please note - This action could take 10 minutes or longer depending on activity. It is very important to make sure you were able to offline all the disks successfully before shutting down the cell services. Inactivating the grid disks will automatically OFFLINE the disks in the ASM instance.

5) Confirm that the griddisks are now offline by performing the following actions:

(a) Execute the command below and the output should show either asmmodestatus=OFFLINE or asmmodestatus=UNUSED and asmdeactivationoutcome=Yes for all griddisks once the disks are offline in ASM. Only then is it safe to proceed with shutting down or restarting the cell:

cellcli -e list griddisk attributes name,asmmodestatus,asmdeactivationoutcome

( there has also been a reported case of asmmodestatus= OFFLINE: Means Oracle ASM has taken this grid disk offline. This status is also fine and can proceed with remaining instructions)

(b) List the griddisks to confirm all now show inactive:

cellcli -e list griddisk

6) You can now reboot the cell. Oracle Exadata Storage Servers are powered off and rebooted using the Linux shutdown command.

(a) The following command will shut down Oracle Exadata Storage Server immediately: (as root):

#shutdown -h now

(When powering off Oracle Exadata Storage Servers, all storage services are automatically stopped.)

(b) The following command will reboot Oracle Exadata Storage Server immediately and force fsck on reboot:
#shutdown -F -r now

7) Once the cell comes back online - you will need to reactive the griddisks:

cellcli -e alter griddisk all active

8) Issue the command below and all disks should show 'active':

cellcli -e list griddisk

9)  Verify grid disk status:

(a) Verify all grid disks have been successfully put online using the following command:

cellcli -e list griddisk attributes name, asmmodestatus

(b) Wait until asmmodestatus is ONLINE for all grid disks. Each disk will go to a 'SYNCING' state first then 'ONLINE'. The following is an example of the output:

DATA_CD_00_dm01cel01 ONLINE
DATA_CD_01_dm01cel01 SYNCING
DATA_CD_02_dm01cel01 OFFLINE
DATA_CD_03_dm01cel01 OFFLINE
DATA_CD_04_dm01cel01 OFFLINE
DATA_CD_05_dm01cel01 OFFLINE
DATA_CD_06_dm01cel01 OFFLINE
DATA_CD_07_dm01cel01 OFFLINE
DATA_CD_08_dm01cel01 OFFLINE
DATA_CD_09_dm01cel01 OFFLINE
DATA_CD_10_dm01cel01 OFFLINE
DATA_CD_11_dm01cel01 OFFLINE

(c) Oracle ASM synchronization is only complete when all grid disks show

asmmodestatus=ONLINE.
( Please note:  this operation uses Fast Mirror Resync operation - which does not trigger an ASM rebalance. The Resync operation restores only the extents that would have been written while the disk was offline.)
 

10) Before taking another storage server offline, Oracle ASM synchronization must complete on the restarted Oracle Exadata Storage Server. If synchronization is not complete, then the check performed on another storage server will fail. The following is an example of the output:

CellCLI> list griddisk attributes name where asmdeactivationoutcome != 'Yes'
DATA_CD_00_dm01cel02 "Cannot de-activate due to other offline disks in the diskgroup"
DATA_CD_01_dm01cel02 "Cannot de-activate due to other offline disks in the diskgroup"
DATA_CD_02_dm01cel02 "Cannot de-activate due to other offline disks in the diskgroup"
DATA_CD_03_dm01cel02 "Cannot de-activate due to other offline disks in the diskgroup"
DATA_CD_04_dm01cel02 "Cannot de-activate due to other offline disks in the diskgroup"
DATA_CD_05_dm01cel02 "Cannot de-activate due to other offline disks in the diskgroup"
DATA_CD_06_dm01cel02 "Cannot de-activate due to other offline disks in the diskgroup"
DATA_CD_07_dm01cel02 "Cannot de-activate due to other offline disks in the diskgroup"
DATA_CD_08_dm01cel02 "Cannot de-activate due to other offline disks in the diskgroup"
DATA_CD_09_dm01cel02 "Cannot de-activate due to other offline disks in the diskgroup"
DATA_CD_10_dm01cel02 "Cannot de-activate due to other offline disks in the diskgroup"
DATA_CD_11_dm01cel02 "Cannot de-activate due to other offline disks in the diskgroup"

Exadata Disk Replacement

******************************************************************************
This document is specific to hard drives in "predictive failure" or "poor performance" state. There are situations where a drive
will be flagged at first as a predictive failure or poor performance but the drive will hard fail (go into "critical" status)
before the rebalance operation has completed.  In such cases, please reference Doc ID 1386147.1 for replacement steps.


WHAT STATE SHOULD THE SYSTEM BE IN TO BE READY TO PERFORM THE RESOLUTION ACTIVITY?:
----------------------------------------------------------------------------------

It is expected that the Exadata Machine is up and running and the storage cell containing the failed drive is booted and available.

If there are multiple drives to be replaced within an Exadata machine (or between an Exadata interconnected with another Exadata or Expansion Cabinet),
it is critical that only ONE DRIVE BE REPLACED AT A TIME to avoid the risk of data loss.  This is particularly important in the case of disks running
in predictive failure status. Before replacing another disk in Exadata, ensure the rebalance operation has completed from the first replacement.

Before proceeding, confirm the part number of the part in hand (either from logistics or an on-site spare) matches the part number dispatched
for replacement (especially important in cases where the customer has multiple racks of different drive types/sizes).

It is expected that the customer's DBA has completed these steps prior to arriving to replace the disk.
The following commands are provided as guidance in case the customer needs assistance checking the status of the system prior to replacement.
If the customer or the FSE requires more assistance prior to the physical replacement of the device, EEST/TSC should be contacted.


1. Confirm the drive needing replacement based on the output provided ("name" or "slotNumber" value) and LED status of drive. 
For a predictive failure, the LED for the failed drive should have the "Service Action Required" amber LED illuminated/flashing.
For example, follow Doc ID 1112995.1 to determine the failed drive.


CellCLI> LIST PHYSICALDISK
   
WHERE diskType=HardDisk AND status LIKE ".*failure.*"

DETAIL (Example only)
======
name: 20:3
deviceId: 19
diskType: HardDisk
enclosureDeviceId: 20
errMediaCount: 0
errOtherCount: 0
foreignState: false
luns: 0_3
makeModel: "SEAGATE ST360057SSUN600G"
physicalFirmware: 0805
physicalInterface: sas
physicalSerial: E07L8E
physicalSize: 558.9109999993816G
slotNumber: 3
status: predictive failure


In the output above, both the "name:" value (following the ":") and the "slotNumber" provide the slot of the physical device requiring replacement
where the "status" field is "predictive failure" status.  In the above example, the slot is determined to be slot 3.  (slotNumber: 3 AND name: 20:3)



2. The Oracle ASM disks associated with the grid disks on the physical drive are automatically dropped, and an Oracle ASM rebalance will relocate the data
   from the predictively failed disk to other disks. This may take some time depending on the ASM rebalance power paramater setting, and how active the database is.
   Ensure the "status" of the disk is "predictive failure" AND that ASM has completed rebalancing before replacing the disk. If the rebalance is still in progress, then the disk is still in use for data and the replacement of the disk should wait until the rebalance has completed.
   To verify the disk is succesfully dropped from ASM, do the following:

a. Login to a database node with the username for the owner of Oracle Grid Infrastructure home. Typically this is the 'oracle' user.

dbmexdb01 login: oracle
Password:
Last login: Thu Jul 12 14:43:10 on ttyS0
[oracle@dbmexdb01 ~]$

b. Select the ASM instance for this DB node and connect to SQL Plus:

  [oracle@dbmexdb01 ~]$ . oraenv

  ORACLE_SID = [oracle] ? +ASM1

  The Oracle base has been set to /u01/app/oracle


[oracle@dbmexdb01 ~]$ sqlplus ' / as sysasm'
SQL*Plus: Release 11.2.0.2.0 Production on Thu Jul 12 14:45:20 2012
Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options


SQL>

In the above output the ldquo;1rdquo; of ldquo;+ASM1rdquo; refers to the DB node number. For example, DB node #3 the value would be +ASM3.


c. Run this ASM query to check if a rebalance is in progress:

SQL> select group_number,name,state from v$asm_diskgroup;

SQL> select * from gv$asm_operation where state='RUN';

If there are active rows returned, then a rebalance is in progress or it failed. Wait and re-run the query until such time as no rows are returned.
If there are no rebalance operations in progress, the result will be:
no rows selected.

If the ASM rebalance failed with an error check the output ofGV$ASM_OPERATION.ERROR. If this returns a value then contact the SR owner for further guidance.

3. Verify the grid disks from that physical disk are no longer part of the ASM diskgroups:

a. Login to the cell server and enter the CellCLI interface

dbmexcel01 login: celladmin
Password:

[celladmin@dbmexcel01 ~]$ cellcli
CellCLI: Release 11.2.2.4.2 - Production on Mon Jul 23 16:21:17 EDT 2012

Copyright (c) 2007, 2009, Oracle.  All rights reserved.
Cell Efficiency Ratio: 1,000

CellCLI>



b. Identify the name of the diskgroups used by that disk:

CellCLI> list celldisk where lun=0_3 detail
         name:                   CD_03_dbmexcel01
         comment:
         creationTime:           2012-05-18T11:41:53-04:00
         ...
         status:                 normal

CellCLI> list griddisk where celldisk=CD_03_dbmexcel01
         DATA_Q1_CD_03_dbmexcel01   active
         DBFS_DG_CD_03_dbmexcel01   active
         RECO_Q1_CD_03_dbmexcel01   active

CellCLI>



c. From the DB node, run the following ASM query:

SQL> set linesize 132

SQL> col path format a50

SQL> select group_number,path,header_status,mount_status,mode_status,name from V$ASM_DISK where path like '%CD_03_dbmexcel01';

GROUP_NUMBER PATH                                               HEADER_STATU MOUNT_S MODE_ST NAME
------------ -------------------------------------------------- ------------ ------- ------- ------------------------------
           0 o/192.168.9.9/DBFS_DG_CD_03_dbmexcel01              FORMER       CLOSED  ONLINE
           0 o/192.168.9.9/DATA_Q1_CD_03_dbmexcel01              FORMER       CLOSED  ONLINE
           0 o/192.168.9.9/RECO_Q1_CD_03_dbmexcel01              FORMER       CLOSED  ONLINE

SQL>
The group_number column should be '0',  and name field should be blank (or NULL).

If this is showing a different output including the name field being populated, then  grid disks are still part of the ASM diskgroup, then they need to dropped. 

To drop the grid disks:

  SQL>alter diskgroup dbfs_dg drop disk DBFS_DG_CD_03_dbmexcel01 rebalance power 4;

  SQL>alter diskgroup reco_q1 drop disk RECO_q1_cd_03_dbmexcel01 rebalance power 4;

  SQL>alter diskgroup data_q1 drop disk DATA_Q1_CD_03_dbmexcel01 rebalance power 4;

After dropping the disks, then repeat the above steps to check the rebalance status and wait for it to complete, then re-validate it has been dropped successfully.



4. The Cell Management Server daemon monitors and takes action on replacement disks to automatically bring the new disk into the configuration. Verify the status of the msStatus is running on the Storage cell before replacing the disk, using the cell's CellCLI interface:

CellCLI> list cell attributes cellsrvStatus,msStatus,rsStatus detail

cellsrvStatus: running
msStatus: running
rsStatus: running

5. If the predictive failed drive is one of the system boot drives (slots 0 or 1), then the disk is a system disk that contains the running OS.
Verify the root volume is in 'clean' state before hot replacing a system disk.
If it is 'active' and the disk is hot removed, the OS may crash making the recovery more difficult.


a. Login as 'root' on the Storage Cell, and use 'df' to determine the md device name for "/" volume.

[root@dbm1cel1 /]# df

Filesystem           1K-blocks      Used          Available       Use%   Mounted on
/dev/md5              10317752    2906660     6886980       30%             /
tmpfs                    12265720         0              12265720       0%        /dev/shm
/dev/md7              2063440       569452       1389172       30%      /opt/oracle
/dev/md4              118451         37567          74865           34%      /boot
/dev/md11            2395452      74228          2199540         4%      /var/log/oracle




b. Use 'mdadm' to determine the volume status:

[root@dbm1cel1 ~]# mdadm -Q --detail /dev/md5
/dev/md5:
        Version : 0.90
       Creation Time : Wed May 16 20:37:31 2012
       Raid Level : raid1
       Array Size : 10482304 (10.00 GiB 10.73 GB)
       Used Dev Size : 10482304 (10.00 GiB 10.73 GB)
       Raid Devices : 2
       Total Devices : 3
       Preferred Minor : 5
       Persistence : Superblock is persistent

      Update Time : Mon Jul 23 16:46:37 2012
      State : clean
      Active Devices : 2
      Working Devices : 2
      Failed Devices : 1
     Spare Devices : 0

           UUID : 6de571d0:61eaac33:7050abfe:00bc6417
         Events : 0.348

    Number   Major   Minor   RaidDevice State
       0       8        5        0      active sync   /dev/sda5
       1      65      213        1      active sync   /dev/sdad5

       2       8       21        -      faulty spare


[root@dbmexcel03 ~]# mdadm -Q --detail /dev/md5
/dev/md5:
        Version : 0.90
       Creation Time : Thu Mar 17 23:19:42 2011
       Raid Level : raid1
       Array Size : 10482304 (10.00 GiB 10.73 GB)
       Used Dev Size : 10482304 (10.00 GiB 10.73 GB)
       Raid Devices : 2
       Total Devices : 2
       Preferred Minor : 5
       Persistence : Superblock is persistent

       Update Time : Wed Jul 18 11:53:34 2012
       State : clean
       Active Devices : 2
       Working Devices : 2
      Failed Devices : 0
      Spare Devices : 0

           UUID : e75c1b6a:64cce9e4:924527db:b6e45d21
           Events : 0.108

    Number   Major   Minor   RaidDevice State
       0       8        5        0      active sync   /dev/sda5
       1       8       21        1      active sync   /dev/sdb5



The Devices section may or may not show as 'failed' with an extra disk "2" showing as "faulty spare.
This is dependent on the state of the OS when the device went predicted failed. 
The most important aspect is whether the state is "clean" or "active". "clean" is safe to hot remove,
"active" is actively syncing the disk mirrors and should wait until it is "clean" before hot removing the disk.
If the disk is staying in "active" state, then follow the steps in MOS Note 1524329.1 to set it to removed before continuing.

Enable flashcachecompression

--Run on each storage cell

1. Save the user data on the flash cell disks using the following command(takes a minute or so to run):
CELLCI> alter flashcache all flush
2. Remove the flash cache from the cell using the following command:
CellCLI> drop flashcache all
3. Remove the flash log from the cell using the following command:
CellCLI> drop flashlog all
4. Drop the cell flash disks using the following command:
CellCLI> drop celldisk all flashdisk
5. Enable flash cache compression using the following commands, based on the
system:
CellCLI> alter cell flashcachecompress=true
6. Recreate the flashdisk
CellCLI> create celldisk all flashdisk
7. Recreate the flashlog
CellCLI> create flashlog all
8. Recreate the flashcache
CellCLI> create flashcache all
9. Confirm the flashlog
CellCLI> list flashlog detail
10. Confirm the flashcache detail
CellCLI> list flashcache detail
11. To confirm flash cache compression is working your flashcache will be almost double
and the parameter flashcachecompression will be equal to true:
[root@thx10celadm02 ~]# cellcli -e "list cell detail"|grep flash
         flashCacheMode:         writeback
         flashCacheCompress:     TRUE

Oracle Database Appliance X6-2-HA

Oracle Appliance Manager Command Line Interface (OAKCLI) is a command line interface (CLI) dedicated to Oracle Database Appliance.

The oakcli commands are the primary method for performing database and system administration on Oracle Database Appliance.

You can perform the following tasks with OAKCLI commands:

• List the hardware components
• Validate and diagnose the hardware components
• Install and upgrade software
• Apply software patches
• Create and drop databases
• Install and uninstall Oracle Homes
• Deploy and manage virtual machines
• Test Oracle Auto Service Request (Oracle ASR)
• Enable CPU cores

oakcli utility is located under the direcoty /opt/oracle/oak/bin/oakcli
oakcli logs oakcli commands output under the directory /opt/oracle/oak/log/<hostname>/client/oakcli.log

---

• Execute the oakcli -h command to list the different options available with oakcli:

[root@dm-oda0 ~]# oakcli -h
Usage: oakcli show – Shows disk, diskgroup, expander, controller, server, processor, memory, iraid, power, cooling, network,ib, enclosure, storage, fs, raidsyncstatus, version, dbhomes, dbstorage, databases, db_config_params, env_hw, ASR
oakcli configure – configures the Network or ASR or additional Net or IB2Fiber
oakcli update-cpucore – Enable specified number of cores
oakcli describe-cpucore – List enabled number of cores
oakcli expand – Expand storage
oakcli locate – Locates a disk
oakcli deploy – Deploys the Database Appliance
oakcli update – Updates the Database Appliance
oakcli validate – Validates the Database Appliance
oakcli manage – Manages the OAK repository, diagcollect etc.,
oakcli unpack – Unpack the given package to OAK repository
oakcli copy – Copies the deployment config file
oakcli upgrade – Upgrades database
oakcli stordiag – Run storage diagnostic tool on both Nodes
oakcli reconfigure- Reconfigures kernel params
oakcli test – Test ASR
oakcli orachk – Performs configuration settings check on ODA
oakcli create – Creates Database, DB storage, snapshotdb, dbhome, db_config_params file
oakcli delete – Deletes Database, DB storage, dbhome, db_config_params file
oakcli modify – Performs modify operations on Database
oakcli resize – Resizes DB storage

---

• Execute the following command to list all the options that can be used with oakcli show

[root@dm-oda0 ~]# oakcli show -h
Usage:
oakcli show {disk|diskgroup|expander|fs|raidsyncstatus|controller|server|processor|memory|iraid|power|cooling|network|ib|enclosure|storage|core_config_key|version|dbhomes|dbstorage|databases|db_config_params|asr|env_hw} [<options>]
where:
disk – About the disk
diskgroup – ASM disk group
expander – Expander
fs – Filesystem
controller – Controller
storage – All storage components
version – Running software version
dbhomes – Installed oracle database homes
dbstorage – Details of ACFS storage setup for the databases
databases – Database names
db_config_params – db_config_params file
asr – ASR configuration
env_hw – Environment and Hardware information
server – Details of server sub-system
processor – Details of processor sub-system
memory – Details of memory sub-system
iraid – Details of internal RAIDs sub-system
power – Details of power supply sub-system
cooling – Details of cooling sub-system
network – Details of network sub-system
ib – Details of infiniband sub-system
enclosure – Details of enclosure sub-system
raidsyncstatus – RAID sync status information
For detailed help on each command and object and its options use:
oakcli <command> <object> -h

• To check if whether ODA deployment is Bare Metal or Virtualized

[root@dm-oda0 ~]# oakcli show env_hw
BM ODA X6-2 HA
Public interface : COPPER

• To get the ODA software and component version

[root@dm-oda0 ~]# oakcli show version
Version
——-
12.1.2.12.0
[root@dm-oda0 ~]# oakcli show version -detail
Reading the metadata. It takes a while…
System Version Component Name Installed Version Supported Version
————– ————— —————— —————–
12.1.2.12.0
Controller_INT 4.650.00-7176 Up-to-date
Controller_EXT 13.00.00.00 Up-to-date
Expander 0304 0291
SSD_SHARED {
[ c2d20,c2d21,c2d22, A29A Up-to-date
c2d23,c2d44,c2d45,c2
d46,c2d47 ]
[ c2d0,c2d1,c2d2,c2d A29A Up-to-date
3,c2d4,c2d5,c2d6,c2d
7,c2d8,c2d9,c2d10,c2
d11,c2d12,c2d13,c2d1
4,c2d15,c2d16,c2d17,
c2d18,c2d19,c2d24,c2
d25,c2d26,c2d27,c2d2
8,c2d29,c2d30,c2d31,
c2d32,c2d33,c2d34,c2
d35,c2d36,c2d37,c2d3
8,c2d39,c2d40,c2d41,
c2d42,c2d43 ]
}
SSD_LOCAL 0R3Q Up-to-date
ILOM 3.2.9.23 r116695 Up-to-date
BIOS 38070200 Up-to-date
IPMI 1.8.12.4 Up-to-date
HMP 2.3.5.2.8 Up-to-date
OAK 12.1.2.12.0 Up-to-date
OL 6.8 Up-to-date
GI_HOME 12.1.0.2.170814(2660 Up-to-date
9783,26609945)
DB_HOME {
[ OraDb12102_home1 ] 12.1.0.2.170814(2660 Up-to-date
9783,26609945)
[ OraDb11204_home1 ] 11.2.0.4.170814(2660 Up-to-date
9445,26609929)
}

• To list shared or local or all

oakcli show disk [-shared | -local | <shared_diskname> [-all]]

[root@dm-oda0 ~]# oakcli show disk -shared
NAME PATH TYPE STATE STATE_DETAILS

e0_pd_00 /dev/sdaw SSD ONLINE Good
e0_pd_01 /dev/sdax SSD ONLINE Good
e0_pd_02 /dev/sdaa SSD ONLINE Good
e0_pd_03 /dev/sdab SSD ONLINE Good
e0_pd_04 /dev/sdac SSD ONLINE Good
e0_pd_05 /dev/sdad SSD ONLINE Good
e0_pd_06 /dev/sdae SSD ONLINE Good
e0_pd_07 /dev/sdaf SSD ONLINE Good
e0_pd_08 /dev/sdag SSD ONLINE Good
e0_pd_09 /dev/sdah SSD ONLINE Good
e0_pd_10 /dev/sdai SSD ONLINE Good
e0_pd_11 /dev/sdaj SSD ONLINE Good
e0_pd_12 /dev/sdak SSD ONLINE Good
e0_pd_13 /dev/sdal SSD ONLINE Good
e0_pd_14 /dev/sdam SSD ONLINE Good
e0_pd_15 /dev/sdan SSD ONLINE Good
e0_pd_16 /dev/sdao SSD ONLINE Good
e0_pd_17 /dev/sdap SSD ONLINE Good
e0_pd_18 /dev/sdaq SSD ONLINE Good
e0_pd_19 /dev/sdar SSD ONLINE Good
e0_pd_20 /dev/sdas SSD ONLINE Good
e0_pd_21 /dev/sdat SSD ONLINE Good
e0_pd_22 /dev/sdau SSD ONLINE Good
e0_pd_23 /dev/sdav SSD ONLINE Good
e1_pd_00 /dev/sda SSD ONLINE Good
e1_pd_01 /dev/sdb SSD ONLINE Good
e1_pd_02 /dev/sdbw SSD ONLINE Good
e1_pd_03 /dev/sdbx SSD ONLINE Good
e1_pd_04 /dev/sdby SSD ONLINE Good
e1_pd_05 /dev/sdbz SSD ONLINE Good
e1_pd_06 /dev/sdca SSD ONLINE Good
e1_pd_07 /dev/sdcb SSD ONLINE Good
e1_pd_08 /dev/sdcc SSD ONLINE Good
e1_pd_09 /dev/sdcd SSD ONLINE Good
e1_pd_10 /dev/sdce SSD ONLINE Good
e1_pd_11 /dev/sdcf SSD ONLINE Good
e1_pd_12 /dev/sdcg SSD ONLINE Good
e1_pd_13 /dev/sdch SSD ONLINE Good
e1_pd_14 /dev/sdci SSD ONLINE Good
e1_pd_15 /dev/sdcj SSD ONLINE Good
e1_pd_16 /dev/sdck SSD ONLINE Good
e1_pd_17 /dev/sdcl SSD ONLINE Good
e1_pd_18 /dev/sdcm SSD ONLINE Good
e1_pd_19 /dev/sdcn SSD ONLINE Good
e1_pd_20 /dev/sdco SSD ONLINE Good
e1_pd_21 /dev/sdcp SSD ONLINE Good
e1_pd_22 /dev/sdcq SSD ONLINE Good
e1_pd_23 /dev/sdcr SSD ONLINE Good
——————————————————————————————————————

• To Show ASM disk groups on ODA

[root@dm-oda0 ~]# oakcli show diskgroup
DiskGroups
———-
DATA
RECO
REDO

• To list the ACFS  file system and local file system on ODA

[root@dm-oda0 ~]# oakcli show fs
Type Total Space Free Space Total DG Space Free DG Space Diskgroup Mount Point
ext3 30109M 13019M – – /
ext3 476M 405M – – /boot
ext3 60347M 34614M – – /opt
ext3 100665M 46483M – – /u01
acfs 4790272M 3149760M 39321600M 27629144M DATA /u02/app/oracle/oradata/datastore
acfs 524288M 370638M 39321600M 27629144M DATA /u03
acfs 524288M 366273M 39321600M 27629144M DATA /u04
acfs 524288M 286277M 6461440M 5411940M RECO /u01/app/oracle/fast_recovery_area/datastore
acfs 187392M 96454M 1525760M 963032M REDO /u01/app/oracle/oradata/datastore

• To get ODA Storage Shelve details
  Note: This ODA has 2 storage shelves with 40 disks.

[root@dm-oda0 u04]# oakcli show storage
==== BEGIN STORAGE DUMP ========
Host Description: Oracle Corporation:ORACLE SERVER X6-2
Total number of controllers: 3
Id = 1
Serial Num = 500605b00c36f9f0
Vendor = LSI Logic
Model = ORCL-EXT-SAS3
FwVers = 13.00.00.00
strId = mpt3sas:03:00.0

Id = 2
Serial Num = 500605b00c36f260
Vendor = LSI Logic
Model = ORCL-EXT-SAS3
FwVers = 13.00.00.00
strId = mpt3sas:13:00.0

Id = 0
Serial Num = SK70770944
Vendor = LSI Logic
Model = LSI MegaRAID 9361-8i
FwVers = 4.650.00-7176
strId = mptmega:23:00.0

Total number of expanders: 4
Id = 1
Serial Num = 5080020001d7ec2c
Vendor = ORACLE
Model = DE3-24C
FwVers = 0304
strId = Secondary
WWN = 50800200021b6a3e

Id = 3
Serial Num = 5080020001d7ec2c
Vendor = ORACLE
Model = DE3-24C
FwVers = 0304
strId = Primary
WWN = 50800200021b75fe

Id = 0
Serial Num = 50800200021ce892
Vendor = ORACLE
Model = DE3-24C
FwVers = 0304
strId = Primary
WWN = 50800200021b87be

Id = 2
Serial Num = 50800200021ce892
Vendor = ORACLE
Model = DE3-24C
FwVers = 0304
strId = Secondary
WWN = 50800200021bc83e

Total number of PDs: 48
/dev/sdaw HGST SSD 1600gb slot: 0 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdax HGST SSD 1600gb slot: 1 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdaa HGST SSD 1600gb slot: 2 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdab HGST SSD 1600gb slot: 3 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdac HGST SSD 1600gb slot: 4 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdad HGST SSD 1600gb slot: 5 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdae HGST SSD 1600gb slot: 6 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdaf HGST SSD 1600gb slot: 7 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdag HGST SSD 1600gb slot: 8 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdah HGST SSD 1600gb slot: 9 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdai HGST SSD 1600gb slot: 10 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdaj HGST SSD 1600gb slot: 11 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdak HGST SSD 1600gb slot: 12 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdal HGST SSD 1600gb slot: 13 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdam HGST SSD 1600gb slot: 14 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdan HGST SSD 1600gb slot: 15 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdao HGST SSD 1600gb slot: 16 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdap HGST SSD 1600gb slot: 17 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdaq HGST SSD 1600gb slot: 18 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdar HGST SSD 1600gb slot: 19 exp: 0 HSCAC2DA2SUN1.6T
/dev/sdas HGST SSD 200gb slot: 20 exp: 0 HSCAC2DA6SUN200G
/dev/sdat HGST SSD 200gb slot: 21 exp: 0 HSCAC2DA6SUN200G
/dev/sdau HGST SSD 200gb slot: 22 exp: 0 HSCAC2DA6SUN200G
/dev/sdav HGST SSD 200gb slot: 23 exp: 0 HSCAC2DA6SUN200G
/dev/sda HGST SSD 1600gb slot: 24 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdb HGST SSD 1600gb slot: 25 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdbw HGST SSD 1600gb slot: 26 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdbx HGST SSD 1600gb slot: 27 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdby HGST SSD 1600gb slot: 28 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdbz HGST SSD 1600gb slot: 29 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdca HGST SSD 1600gb slot: 30 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcb HGST SSD 1600gb slot: 31 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcc HGST SSD 1600gb slot: 32 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcd HGST SSD 1600gb slot: 33 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdce HGST SSD 1600gb slot: 34 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcf HGST SSD 1600gb slot: 35 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcg HGST SSD 1600gb slot: 36 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdch HGST SSD 1600gb slot: 37 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdci HGST SSD 1600gb slot: 38 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcj HGST SSD 1600gb slot: 39 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdck HGST SSD 1600gb slot: 40 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcl HGST SSD 1600gb slot: 41 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcm HGST SSD 1600gb slot: 42 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdcn HGST SSD 1600gb slot: 43 exp: 3 HSCAC2DA2SUN1.6T
/dev/sdco HGST SSD 200gb slot: 44 exp: 3 HSCAC2DA6SUN200G
/dev/sdcp HGST SSD 200gb slot: 45 exp: 3 HSCAC2DA6SUN200G
/dev/sdcq HGST SSD 200gb slot: 46 exp: 3 HSCAC2DA6SUN200G
/dev/sdcr HGST SSD 200gb slot: 47 exp: 3 HSCAC2DA6SUN200G
==== END STORAGE DUMP =========

• To list database storage on ODA

[root@dm-oda0 u04]# oakcli show dbstorage

All the DBs with DB TYPE as non-CDB share the same volumes

DB_NAMES DB_TYPE Filesystem Size Used Available AutoExtend Size DiskGroup
——- ——- ———— —— —– ——— —————- ——–
cfcdev, cfctest1, non-CDB /u01/app/oracle/oradata/datastore 183G 88.81G 94.19G 9G REDO
cfctest2, DEV01DW,
DEV02, DEV03, DWP
RD,  TEST1,
TEST1DW, TEST2
/u02/app/oracle/oradata/datastore 4678G 1602.06G 3075.94G 467G DATA
/u01/app/oracle/fast_recovery_area/datastore 512G 232.43G 279.57G 51G RECO

To show dbhomes
[root@dm-oda0 u04]# oakcli show dbhomes
Oracle Home Name Oracle Home version Home Location
—————- ——————- ————
OraDb11204_home1 11.2.0.4.170814(26609445,26609929) /u01/app/oracle/product/11.2.0.4/dbhome_1
OraDb12102_home1 12.1.0.2.170814(26609783,26609945) /u01/app/oracle/product/12.1.0.2/dbhome_1

To list database on ODA
[root@dm-oda0 u04]# oakcli show databases
Name Type Storage HomeName HomeLocation Version
—– —— ——– ————– —————- ———-
cfcdev RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
TEST1 RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
TEST2 RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
TEST1DW RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
DEV01DW RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
cfctest2 RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
DWPRD RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
cfctest1 RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
DEV02 RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)
DEV03 RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.170814(26609445,26609929)

• To check the ODA servers and hardware status

[root@dm-oda0 ~]# oakcli show server

Power State : On
Open Problems : 0
Model : ODA X6-2-HA
Type : Rack Mount
Part Number : ODA X6-2-HA
Serial Number : 1722NM100L
Primary OS : Not Available
ILOM Address : 10.253.99.52
ILOM MAC Address : 00:10:E0:CC:19:EE
Description : Oracle Database Appliance X6-2 High Availability 1727NM0005
Locator Light : Off
Actual Power Consumption : 198 watts
Ambient Temperature : 27.750 degree C
Open Problems Report : System is healthy

[root@dm-oda0 ~]# oakcli show processor

NAME HEALTH HEALTH_DETAILS PART_NO. LOCATION MODEL MAX_CLK_SPEED TOTAL_CORES ENABLED_CORES

CPU_0 OK – 060F P0 (CPU 0) Intel(R) Xeon(R) CPU E5-2630 2.200 GHz 10 NA
CPU_1 OK – 060F P1 (CPU 1) Intel(R) Xeon(R) CPU E5-2630 2.200 GHz 10 NA
[root@dm-oda0 ~]# oakcli show memory

NAME HEALTH HEALTH_DETAILS PART_NO. SERIAL_NO. LOCATION MANUFACTURER MEMORY_SIZE CURR_CLK_SPEED ECC_Errors

DIMM_0 OK – 3A4K40BB1-CRC 00CE031721195F2472 P0/D0 Samsung 32 GB 2400 MHz 0
DIMM_11 OK – 3A4K40BB1-CRC 00CE031721195F2471 P0/D1 Samsung 32 GB 2400 MHz 0
DIMM_12 OK – 3A4K40BB1-CRC 00CE031721195F243C P1/D0 Samsung 32 GB 2400 MHz 0
DIMM_15 OK – 3A4K40BB1-CRC 00CE031721195F2E7C P1/D3 Samsung 32 GB 2400 MHz 0
DIMM_20 OK – 3A4K40BB1-CRC 00CE031721195F2E7B P1/D8 Samsung 32 GB 2400 MHz 0
DIMM_23 OK – 3A4K40BB1-CRC 00CE031721195F1B55 P1/D1 Samsung 32 GB 2400 MHz 0
DIMM_3 OK – 3A4K40BB1-CRC 00CE031721195F1F34 P0/D3 Samsung 32 GB 2400 MHz 0
DIMM_8 OK – 3A4K40BB1-CRC 00CE031721195F236B P0/D8 Samsung 32 GB 2400 MHz 0
[root@dm-oda0 ~]# oakcli show iraid

NAME CTRL# PRODUCT SERIAL_NO BIOS_VER FW_VER VDISK_TYPE VDISK_STATE PDISK_MODEL EID:SLT PDISK_STATE SIZE CV_MODEL CV_STATE CV_TEMP
IR_0_0_0 0 LSI MegaRAID 9361-8i SK70770944 6.31.03.1_4.19.08.00_0x061402 4.650.00-7176 RAID1 Optl MS4SC2JH2ORA480G 252:0 Onln 446.102 GB CVPM02 Optimal 26C
IR_0_0_1 0 LSI MegaRAID 9361-8i SK70770944 6.31.03.1_4.19.08.00_0x061402 4.650.00-7176 RAID1 Optl MS4SC2JH2ORA480G 252:1 Onln 446.102 GB CVPM02 Optimal 25C
[root@dm-oda0 ~]# oakcli show power

NAME HEALTH HEALTH_DETAILS PART_NO. SERIAL_NO. LOCATION INPUT_POWER OUTPUT_POWER INLET_TEMP EXHAUST_TEMP

Power_Supply_0 OK – 7079395 476856Z+1652CE02CH PS0 Present 87 watts 30.000 degree C 35.938 degree C
Power_Supply_1 OK – 7079395 476856Z+1652CE02E8 PS1 Present 84 watts 30.000 degree C 36.875 degree C
[root@dm-oda0 ~]# oakcli show cooling

NAME HEALTH HEALTH_DETAILS LOCATION FAN % FAN SPEED

Fan_0 OK – FM0 29 % 5600 RPM
Fan_1 OK – FM0 17 % 3000 RPM
Fan_10 OK – FM2 31 % 6100 RPM
Fan_11 OK – FM2 21 % 3700 RPM
Fan_12 OK – FM3 33 % 6400 RPM
Fan_13 OK – FM3 21 % 3700 RPM
Fan_14 OK – FM3 24 % 4700 RPM
Fan_15 OK – FM3 15 % 2600 RPM
Fan_2 OK – FM0 33 % 6400 RPM
Fan_3 OK – FM0 20 % 3600 RPM
Fan_4 OK – FM1 32 % 6300 RPM
Fan_5 OK – FM1 22 % 3800 RPM
Fan_6 OK – FM1 33 % 6400 RPM
Fan_7 OK – FM1 22 % 3800 RPM
Fan_8 OK – FM2 31 % 6100 RPM
Fan_9 OK – FM2 21 % 3700 RPM

• To check network status on ODA

[root@dm-oda0 ~]# oakcli show network

NAME HEALTH HEALTH_DETAILS LOCATION PART_NO MANUFACTURER MAC_ADDRESS LINK_DETECTED DIE_TEMP

Ethernet_NIC_0 OK – NET0 X540 INTEL 00:10:E0:CC:19:EA yes (eth0) 54.250 degree C
Ethernet_NIC_1 OK – NET1 X540 INTEL 00:10:E0:CC:19:EB yes (eth1) 54.250 degree C
Ethernet_NIC_2 OK – NET2 X540 INTEL 00:10:E0:CC:19:EC yes (eth2) 56.000 degree C
Ethernet_NIC_3 OK – NET3 X540 INTEL 00:10:E0:CC:19:ED no (eth3) 56.250 degree C
[root@dm-oda0 ~]# oakcli show ib

NAME MANUFACTURER MODEL DEVICE# CA_TYPE PORT# STATE LINK_STATUS RATE PORT_GUID NODE_GUID SYS_IMAGE_GUID
IB_mlx4_0_1 Mellanox Techn MT27500 mlx4_0 MT4099 1 Active LinkUp 40 (FD 0x0010e00001c88251 0x0010e00001c88250 0x0010e00001c88253
IB_mlx4_0_2 Mellanox Techn MT27500 mlx4_0 MT4099 2 Active LinkUp 40 (FD 0x0010e00001c88252 0x0010e00001c88250 0x0010e00001c88253

To check ODA servers enclosure
[root@dm-oda0 ~]# oakcli show enclosure

NAME SUBSYSTEM STATUS METRIC

E0_FAN0 Cooling OK 4930 rpm
E0_FAN1 Cooling OK 4550 rpm
E0_FAN2 Cooling OK 4910 rpm
E0_FAN3 Cooling OK 4500 rpm
E0_IOM0 Encl_Electronics OK –
E0_IOM1 Encl_Electronics OK –
E0_PSU0 Power_Supply OK –
E0_PSU1 Power_Supply OK –
E0_TEMP0 Amb_Temp OK 20 C
E0_TEMP1 Midplane_Temp OK 20 C
E0_TEMP2 PCM0_Inlet_Temp OK 25 C
E0_TEMP3 PCM0_Hotspot_Temp OK 21 C
E0_TEMP4 PCM1_Inlet_Temp OK 44 C
E0_TEMP5 PCM1_Hotspot_Temp OK 32 C
E0_TEMP6 IOM0_Temp OK 17 C
E0_TEMP7 IOM1_Temp OK 26 C
E1_FAN0 Cooling OK 4910 rpm
E1_FAN1 Cooling OK 4520 rpm
E1_FAN2 Cooling OK 4910 rpm
E1_FAN3 Cooling OK 4530 rpm
E1_IOM0 Encl_Electronics OK –
E1_IOM1 Encl_Electronics OK –
E1_PSU0 Power_Supply OK –
E1_PSU1 Power_Supply OK –
E1_TEMP0 Amb_Temp OK 22 C
E1_TEMP1 Midplane_Temp OK 20 C
E1_TEMP2 PCM0_Inlet_Temp OK 24 C
E1_TEMP3 PCM0_Hotspot_Temp OK 22 C
E1_TEMP4 PCM1_Inlet_Temp OK 44 C
E1_TEMP5 PCM1_Hotspot_Temp OK 34 C
E1_TEMP6 IOM0_Temp OK 17 C
E1_TEMP7 IOM1_Temp OK 28 C

---

Other oakcli commands

• To configure fistnet on ODA

[root@dm-oda0 ~]#oakcli configure firstnet

• To deploy ODA

[root@dm-oda0 ~]# oakcli deploy

• To unpack sofware on ODA

[root@odanode1 ~]#oakcli unpack -package p12978712_1212120_Linux-x86-64_1of2.zip
Unpacking will take some time , Please wait…
Successfully unpacked the files to repository.

• To create Database on ODA

[root@odanode1 ~]# oakcli create database -db demo -oh OraDb11204_home1

• To validate cabling on ODA

[root@dm-oda0 ~]# oakcli validate -c storagetopology

• To update/patch ODA server

[root@dm-oda0 ~]# oakcli update -patch 12.1.2.12.0 –server -local

• To update/patch ODA storage

[root@dm-oda0 ~]# oakcli update -patch 12.1.2.12.0 –storage

Duplicate a Database Using RMAN in Oracle Database 11.2.0.4(Backup Based with Same directory structure)

• Create a backup of the source database.

[oracle@dmdba-prd ~]$ rman target / catalog rcat_owner/rcat_owner@rcat

Recovery Manager: Release 11.2.0.4.0 – Production on Mon Apr 16 09:29:00 2018

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

connected to target database: PROD (DBID=302684881)
connected to recovery catalog database

RMAN> list backup summary;

starting full resync of recovery catalog
full resync complete

List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
——- — — – ———– ————— ——- ——- ———- —
874 B F A DISK 13-APR-18 1 1 NO TAG20181013T111307
891 B A A DISK 13-APR-18 1 1 YES TAG20181013T111659
905 B 0 A DISK 13-APR-18 1 1 YES TAG20181013T111700
906 B 0 A DISK 13-APR-18 1 1 YES TAG20181013T111700
907 B 0 A DISK 13-APR-18 1 1 YES TAG20181013T111700
908 B 0 A DISK 13-APR-18 1 1 YES TAG20181013T111700
981 B A A DISK 13-APR-18 1 1 YES TAG20181013T141028
1007 B F A DISK 13-APR-18 1 1 NO TAG20181013T141030

RMAN> backup incremental level 0 cumulative database plus archivelog ;
Starting backup at 16-APR-18
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=252 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=8 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=170 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=254 device type=DISK
skipping archived logs of thread 1 from sequence 1 to 2; already backed up
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3 RECID=3 STAMP=957519339
channel ORA_DISK_1: starting piece 1 at 16-APR-18
channel ORA_DISK_1: finished piece 1 at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0ksh55fd_1_1 tag=TAG20181016T093541 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 16-APR-18

Starting backup at 16-APR-18
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00018 name=/u04/app/oracle/oradata/PROD/grants_indexes01.dbf
input datafile file number=00012 name=/u04/app/oracle/oradata/PROD/grants_dataB_05.dbf
input datafile file number=00013 name=/u04/app/oracle/oradata/PROD/grants_dataB_04.dbf
input datafile file number=00019 name=/u04/app/oracle/oradata/PROD/grants_report_data_B_05.dbf
input datafile file number=00023 name=/u04/app/oracle/oradata/PROD/grants_report_dataB.dbf
input datafile file number=00040 name=/u04/app/oracle/oradata/PROD/grants_report_data_B_07.dbf
input datafile file number=00051 name=/u04/app/oracle/oradata/PROD/grant_report_data_B_09.dbf
input datafile file number=00031 name=/u04/app/oracle/oradata/PROD/grant_txn_index011.dbf
input datafile file number=00007 name=/u04/app/oracle/oradata/PROD/dmdba_audit.dbf
input datafile file number=00055 name=/u04/app/oracle/oradata/PROD/da_data01.dbf
input datafile file number=00058 name=/u04/app/oracle/oradata/PROD/grants_isir_data03.dbf
input datafile file number=00009 name=/u04/app/oracle/oradata/PROD/foster_indexes01.dbf
input datafile file number=00008 name=/u04/app/oracle/oradata/PROD/foster_data01.dbf
input datafile file number=00057 name=/u04/app/oracle/oradata/PROD/grant_tmp_data01.dbf
input datafile file number=00050 name=/u04/app/oracle/oradata/PROD/calsoap_indexes01.dbf
channel ORA_DISK_1: starting piece 1 at 16-APR-18
channel ORA_DISK_2: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00011 name=/u04/app/oracle/oradata/PROD/grants_dataB_06.dbf
input datafile file number=00044 name=/u04/app/oracle/oradata/PROD/grants_dataB_08.dbf
input datafile file number=00016 name=/u04/app/oracle/oradata/PROD/grants_dataB.dbf
input datafile file number=00022 name=/u04/app/oracle/oradata/PROD/grants_report_dataB_02.dbf
input datafile file number=00038 name=/u04/app/oracle/oradata/PROD/grant_txn_dataB_02.dbf
input datafile file number=00053 name=/u04/app/oracle/oradata/PROD/grant_report_data_B_10.dbf
input datafile file number=00002 name=/u04/app/oracle/oradata/PROD/undotbs01.dbf
input datafile file number=00026 name=/u04/app/oracle/oradata/PROD/grants_web_files01.dbf
input datafile file number=00046 name=/u04/app/oracle/oradata/PROD/grants_isir_indexes.dbf
input datafile file number=00003 name=/u04/app/oracle/oradata/PROD/sysaux01.dbf
input datafile file number=00034 name=/u04/app/oracle/oradata/PROD/users01.dbf
input datafile file number=00035 name=/u04/app/oracle/oradata/PROD/aple_indexes01.dbf
input datafile file number=00032 name=/u04/app/oracle/oradata/PROD/reftabs_data01.dbf
input datafile file number=00024 name=/u04/app/oracle/oradata/PROD/grants_report_indexes02.dbf
channel ORA_DISK_2: starting piece 1 at 16-APR-18
channel ORA_DISK_3: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
input datafile file number=00017 name=/u04/app/oracle/oradata/PROD/grants_indexes02.dbf
input datafile file number=00001 name=/u04/app/oracle/oradata/PROD/system01.dbf
input datafile file number=00014 name=/u04/app/oracle/oradata/PROD/grants_dataB_03.dbf
input datafile file number=00020 name=/u04/app/oracle/oradata/PROD/grants_report_data_B_04.dbf
input datafile file number=00030 name=/u04/app/oracle/oradata/PROD/grant_txn_dataB.dbf
input datafile file number=00045 name=/u04/app/oracle/oradata/PROD/grants_report_data_B_08.dbf
input datafile file number=00039 name=/u04/app/oracle/oradata/PROD/grants_isir_data02.dbf
input datafile file number=00005 name=/u04/app/oracle/oradata/PROD/archive_data01.dbf
input datafile file number=00027 name=/u04/app/oracle/oradata/PROD/grants_web_indexes01.dbf
input datafile file number=00047 name=/u04/app/oracle/oradata/PROD/mcs_data01.dbf
input datafile file number=00056 name=/u04/app/oracle/oradata/PROD/da_data02.dbf
input datafile file number=00041 name=/u04/app/oracle/oradata/PROD/user_securit
input datafile file number=00048 name=/u04/app/oracle/oradata/PROD/mcs_indexes0
input datafile file number=00004 name=/u04/app/oracle/oradata/PROD/aple_data01.
input datafile file number=00033 name=/u04/app/oracle/oradata/PROD/reftabs_inde
channel ORA_DISK_3: starting piece 1 at 16-APR-18
channel ORA_DISK_4: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup set
input datafile file number=00010 name=/u04/app/oracle/oradata/PROD/grants_dataB
input datafile file number=00043 name=/u04/app/oracle/oradata/PROD/grants_index
input datafile file number=00015 name=/u04/app/oracle/oradata/PROD/grants_dataB
input datafile file number=00021 name=/u04/app/oracle/oradata/PROD/grants_repor
input datafile file number=00037 name=/u04/app/oracle/oradata/PROD/grants_repor
input datafile file number=00052 name=/u04/app/oracle/oradata/PROD/system02.dbf
input datafile file number=00036 name=/u04/app/oracle/oradata/PROD/grants_isir_
input datafile file number=00054 name=/u04/app/oracle/oradata/PROD/grants_repor
input datafile file number=00028 name=/u04/app/oracle/oradata/PROD/grants_work_
input datafile file number=00029 name=/u04/app/oracle/oradata/PROD/grants_work_
input datafile file number=00006 name=/u04/app/oracle/oradata/PROD/archive_inde
input datafile file number=00042 name=/u04/app/oracle/oradata/PROD/user_securit
input datafile file number=00025 name=/u04/app/oracle/oradata/PROD/grants_repor
input datafile file number=00049 name=/u04/app/oracle/oradata/PROD/calsoap_data
input datafile file number=00059 name=/u04/app/oracle/oradata/PROD/grants_dataB
channel ORA_DISK_4: starting piece 1 at 16-APR-18
channel ORA_DISK_1: finished piece 1 at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0lsh55fu_1_1 tag=TAG20181016T093556 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:38:53
channel ORA_DISK_2: finished piece 1 at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0msh55fu_1_1 tag=TAG20181016T093556 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:38:53
channel ORA_DISK_3: finished piece 1 at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0nsh55fu_1_1 tag=TAG20181016T093556 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:38:53
channel ORA_DISK_4: finished piece 1 at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0osh55fu_1_1 tag=TAG20181016T093556 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed time: 00:38:52
Finished backup at 16-APR-18

Starting backup at 16-APR-18
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=4 RECID=4 STAMP=957520190
channel ORA_DISK_1: starting piece 1 at 16-APR-18
channel ORA_DISK_2: starting compressed archived log backup set
channel ORA_DISK_2: specifying archived log(s) in backup set
input archived log thread=1 sequence=5 RECID=5 STAMP=957521691
channel ORA_DISK_2: starting piece 1 at 16-APR-18
channel ORA_DISK_1: finished piece 1 at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0psh57ot_1_1 tag=TAG20181016T101453 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_2: finished piece 1 at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0qsh57ot_1_1 tag=TAG20181016T101453 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
Finished backup at 16-APR-18

Starting Control File and SPFILE Autobackup at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/control_file_c-302684881-20181016-00 comment=NONE
Finished Control File and SPFILE Autobackup at 16-APR-18

RMAN> exit

---

Target Database

Edit the init parameter file.

[oracle@dmdba-rnd ~]$ cd $ORACLE_HOME/dbs
[oracle@dmdba-rnd dbs]$ cat initPRODCOPY.ora
*.db_name=’PRODCOPY’
*.audit_file_dest=’/u01/app/oracle/admin/PRODCOPY/adump’
*.control_files=’/u04/app/oracle/oradata/PRODCOPY/control01.ctl’,’/u04/app/oracle/oradata/PRODCOPY/control02.ctl’,’/u04/app/oracle/oradata/PRODCOPY/control03.ctl’
*.core_dump_dest=’/u01/app/oracle/admin/PRODCOPY/cdump’
*.db_create_file_dest=’/u04/app/oracle/oradata/PRODCOPY’
*.db_file_name_convert=(‘/u04/app/oracle/oradata/PROD/’,’/u04/app/oracle/oradata/PRODCOPY’)
*.log_file_name_convert=(‘/u04/app/oracle/oradata/PROD/’,’/u04/app/oracle/oradata/PRODCOPY’)
*.diagnostic_dest=’/u01/app/oracle/admin/PRODCOPY/bdump’

Start the target database in nomount

[oracle@dmdba-rnd dbs]$ sqlplus “/ as sysdba”

SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 16 10:01:37 2018

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

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 1920831488 bytes
Fixed Size 2243232 bytes
Variable Size 436208992 bytes
Database Buffers 1476395008 bytes
Redo Buffers 5984256 bytes
SQL> show parameter db_name;

NAME TYPE VALUE
———————————— ———– ——————————
db_name string PRODCOPY
SQL> show parameter convert

NAME TYPE VALUE
———————————— ———– ——————————
db_file_name_convert string /u04/app/oracle/oradata/PROD/
, /u04/app/oracle/oradata/PROD
COPY
log_file_name_convert string /u04/app/oracle/oradata/PROD/
, /u04/app/oracle/oradata/PROD
COPY
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

---

Start the rman duplication Process

[oracle@dmdba-rnd dbs]$ rman target sys/Welcome1@PROD catalog rcat_owner/rcat_owner@RCAT auxiliary /

Recovery Manager: Release 11.2.0.4.0 – Production on Mon Apr 16 10:16:54 2018

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

connected to target database: PROD (DBID=302684881)
connected to recovery catalog database
connected to auxiliary database: PRODCOPY (not mounted)

RMAN> DUPLICATE DATABASE TO PRODCOPY NOFILENAMECHECK;

Starting Duplicate Db at 16-APR-18
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=249 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=5 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=86 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=168 device type=DISK

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

Fixed Size 2229544 bytes
Variable Size 452987608 bytes
Database Buffers 1442840576 bytes
Redo Buffers 22700032 bytes

contents of Memory Script:
{
sql clone “alter system set db_name =
”PROD” comment=
”Modified by RMAN duplicate” scope=spfile”;
sql clone “alter system set db_unique_name =
”PRODCOPY” 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

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

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

Oracle instance shut down

Oracle instance started

Total System Global Area 1920757760 bytes

Fixed Size 2229544 bytes
Variable Size 452987608 bytes
Database Buffers 1442840576 bytes
Redo Buffers 22700032 bytes

Starting restore at 16-APR-18
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=244 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=5 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=86 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=168 device type=DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u04/app/oracle/backup/PROD/control_file_c-302684881-20181016-00
channel ORA_AUX_DISK_1: piece handle=/u04/app/oracle/backup/PROD/control_file_c-302684881-20181016-00 tag=TAG20181016T101455
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u04/app/oracle/oradata/PRODCOPY/control01.ctl
output file name=/u04/app/oracle/oradata/PRODCOPY/control02.ctl
output file name=/u04/app/oracle/oradata/PRODCOPY/control03.ctl
Finished restore at 16-APR-18

database mounted

contents of Memory Script:
{
set until scn 7064436942;
set newname for datafile 1 to
“/u04/app/oracle/oradata/PRODCOPYsystem01.dbf”;
set newname for datafile 2 to
“/u04/app/oracle/oradata/PRODCOPYundotbs01.dbf”;
set newname for datafile 3 to
“/u04/app/oracle/oradata/PRODCOPYsysaux01.dbf”;
set newname for datafile 4 to
“/u04/app/oracle/oradata/PRODCOPYaple_data01.dbf”;
set newname for datafile 5 to
“/u04/app/oracle/oradata/PRODCOPYarchive_data01.dbf”;
set newname for datafile 6 to
“/u04/app/oracle/oradata/PRODCOPYarchive_indexes01.dbf”;
set newname for datafile 7 to
“/u04/app/oracle/oradata/PRODCOPYdmdba_audit.dbf”;
set newname for datafile 8 to
“/u04/app/oracle/oradata/PRODCOPYfoster_data01.dbf”;
set newname for datafile 9 to
“/u04/app/oracle/oradata/PRODCOPYfoster_indexes01.dbf”;
set newname for datafile 10 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_07.dbf”;
set newname for datafile 11 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_06.dbf”;
set newname for datafile 12 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_05.dbf”;
set newname for datafile 13 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_04.dbf”;
set newname for datafile 14 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_03.dbf”;
set newname for datafile 15 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_02.dbf”;
set newname for datafile 16 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB.dbf”;
set newname for datafile 17 to
“/u04/app/oracle/oradata/PRODCOPYgrants_indexes02.dbf”;
set newname for datafile 18 to
“/u04/app/oracle/oradata/PRODCOPYgrants_indexes01.dbf”;
set newname for datafile 19 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_05.dbf”;
set newname for datafile 20 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_04.dbf”;
set newname for datafile 21 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_03.dbf”;
set newname for datafile 22 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_02.dbf”;
set newname for datafile 23 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB.dbf”;
set newname for datafile 24 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes02.dbf”;
set newname for datafile 25 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes01.dbf”;
set newname for datafile 26 to
“/u04/app/oracle/oradata/PRODCOPYgrants_web_files01.dbf”;
set newname for datafile 27 to
“/u04/app/oracle/oradata/PRODCOPYgrants_web_indexes01.dbf”;
set newname for datafile 28 to
“/u04/app/oracle/oradata/PRODCOPYgrants_work_files01.dbf”;
set newname for datafile 29 to
“/u04/app/oracle/oradata/PRODCOPYgrants_work_indexes01.dbf”;
set newname for datafile 30 to
“/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB.dbf”;
set newname for datafile 31 to
“/u04/app/oracle/oradata/PRODCOPYgrant_txn_index011.dbf”;
set newname for datafile 32 to
“/u04/app/oracle/oradata/PRODCOPYreftabs_data01.dbf”;
set newname for datafile 33 to
“/u04/app/oracle/oradata/PRODCOPYreftabs_indexes01.dbf”;
set newname for datafile 34 to
“/u04/app/oracle/oradata/PRODCOPYusers01.dbf”;
set newname for datafile 35 to
“/u04/app/oracle/oradata/PRODCOPYaple_indexes01.dbf”;
set newname for datafile 36 to
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_data01.dbf”;
set newname for datafile 37 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_06.dbf”;
set newname for datafile 38 to
“/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB_02.dbf”;
set newname for datafile 39 to
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_data02.dbf”;
set newname for datafile 40 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_07.dbf”;
set newname for datafile 41 to
“/u04/app/oracle/oradata/PRODCOPYuser_security_data01.dbf”;
set newname for datafile 42 to
“/u04/app/oracle/oradata/PRODCOPYuser_security_indexes01.dbf”;
set newname for datafile 43 to
“/u04/app/oracle/oradata/PRODCOPYgrants_indexes03.dbf”;
set newname for datafile 44 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_08.dbf”;
set newname for datafile 45 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_08.dbf”;
set newname for datafile 46 to
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_indexes.dbf”;
set newname for datafile 47 to
“/u04/app/oracle/oradata/PRODCOPYmcs_data01.dbf”;
set newname for datafile 48 to
“/u04/app/oracle/oradata/PRODCOPYmcs_indexes01.dbf”;
set newname for datafile 49 to
“/u04/app/oracle/oradata/PRODCOPYcalsoap_data01.dbf”;
set newname for datafile 50 to
“/u04/app/oracle/oradata/PRODCOPYcalsoap_indexes01.dbf”;
set newname for datafile 51 to
“/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_09.dbf”;
set newname for datafile 52 to
“/u04/app/oracle/oradata/PRODCOPYsystem02.dbf”;
set newname for datafile 53 to
“/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_10.dbf”;
set newname for datafile 54 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_11.dbf”;
set newname for datafile 55 to
“/u04/app/oracle/oradata/PRODCOPYda_data01.dbf”;
set newname for datafile 56 to
“/u04/app/oracle/oradata/PRODCOPYda_data02.dbf”;
set newname for datafile 57 to
“/u04/app/oracle/oradata/PRODCOPYgrant_tmp_data01.dbf”;
set newname for datafile 58 to
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_data03.dbf”;
set newname for datafile 59 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_09.dbf”;
restore
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

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

executing command: SET NEWNAME

Starting restore at 16-APR-18
using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
using channel ORA_AUX_DISK_3
using channel ORA_AUX_DISK_4

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00002 to /u04/app/oracle/oradata/PRODCOPYundotbs01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u04/app/oracle/oradata/PRODCOPYsysaux01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00011 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_06.dbf
channel ORA_AUX_DISK_1: restoring datafile 00016 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB.dbf
channel ORA_AUX_DISK_1: restoring datafile 00022 to /u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00024 to /u04/app/oracle/oradata/PRODCOPYgrants_report_indexes02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00026 to /u04/app/oracle/oradata/PRODCOPYgrants_web_files01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00032 to /u04/app/oracle/oradata/PRODCOPYreftabs_data01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00034 to /u04/app/oracle/oradata/PRODCOPYusers01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00035 to /u04/app/oracle/oradata/PRODCOPYaple_indexes01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00038 to /u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB_02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00044 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_08.dbf
channel ORA_AUX_DISK_1: restoring datafile 00046 to /u04/app/oracle/oradata/PRODCOPYgrants_isir_indexes.dbf
channel ORA_AUX_DISK_1: restoring datafile 00053 to /u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_10.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181013_0fsgte9e_1_1
channel ORA_AUX_DISK_2: starting datafile backup set restore
channel ORA_AUX_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_2: restoring datafile 00006 to /u04/app/oracle/oradata/PRODCOPYarchive_indexes01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00010 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_07.dbf
channel ORA_AUX_DISK_2: restoring datafile 00015 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_02.dbf
channel ORA_AUX_DISK_2: restoring datafile 00021 to /u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_03.dbf
channel ORA_AUX_DISK_2: restoring datafile 00025 to /u04/app/oracle/oradata/PRODCOPYgrants_report_indexes01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00028 to /u04/app/oracle/oradata/PRODCOPYgrants_work_files01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00029 to /u04/app/oracle/oradata/PRODCOPYgrants_work_indexes01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00036 to /u04/app/oracle/oradata/PRODCOPYgrants_isir_data01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00037 to /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_06.dbf
channel ORA_AUX_DISK_2: restoring datafile 00042 to /u04/app/oracle/oradata/PRODCOPYuser_security_indexes01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00043 to /u04/app/oracle/oradata/PRODCOPYgrants_indexes03.dbf
channel ORA_AUX_DISK_2: restoring datafile 00049 to /u04/app/oracle/oradata/PRODCOPYcalsoap_data01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00052 to /u04/app/oracle/oradata/PRODCOPYsystem02.dbf
channel ORA_AUX_DISK_2: restoring datafile 00054 to /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_11.dbf
channel ORA_AUX_DISK_2: restoring datafile 00059 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_09.dbf
channel ORA_AUX_DISK_2: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181013_0hsgte9e_1_1
channel ORA_AUX_DISK_3: starting datafile backup set restore
channel ORA_AUX_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_3: restoring datafile 00007 to /u04/app/oracle/oradata/PRODCOPYdmdba_audit.dbf
channel ORA_AUX_DISK_3: restoring datafile 00008 to /u04/app/oracle/oradata/PRODCOPYfoster_data01.dbf
channel ORA_AUX_DISK_3: restoring datafile 00009 to /u04/app/oracle/oradata/PRODCOPYfoster_indexes01.dbf
channel ORA_AUX_DISK_3: restoring datafile 00012 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_05.dbf
channel ORA_AUX_DISK_3: restoring datafile 00013 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_04.dbf
channel ORA_AUX_DISK_3: restoring datafile 00018 to /u04/app/oracle/oradata/PRODCOPYgrants_indexes01.dbf
channel ORA_AUX_DISK_3: restoring datafile 00019 to /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_05.dbf
channel ORA_AUX_DISK_3: restoring datafile 00023 to /u04/app/oracle/oradata/PRODCOPYgrants_report_dataB.dbf
channel ORA_AUX_DISK_3: restoring datafile 00031 to /u04/app/oracle/oradata/PRODCOPYgrant_txn_index011.dbf
channel ORA_AUX_DISK_3: restoring datafile 00040 to /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_07.dbf
channel ORA_AUX_DISK_3: restoring datafile 00050 to /u04/app/oracle/oradata/PRODCOPYcalsoap_indexes01.dbf
channel ORA_AUX_DISK_3: restoring datafile 00051 to /u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_09.dbf
channel ORA_AUX_DISK_3: restoring datafile 00055 to /u04/app/oracle/oradata/PRODCOPYda_data01.dbf
channel ORA_AUX_DISK_3: restoring datafile 00057 to /u04/app/oracle/oradata/PRODCOPYgrant_tmp_data01.dbf
channel ORA_AUX_DISK_3: restoring datafile 00058 to /u04/app/oracle/oradata/PRODCOPYgrants_isir_data03.dbf
channel ORA_AUX_DISK_3: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181013_0esgte9e_1_1
channel ORA_AUX_DISK_4: starting datafile backup set restore
channel ORA_AUX_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_4: restoring datafile 00001 to /u04/app/oracle/oradata/PRODCOPYsystem01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00004 to /u04/app/oracle/oradata/PRODCOPYaple_data01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00005 to /u04/app/oracle/oradata/PRODCOPYarchive_data01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00014 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_03.dbf
channel ORA_AUX_DISK_4: restoring datafile 00017 to /u04/app/oracle/oradata/PRODCOPYgrants_indexes02.dbf
channel ORA_AUX_DISK_4: restoring datafile 00020 to /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_04.dbf
channel ORA_AUX_DISK_4: restoring datafile 00027 to /u04/app/oracle/oradata/PRODCOPYgrants_web_indexes01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00030 to /u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB.dbf
channel ORA_AUX_DISK_4: restoring datafile 00033 to /u04/app/oracle/oradata/PRODCOPYreftabs_indexes01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00039 to /u04/app/oracle/oradata/PRODCOPYgrants_isir_data02.dbf
channel ORA_AUX_DISK_4: restoring datafile 00041 to /u04/app/oracle/oradata/PRODCOPYuser_security_data01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00045 to /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_08.dbf
channel ORA_AUX_DISK_4: restoring datafile 00047 to /u04/app/oracle/oradata/PRODCOPYmcs_data01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00048 to /u04/app/oracle/oradata/PRODCOPYmcs_indexes01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00056 to /u04/app/oracle/oradata/PRODCOPYda_data02.dbf
channel ORA_AUX_DISK_4: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181013_0gsgte9e_1_1
channel ORA_AUX_DISK_1: piece handle=/u04/app/oracle/backup/PROD/PROD_20181013_0fsgte9e_1_1 tag=TAG20181013T111700
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 02:15:12
channel ORA_AUX_DISK_2: piece handle=/u04/app/oracle/backup/PROD/PROD_20181013_0hsgte9e_1_1 tag=TAG20181013T111700
channel ORA_AUX_DISK_2: restored backup piece 1
channel ORA_AUX_DISK_2: restore complete, elapsed time: 02:31:23
channel ORA_AUX_DISK_3: piece handle=/u04/app/oracle/backup/PROD/PROD_20181013_0esgte9e_1_1 tag=TAG20181013T111700
channel ORA_AUX_DISK_3: restored backup piece 1
channel ORA_AUX_DISK_3: restore complete, elapsed time: 02:49:24
channel ORA_AUX_DISK_4: piece handle=/u04/app/oracle/backup/PROD/PROD_20181013_0gsgte9e_1_1 tag=TAG20181013T111700
channel ORA_AUX_DISK_4: restored backup piece 1
channel ORA_AUX_DISK_4: restore complete, elapsed time: 02:57:34
Finished restore at 16-APR-18

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=60 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYsystem01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=61 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYundotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=62 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYsysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=63 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYaple_data01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=64 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYarchive_data01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=65 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYarchive_indexes01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=66 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYdmdba_audit.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=67 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYfoster_data01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=68 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYfoster_indexes01.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=69 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_07.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=70 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_06.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=71 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_05.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=72 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_04.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=73 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_03.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=74 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_02.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=75 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=76 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes02.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=77 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes01.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=78 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_05.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=79 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_04.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=80 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_03.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=81 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_02.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=82 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=83 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes02.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=84 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes01.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=85 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_web_files01.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=86 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_web_indexes01.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=87 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_work_files01.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=88 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_work_indexes01.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=89 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=90 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_index011.dbf
datafile 32 switched to datafile copy
input datafile copy RECID=91 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYreftabs_data01.dbf
datafile 33 switched to datafile copy
input datafile copy RECID=92 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYreftabs_indexes01.dbf
datafile 34 switched to datafile copy
input datafile copy RECID=93 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYusers01.dbf
datafile 35 switched to datafile copy
input datafile copy RECID=94 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYaple_indexes01.dbf
datafile 36 switched to datafile copy
input datafile copy RECID=95 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data01.dbf
datafile 37 switched to datafile copy
input datafile copy RECID=96 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_06.dbf
datafile 38 switched to datafile copy
input datafile copy RECID=97 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB_02.dbf
datafile 39 switched to datafile copy
input datafile copy RECID=98 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data02.dbf
datafile 40 switched to datafile copy
input datafile copy RECID=99 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_07.dbf
datafile 41 switched to datafile copy
input datafile copy RECID=100 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYuser_security_data01.dbf
datafile 42 switched to datafile copy
input datafile copy RECID=101 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYuser_security_indexes01.dbf
datafile 43 switched to datafile copy
input datafile copy RECID=102 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes03.dbf
datafile 44 switched to datafile copy
input datafile copy RECID=103 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_08.dbf
datafile 45 switched to datafile copy
input datafile copy RECID=104 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_08.dbf
datafile 46 switched to datafile copy
input datafile copy RECID=105 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_indexes.dbf
datafile 47 switched to datafile copy
input datafile copy RECID=106 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYmcs_data01.dbf
datafile 48 switched to datafile copy
input datafile copy RECID=107 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYmcs_indexes01.dbf
datafile 49 switched to datafile copy
input datafile copy RECID=108 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYcalsoap_data01.dbf
datafile 50 switched to datafile copy
input datafile copy RECID=109 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYcalsoap_indexes01.dbf
datafile 51 switched to datafile copy
input datafile copy RECID=110 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_09.dbf
datafile 52 switched to datafile copy
input datafile copy RECID=111 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYsystem02.dbf
datafile 53 switched to datafile copy
input datafile copy RECID=112 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_10.dbf
datafile 54 switched to datafile copy
input datafile copy RECID=113 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_11.dbf
datafile 55 switched to datafile copy
input datafile copy RECID=114 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYda_data01.dbf
datafile 56 switched to datafile copy
input datafile copy RECID=115 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYda_data02.dbf
datafile 57 switched to datafile copy
input datafile copy RECID=116 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYgrant_tmp_data01.dbf
datafile 58 switched to datafile copy
input datafile copy RECID=117 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data03.dbf
datafile 59 switched to datafile copy
input datafile copy RECID=118 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_09.dbf

contents of Memory Script:
{
set until scn 7064436942;
recover
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 16-APR-18
using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
using channel ORA_AUX_DISK_3
using channel ORA_AUX_DISK_4
channel ORA_AUX_DISK_1: starting incremental datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /u04/app/oracle/oradata/PRODCOPYarchive_indexes01.dbf
destination for restore of datafile 00010: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_07.dbf
destination for restore of datafile 00015: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_02.dbf
destination for restore of datafile 00021: /u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_03.dbf
destination for restore of datafile 00025: /u04/app/oracle/oradata/PRODCOPYgrants_report_indexes01.dbf
destination for restore of datafile 00028: /u04/app/oracle/oradata/PRODCOPYgrants_work_files01.dbf
destination for restore of datafile 00029: /u04/app/oracle/oradata/PRODCOPYgrants_work_indexes01.dbf
destination for restore of datafile 00036: /u04/app/oracle/oradata/PRODCOPYgrants_isir_data01.dbf
destination for restore of datafile 00037: /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_06.dbf
destination for restore of datafile 00042: /u04/app/oracle/oradata/PRODCOPYuser_security_indexes01.dbf
destination for restore of datafile 00043: /u04/app/oracle/oradata/PRODCOPYgrants_indexes03.dbf
destination for restore of datafile 00049: /u04/app/oracle/oradata/PRODCOPYcalsoap_data01.dbf
destination for restore of datafile 00052: /u04/app/oracle/oradata/PRODCOPYsystem02.dbf
destination for restore of datafile 00054: /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_11.dbf
destination for restore of datafile 00059: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_09.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181016_0osh55fu_1_1
channel ORA_AUX_DISK_2: starting incremental datafile backup set restore
channel ORA_AUX_DISK_2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /u04/app/oracle/oradata/PRODCOPYsystem01.dbf
destination for restore of datafile 00004: /u04/app/oracle/oradata/PRODCOPYaple_data01.dbf
destination for restore of datafile 00005: /u04/app/oracle/oradata/PRODCOPYarchive_data01.dbf
destination for restore of datafile 00014: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_03.dbf
destination for restore of datafile 00017: /u04/app/oracle/oradata/PRODCOPYgrants_indexes02.dbf
destination for restore of datafile 00020: /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_04.dbf
destination for restore of datafile 00027: /u04/app/oracle/oradata/PRODCOPYgrants_web_indexes01.dbf
destination for restore of datafile 00030: /u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB.dbf
destination for restore of datafile 00033: /u04/app/oracle/oradata/PRODCOPYreftabs_indexes01.dbf
destination for restore of datafile 00039: /u04/app/oracle/oradata/PRODCOPYgrants_isir_data02.dbf
destination for restore of datafile 00041: /u04/app/oracle/oradata/PRODCOPYuser_security_data01.dbf
destination for restore of datafile 00045: /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_08.dbf
destination for restore of datafile 00047: /u04/app/oracle/oradata/PRODCOPYmcs_data01.dbf
destination for restore of datafile 00048: /u04/app/oracle/oradata/PRODCOPYmcs_indexes01.dbf
destination for restore of datafile 00056: /u04/app/oracle/oradata/PRODCOPYda_data02.dbf
channel ORA_AUX_DISK_2: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181016_0nsh55fu_1_1
channel ORA_AUX_DISK_3: starting incremental datafile backup set restore
channel ORA_AUX_DISK_3: specifying datafile(s) to restore from backup set
destination for restore of datafile 00007: /u04/app/oracle/oradata/PRODCOPYdmdba_audit.dbf
destination for restore of datafile 00008: /u04/app/oracle/oradata/PRODCOPYfoster_data01.dbf
destination for restore of datafile 00009: /u04/app/oracle/oradata/PRODCOPYfoster_indexes01.dbf
destination for restore of datafile 00012: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_05.dbf
destination for restore of datafile 00013: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_04.dbf
destination for restore of datafile 00018: /u04/app/oracle/oradata/PRODCOPYgrants_indexes01.dbf
destination for restore of datafile 00019: /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_05.dbf
destination for restore of datafile 00023: /u04/app/oracle/oradata/PRODCOPYgrants_report_dataB.dbf
destination for restore of datafile 00031: /u04/app/oracle/oradata/PRODCOPYgrant_txn_index011.dbf
destination for restore of datafile 00040: /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_07.dbf
destination for restore of datafile 00050: /u04/app/oracle/oradata/PRODCOPYcalsoap_indexes01.dbf
destination for restore of datafile 00051: /u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_09.dbf
destination for restore of datafile 00055: /u04/app/oracle/oradata/PRODCOPYda_data01.dbf
destination for restore of datafile 00057: /u04/app/oracle/oradata/PRODCOPYgrant_tmp_data01.dbf
destination for restore of datafile 00058: /u04/app/oracle/oradata/PRODCOPYgrants_isir_data03.dbf
channel ORA_AUX_DISK_3: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181016_0lsh55fu_1_1
channel ORA_AUX_DISK_4: starting incremental datafile backup set restore
channel ORA_AUX_DISK_4: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: /u04/app/oracle/oradata/PRODCOPYundotbs01.dbf
destination for restore of datafile 00003: /u04/app/oracle/oradata/PRODCOPYsysaux01.dbf
destination for restore of datafile 00011: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_06.dbf
destination for restore of datafile 00016: /u04/app/oracle/oradata/PRODCOPYgrants_dataB.dbf
destination for restore of datafile 00022: /u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_02.dbf
destination for restore of datafile 00024: /u04/app/oracle/oradata/PRODCOPYgrants_report_indexes02.dbf
destination for restore of datafile 00026: /u04/app/oracle/oradata/PRODCOPYgrants_web_files01.dbf
destination for restore of datafile 00032: /u04/app/oracle/oradata/PRODCOPYreftabs_data01.dbf
destination for restore of datafile 00034: /u04/app/oracle/oradata/PRODCOPYusers01.dbf
destination for restore of datafile 00035: /u04/app/oracle/oradata/PRODCOPYaple_indexes01.dbf
destination for restore of datafile 00038: /u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB_02.dbf
destination for restore of datafile 00044: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_08.dbf
destination for restore of datafile 00046: /u04/app/oracle/oradata/PRODCOPYgrants_isir_indexes.dbf
destination for restore of datafile 00053: /u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_10.dbf
channel ORA_AUX_DISK_4: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181016_0msh55fu_1_1
channel ORA_AUX_DISK_1: piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0osh55fu_1_1 tag=TAG20181016T093556
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_2: piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0nsh55fu_1_1 tag=TAG20181016T093556
channel ORA_AUX_DISK_2: restored backup piece 1
channel ORA_AUX_DISK_2: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_3: piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0lsh55fu_1_1 tag=TAG20181016T093556
channel ORA_AUX_DISK_3: restored backup piece 1
channel ORA_AUX_DISK_3: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_4: piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0msh55fu_1_1 tag=TAG20181016T093556
channel ORA_AUX_DISK_4: restored backup piece 1
channel ORA_AUX_DISK_4: restore complete, elapsed time: 00:00:15

starting media recovery

archived log for thread 1 with sequence 4 is already on disk as file /u04/backup/PROD/arch/1_4_957265928.dbf
archived log for thread 1 with sequence 5 is already on disk as file /u04/backup/PROD/arch/1_5_957265928.dbf
archived log file name=/u04/backup/PROD/arch/1_4_957265928.dbf thread=1 sequence=4
archived log file name=/u04/backup/PROD/arch/1_5_957265928.dbf thread=1 sequence=5
media recovery complete, elapsed time: 00:00:01
Finished recover at 16-APR-18
Oracle instance started

Total System Global Area 1920757760 bytes

Fixed Size 2229544 bytes
Variable Size 452987608 bytes
Database Buffers 1442840576 bytes
Redo Buffers 22700032 bytes

contents of Memory Script:
{
sql clone “alter system set db_name =
”PRODCOPY” comment=
”Reset to original value by RMAN” scope=spfile”;
sql clone “alter system reset db_unique_name scope=spfile”;
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script

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

sql statement: alter system reset db_unique_name scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 1920757760 bytes

Fixed Size 2229544 bytes
Variable Size 452987608 bytes
Database Buffers 1442840576 bytes
Redo Buffers 22700032 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE “PRODCOPY” RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 4674
LOGFILE
GROUP 1 ( ‘/u04/app/oracle/oradata/PRODCOPYredo01a.log’, ‘/u04/app/oracle/oradata/PRODCOPYredo01b.log’ ) SIZE 1 G REUSE,
GROUP 2 ( ‘/u04/app/oracle/oradata/PRODCOPYredo02a.log’, ‘/u04/app/oracle/oradata/PRODCOPYredo02b.log’ ) SIZE 1 G REUSE,
GROUP 3 ( ‘/u04/app/oracle/oradata/PRODCOPYredo03a.log’, ‘/u04/app/oracle/oradata/PRODCOPYredo03b.log’ ) SIZE 1 G REUSE,
GROUP 4 ( ‘/u04/app/oracle/oradata/PRODCOPYredo04a.log’, ‘/u04/app/oracle/oradata/PRODCOPYredo04b.log’ ) SIZE 1 G REUSE
DATAFILE
‘/u04/app/oracle/oradata/PRODCOPYsystem01.dbf’
CHARACTER SET WE8ISO8859P1
contents of Memory Script:
{
set newname for tempfile 1 to
“/u04/app/oracle/oradata/PRODCOPYtemp01.dbf”;
set newname for tempfile 2 to
“/u04/app/oracle/oradata/PRODCOPYtempGrp1.dbf”;
set newname for tempfile 3 to
“/u04/app/oracle/oradata/PRODCOPYtempGrp2.dbf”;
set newname for tempfile 4 to
“/u04/app/oracle/oradata/PRODCOPYtempGrp3.dbf”;
switch clone tempfile all;
catalog clone datafilecopy “/u04/app/oracle/oradata/PRODCOPYundotbs01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYsysaux01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYaple_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYarchive_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYarchive_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYdmdba_audit.dbf”,
“/u04/app/oracle/oradata/PRODCOPYfoster_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYfoster_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_07.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_06.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_05.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_04.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_03.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_indexes02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_05.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_04.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_03.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_web_files01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_web_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_work_files01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_work_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrant_txn_index011.dbf”,
“/u04/app/oracle/oradata/PRODCOPYreftabs_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYreftabs_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYusers01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYaple_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_06.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB_02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_data02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_07.dbf”,
“/u04/app/oracle/oradata/PRODCOPYuser_security_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYuser_security_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_indexes03.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_08.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_08.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_indexes.dbf”,
“/u04/app/oracle/oradata/PRODCOPYmcs_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYmcs_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYcalsoap_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYcalsoap_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_09.dbf”,
“/u04/app/oracle/oradata/PRODCOPYsystem02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_10.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_11.dbf”,
“/u04/app/oracle/oradata/PRODCOPYda_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYda_data02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrant_tmp_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_data03.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_09.dbf”;
switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to /u04/app/oracle/oradata/PRODCOPYtemp01.dbf in control file
renamed tempfile 2 to /u04/app/oracle/oradata/PRODCOPYtempGrp1.dbf in control file
renamed tempfile 3 to /u04/app/oracle/oradata/PRODCOPYtempGrp2.dbf in control file
renamed tempfile 4 to /u04/app/oracle/oradata/PRODCOPYtempGrp3.dbf in control file

cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYundotbs01.dbf RECID=1 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYsysaux01.dbf RECID=2 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYaple_data01.dbf RECID=3 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYarchive_data01.dbf RECID=4 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYarchive_indexes01.dbf RECID=5 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYdmdba_audit.dbf RECID=6 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYfoster_data01.dbf RECID=7 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYfoster_indexes01.dbf RECID=8 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_07.dbf RECID=9 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_06.dbf RECID=10 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_05.dbf RECID=11 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_04.dbf RECID=12 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_03.dbf RECID=13 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_02.dbf RECID=14 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB.dbf RECID=15 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes02.dbf RECID=16 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes01.dbf RECID=17 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_05.dbf RECID=18 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_04.dbf RECID=19 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_03.dbf RECID=20 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_02.dbf RECID=21 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB.dbf RECID=22 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes02.dbf RECID=23 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes01.dbf RECID=24 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_web_files01.dbf RECID=25 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_web_indexes01.dbf RECID=26 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_work_files01.dbf RECID=27 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_work_indexes01.dbf RECID=28 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB.dbf RECID=29 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_index011.dbf RECID=30 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYreftabs_data01.dbf RECID=31 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYreftabs_indexes01.dbf RECID=32 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYusers01.dbf RECID=33 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYaple_indexes01.dbf RECID=34 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data01.dbf RECID=35 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_06.dbf RECID=36 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB_02.dbf RECID=37 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data02.dbf RECID=38 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_07.dbf RECID=39 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYuser_security_data01.dbf RECID=40 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYuser_security_indexes01.dbf RECID=41 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes03.dbf RECID=42 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_08.dbf RECID=43 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_08.dbf RECID=44 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_indexes.dbf RECID=45 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYmcs_data01.dbf RECID=46 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYmcs_indexes01.dbf RECID=47 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYcalsoap_data01.dbf RECID=48 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYcalsoap_indexes01.dbf RECID=49 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_09.dbf RECID=50 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYsystem02.dbf RECID=51 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_10.dbf RECID=52 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_11.dbf RECID=53 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYda_data01.dbf RECID=54 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYda_data02.dbf RECID=55 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrant_tmp_data01.dbf RECID=56 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data03.dbf RECID=57 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_09.dbf RECID=58 STAMP=957532933

datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYundotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYsysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYaple_data01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYarchive_data01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYarchive_indexes01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYdmdba_audit.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYfoster_data01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYfoster_indexes01.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_07.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_06.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_05.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_04.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=13 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_03.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=14 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_02.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=15 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=16 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes02.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=17 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes01.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=18 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_05.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=19 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_04.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=20 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_03.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=21 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_02.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=22 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=23 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes02.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=24 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes01.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=25 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_web_files01.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=26 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_web_indexes01.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=27 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_work_files01.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=28 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_work_indexes01.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=29 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=30 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_index011.dbf
datafile 32 switched to datafile copy
input datafile copy RECID=31 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYreftabs_data01.dbf
datafile 33 switched to datafile copy
input datafile copy RECID=32 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYreftabs_indexes01.dbf
datafile 34 switched to datafile copy
input datafile copy RECID=33 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYusers01.dbf
datafile 35 switched to datafile copy
input datafile copy RECID=34 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYaple_indexes01.dbf
datafile 36 switched to datafile copy
input datafile copy RECID=35 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data01.dbf
datafile 37 switched to datafile copy
input datafile copy RECID=36 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_06.dbf
datafile 38 switched to datafile copy
input datafile copy RECID=37 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB_02.dbf
datafile 39 switched to datafile copy
input datafile copy RECID=38 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data02.dbf
datafile 40 switched to datafile copy
input datafile copy RECID=39 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_07.dbf
datafile 41 switched to datafile copy
input datafile copy RECID=40 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYuser_security_data01.dbf
datafile 42 switched to datafile copy
input datafile copy RECID=41 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYuser_security_indexes01.dbf
datafile 43 switched to datafile copy
input datafile copy RECID=42 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes03.dbf
datafile 44 switched to datafile copy
input datafile copy RECID=43 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_08.dbf
datafile 45 switched to datafile copy
input datafile copy RECID=44 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_08.dbf
datafile 46 switched to datafile copy
input datafile copy RECID=45 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_indexes.dbf
datafile 47 switched to datafile copy
input datafile copy RECID=46 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYmcs_data01.dbf
datafile 48 switched to datafile copy
input datafile copy RECID=47 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYmcs_indexes01.dbf
datafile 49 switched to datafile copy
input datafile copy RECID=48 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYcalsoap_data01.dbf
datafile 50 switched to datafile copy
input datafile copy RECID=49 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYcalsoap_indexes01.dbf
datafile 51 switched to datafile copy
input datafile copy RECID=50 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_09.dbf
datafile 52 switched to datafile copy
input datafile copy RECID=51 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYsystem02.dbf
datafile 53 switched to datafile copy
input datafile copy RECID=52 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_10.dbf
datafile 54 switched to datafile copy
input datafile copy RECID=53 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_11.dbf
datafile 55 switched to datafile copy
input datafile copy RECID=54 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYda_data01.dbf
datafile 56 switched to datafile copy
input datafile copy RECID=55 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYda_data02.dbf
datafile 57 switched to datafile copy
input datafile copy RECID=56 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrant_tmp_data01.dbf
datafile 58 switched to datafile copy
input datafile copy RECID=57 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data03.dbf
datafile 59 switched to datafile copy
input datafile copy RECID=58 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_09.dbf

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

database opened
Finished Duplicate Db at 16-APR-18

RMAN>

---

Check the Database

[oracle@dmdba-rnd trace]$ sqlplus “/ as sysdba”

SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 16 13:24:13 2018

Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name,open_mode from v$database;

NAME OPEN_MODE
——— ——————–
PRODCOPY READ WRITE

SQL> select count(*),online_status from dba_data_files group by online_status;

COUNT(*) ONLINE_
———- ——-
57 ONLINE
2 SYSTEM