Tuesday 30 March 2021

Oracle Operating System Pre Requestories OEL 6.7


Hi all this is self OS troubleshooting tutorial for me .

  • Create oracle user and grid user

groupadd -g 54321 oinstall

groupadd -g 54322 dba
groupadd -g 54323 oper

useradd -u 54321 -g oinstall -G dba,oper oracle

passwd oracle

groupadd asmadmin

groupadd asmdba

useradd -u 54323 -g oinstall -G asmadmin,asmdba grid



passwd oracle
passwd grid

usermod -a -G asmdba oracle

  • Make sure that all the required libraries are installed.

/usr/bin/oracle-rdbms-server-12cR1-preinstall-verify
# if the command above reported any missing library, issue the following command:
yum install oracle-rdbms-server-12cR1-preinstall

Install Oracle ASMLib package

yum install oracleasm-support
# the following command will take a few minutes to finish:
yum install kmod-oracleasm


  • Configure and load the ASM kernel module

oracleasm configure -i


  • Open a terminal window and edit the udev rule for network devices in the file

/etc/udev/rules.d/70-persistent-net.rules


  • Create Directory:

mkdir -p /u01/app/oracle/product
chown -R oracle:oinstall /u01
chmod -R 775 /u01
mkdir -p /u01/app/grid
mkdir -p /u01/app/12.1.0/grid
chown -R grid:oinstall /u01/app/grid
chown -R grid:oinstall /u01/app/12.1.0/grid
chmod -R 775 /u01

  • Grid bash_profile
/home/grid

[grid@srv1 ~]$ cat .bash_profile
# .bash_profile #
OS User: grid

if [ -f ~/.bashrc ]; then
.~/.bashrc
fi
ORACLE_SID=+ASM1; export ORACLE_SID
ORACLE_BASE=/u01/app/grid; export ORACLE_BASE
# it must not be under the ORACLE_BASE
ORACLE_HOME=/u01/app/12.1.0/grid; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
PATH=.:${PATH}:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/local/bin
export PATH
export TEMP=/tmp
export TMPDIR=/tmp
umask 022
[grid@srv1 ~]$


  • Oracle bash_profile
/home/oracle

[oracle@srv1 ~]$ cat .bash_profile
# .bash_profile
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

ORACLE_SID=rac1; export ORACLE_SID
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
PATH=.:${PATH}:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/local/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
THREADS_FLAG=native; export THREADS_FLAG
export TEMP=/tmp
export TMPDIR=/tmp
export EDITOR=vi
umask 022

[oracle@srv1 ~]$

  • Useful links :






  • Disable NTP

service ntpd status
chkconfig ntpd off
mv /etc/ntp.conf /etc/ntp.conf.orig
rm /var/run/ntpd.pid


rpm -iv cvuqdisk-1.0.9-1.rpm

  • Disable firewall

chkconfig iptables off
chkconfig ip6tables off
service iptables stop
service ip6tables stop
vi /etc/selinux/config
change SELinux=enforcing to SELinux=disabled

If oel 7
systemctl stop firewalld
systemctl disable firewalld


  • Change hostname:

[root@srv3 Desktop]# vi /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=srv4.example.com
# oracle-rdbms-server-12cR1-preinstall : Add NOZEROCONF=yes
NOZEROCONF=yes
[root@srv3 Desktop]# 



  • Change MAC address

[root@srv3 rules.d]# pwd
/etc/udev/rules.d
[root@srv3 rules.d]# 

[root@srv3 rules.d]# cat 70-persistent-net.rules
# This file was automatically generated by the /lib/udev/write_net_rules
# program, run by the persistent-net-generator.rules rules file.
#
# You can modify it, as long as you keep each rule on a single
# line, and change only the value of the NAME= key.

# PCI device 0x8086:0x100e (e1000)
SUBSYSTEM=="net", ACTION=="add", DRIVERS=="?*", ATTR{address}=="08:00:27:9e:7e:3e", ATTR{type}=="1", KERNEL=="eth*", NAME="eth0"

# PCI device 0x8086:0x100e (e1000)
SUBSYSTEM=="net", ACTION=="add", DRIVERS=="?*", ATTR{address}=="08:00:27:58:55:fa", ATTR{type}=="1", KERNEL=="eth*", NAME="eth1"
[root@srv3 rules.d]# 


  • Change IP address by adding MAC address:

root@srv3 network-scripts]# pwd
/etc/sysconfig/network-scripts
[root@srv3 network-scripts]# 

[root@srv3 network-scripts]# vi ifcfg-eth0

DEVICE=eth0
TYPE=Ethernet
UUID=5f79efb6-0c82-42b6-a1aa-16631b453e11
ONBOOT=yes
NM_CONTROLLED=yes
BOOTPROTO=none
HWADDR=08:00:27:58:55:fa
IPADDR=192.168.56.74
PREFIX=24
DEFROUTE=yes
IPV4_FAILURE_FATAL=yes
IPV6INIT=no
NAME=eth0

  • ADD SWAP SIZE

