Oracle Database Commands and Practical Examples: March 2021

Tuesday 30 March 2021

Multitenant - Triggers 12.1.0.2.0

Hi all in 12.1.0.2.0 we use trigger and for 12.2 we use savepoint .

We tested in both standalone or RAC grid database when start again CDB get started but PDB remains mounted. So in order to avoid this we user trigger in 12.1 and in 12.2 we use save point.

Below example we execute trigger so on next time when we start CDB automatically all pdb will be in read write. We can modify triggers as per requirement just like save point.

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 NEWSMRUPGR10 READ WRITE NO

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 NEWSMRUPGR10 READ WRITE NO

SQL> CREATE OR REPLACE TRIGGER open_pdbs

AFTER STARTUP ON DATABASE

BEGIN

EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN';

END open_pdbs;

/ 2 3 4 5 6

Trigger created.

SQL> @d

NAME INSTANCE_NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FAILOVER_SCN

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

SMRCDB SMRCDB SMRCDB READ WRITE PRIMARY NO 0

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@TEST:~> tnsping SMRCDB

TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 24-FEB-2021 08:56:06

Used parameter files:

/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1523)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SMRCDB)))

OK (0 msec)

oracle@TEST:~> sqlplus sys/----@SMRCDB as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 24 08:56:16 2021

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> @d

NAME INSTANCE_NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FAILOVER_SCN

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

SMRCDB SMRCDB SMRCDB READ WRITE PRIMARY NO 0

SQL> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

ERROR:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Warning: You are no longer connected to ORACLE.

SQL> exit

oracle@TEST:~> . oraenv

ORACLE_SID = [SMRCDB] ?

The Oracle base remains unchanged with value /u01/app/oracle

oracle@TEST:~> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 24 08:56:56 2021

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 2147483648 bytes

Fixed Size 3712904 bytes

Variable Size 654313592 bytes

Database Buffers 1476395008 bytes

Redo Buffers 13062144 bytes

Database mounted.

Database opened.

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 NEWSMRUPGR10 READ WRITE NO

SQL>

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

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

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 :

YUM installation

DNS Configuration

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

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

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

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 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

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

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 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 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>

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

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

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

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

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

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

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

6 rows selected.

Thread Last Sequence Received Last Sequence Applied Difference

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

1 1121 1121 0

SQL> !hostname

srv3.example.com

Wednesday 10 March 2021

Dataguard 12c: Configure Dataguard on physical standby 12c

Data guard Configuration 12.1.0.2.0 Release

Configure the Broker in a Data Guard configuration

Create physical standby and tnsping both machine.

Create necessary directories for DG_BROKER_CONFIG_FILE

(In our case we mentioned $ORACLE_HOME/dbs localtion )

• Set Broker configuration file parameters

NOTE : 2 DG_BROKER_CONFIG_FILE is for multiplexing

(DG_BROKER_CONFIG_FILE1, DG_BROKER_CONFIG_FILE2)

• Set up the static listener entries on all databases

• Start the Broker processes on all the databases

(DG_BROKER_START=TRUE)

• Start DGMGRL and connect to the primary database

(dgmgrl sys/type_sys_pwd@db_service_name)

• Create the base configuration

DGMGRL> CREATE CONFIGURATION zabbix AS PRIMARY DATABASE IS zabbix CONNECT IDENTIFIER IS zabbix;

• Add the standby database to the Broker configuration

DGMGRL> ADD DATABASE zabbixdr AS CONNECT IDENTIFIER IS zabbixdr;

• Set the database properties

SHOW DATABASE VERBOSE Primary or database name;

• Enable the configuration

DGMGRL> ENABLE CONFIGURATION;
• Verify the configuration

DGMGRL> SHOW CONFIGURATION;

Step 1: Set Broker configuration file parameters (DG_BROKER_CONFIG_FILE1, DG_BROKER_CONFIG_FILE2)

