9 Migrating the EBS 12.2.14 Database 12c to ASM (19c Grid)

 

9.1       19c Grid Installation Standalone on Linux 8

9.1.1     Download the 19c Grid software 





9.1.2     Create user oraasm for grid home. dba group was already present on my server. If it is not present, please create it.



useradd -g dba -c "ASM user" -d /home/oraasm -s /bin/bash oraasm
useradd -g oinstall -c "ASM user" -d /home/oraasm -s /bin/bash oraasm
uid=54323(oraasm) gid=54322(dba) groups=54322(dba),54321(oinstall)



9.1.3     I will create disk for ASM but not using oracleasm utility but using udev.


Udev is the mechanism used to create and name /dev device nodes corresponding to the devices that are present in the system. Udev uses matching information provided by sysfs with rules provided by the user to dynamically add the required device nodes.

 

9.1.3.1      Attach a raw disk to the server.

 

9.1.3.2      Use lsblk or fdisk -l command to find the new added disk names.

 

example:

 

/dev/sdg
/dev/sde
/dev/sdf
/dev/sdc
/dev/sdd

 

9.1.3.3      Find the ID_Serial for each associated disk, if we directly use the disk name it might get chnaged after the server reboot.

 

udevadm info --query=property /dev/sdg
udevadm info --query=property /dev/sde
udevadm info --query=property /dev/sdf
udevadm info --query=property /dev/sdc
udevadm info --query=property /dev/sdd

 

9.1.3.4      Asmdevices rules

Go to cd /etc/udev/rules.d directory and add the new disk details in file 99-oracle-asmdevices.rules as below. Make sure to update ID_SERIAL with your correct value and disk owner and group should be correct based on the env. Also I will give a virtual name/symbolink for eash disk as oraasm01/02/03 etc.

 

 

ACTION=="add|change", SUBSYSTEM=="block", ENV{ID_SERIAL}=="36000c297a90d6a9681b1d2a5a1b88568", GROUP="dba", SYMLINK+="oraasm01",OWNER="oraasm", MODE="0660"
ACTION=="add|change", SUBSYSTEM=="block", ENV{ID_SERIAL}=="36000c29906aa418e9822a0947ce9ad22", GROUP="dba", SYMLINK+="oraasm02",OWNER="oraasm", MODE="0660"
ACTION=="add|change", SUBSYSTEM=="block", ENV{ID_SERIAL}=="36000c291823fef46b990dbc1fe7bebdf", GROUP="dba", SYMLINK+="oraasm03",OWNER="oraasm", MODE="0660"
ACTION=="add|change", SUBSYSTEM=="block", ENV{ID_SERIAL}=="36000c2944397980b1b7f91a3d0c99e56", GROUP="dba", SYMLINK+="oraasm04",OWNER="oraasm", MODE="0660"
ACTION=="add|change", SUBSYSTEM=="block", ENV{ID_SERIAL}=="36000c2954d200a2927a1e815945e603d", GROUP="dba", SYMLINK+="oraasm05",OWNER="oraasm", MODE="0660"

 

9.1.3.5      Reload the udev rules to identify the new disks.

 

udevadm control --reload-rules
udevadm trigger --type=devices --action=change

 

 

Note:

# #OL5

# /sbin/udevcontrol reload_rules

 

# #OL6 and OL7

# udevadm control --reload-rules

 

# #OL5 and OL6 : Not needed for OL7 or OL8

# /sbin/start_udev

 

9.1.3.6     Verify the disk permissions and permissions

 

ls -l /dev/oraasm05
ls -l /dev/oraasm03
ls -l /dev/oraasm04
ls -l /dev/oraasm01
ls -l /dev/oraasm02

 

9.1.3.7      Make sure the ASM disk string should be set as  asm_diskstring='/dev/ora*' to identify the disks.

 

9.1.3.8      Attach the new disks to the diskgroup in asm now.

 

alter diskgroup TEST add disk '/dev/oraasm01' rebalance power 5;

 

Example:

 

SQL> set pages 40000 lines 120
col PATH for a30
select DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,PATH FROM V$ASM_DISK;
SQL> 
DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE    PATH
----------- ------- ------------ ------- -------- ------------------------------
          4 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm05
          2 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm03
          3 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm04
          0 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm01
          1 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm02



9.1.4     Verify the disk now.