[root@srv1 ~]# swapon -s
Filename                                Type            Size    Used    Priority
[root@srv1 ~]# mkswap /dev/sde1
Setting up swapspace version 1, size = 4192928 KiB
no label, UUID=06564f18-2637-4de8-bb95-0f6ea1b88c84
[root@srv1 ~]# swapon -s
Filename                                Type            Size    Used    Priority
[root@srv1 ~]# swapon -a
[root@srv1 ~]# swapon -s
Filename                                Type            Size    Used    Priority
/dev/sde1                               partition       4192928 0       -1
[root@srv1 ~]# cat /etc/fstab

#
# /etc/fstab
# Created by anaconda on Tue Feb  2 13:28:55 2021
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
UUID=ea2f6384-7a15-4150-9891-c554f9c7c339 /                       ext4    defaults        1 1
UUID=0d4ffc14-d2a0-4373-94d9-1646bbc2effa /boot                   ext4    defaults        1 2
UUID=0e485d97-fcbc-42aa-b21d-316ed75dc3f5 /tmp                    ext4    defaults        1 2
#tmpfs                   /dev/shm                tmpfs   defaults        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
tmpfs                    /dev/shm                tmpfs   defaults,size=4G       0 0
/dev/sde1 swap swap 0 0
[root@srv1 ~]#

Issues:
==============================================================
/etc/fstab

none                    /dev/shm                tmpfs   defaults,size=3G       0 0

==============================================================
fix swap issue with file

from root user:
swapon -s
dd if=/dev/zero of=/home/swapfile1 bs=1024 count=2097152
mkswap /home/swapfile1
swapon /home/swapfile1
swapon -a
swapon -s


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

Edit the "/etc/oratab"

End.




[root@zabbix ~]# df -h /dev/shm
Filesystem      Size  Used Avail Use% Mounted on
shmfs           4.0G     0  4.0G   0% /dev/shm
[root@zabbix ~]# mount -t tmpfs shmfs -o size=3072m /dev/shm
[root@zabbix ~]# mount -t tmpfs shmfs -o size=4096m /dev/shm
[root@zabbix ~]# df -h /dev/shm
Filesystem      Size  Used Avail Use% Mounted on
shmfs           4.0G     0  4.0G   0% /dev/shm


  • RPM Package:

rpm -Uvh binutils*
rpm -Uvh compat-libstdc++-33*
rpm -Uvh compat-libstdc++-33.i686*
rpm -Uvh gcc*
rpm -Uvh gcc-c++*
rpm -Uvh glibc*
rpm -Uvh glibc.i686*
rpm -Uvh glibc-devel*
rpm -Uvh glibc-devel.i686*
rpm -Uvh ksh*
rpm -Uvh libgcc*
rpm -Uvh libgcc.i686*
rpm -Uvh libstdc++*
rpm -Uvh libstdc++.i686*
rpm -Uvh libstdc++-devel*
rpm -Uvh libstdc++-devel.i686*
rpm -Uvh libaio*
rpm -Uvh libaio.i686*
rpm -Uvh libaio-devel*
rpm -Uvh libaio-devel.i686*
rpm -Uvh libXext*
rpm -Uvh libXext.i686*
rpm -Uvh libXtst*
rpm -Uvh libXtst.i686*
rpm -Uvh libX11*
rpm -Uvh libX11.i686*
rpm -Uvh libXau*
rpm -Uvh libXau.i686*
rpm -Uvh libxcb*
rpm -Uvh libxcb.i686*
rpm -Uvh libXi*
rpm -Uvh libXi.i686*
rpm -Uvh make*
rpm -Uvh sysstat*
rpm -Uvh unixODBC*
rpm -Uvh unixODBC-devel*
rpm -Uvh zlib-devel*
rpm -Uvh zlib-devel.i686*
rpm -Uvh compat-libstdc++-33-3.2.3-71.el7.x86_64.rpm 
rpm -Uvh libstdc++-devel-4.8.2-16.el7.x86_64.rpm 
rpm -Uvh gcc-c++-4.8.2-16.el7.x86_64.rpm 
rpm -Uvh libaio-devel-0.3.109-12.el7.x86_64.rpm 


  • /etc/sysctl.conf

fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

Run:
sysctl -p

etc/security/limits.con

oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    2047
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768

# oracle-rdbms-server-12cR1-preinstall setting for nofile soft limit is 1024 
oracle soft nofile 1024 
grid soft nofile 1024 
 
# oracle-rdbms-server-12cR1-preinstall setting for nofile hard limit is 65536 
oracle hard nofile 65536 
grid hard nofile 65536 
 