[oracle@srv3 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 17 20:10:08 2021

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> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 PDB1 READ WRITE NO

SQL> ALTER SYSTEM SET DG_BROKER_CONFIG_FILE1='/u01/app/oracle/product/12.1.0.2/db_1/dbs/pr1ORADB.dat';

System altered.

SQL> ALTER SYSTEM SET DG_BROKER_CONFIG_FILE2='/u01/app/oracle/product/12.1.0.2/db_1/dbs/pr2ORADB.dat';

System altered.

SQL> exit

Step 2: Start the Broker processes on all the databases

SQL> SHOW PARAMETER DG_BROKER_START

NAME TYPE VALUE

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

dg_broker_start boolean FALSE

SQL> ALTER SYSTEM SET DG_BROKER_START=TRUE SCOPE=BOTH;

System altered.

Step 3:

SQL> alter system set LOG_ARCHIVE_DEST_2='' SCOPE=BOTH sid='*';

System altered.

SQL> exit

Step 3: Connect standby database Configure DG broker config file

SQL> ALTER SYSTEM SET DG_BROKER_CONFIG_FILE1='/u01/app/oracle/product/12.1.0.2/db_1/dbs/dr1ORADB.dat';

System altered.

SQL> ALTER SYSTEM SET DG_BROKER_CONFIG_FILE2='/u01/app/oracle/product/12.1.0.2/db_1/dbs/dr2ORADB.dat';

System altered.

SQL> SHOW PARAMETER DG_BROKER_START

NAME TYPE VALUE

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

dg_broker_start boolean FALSE

SQL> ALTER SYSTEM SET DG_BROKER_START=TRUE SCOPE=BOTH;

System altered.

SQL> alter system set LOG_ARCHIVE_DEST_2='' SCOPE=BOTH sid='*';

System altered.

Step4 : Start DGMGRL and connect to the primary database

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

DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

Welcome to DGMGRL, type "help" for information.

Connected as SYSDBA.

DGMGRL> show configuration

ORA-16532: Oracle Data Guard broker configuration does not exist

Configuration details cannot be determined by DGMGRL

#####################################################

STEP 5 : Create the base configuration on primary db host

DGMGRL> CREATE CONFIGURATION zabbix AS PRIMARY DATABASE IS zabbix CONNECT IDENTIFIER IS zabbix;

Configuration "zabbix" created with primary database "zabbix"

DGMGRL> show configuration

Configuration - zabbix

Protection Mode: MaxPerformance

Members:

zabbix - Primary database

Fast-Start Failover: DISABLED

Configuration Status:

DISABLED

Step 6 : Add Standby database in DGMGRL configuration on primary host.

DGMGRL> ADD DATABASE zabbixdr AS CONNECT IDENTIFIER IS zabbixdr;

Database "zabbixdr" added

DGMGRL> SHOW CONFIGURATION;

Configuration - zabbix

Protection Mode: MaxPerformance

Members:

zabbix - Primary database

zabbixdr - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

DISABLED

STEP 7 : Enable configuration on primary database

DGMGRL> ENABLE CONFIGURATION;

Enabled.

DGMGRL> SHOW CONFIGURATION;

Configuration - zabbix

Protection Mode: MaxPerformance

Members:

zabbix - Primary database

zabbixdr - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS (status updated 17 seconds ago)

DGMGRL>

STEP 7: Check standby database as well on DR database

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

DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

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

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS (status updated 15 seconds ago)

DGMGRL>

##################################################################

DGMGRL> SHOW DATABASE VERBOSE zabbix;

Database - zabbix

Role: PRIMARY

Intended State: TRANSPORT-ON

Instance(s):

zabbix

Properties:

DGConnectIdentifier = 'zabbix'

ObserverConnectIdentifier = ''

LogXptMode = 'ASYNC'

RedoRoutes = ''

DelayMins = '0'

Binding = 'optional'

MaxFailure = '0'

MaxConnections = '1'

ReopenSecs = '300'

NetTimeout = '30'

RedoCompression = 'DISABLE'

LogShipping = 'ON'

PreferredApplyInstance = ''

ApplyInstanceTimeout = '0'

ApplyLagThreshold = '0'

TransportLagThreshold = '0'

TransportDisconnectedThreshold = '30'

ApplyParallel = 'AUTO'

StandbyFileManagement = 'AUTO'

ArchiveLagTarget = '1800'

LogArchiveMaxProcesses = '4'

LogArchiveMinSucceedDest = '1'

DbFileNameConvert = '/u01/app/oracle/oradata/zabbixdr/, /u01/app/oracle/oradata/zabbix/'

LogFileNameConvert = '/u01/app/oracle/oradata/zabbixdr/, /u01/app/oracle/oradata/zabbix/'

FastStartFailoverTarget = ''

InconsistentProperties = '(monitor)'

InconsistentLogXptProps = '(monitor)'

SendQEntries = '(monitor)'

LogXptStatus = '(monitor)'

RecvQEntries = '(monitor)'

StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srv3.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=zabbix_DGMGRL)(INSTANCE_NAME=zabbix)(SERVER=DEDICATED)))'

StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'

AlternateLocation = ''

LogArchiveTrace = '0'

LogArchiveFormat = '%t_%s_%r.dbf'

TopWaitEvents = '(monitor)'

Database Status:

SUCCESS

DGMGRL>

#############################################################################

DGMGRL> SHOW DATABASE VERBOSE zabbixdr;

Database - zabbixdr

Role: PHYSICAL STANDBY

Intended State: APPLY-ON

Transport Lag: 0 seconds (computed 1 second ago)

Apply Lag: 0 seconds (computed 1 second ago)

Average Apply Rate: 1.00 KByte/s

Active Apply Rate: 2.37 MByte/s

Maximum Apply Rate: 2.38 MByte/s

Real Time Query: OFF

Instance(s):

zabbixdr

Properties:

DGConnectIdentifier = 'zabbixdr'

ObserverConnectIdentifier = ''

LogXptMode = 'ASYNC'

RedoRoutes = ''

DelayMins = '0'

Binding = 'optional'

MaxFailure = '0'

MaxConnections = '1'

ReopenSecs = '300'

NetTimeout = '30'

RedoCompression = 'DISABLE'

LogShipping = 'ON'

PreferredApplyInstance = ''

ApplyInstanceTimeout = '0'

ApplyLagThreshold = '0'

TransportLagThreshold = '0'

TransportDisconnectedThreshold = '30'

ApplyParallel = 'AUTO'

StandbyFileManagement = 'AUTO'

ArchiveLagTarget = '1800'

LogArchiveMaxProcesses = '4'

LogArchiveMinSucceedDest = '1'

DbFileNameConvert = '/u01/app/oracle/oradata/zabbix/, /u01/app/oracle/oradata/zabbixdr/'

LogFileNameConvert = '/u01/app/oracle/oradata/zabbix/, /u01/app/oracle/oradata/zabbixdr/'

FastStartFailoverTarget = ''

InconsistentProperties = '(monitor)'

InconsistentLogXptProps = '(monitor)'

SendQEntries = '(monitor)'

LogXptStatus = '(monitor)'

RecvQEntries = '(monitor)'

StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srv4.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=zabbixdr_DGMGRL)(INSTANCE_NAME=zabbixdr)(SERVER=DEDICATED)))'

StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'

AlternateLocation = ''

LogArchiveTrace = '0'

LogArchiveFormat = '%t_%s_%r.dbf'

TopWaitEvents = '(monitor)'

Database Status:

SUCCESS

DGMGRL>

##########################################

STEP 8 : Shutdown DG broker configuration to stop MRP process in standby

DGMGRL> EDIT DATABASE zabbixdr SET STATE=APPLY-OFF;

Succeeded.

DGMGRL> show configuration;

Configuration - zabbix

Protection Mode: MaxPerformance

Members:

zabbix - Primary database

zabbixdr - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS (status updated 3 seconds ago)

DGMGRL>