[root@fbstest rules.d]# ls -ltr /dev/ora*
lrwxrwxrwx. 1 root root 3 Feb 15 18:53 /dev/oraasm01 -> sdc

 

 

9.1.5     Make a directory Structure or mount point  for grid installation

 

Connect as oraasm (My Grid OS user which will be used for installation)

 

9.1.6     Grid home

[oraasm@fbstest oraapps122]$ mkdir -p /u01/app/FBS/db/grid19c

 

 

9.1.7     Copy the grid software zip file on the path.

 

 

[oraasm@fbstest grid19c]$ cp /tmp/LINUX.X64_193000_grid_home.zip /u01/app/FBS/db/grid19c/

 

 

9.1.8     Install pre-req for 19c on server from root user

 

yum search preinstall
 
yum install oracle-database-preinstall-19c.x86_64 -y

 

9.1.9     Unzip the grid software and remove the zip file then

 

[oraasm@fbstest grid19c]$ cd /u01/app/FBS/db/grid19c
[oraasm@fbstest grid19c]$ unzip LINUX.X64_193000_grid_home.zip





9.1.10                             Install the cvu disk package from the unzip grid software from root user

 

rpm -ivh /u01/app/FBS/db/grid19c/cv/rpm/cvuqdisk-1.0.10-1.rpm





Preparing...                          ################################# [100%]
Updating / installing...
   1:cvuqdisk-1.0.10-1                ################################# [100%]

 

 

9.1.11                             Launch the grid installer (gridSetup.sh) from oraasm user

 

/u01/app/FBS/db/grid19c/gridSetup.sh





 

Click Next

 

Give DISK group name as EBS_DATA

Set Redundancy as external

Set the Discovery path as /dev/ora*

 

 



 

Make sue you can see new  disk which we created in earlier steps


 

Click Next

 



 

Click Yes and Continue

 



 




No Action required , click next

 



 

 

Click Next

 

For below warning click Yes

 



 

Click the path where to create the GRID Base

 



 

Click Next

 



 

 

I will take a backup of my inventory as other oracle products are also installed. If you are doing new, this will not occur.

 

[root@fbstest oracle]# pwd
/oraapps122/oracle
[root@fbstest oracle]# cp -r oraInventory oraInventory_bkp
 chmod -R 777 oraInventory

 

Click OK and Continue.

 




Click Next

 



 


Install Summary.

 



 

Click Install

 



 

Run Below script as root.

 



 

[root@fbstest oracle]# /u01/app/FBS/db/grid19c/root.sh
Performing root user operation.





The following environment variables are set as:
    ORACLE_OWNER= oraasm
    ORACLE_HOME=  /u01/app/FBS/db/grid19c





Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...





Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/FBS/db/grid19c/crs/install/crsconfig_params
The log of current session can be found at:
  /oraapps122/app/ASM19c/crsdata/fbstest/crsconfig/roothas_2022-02-15_09-32-52PM.log
LOCAL ADD MODE
Creating OCR keys for user 'oraasm', privgrp 'dba'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node fbstest successfully pinned.
2022/02/15 21:33:41 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'





fbstest     2022/02/15 21:36:06     /oraapps122/app/ASM19c/crsdata/fbstest/olr/backup_20220215_213606.olr     724960844
2022/02/15 21:36:12 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

 

 

Once root.sh is done ,click  ok to completed the installation. 

 



 

Installation Successfull

 

9.1.12                             Login to oraasm and validate

[oraasm@fbstest ~]$ . oraenv
ORACLE_SID = [oraasm] ? +ASM
The Oracle base has been set to /oraapps122/app/ASM19c
[oraasm@fbstest ~]$ echo $ORACLE_HOME
/u01/app/FBS/db/grid19c