# oracle-rdbms-server-12cR1-preinstall setting for nproc soft limit is 16384 # refer orabug15971421 for more info. 
oracle soft nproc 16384 
grid soft nproc 16384 
 
# oracle-rdbms-server-12cR1-preinstall setting for nproc hard limit is 16384 
oracle hard nproc 16384 
grid hard nproc 16384 
 
# oracle-rdbms-server-12cR1-preinstall setting for stack soft limit is 10240KB 
oracle soft stack 10240 
grid soft stack 10240 
 
# oracle-rdbms-server-12cR1-preinstall setting for stack hard limit is 32768KB 
oracle hard stack 32768 
grid hard stack 32768 
 
# oracle-rdbms-server-11gR2-preinstall setting for memlock hard limit is maximum of {128GB (x86_64) / 3GB (x86) or 90 % of RAM} 
oracle hard memlock 134217728 
grid hard memlock 134217728 
 
# oracle-rdbms-server-11gR2-preinstall setting for memlock soft limit is maximum of {128GB (x86_64) / 3GB (x86) or 90% of RAM} 
oracle soft memlock 134217728 
grid soft memlock 134217728 


  • /etc/hosts Entry:

#127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
#::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

127.0.0.1   localhost.localdomain localhost
# Public
192.168.56.71   srv1.example.com        srv1
192.168.56.72   srv2.example.com        srv2

# Private
192.168.10.1    srv1-priv.example.com   srv1-priv
192.168.10.2    srv2-priv.example.com   srv2-priv

# Virtual
192.168.56.81   srv1-vip.example.com    srv1-vip
192.168.56.82   srv2-vip.example.com    srv2-vip

# SCAN (in production this should be configured in DNS)
192.168.56.91   srv-scan.example.com    srv-scan
192.168.56.92   srv-scan.example.com    srv-scan
192.168.56.93   srv-scan.example.com    srv-scan
Posted by at No comments:
Labels:

Monday 15 March 2021

Dataguard : Recover of physical standby database using primary full rman backup

 Dataguard : Recover of physical standby database from scratch using  primary database  full rman backup

  • Take rman full backup.
  • SCP  rman backup to physical standby Dataguard.
  • Restore standby control file from backup
  • Restore and recover database using rman backup

Rman Backup Script:

run

{

allocate channel c1 device type disk format '/u01/backup/Backup_%d_DB_%u_%s_%p_%T';

allocate channel c2 device type disk format '/u01/backup/Backup_%d_DB_%u_%s_%p_%T';

crosscheck backup;

crosscheck archivelog all;

report obsolete;

delete noprompt obsolete;

sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 tag='FULL_BACKUP_WEEKLY' DATABASE INCLUDE CURRENT CONTROLFILE FILESPERSET 1;

BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL;

delete noprompt archivelog all backed up 1 times to disk;

copy current controlfile to '/u01/backup/control_%d_%T_%U.ctl';

backup current controlfile for standby format '/u01/backup/standbycontrol_%d_%T_%U.ctl';

release channel c1;

release channel c2;

}


  • Start physical database in nomount stage either pfile or spfile optional.

[oracle@srv5 backup]$ sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 15 13:20:26 2021


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



Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options




SQL> startup nomount pfile='/u01/app/oracle/product/12.1.0.2/db_1/dbs/initzabbixdr2.ora';

ORACLE instance started.


Total System Global Area 1509949440 bytes

Fixed Size                  2924640 bytes

Variable Size            1207963552 bytes

Database Buffers          285212672 bytes

Redo Buffers               13848576 bytes

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options


  • Restore standby controlfile using rman backup


[oracle@srv5 backup]$ rman target /


Recovery Manager: Release 12.1.0.2.0 - Production on Mon Mar 15 13:21:45 2021


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


connected to target database: ZABBIX (not mounted)


RMAN> restore standby controlfile from '/u01/backup/standbycontrol_ZABBIX_20210315_38vpq6fk_1_1.ctl';


Starting restore at 15-MAR-21

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=23 device type=DISK


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/zabbixdr2/control01.ctl

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

Finished restore at 15-MAR-21

  • Open standby database in mount state

RMAN> sql 'alter database mount standby database';


sql statement: alter database mount standby database

released channel: ORA_DISK_1

  • Catalog rman backup location 

RMAN> catalog start with '/u01/backup/';


Starting implicit crosscheck backup at 15-MAR-21

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=38 device type=DISK

Crosschecked 46 objects

Finished implicit crosscheck backup at 15-MAR-21


Starting implicit crosscheck copy at 15-MAR-21

using channel ORA_DISK_1

Crosschecked 6 objects

Finished implicit crosscheck copy at 15-MAR-21


searching for all files in the recovery area

cataloging files...

cataloging done


