Oracle Database Commands and Practical Examples

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>