[oraasm@fbstest ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.EBS_DATA.dg
               ONLINE  ONLINE       fbstest                STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       fbstest                STABLE
ora.asm
               ONLINE  ONLINE       fbstest                Started,STABLE
ora.ons
               OFFLINE OFFLINE      fbstest                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       fbstest                STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       fbstest                STABLE
--------------------------------------------------------------------------------





[oraasm@fbstest ~]$ asmcmd
ASMCMD> lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512             512   4096  4194304    122880   122780                0          122780              0             N  EBS_DATA/

9.2       Check the Location of the Parameter File, Control file, Temp files, Redo Log files

show parameter pfile
select name from v$controlfile;
select name from V$datafile;
select name from v$tempfile;
select  member from v$logfile;

 

9.3       Make sure you have the diskgroup.

 

I have already created a diskgroup name as EBS_DATA

 



9.4       Create ASM password(if not done or present) file to take a new name with actual path. Use -f to force create the file otherwise the command will say already file exists. Also make sure password is complex.

 

[oraasm@fbstest ~]$ asmcmd pwcreate --asm '+EBS_DATA/orapwasm'
Enter password: ********
OPW-00010: Could not create the password file. A password file with this name is present.
 
ASMCMD-9454: could not create new password file
[oraasm@fbstest ~]$ asmcmd pwcreate --asm '+EBS_DATA/orapwasm' -f
Enter password: ********
[oraasm@fbstest ~]$ 
[oraasm@fbstest ~]$ asmcmd pwget --asm
+EBS_DATA/orapwasm





sqlplus / as sysasm
 
SQL> alter system flush PASSWORDFILE_METADATA_CACHE;

 

 

Compare permissions of GRID home and database home

 

ls -lhrt $GRID_HOME/bin/oracle
ls -lhrt $ORACLE_HOME/bin/oracle





across the cluster, make sure that permissions on oracle binary are identical on each node. For example, GRID_HOME oracle permission should be 6751





To correct the permission, as owner of oracle binary:





cd $GRID_HOME/bin
chmod 6751 oracle

 

From DB home register to srvctl

 

[oracle@fbstest trace]$ cd $ORACLE_HOME/bin
[oracle@fbstest bin]$ srvctl add database -d FBS -o /u01/app/FBS/db/tech_st/12.1.0

 

9.5  Add ASM entry in tnsnames.ora ifile on Database

 

 cat /u01/app/FBS/db/tech_st/12.1.0/network/admin/FBS_fbstest/FBS_fbstest_ifile.ora
+ASM=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = fbstest.finsys.co.ke)(PORT = 1521)))(CONNECT_DATA =(ORACLE_SID = +ASM)))

 

9.6       Change the location of control_files,db_create_file_dest

 

SYS@FBS >alter system set control_files='+EBS_DATA' scope=spfile;





System altered.










SYS@FBS >alter system set db_create_file_dest='+EBS_DATA'  scope=spfile;





System altered.





SYS@FBS >alter system set db_recovery_file_dest='+EBS_DATA' scope=spfile;  -->optional if using





System altered.

 

9.7       Shutdown database and start in nomount

 

SYS@FBS >shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@FBS >startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.





Total System Global Area 2147483648 bytes
Fixed Size                  2926472 bytes
Variable Size             788531320 bytes
Database Buffers         1342177280 bytes
Redo Buffers               13848576 bytes

 

9.8       Restore Control file from file system  to ASM. If multiple control file, pick any one.

 

RMAN> restore controlfile from '/u01/app/FBS/db/apps_st/data/cntrl01.dbf';





Starting restore at 18-FEB-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=204 device type=DISK





channel ORA_DISK_1: copied control file copy
output file name=+EBS_DATA/FBS/CONTROLFILE/current.259.1096979313
Finished restore at 18-FEB-22
 

 

9.9       Mount database and copy datafile from filesystem to ASM. This I am doing in EBS database(100 GB size) so it will take time.

 

RMAN> alter database mount;





Statement processed
released channel: ORA_DISK_1










RMAN> backup as copy database format '+EBS_DATA';
 