List of Cataloged Files

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

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1082_j4ksh5db_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1086_j4kxvkk7_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1077_j4kl56z7_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1078_j4klg88t_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1079_j4kn6frr_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1069_j4kfwk66_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1072_j4kfwk1c_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1076_j4kjf08g_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1066_j4kfwk4c_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1080_j4koypoh_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1084_j4kwznpx_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1074_j4kjdv65_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1067_j4kfwjxw_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1068_j4kfwk60_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1083_j4kv7g7v_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1075_j4kjdwtj_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1089_j4l346yk_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1073_j4khnpxh_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1065_j4kfwk74_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1081_j4kqpw22_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1071_j4kfwk85_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1085_j4kx517k_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1070_j4kfwk78_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1087_j4kzmo4n_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_10/o1_mf_1_1088_j4l1cyb5_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1116_j4mllx0c_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1133_j4mzcf92_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1119_j4mqvnol_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1132_j4mzcfbs_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1118_j4mp3ddc_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1100_j4lpgx1b_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1092_j4l8dxgh_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1091_j4l6no22_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1095_j4lfonj3_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_5_j4n22226_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1124_j4myt1b3_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1106_j4m10dwz_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1111_j4m9soyd_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1105_j4lz84js_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1097_j4lk65z1_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1093_j4lb56fw_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1110_j4m81dz1_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1121_j4mvd4fj_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1108_j4m4jw86_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1109_j4m694j3_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1123_j4myt1fq_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1135_j4mzg2dv_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1104_j4lxhwq0_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1136_j4mzg4mz_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1102_j4lszgry_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1125_j4mz7kr1_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1107_j4m2rp9s_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1134_j4mzfrpf_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1090_j4l4wdc8_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1098_j4llyd0m_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_2_j4n09855_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1115_j4mjto0s_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1103_j4lvqn7m_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1113_j4mfb6ho_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1128_j4mz8bq9_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1122_j4mx4gob_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1126_j4mz8000_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1120_j4msmxtp_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1112_j4mckxs7_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1_j4n094j5_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_3_j4n09gv3_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1127_j4mz87lp_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1114_j4mh2dnw_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1094_j4lcxghz_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1131_j4mz92qp_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_4_j4n09srf_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1101_j4lr76hp_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1099_j4lnpnmh_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1129_j4mz8ppk_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1096_j4lhfwmh_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1117_j4mnc5yt_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/archivelog/2021_03_11/o1_mf_1_1130_j4mz900b_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1141_j4n0ztx6_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1128_j4n08w4x_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1137_j4n08yjv_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1140_j4n0zqdd_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1129_j4n08wbk_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1146_j4n1qdvf_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1145_j4n1qd0c_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1143_j4n19j2h_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1144_j4n19m5t_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1147_j4n1qkn8_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1132_j4n08wfp_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1133_j4n08whb_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1136_j4n08ygf_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1138_j4n08ygv_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1134_j4n08wjj_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1135_j4n08wl1_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1127_j4n08w4q_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1139_j4n0zpft_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1126_j4n08wfz_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1130_j4n08wd4_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1148_j4n1qks0_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1131_j4n08wdo_.arc

File Name: /u01/app/oracle/fast_recovery_area/ZABBIXDR2/foreign_archivelog/zabbix/2021_03_11/o1_mf_1_1142_j4n19695_.arc


searching for all files that match the pattern /u01/backup/


List of Files Unknown to the Database

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

File Name: /u01/backup/1evpabqv_1_1

File Name: /u01/backup/ZABBIX_0rvp8cid_1_1.bckp

File Name: /u01/backup/ZABBIX_0qvp8cht_1_1.bckp

File Name: /u01/backup/1hvpabru_1_1

File Name: /u01/backup/1cvpabq8_1_1

File Name: /u01/backup/ZABBIX_0ivp8ce4_1_1.bckp

File Name: /u01/backup/ZABBIX_0ovp8cgv_1_1.bckp

File Name: /u01/backup/14vpabmt_1_1

File Name: /u01/backup/ZABBIX_0kvp8cf2_1_1.bckp

File Name: /u01/backup/17vpabns_1_1

File Name: /u01/backup/ZABBIX_0mvp8cg1_1_1.bckp

File Name: /u01/backup/standbycontrol_ZABBIX_20210315_38vpq6fk_1_1.ctl

File Name: /u01/backup/ZABBIX_0hvp8cdl_1_1.bckp

File Name: /u01/backup/ZABBIX_0gvp8cd6_1_1.bckp

File Name: /u01/backup/ZABBIX_0jvp8cej_1_1.bckp

File Name: /u01/backup/ZABBIX_0nvp8cgg_1_1.bckp

File Name: /u01/backup/ZABBIX_0lvp8cfi_1_1.bckp

File Name: /u01/backup/ZABBIX_0fvp8ccn_1_1.bckp

