Oracle Certified Master's - Blogs: September 2015

Migration: Oracle Enterprise Manager Cloud Control 12c R5

Moving Oracle Management Repository (OMR) to New Server (11.2.0.4.6 - PSU)

Today's demonstration is for data center migration from one location to other location, where we have to plan migrate our existing setup to new environment. In our environment we have Oracle Enterprise Manger Cloud Control - Release 5 (OEM12c - R5) having management repository 11.2.0.4.6 (PSU) applied.

In first phase we are planning to all management repository to new environment. In order to achieve this task we are following one approach in list of below.

1. RMAN Backup restoration and recovery

2. Export and Import

3. Data Guard with broker

4. Cold Backup

In this demonstration I am using approach 1 which is RMAN Backup restoration and recovery.

In our next post I will do this with the help of data guard which is coming soon.

In Second phase we will migrate our existing management server to new environment in next post.

We are considering that we have taken Level 0 RMAN backup and redo archive log till level 0 backup.

Source Repository Server : rac126.ora.com

Target Repository Server : rac127.ora.com

Oracle Management Server : oem250.ora.com

Process will be looking for the "emkey". This key needs to be placed inside the database so it can be referenced during the Migration. If not available, then we will face issue during process.

After that we will take RMAN level 0 backup from existing repository server.

[oracle@oem250 config]$ emctl status emkey

Oracle Enterprise Manager Cloud Control 12c Release 5

Enter Enterprise Manager Root (SYSMAN) Password :

The EMKey is configured properly.

[oracle@oem250 config]$ emctl config emkey -copy_to_repos

Oracle Enterprise Manager Cloud Control 12c Release 5

Enter Enterprise Manager Root (SYSMAN) Password :

The EMKey has been copied to the Management Repository. This operation will cause the EMKey to become unsecure.

After the required operation has been completed, secure the EMKey by running "emctl config emkey -remove_from_repos".

Now Stop OMS and management agent on OMS Server. Here do not use "all" option while stopping OMS.

[oracle@oem250 bin]$ emctl stop oms

Oracle Enterprise Manager Cloud Control 12c Release 5

Stopping WebTier...

WebTier Successfully Stopped

Stopping Oracle Management Server...

Oracle Management Server Successfully Stopped

Oracle Management Server is Down

[oracle@oem250 bin]$ emctl stop agent

Oracle Enterprise Manager Cloud Control 12c Release 5

Stopping agent ..... stopped.

[oracle@oem250 bin]$

After shutdown the OMS and management Agent we will start database backup restoration on Target Repository Server

Create necessary directory on target database "rac127"

mkdir -p /u01/app/oracle/admin/EMREP12C/adump

mkdir -p /u01/app/oracle/fast_recovery_area/EMREP12C/

mkdir -p /u01/app/oracle/oradata/EMREP12C/

Go the backup location where Level 0 backup and archivelog. Set the environment for new database and put database in nomount and restore spfile , and then after restore controlfile, catalog backup and start restoration and recovery and open database in resetlogs.

RMAN> startup force nomount

Oracle instance started

Total System Global Area 2137886720 bytes

Fixed Size 2254952 bytes

Variable Size 1493174168 bytes

Database Buffers 637534208 bytes

Redo Buffers 4923392 bytes

RMAN> restore controlfile from '/Shared_NAS/BACKUP/EMREP12c/control_c-3728288860-20150909-00' ;

Starting restore at 26-SEP-15

using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/u01/app/oracle/oradata/EMREP12C/control01.ctl

output file name=/u01/app/oracle/fast_recovery_area/EMREP12C/control02.ctl

Finished restore at 26-SEP-15

RMAN> alter database mount ;

database mounted

released channel: ORA_DISK_1

RMAN> catalog start with '/Shared_NAS/BACKUP/EMREP12c/' ;

Starting implicit crosscheck backup at 26-SEP-15

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=21 device type=DISK

Crosschecked 3 objects

Finished implicit crosscheck backup at 26-SEP-15

Starting implicit crosscheck copy at 26-SEP-15

using channel ORA_DISK_1

Crosschecked 2 objects

Finished implicit crosscheck copy at 26-SEP-15

searching for all files in the recovery area

cataloging files...

no files cataloged

searching for all files that match the pattern /Shared_NAS/BACKUP/EMREP12c/

List of Files Unknown to the Database

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

File Name: /Shared_NAS/BACKUP/EMREP12c/control_c-3728288860-20150909-00

File Name: /Shared_NAS/BACKUP/EMREP12c/ARCHIVELOG/o1_mf_1_195_byyqz2vh_.arc

File Name: /Shared_NAS/BACKUP/EMREP12c/ARCHIVELOG/o1_mf_1_197_byyr0d1s_.arc

File Name: /Shared_NAS/BACKUP/EMREP12c/ARCHIVELOG/o1_mf_1_196_byyr0cqv_.arc

File Name: /Shared_NAS/BACKUP/EMREP12c/ARCHIVELOG/o1_mf_1_198_byys39v2_.arc

File Name: /Shared_NAS/BACKUP/EMREP12c/ARCHIVELOG/o1_mf_1_194_byx5q8wd_.arc

File Name: /Shared_NAS/BACKUP/EMREP12c/ARCHIVELOG/o1_mf_1_193_byvgxqsh_.arc

File Name: /Shared_NAS/BACKUP/EMREP12c/ARCHIVELOG/o1_mf_1_192_bysbor59_.arc

Do you really want to catalog the above files (enter YES or NO)? yes

cataloging files...

cataloging done

List of Cataloged Files

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