Starting backup at 18-FEB-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=204 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00014 name=/u01/app/FBS/db/apps_st/data/a_txn_data04.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.260.1096979491 tag=TAG20220218T123128 RECID=59 STAMP=1096979606
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:06
channel ORA_DISK_1: starting datafile copy
input datafile file number=00019 name=/u01/app/FBS/db/apps_st/data/system13.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.261.1096979615 tag=TAG20220218T123128 RECID=60 STAMP=1096979658
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00020 name=/u01/app/FBS/db/apps_st/data/system14.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.262.1096979661 tag=TAG20220218T123128 RECID=61 STAMP=1096979701
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00021 name=/u01/app/FBS/db/apps_st/data/system15.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.263.1096979707 tag=TAG20220218T123128 RECID=62 STAMP=1096979749
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00022 name=/u01/app/FBS/db/apps_st/data/system16.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.264.1096979753 tag=TAG20220218T123128 RECID=63 STAMP=1096979786
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00023 name=/u01/app/FBS/db/apps_st/data/system17.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.265.1096979789 tag=TAG20220218T123128 RECID=64 STAMP=1096979832
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00024 name=/u01/app/FBS/db/apps_st/data/system18.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.266.1096979833 tag=TAG20220218T123128 RECID=65 STAMP=1096979873
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00025 name=/u01/app/FBS/db/apps_st/data/system19.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.267.1096979879 tag=TAG20220218T123128 RECID=66 STAMP=1096979924
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00026 name=/u01/app/FBS/db/apps_st/data/system20.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.268.1096979925 tag=TAG20220218T123128 RECID=67 STAMP=1096979961
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00027 name=/u01/app/FBS/db/apps_st/data/system21.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.269.1096979971 tag=TAG20220218T123128 RECID=68 STAMP=1096980012
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00028 name=/u01/app/FBS/db/apps_st/data/system22.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.270.1096980017 tag=TAG20220218T123128 RECID=69 STAMP=1096980048
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00029 name=/u01/app/FBS/db/apps_st/data/system23.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.271.1096980051 tag=TAG20220218T123128 RECID=70 STAMP=1096980093
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00030 name=/u01/app/FBS/db/apps_st/data/system24.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.272.1096980097 tag=TAG20220218T123128 RECID=71 STAMP=1096980126
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00031 name=/u01/app/FBS/db/apps_st/data/system25.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.273.1096980133 tag=TAG20220218T123128 RECID=72 STAMP=1096980174
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00032 name=/u01/app/FBS/db/apps_st/data/a_ref04.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_seed.274.1096980179 tag=TAG20220218T123128 RECID=73 STAMP=1096980209
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00033 name=/u01/app/FBS/db/apps_st/data/a_ref05.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_seed.275.1096980215 tag=TAG20220218T123128 RECID=74 STAMP=1096980257
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00034 name=/u01/app/FBS/db/apps_st/data/a_ref06.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_seed.276.1096980259 tag=TAG20220218T123128 RECID=75 STAMP=1096980291
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00379 name=/u01/app/FBS/db/apps_st/data/undo01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_undots1.277.1096980295 tag=TAG20220218T123128 RECID=76 STAMP=1096980344
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00406 name=/u01/app/FBS/db/apps_st/data/a_txn_ind05.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.278.1096980351 tag=TAG20220218T123128 RECID=77 STAMP=1096980387
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00353 name=/u01/app/FBS/db/apps_st/data/system08.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.279.1096980397 tag=TAG20220218T123128 RECID=78 STAMP=1096980436
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00392 name=/u01/app/FBS/db/apps_st/data/a_txn_data01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.280.1096980443 tag=TAG20220218T123128 RECID=79 STAMP=1096980478
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00405 name=/u01/app/FBS/db/apps_st/data/a_txn_ind04.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.281.1096980489 tag=TAG20220218T123128 RECID=80 STAMP=1096980533
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00404 name=/u01/app/FBS/db/apps_st/data/a_txn_ind03.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.282.1096980543 tag=TAG20220218T123128 RECID=81 STAMP=1096980574
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00400 name=/u01/app/FBS/db/apps_st/data/a_media01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_media.283.1096980579 tag=TAG20220218T123128 RECID=82 STAMP=1096980621
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00401 name=/u01/app/FBS/db/apps_st/data/a_txn_data02.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.284.1096980625 tag=TAG20220218T123128 RECID=83 STAMP=1096980651
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00013 name=/u01/app/FBS/db/apps_st/data/system12.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.285.1096980661 tag=TAG20220218T123128 RECID=84 STAMP=1096980694
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00403 name=/u01/app/FBS/db/apps_st/data/a_txn_ind02.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.286.1096980697 tag=TAG20220218T123128 RECID=85 STAMP=1096980730
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:36
channel ORA_DISK_1: starting datafile copy
input datafile file number=00352 name=/u01/app/FBS/db/apps_st/data/system09.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.287.1096980731 tag=TAG20220218T123128 RECID=86 STAMP=1096980767
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00394 name=/u01/app/FBS/db/apps_st/data/a_ref01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_seed.288.1096980777 tag=TAG20220218T123128 RECID=87 STAMP=1096980808
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00402 name=/u01/app/FBS/db/apps_st/data/a_txn_data03.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.289.1096980813 tag=TAG20220218T123128 RECID=88 STAMP=1096980843
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00354 name=/u01/app/FBS/db/apps_st/data/system11.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.290.1096980849 tag=TAG20220218T123128 RECID=89 STAMP=1096980867
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00407 name=/u01/app/FBS/db/apps_st/data/a_ref02.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_seed.291.1096980873 tag=TAG20220218T123128 RECID=90 STAMP=1096980898
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00396 name=/u01/app/FBS/db/apps_st/data/a_summ01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_summary.292.1096980899 tag=TAG20220218T123128 RECID=91 STAMP=1096980919
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00393 name=/u01/app/FBS/db/apps_st/data/a_txn_ind01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.293.1096980925 tag=TAG20220218T123128 RECID=92 STAMP=1096980947
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00015 name=/u01/app/FBS/db/apps_st/data/a_txn_ind06.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.294.1096980951 tag=TAG20220218T123128 RECID=93 STAMP=1096980981
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00395 name=/u01/app/FBS/db/apps_st/data/a_int01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_interface.295.1096980987 tag=TAG20220218T123128 RECID=94 STAMP=1096981003
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00288 name=/u01/app/FBS/db/apps_st/data/system10.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.296.1096981011 tag=TAG20220218T123128 RECID=95 STAMP=1096981036
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/FBS/db/apps_st/data/system01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.297.1096981037 tag=TAG20220218T123128 RECID=96 STAMP=1096981058
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/FBS/db/apps_st/data/system02.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.298.1096981063 tag=TAG20220218T123128 RECID=97 STAMP=1096981080
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/FBS/db/apps_st/data/system03.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.299.1096981089 tag=TAG20220218T123128 RECID=98 STAMP=1096981109
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/FBS/db/apps_st/data/system04.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.300.1096981115 tag=TAG20220218T123128 RECID=99 STAMP=1096981130
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u01/app/FBS/db/apps_st/data/system05.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.301.1096981141 tag=TAG20220218T123128 RECID=100 STAMP=1096981156
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=/u01/app/FBS/db/apps_st/data/sysaux01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/sysaux.302.1096981165 tag=TAG20220218T123128 RECID=101 STAMP=1096981187
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00018 name=/u01/app/FBS/db/apps_st/data/sysaux02.dbf
output file name=+EBS_DATA/FBS/DATAFILE/sysaux.303.1096981191 tag=TAG20220218T123128 RECID=102 STAMP=1096981208
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00035 name=/u01/app/FBS/db/apps_st/data/undo02.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_undots1.304.1096981217 tag=TAG20220218T123128 RECID=103 STAMP=1096981233
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00398 name=/u01/app/FBS/db/apps_st/data/a_archive01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_archive.305.1096981243 tag=TAG20220218T123128 RECID=104 STAMP=1096981261
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00295 name=/u01/app/FBS/db/apps_st/data/system06.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.306.1096981267 tag=TAG20220218T123128 RECID=105 STAMP=1096981279
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00351 name=/u01/app/FBS/db/apps_st/data/system07.dbf
output file name=+EBS_DATA/FBS/DATAFILE/system.307.1096981283 tag=TAG20220218T123128 RECID=106 STAMP=1096981295
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00016 name=/u01/app/FBS/db/apps_st/data/a_ref03.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_seed.308.1096981299 tag=TAG20220218T123128 RECID=107 STAMP=1096981307
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=/u01/app/FBS/db/apps_st/data/a_queue02.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_queues.309.1096981315 tag=TAG20220218T123128 RECID=108 STAMP=1096981325
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00012 name=/u01/app/FBS/db/apps_st/data/apps_ts_tools01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_tools.310.1096981331 tag=TAG20220218T123128 RECID=109 STAMP=1096981338
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00399 name=/u01/app/FBS/db/apps_st/data/a_queue01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_queues.311.1096981345 tag=TAG20220218T123128 RECID=110 STAMP=1096981354
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00314 name=/u01/app/FBS/db/apps_st/data/portal01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/portal.312.1096981361 tag=TAG20220218T123128 RECID=111 STAMP=1096981363
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00397 name=/u01/app/FBS/db/apps_st/data/a_nolog01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_nologging.313.1096981365 tag=TAG20220218T123128 RECID=112 STAMP=1096981366
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/u01/app/FBS/db/apps_st/data/ctxd01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/ctxd.314.1096981369 tag=TAG20220218T123128 RECID=113 STAMP=1096981369
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=+EBS_DATA/FBS/CONTROLFILE/backup.315.1096981371 tag=TAG20220218T123128 RECID=114 STAMP=1096981376
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00010 name=/u01/app/FBS/db/apps_st/data/olap.dbf
output file name=+EBS_DATA/FBS/DATAFILE/olap.316.1096981379 tag=TAG20220218T123128 RECID=115 STAMP=1096981380
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00017 name=/u01/app/FBS/db/apps_st/data/a_int02.dbf
output file name=+EBS_DATA/FBS/DATAFILE/apps_ts_interface.317.1096981383 tag=TAG20220218T123128 RECID=116 STAMP=1096981383
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00009 name=/u01/app/FBS/db/apps_st/data/odm.dbf
output file name=+EBS_DATA/FBS/DATAFILE/odm.318.1096981385 tag=TAG20220218T123128 RECID=117 STAMP=1096981385
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/u01/app/FBS/db/apps_st/data/owad01.dbf
output file name=+EBS_DATA/FBS/DATAFILE/owapub.319.1096981387 tag=TAG20220218T123128 RECID=118 STAMP=1096981386
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 18-FEB-22
channel ORA_DISK_1: finished piece 1 at 18-FEB-22
piece handle=+EBS_DATA/FBS/BACKUPSET/2022_02_18/nnsnf0_tag20220218t123128_0.320.1096981387 tag=TAG20220218T123128 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 18-FEB-22

 

 

 