File Name: /u01/backup/19vpaboq_1_1

File Name: /u01/backup/18vpabob_1_1

File Name: /u01/backup/ZABBIX_0tvp8cj3_1_1.bckp

File Name: /u01/backup/ZABBIX_0uvp8cji_1_1.bckp

File Name: /u01/backup/ZABBIX_0svp8cis_1_1.bckp

File Name: /u01/backup/1ivpabs5_1_1

File Name: /u01/backup/16vpabnd_1_1

File Name: /u01/backup/1avpabpa_1_1

File Name: /u01/backup/ZABBIX_0pvp8che_1_1.bckp

File Name: /u01/backup/1fvpabrf_1_1

File Name: /u01/backup/1gvpabrm_1_1

File Name: /u01/backup/1dvpabqo_1_1

File Name: /u01/backup/1bvpabpp_1_1


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

cataloging files...

cataloging done


List of Cataloged Files

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

File Name: /u01/backup/1evpabqv_1_1

File Name: /u01/backup/ZABBIX_0rvp8cid_1_1.bckp

File Name: /u01/backup/ZABBIX_0qvp8cht_1_1.bckp

File Name: /u01/backup/1hvpabru_1_1

File Name: /u01/backup/1cvpabq8_1_1

File Name: /u01/backup/ZABBIX_0ivp8ce4_1_1.bckp

File Name: /u01/backup/ZABBIX_0ovp8cgv_1_1.bckp

File Name: /u01/backup/14vpabmt_1_1

File Name: /u01/backup/ZABBIX_0kvp8cf2_1_1.bckp

File Name: /u01/backup/17vpabns_1_1

File Name: /u01/backup/ZABBIX_0mvp8cg1_1_1.bckp

File Name: /u01/backup/standbycontrol_ZABBIX_20210315_38vpq6fk_1_1.ctl

File Name: /u01/backup/ZABBIX_0hvp8cdl_1_1.bckp

File Name: /u01/backup/ZABBIX_0gvp8cd6_1_1.bckp

File Name: /u01/backup/ZABBIX_0jvp8cej_1_1.bckp

File Name: /u01/backup/ZABBIX_0nvp8cgg_1_1.bckp

File Name: /u01/backup/ZABBIX_0lvp8cfi_1_1.bckp

File Name: /u01/backup/ZABBIX_0fvp8ccn_1_1.bckp

File Name: /u01/backup/19vpaboq_1_1

File Name: /u01/backup/18vpabob_1_1

File Name: /u01/backup/ZABBIX_0tvp8cj3_1_1.bckp

File Name: /u01/backup/ZABBIX_0uvp8cji_1_1.bckp

File Name: /u01/backup/ZABBIX_0svp8cis_1_1.bckp

File Name: /u01/backup/1ivpabs5_1_1

File Name: /u01/backup/16vpabnd_1_1

File Name: /u01/backup/1avpabpa_1_1

File Name: /u01/backup/ZABBIX_0pvp8che_1_1.bckp

File Name: /u01/backup/1fvpabrf_1_1

File Name: /u01/backup/1gvpabrm_1_1

File Name: /u01/backup/1dvpabqo_1_1

File Name: /u01/backup/1bvpabpp_1_1

  • Configure disk parallelism to speed up process this is optional

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 20 BACKUP TYPE TO BACKUPSET;


new RMAN configuration parameters:

CONFIGURE DEVICE TYPE DISK PARALLELISM 20 BACKUP TYPE TO BACKUPSET;

new RMAN configuration parameters are successfully stored

released channel: ORA_DISK_1

  • Restore and recover DR restore database (For full rman backup restoration if using incremental backup to resysnc logs  do recover option )

RMAN> restore database;   


Starting restore at 15-MAR-21

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=38 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=39 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=40 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=41 device type=DISK

allocated channel: ORA_DISK_5

channel ORA_DISK_5: SID=42 device type=DISK

allocated channel: ORA_DISK_6

channel ORA_DISK_6: SID=43 device type=DISK

allocated channel: ORA_DISK_7

channel ORA_DISK_7: SID=44 device type=DISK

allocated channel: ORA_DISK_8

channel ORA_DISK_8: SID=45 device type=DISK

allocated channel: ORA_DISK_9

channel ORA_DISK_9: SID=46 device type=DISK

allocated channel: ORA_DISK_10

channel ORA_DISK_10: SID=47 device type=DISK

allocated channel: ORA_DISK_11

channel ORA_DISK_11: SID=48 device type=DISK

allocated channel: ORA_DISK_12

channel ORA_DISK_12: SID=49 device type=DISK

allocated channel: ORA_DISK_13

channel ORA_DISK_13: SID=50 device type=DISK

allocated channel: ORA_DISK_14

channel ORA_DISK_14: SID=51 device type=DISK

