Pages

Sunday, November 19, 2017

[SOLVED] - RMAN-03002 RMAN-12009 RMAN-12017

RMAN-03002 RMAN-12009 RMAN-12017

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/24/2017 21:25:09
RMAN-12009: command aborted because some backup pieces could not be located
RMAN-12017: could not locate pieces of backup set key 10400



Issue:


RMAN> catalog start with '/backup1/rman/';
RMAN> recover database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/24/2017 21:25:09
RMAN-12009: command aborted because some backup pieces could not be located
RMAN-12017: could not locate pieces of backup set key 10400



Solution:


RMAN> catalog backuppiece '/backup1/rman/1_gtmh8n3v_20110712.rmb';
RMAN> recover database;


Note: Catalog backup piece manually.

Tuesday, November 8, 2016

iperf - Network Bandwidth calculator between two servers

Network Bandwidth calculator between two servers - iperf


Download the rpm/software from the website: https://iperf.fr/

Direct Download link for Redhat: https://iperf.fr/download/fedora/iperf3-3.1.3-1.fc24.x86_64.rpm


Install on both source and destination servers.
normally no dependency rpm.you can remove the rpm after test.
[root@hsb-dr-ora-test ~]# rpm -ivh iperf3-3.1.3-1.fc24.x86_64.rpm

[root@hsb-hq-ora-test ~]# rpm -ivh iperf3-3.1.3-1.fc24.x86_64.rpm

Below command listens for the port 1522: (choose ports that is not used)

[root@hsb-dr-ora-test ~]# iperf -s -p 1522
------------------------------------------------------------
Server listening on TCP port 1522
TCP window size: 85.3 KByte (default)
------------------------------------------------------------
[  4] local 172.166.0.166 port 1522 connected with 172.199.0.166 port 59973
[ ID] Interval       Transfer     Bandwidth
[  4]  0.0-10.7 sec  2.75 MBytes  2.15 Mbits/sec
[  5] local 172.166.0.166 port 1522 connected with 172.199.0.166 port 59979
[  5]  0.0-10.7 sec  3.25 MBytes  2.55 Mbits/sec
[root@hsb-dr-ora-test ~]#


Below command transfers packet on port 1522:

[root@hsb-hq-ora-test ~]# iperf -c 172.166.0.166 -p 1522
------------------------------------------------------------
Client connecting to 172.166.0.166, TCP port 1522
TCP window size: 16.0 KByte (default)
------------------------------------------------------------
[  3] local 172.199.0.166 port 9927 connected with 172.166.0.166 port 1522
[ ID] Interval       Transfer     Bandwidth
[  3]  0.0-10.5 sec  2.88 MBytes  2.29 Mbits/sec
[root@hsb-hq-ora-test ~]# 


Options used above:
 -s (running as server)
 -c (running as client)
 -p (port to check)