9.10      Switch database to copy on ASM which will update control file as well.



RMAN> switch database to copy;
 
datafile 1 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.297.1096981037"
datafile 2 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.298.1096981063"
datafile 3 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.299.1096981089"
datafile 4 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.300.1096981115"
datafile 5 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.301.1096981141"
datafile 6 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/ctxd.314.1096981369"
datafile 7 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/owapub.319.1096981387"
datafile 8 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_queues.309.1096981315"
datafile 9 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/odm.318.1096981385"
datafile 10 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/olap.316.1096981379"
datafile 11 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/sysaux.302.1096981165"
datafile 12 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_tools.310.1096981331"
datafile 13 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.285.1096980661"
datafile 14 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.260.1096979491"
datafile 15 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.294.1096980951"
datafile 16 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_seed.308.1096981299"
datafile 17 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_interface.317.1096981383"
datafile 18 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/sysaux.303.1096981191"
datafile 19 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.261.1096979615"
datafile 20 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.262.1096979661"
datafile 21 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.263.1096979707"
datafile 22 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.264.1096979753"
datafile 23 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.265.1096979789"
datafile 24 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.266.1096979833"
datafile 25 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.267.1096979879"
datafile 26 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.268.1096979925"
datafile 27 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.269.1096979971"
datafile 28 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.270.1096980017"
datafile 29 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.271.1096980051"
datafile 30 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.272.1096980097"
datafile 31 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.273.1096980133"
datafile 32 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_seed.274.1096980179"
datafile 33 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_seed.275.1096980215"
datafile 34 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_seed.276.1096980259"
datafile 35 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_undots1.304.1096981217"
datafile 288 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.296.1096981011"
datafile 295 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.306.1096981267"
datafile 314 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/portal.312.1096981361"
datafile 351 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.307.1096981283"
datafile 352 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.287.1096980731"
datafile 353 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.279.1096980397"
datafile 354 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/system.290.1096980849"
datafile 379 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_undots1.277.1096980295"
datafile 392 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.280.1096980443"
datafile 393 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.293.1096980925"
datafile 394 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_seed.288.1096980777"
datafile 395 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_interface.295.1096980987"
datafile 396 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_summary.292.1096980899"
datafile 397 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_nologging.313.1096981365"
datafile 398 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_archive.305.1096981243"
datafile 399 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_queues.311.1096981345"
datafile 400 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_media.283.1096980579"
datafile 401 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.284.1096980625"
datafile 402 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.289.1096980813"
datafile 403 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.286.1096980697"
datafile 404 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.282.1096980543"
datafile 405 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.281.1096980489"
datafile 406 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.278.1096980351"
datafile 407 switched to datafile copy "+EBS_DATA/FBS/DATAFILE/apps_ts_seed.291.1096980873"

 

 