allocated channel: ORA_DISK_15

channel ORA_DISK_15: SID=52 device type=DISK

allocated channel: ORA_DISK_16

channel ORA_DISK_16: SID=53 device type=DISK

allocated channel: ORA_DISK_17

channel ORA_DISK_17: SID=54 device type=DISK

allocated channel: ORA_DISK_18

channel ORA_DISK_18: SID=55 device type=DISK

allocated channel: ORA_DISK_19

channel ORA_DISK_19: SID=56 device type=DISK

allocated channel: ORA_DISK_20

channel ORA_DISK_20: SID=57 device type=DISK


channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/zabbixdr/system01.dbf

channel ORA_DISK_1: reading from backup piece /u01/backup/Backup_ZABBIX_DB_2ovpq691_88_1_20210315

channel ORA_DISK_2: starting datafile backup set restore

channel ORA_DISK_2: specifying datafile(s) to restore from backup set

channel ORA_DISK_2: restoring datafile 00003 to /u01/app/oracle/oradata/zabbixdr/sysaux01.dbf

channel ORA_DISK_2: reading from backup piece /u01/backup/Backup_ZABBIX_DB_2nvpq690_87_1_20210315

channel ORA_DISK_3: starting datafile backup set restore

channel ORA_DISK_3: specifying datafile(s) to restore from backup set

channel ORA_DISK_3: restoring datafile 00007 to /u01/app/oracle/oradata/zabbixdr/pdbseed/sysaux01.dbf

channel ORA_DISK_3: reading from backup piece /u01/backup/Backup_ZABBIX_DB_2qvpq6bo_90_1_20210315

channel ORA_DISK_4: starting datafile backup set restore

channel ORA_DISK_4: specifying datafile(s) to restore from backup set

channel ORA_DISK_4: restoring datafile 00009 to /u01/app/oracle/oradata/zabbixdr/pdb1/sysaux01.dbf

channel ORA_DISK_4: reading from backup piece /u01/backup/Backup_ZABBIX_DB_2pvpq6bn_89_1_20210315

channel ORA_DISK_5: starting datafile backup set restore

channel ORA_DISK_5: specifying datafile(s) to restore from backup set

channel ORA_DISK_5: restoring datafile 00005 to /u01/app/oracle/oradata/zabbixdr/pdbseed/system01.dbf

channel ORA_DISK_5: reading from backup piece /u01/backup/Backup_ZABBIX_DB_2svpq6cr_92_1_20210315

channel ORA_DISK_6: starting datafile backup set restore

channel ORA_DISK_6: specifying datafile(s) to restore from backup set

channel ORA_DISK_6: restoring datafile 00008 to /u01/app/oracle/oradata/zabbixdr/pdb1/system01.dbf

channel ORA_DISK_6: reading from backup piece /u01/backup/Backup_ZABBIX_DB_2rvpq6cr_91_1_20210315

channel ORA_DISK_7: starting datafile backup set restore

channel ORA_DISK_7: specifying datafile(s) to restore from backup set

channel ORA_DISK_7: restoring datafile 00004 to /u01/app/oracle/oradata/zabbixdr/undotbs01.dbf

channel ORA_DISK_7: reading from backup piece /u01/backup/Backup_ZABBIX_DB_2tvpq6da_93_1_20210315

channel ORA_DISK_8: starting datafile backup set restore

channel ORA_DISK_8: specifying datafile(s) to restore from backup set

channel ORA_DISK_8: restoring datafile 00006 to /u01/app/oracle/oradata/zabbixdr/users01.dbf

channel ORA_DISK_8: reading from backup piece /u01/backup/Backup_ZABBIX_DB_2vvpq6dc_95_1_20210315

channel ORA_DISK_9: starting datafile backup set restore

channel ORA_DISK_9: specifying datafile(s) to restore from backup set

channel ORA_DISK_9: restoring datafile 00010 to /u01/app/oracle/oradata/zabbixdr/pdb1/pdb1_users01.dbf

channel ORA_DISK_9: reading from backup piece /u01/backup/Backup_ZABBIX_DB_30vpq6dd_96_1_20210315

channel ORA_DISK_8: piece handle=/u01/backup/Backup_ZABBIX_DB_2vvpq6dc_95_1_20210315 tag=FULL_BACKUP_WEEKLY

channel ORA_DISK_8: restored backup piece 1

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

channel ORA_DISK_9: piece handle=/u01/backup/Backup_ZABBIX_DB_30vpq6dd_96_1_20210315 tag=FULL_BACKUP_WEEKLY

channel ORA_DISK_9: restored backup piece 1

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

channel ORA_DISK_7: piece handle=/u01/backup/Backup_ZABBIX_DB_2tvpq6da_93_1_20210315 tag=FULL_BACKUP_WEEKLY

channel ORA_DISK_7: restored backup piece 1

