Migrate database from One RMAN catalog to another RMAN catalog

Migrate database from One RMAN catalog to another RMAN catalog

http://www.nazmulhuda.info/migrate-database-from-one-rman-catalog-to-another-rman-catalog

 

Migrate database from One RMAN catalog to another RMAN catalog

In that scenario we will move catalog from stagecat(source catalog) to target database CLOUD.

 

[oracle@rmancatalog2 ~]$ rman target / catalog=rman/kjh7Rjsr1

Recovery Manager: Release 11.2.0.3.0 - Production on Wed Dec 21 09:28:47 2016

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

connected to target database: CLOUD (DBID=1801493836)

connected to recovery catalog database

RMAN> list db_unique_name all;

List of Databases
DB Key  DB Name  DB ID            Database Role    Db_unique_name
------- ------- ----------------- ---------------  ------------------
49382        DB2   3896599226       PRIMARY          DB2
49382        DB2   3896599226       STANDBY          DB1
1                DB1   4139331099       PRIMARY          DB1
1                DB1   4139331099       STANDBY          DB2

SQL> select * from rman.rc_database;

DB_KEY	DBINC_KEY	DBID	NAME	RESELOGS_CHANGE#	RESETLOGS_TIME
1	247199	4139331099	DB1	116371882675	06/07/2015 18:23
49382	49383	3896599226	DB2	90051108188	09/02/2012 16:18

 

RMAN> import catalog rman/U98wsjdw2#@stagecat;

Starting import catalog at 2016-12-21 09:36:33

connected to source recovery catalog database

import validation complete

Finished import catalog at 2016-12-21 09:36:40

RMAN> list db_unique_name all;

List of Databases
DB Key  DB Name  DB ID            Database Role    Db_unique_name
------- ------- ----------------- ---------------  ------------------
548781  DB3      829073653        PRIMARY          DB3
514674  DB4      1753676295       PRIMARY          DB4
523618  DB5      3779067219       PRIMARY          DB5
551022  DB6      4018492764       PRIMARY          DB6
545408  DB7      4110887114       PRIMARY          DB7

SQL> select * from rman.rc_database;

DB_KEY	DBINC_KEY	DBID	NAME	RESELOGS_CHANGE#	RESETLOGS_TIME
1	247199	4139331099	DB1	116371882675	06/07/2015 18:23:36
49382	49383	3896599226	DB2	90051108188	09/02/2012 16:18:57
548781	548782	829073653	DB3	1	08/09/2015 09:48:37
514674	514675	1753676295	DB4	1	29/06/2015 09:19:03
523618	523619	3779067219	DB5	1	27/08/2015 12:55:47
551022	551023	4018492764	DB6	1	02/09/2015 09:18:20
545408	545409	4110887114	DB7	1	22/06/2015 13:41:30

On the Source Catalog, the database will be automatically unregistered after the IMPORT CATALOG. If you need to retain the catalog on the source side even after the import then use keyword NO UNREGISTER.

Example:

RMAN> import catalog rman/U98wsjdw2#@stagecat no unregister;

 

 

Checking Firewall Ports on remote Host with SSH auth

#!/bin/bash
 
 input file format is:  hostname
 USAGE: ./scan_oem_ports_remote_hosts.sh hostfile
 if test 'X'"$1" = 'X'; then
         echo -n "ENter full path and name of file containing host names: ";read file
 else
         file="$1"
 fi
 grep -v "^#" $file|while read host 
 do
         if test 'X'"$host" = 'X'; then
                 echo "Malformed line in input file, skipping, should be name $host"
         else
                 RESULTS=$(ssh -n -q $host "timeout 5 bash -c 'oemap01.mydomain.com:4903  NOT open"}'

           if test "$RESULTS" != "OPEN"; then
                         /usr/bin/dig +short  $host | awk -v ip=$host '{print ip,"   " $NF "  -->oemap01.mydomain.com    4903  NOT open"}'  
           fi  
         fi
 done

Other Tools you can use for the same instead of /dev/tcp 
nc -vz -w5 hostname port (TCP) 
nc -vzu -w5 hostname port (UDP) 

Reference: https://superuser.com/questions/621870/test-if-a-port-on-a-remote-system-is-reachable-without-telnet

https://arunbavera.wordpress.com/category/em13c/

Patching OEM 13c Release 2 PSU for OMS and Agent

Patching OMS 13c Release 2 (13.2.0.0.181016) System PSU Patch :-

Download Link : OPatch version 13.9.3.3.0 for EMCC 13.x customers Only (not for FMW 12c) (Patch)

 

Download Link : OPatch version 13.9.3.3.0 for EMCC 13.x customers Only (not for FMW 12c) (Patch)