9.11      Migrate temp file to ASM



RMAN> run{
set newname for tempfile '/u01/app/FBS/db/apps_st/data/temp01.dbf' to '+EBS_DATA';
set newname for tempfile '/u01/app/FBS/db/apps_st/data/temp02.dbf' to '+EBS_DATA';
set newname for tempfile '/u01/app/FBS/db/apps_st/data/temp0001.dbf' to '+EBS_DATA';
switch tempfile all;
2> 3> 4> 5> 6> }





executing command: SET NEWNAME





executing command: SET NEWNAME





executing command: SET NEWNAME





renamed tempfile 1 to +EBS_DATA in control file
renamed tempfile 2 to +EBS_DATA in control file
renamed tempfile 3 to +EBS_DATA in control file

 

9.12      Open the database

 

RMAN> alter database open;





Statement processed
 

9.13      Validate the Control files, temp files and datafiles;



SYS@FBS >select name from v$controlfile;





+EBS_DATA/FBS/CONTROLFILE/current.259.1096979313





SYS@FBS >select name from v$datafile;





+EBS_DATA/FBS/DATAFILE/system.297.1096981037
+EBS_DATA/FBS/DATAFILE/system.298.1096981063
+EBS_DATA/FBS/DATAFILE/system.299.1096981089
+EBS_DATA/FBS/DATAFILE/system.300.1096981115
+EBS_DATA/FBS/DATAFILE/system.301.1096981141
+EBS_DATA/FBS/DATAFILE/ctxd.314.1096981369
+EBS_DATA/FBS/DATAFILE/owapub.319.1096981387
+EBS_DATA/FBS/DATAFILE/apps_ts_queues.309.1096981315
+EBS_DATA/FBS/DATAFILE/odm.318.1096981385
+EBS_DATA/FBS/DATAFILE/olap.316.1096981379
+EBS_DATA/FBS/DATAFILE/sysaux.302.1096981165
+EBS_DATA/FBS/DATAFILE/apps_ts_tools.310.1096981331
+EBS_DATA/FBS/DATAFILE/system.285.1096980661
+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.260.1096979491
+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.294.1096980951
+EBS_DATA/FBS/DATAFILE/apps_ts_seed.308.1096981299
+EBS_DATA/FBS/DATAFILE/apps_ts_interface.317.1096981383
+EBS_DATA/FBS/DATAFILE/sysaux.303.1096981191
+EBS_DATA/FBS/DATAFILE/system.261.1096979615
+EBS_DATA/FBS/DATAFILE/system.262.1096979661
+EBS_DATA/FBS/DATAFILE/system.263.1096979707
+EBS_DATA/FBS/DATAFILE/system.264.1096979753
+EBS_DATA/FBS/DATAFILE/system.265.1096979789
+EBS_DATA/FBS/DATAFILE/system.266.1096979833
+EBS_DATA/FBS/DATAFILE/system.267.1096979879
+EBS_DATA/FBS/DATAFILE/system.268.1096979925
+EBS_DATA/FBS/DATAFILE/system.269.1096979971
+EBS_DATA/FBS/DATAFILE/system.270.1096980017
+EBS_DATA/FBS/DATAFILE/system.271.1096980051
+EBS_DATA/FBS/DATAFILE/system.272.1096980097
+EBS_DATA/FBS/DATAFILE/system.273.1096980133
+EBS_DATA/FBS/DATAFILE/apps_ts_seed.274.1096980179
+EBS_DATA/FBS/DATAFILE/apps_ts_seed.275.1096980215
+EBS_DATA/FBS/DATAFILE/apps_ts_seed.276.1096980259
+EBS_DATA/FBS/DATAFILE/apps_undots1.304.1096981217
+EBS_DATA/FBS/DATAFILE/system.296.1096981011
+EBS_DATA/FBS/DATAFILE/system.306.1096981267
+EBS_DATA/FBS/DATAFILE/portal.312.1096981361
+EBS_DATA/FBS/DATAFILE/system.307.1096981283
+EBS_DATA/FBS/DATAFILE/system.287.1096980731
+EBS_DATA/FBS/DATAFILE/system.279.1096980397
+EBS_DATA/FBS/DATAFILE/system.290.1096980849
+EBS_DATA/FBS/DATAFILE/apps_undots1.277.1096980295
+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.280.1096980443
+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.293.1096980925
+EBS_DATA/FBS/DATAFILE/apps_ts_seed.288.1096980777
+EBS_DATA/FBS/DATAFILE/apps_ts_interface.295.1096980987
+EBS_DATA/FBS/DATAFILE/apps_ts_summary.292.1096980899
+EBS_DATA/FBS/DATAFILE/apps_ts_nologging.313.1096981365
+EBS_DATA/FBS/DATAFILE/apps_ts_archive.305.1096981243
+EBS_DATA/FBS/DATAFILE/apps_ts_queues.311.1096981345
+EBS_DATA/FBS/DATAFILE/apps_ts_media.283.1096980579
+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.284.1096980625
+EBS_DATA/FBS/DATAFILE/apps_ts_tx_data.289.1096980813
+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.286.1096980697
+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.282.1096980543
+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.281.1096980489
+EBS_DATA/FBS/DATAFILE/apps_ts_tx_idx.278.1096980351
+EBS_DATA/FBS/DATAFILE/apps_ts_seed.291.1096980873