channel ORA_DISK_7: restore complete, elapsed time: 00:00:07

channel ORA_DISK_5: piece handle=/u01/backup/Backup_ZABBIX_DB_2svpq6cr_92_1_20210315 tag=FULL_BACKUP_WEEKLY

channel ORA_DISK_5: restored backup piece 1

channel ORA_DISK_5: restore complete, elapsed time: 00:00:55

channel ORA_DISK_6: piece handle=/u01/backup/Backup_ZABBIX_DB_2rvpq6cr_91_1_20210315 tag=FULL_BACKUP_WEEKLY

channel ORA_DISK_6: restored backup piece 1

channel ORA_DISK_6: restore complete, elapsed time: 00:00:55

channel ORA_DISK_3: piece handle=/u01/backup/Backup_ZABBIX_DB_2qvpq6bo_90_1_20210315 tag=FULL_BACKUP_WEEKLY

channel ORA_DISK_3: restored backup piece 1

channel ORA_DISK_3: restore complete, elapsed time: 00:01:25

channel ORA_DISK_4: piece handle=/u01/backup/Backup_ZABBIX_DB_2pvpq6bn_89_1_20210315 tag=FULL_BACKUP_WEEKLY

channel ORA_DISK_4: restored backup piece 1

channel ORA_DISK_4: restore complete, elapsed time: 00:01:25

channel ORA_DISK_1: piece handle=/u01/backup/Backup_ZABBIX_DB_2ovpq691_88_1_20210315 tag=FULL_BACKUP_WEEKLY

channel ORA_DISK_1: restored backup piece 1

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

channel ORA_DISK_2: piece handle=/u01/backup/Backup_ZABBIX_DB_2nvpq690_87_1_20210315 tag=FULL_BACKUP_WEEKLY

channel ORA_DISK_2: restored backup piece 1

channel ORA_DISK_2: restore complete, elapsed time: 00:01:55

Finished restore at 15-MAR-21


RMAN> RECOVER DATABASE NOREDO;


Starting recover at 15-MAR-21

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

using channel ORA_DISK_5

using channel ORA_DISK_6

using channel ORA_DISK_7

using channel ORA_DISK_8

using channel ORA_DISK_9

using channel ORA_DISK_10

using channel ORA_DISK_11

using channel ORA_DISK_12

using channel ORA_DISK_13

using channel ORA_DISK_14

using channel ORA_DISK_15

using channel ORA_DISK_16

using channel ORA_DISK_17

using channel ORA_DISK_18

using channel ORA_DISK_19

using channel ORA_DISK_20


Finished recover at 15-MAR-21

  • Check MRP0 process and start MRP0 process to make sync.

RMAN> select process,status,sequence# from v$managed_standby;


PROCESS   STATUS        SEQUENCE#

--------- ------------ ----------

ARCH      CONNECTED             0

ARCH      CONNECTED             0

ARCH      CONNECTED             0

ARCH      CLOSING            1351

RFS       IDLE                  0

RFS       IDLE               1352


RMAN> exit



Recovery Manager complete.

[oracle@srv5 backup]$ sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 15 13:35:30 2021


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



Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options


SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oracle@srv5 backup]$ sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 15 13:35:34 2021


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



Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options


SQL> @/home/oracle/d


NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN

--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------

ZABBIX    zabbixdr2        zabbixdr2                      MOUNTED              PHYSICAL STANDBY NO                 0


SQL> @/home/oracle/standby


NAME      OPEN_MODE            DATABASE_ROLE

--------- -------------------- ----------------

ZABBIX    MOUNTED              PHYSICAL STANDBY



PROCESS   STATUS        SEQUENCE#

--------- ------------ ----------

ARCH      CONNECTED             0

ARCH      CONNECTED             0

ARCH      CONNECTED             0

ARCH      CLOSING            1351

RFS       IDLE                  0

RFS       IDLE               1352


6 rows selected.



    Thread Last Sequence Received Last Sequence Applied Difference

---------- ---------------------- --------------------- ----------

         1                   1351                  1350          1



SQL> alter database recover managed standby database disconnect from session;


Database altered.


SQL> @/home/oracle/standby


NAME      OPEN_MODE            DATABASE_ROLE

--------- -------------------- ----------------

ZABBIX    MOUNTED              PHYSICAL STANDBY



PROCESS   STATUS        SEQUENCE#

--------- ------------ ----------

ARCH      CONNECTED             0

ARCH      CONNECTED             0

ARCH      CONNECTED             0

ARCH      CLOSING            1351

RFS       IDLE                  0

RFS       IDLE               1352

MRP0      APPLYING_LOG       1352

RFS       IDLE                  0


8 rows selected.



    Thread Last Sequence Received Last Sequence Applied Difference

---------- ---------------------- --------------------- ----------

         1                   1351                  1351          0


SQL>

  • Check physical standby Data guard  status using DGMGRL command.
DGMGRL> show configuration;

Configuration - zabbix

  Protection Mode: MaxPerformance
  Members:
  zabbix    - Primary database
    zabbixdr  - Physical standby database
    zabbixdr2 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 9 seconds ago)

DGMGRL>

Posted by at No comments:
Labels:

Thursday 11 March 2021

Dataguard12c - Multiple physical standby Dataguard on 12c

 Dataguard12c - Multiple physical standby Data guard on 12c 

Primary Database : srv3.example.com

1st Standby Database : srv4.example.com

2nd Standby Database : srv5.example.com


Step 1: create multiple physical standby database  and  add DG broker pre requestories.

link to create physical standby dataguard  dataguard setup steps link

Step 2 : Connect to primary database and create DG configuration

[oracle@srv3 dbs]$ dgmgrl sys/system123@zabbix

DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected as SYSDBA.
DGMGRL> CREATE CONFIGURATION zabbix AS PRIMARY DATABASE IS zabbix CONNECT IDENTIFIER IS zabbix;
Configuration "zabbix" created with primary database "zabbix"

Step 3: Add multiple standby database configuration:

DGMGRL> ADD DATABASE zabbixdr AS CONNECT IDENTIFIER IS zabbixdr;
Database "zabbixdr" added

DGMGRL> ADD DATABASE zabbixdr2 AS CONNECT IDENTIFIER IS zabbixdr2;
Database "zabbixdr2" added

Step 4: Enable Configuration .

DGMGRL> enable configuration;

Enabled.


Step 5 : check dataguard configuration : 

[oracle@srv3 dbs]$ dgmgrl sys/system123@zabbix

DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected as SYSDBA.

DGMGRL> show configuration;

Configuration - zabbix

  Protection Mode: MaxPerformance
  Members:
  zabbix    - Primary database
    zabbixdr  - Physical standby database
    zabbixdr2 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 28 seconds ago)

DGMGRL>


[oracle@srv4 dbs]$ dgmgrl sys/system123@zabbixdr

DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected as SYSDBA.
DGMGRL> show configuration;

Configuration - zabbix

  Protection Mode: MaxPerformance
  Members:
  zabbix    - Primary database
    zabbixdr  - Physical standby database
    zabbixdr2 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 14 seconds ago)

DGMGRL>


[oracle@srv5 dbs]$ dgmgrl sys/system123@zabbixdr2

DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected as SYSDBA.

DGMGRL> show configuration;

Configuration - zabbix

  Protection Mode: MaxPerformance
  Members:
  zabbix    - Primary database
    zabbixdr  - Physical standby database
    zabbixdr2 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 41 seconds ago)

DGMGRL>

Step 6 :  Check standby MRP0 status using sql query

oracle@:~> cat standby.sql
select name,open_mode,database_role from v$database;

select process,status,sequence# from v$managed_standby;

SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH, (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL WHERE ARCH.THREAD# = APPL.THREAD#;

SQL> @standby

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
ZABBIX    READ WRITE           PRIMARY


PROCESS   STATUS        SEQUENCE#
--------- ------------ ----------
ARCH      CLOSING            1121
ARCH      CLOSING            1119
ARCH      CLOSING            1071
SQL> @standby

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
ZABBIX    MOUNTED              PHYSICAL STANDBY


PROCESS   STATUS        SEQUENCE#
--------- ------------ ----------
ARCH      CLOSING            1115
ARCH      CLOSING            1121
ARCH      CONNECTED             0
ARCH      CLOSING            1120
MRP0      APPLYING_LOG       1122
RFS       IDLE                  0
RFS       IDLE               1122
RFS       IDLE                  0
RFS       IDLE                  0

9 rows selected.


    Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
         1                   1121                  1121          0

SQL> !hostname
srv4.example.com

SQL>


SQL> @standby

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
ZABBIX    MOUNTED              PHYSICAL STANDBY


PROCESS   STATUS        SEQUENCE#
--------- ------------ ----------
ARCH      CLOSING            1121
ARCH      CLOSING            1120
ARCH      CONNECTED             0
ARCH      CLOSING            1116
RFS       IDLE               1122
RFS       IDLE                  0
RFS       IDLE                  0
RFS       IDLE                  0
MRP0      APPLYING_LOG       1122

9 rows selected.


    Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
         1                   1121                  1121          0

SQL> !hostname
srv5.example.com

SQL>

ARCH      CLOSING            1120
LNS       WRITING            1122
LNS       WRITING            1122

6 rows selected.


    Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
         1                   1121                  1121          0
         1                   1121                  1121          0
         1                   1121                  1121          0

SQL> !hostname
srv3.example.com




Posted by at No comments:
Labels:
Subscribe to: Posts (Atom)