59 rows selected.





SYS@FBS >select name from v$tempfile;





+EBS_DATA/FBS/TEMPFILE/temp1.322.1096982783
+EBS_DATA/FBS/TEMPFILE/temp2.323.1096982785
+EBS_DATA/FBS/TEMPFILE/temp1.321.1096982783

 



9.14      Now I will move the redo log files



SYS@FBS >select GROUP#,THREAD#,SEQUENCE#,bytes/1024/1024 as "Size in MB",MEMBERS,STATUS from v$log;





    GROUP#    THREAD#  SEQUENCE# Size in MB    MEMBERS STATUS
---------- ---------- ---------- ---------- ---------- ----------------
         1          1         29       1000          2 CURRENT
         2          1         28       1000          2 INACTIVE

 

I will add one more log group as I have only 2 log groups.



SYS@FBS >ALTER DATABASE ADD LOGFILE ('+EBS_DATA','+EBS_DATA') size 1000M;










Database altered.





SYS@FBS >SYS@FBS >select GROUP#,THREAD#,SEQUENCE#,bytes/1024/1024 as "Size in MB",MEMBERS,STATUS from v$log;





    GROUP#    THREAD#  SEQUENCE# Size in MB    MEMBERS STATUS
---------- ---------- ---------- ---------- ---------- ----------------
         1          1         29       1000          2 CURRENT
         2          1         28       1000          2 INACTIVE
         3          1          0       1000          2 UNUSED





SYS@FBS >alter database drop logfile group 2;





Database altered.





SYS@FBS >ALTER DATABASE ADD LOGFILE ('+EBS_DATA','+EBS_DATA') size 1000M;





SYS@FBS >alter system switch logfile;





System altered.
 
SYS@FBS >alter database drop logfile group 1;





Database altered.





SYS@FBS >ALTER DATABASE ADD LOGFILE ('+EBS_DATA','+EBS_DATA') size 1000M;










Database altered.





SYS@FBS >select GROUP#,TYPE,MEMBER from v$logfile;





    GROUP# TYPE    MEMBER
---------- ------- --------------------------------------------------
         2 ONLINE  +EBS_DATA/FBS/ONLINELOG/group_2.324.1096983873
         2 ONLINE  +EBS_DATA/FBS/ONLINELOG/group_2.325.1096983901
         1 ONLINE  +EBS_DATA/FBS/ONLINELOG/group_1.326.1096984173
         1 ONLINE  +EBS_DATA/FBS/ONLINELOG/group_1.327.1096984207
         3 ONLINE  +EBS_DATA/FBS/ONLINELOG/group_3.258.1096983689
         3 ONLINE  +EBS_DATA/FBS/ONLINELOG/group_3.257.1096983723





6 rows selected.

 

So now redo are also migrated.





All our files are migrated.



Login to EBS application and validate





Refer:

Oracle Clusterware (CRS/GI) - ASM - Database Version Compatibility (Doc ID 337737.1)


No comments:

Post a Comment

Subscribe to: Posts (Atom)