Database Administrator's blog: DataGuard

Showing posts with label DataGuard. Show all posts

Sunday, March 2, 2025

Resolving Gaps In Data Guard Using Incremental Rman Backup

1. [Standby] Stop the managed standby apply process:

SQL> alter database recover managed standby database cancel;

2. [Standby] Shutdown the standby database

3. [Primary] On the primary, take an incremental backup from the SCN number where the standby has been stuck:

StandBY

========

SQL> select to_char(current_scn) from v$database;

TO_CHAR(CURRENT_SCN)

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

33762732337439

SQL>

Primary

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

SQL> select to_char(current_scn) from v$database;

TO_CHAR(CURRENT_SCN)

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

33763275785289

--=== Primary ==

run {

allocate channel c1 type disk format '/u03/dpump/%U.rmb';

backup incremental from scn 33762732337439 database;

}

4. [Primary] On the primary, create a new standby controlfile:

alter database create standby controlfile as '/u03/dpump/BACH_standby.ctl';

SQL> alter database create standby controlfile as '/u03/dpump/BACH_standby.ctl';

Database altered.

SQL>

[oracle@drbach dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Mar 3 10:21:51 2025

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 1.3422E+11 bytes

Fixed Size 30046408 bytes

Variable Size 1.9059E+10 bytes

Database Buffers 1.1489E+11 bytes

Redo Buffers 238387200 bytes

SQL>

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "BAwalletpass#456" CONTAINER=ALL;

keystore altered.

SQL>

8. [Standby] Replace the controlfile with the one you just created in primary.

[oracle@drbach dpump]$ cp BACH_standby.ctl /u05/app/oracle/oradata/bachdb/control01.ctl

[oracle@drbach dpump]$ cp BACH_standby.ctl /fra/control02.ctl

[oracle@drbach dpump]$

[oracl

10.[Standby] Mount the standby database:

SQL> alter database mount standby database;

Database altered.

SQL>

11.[Standby] RMAN does not know about these files yet; so you must let it know – by a process called cataloging. Catalog these files:

RMAN> catalog start with '/u03/dpump';

Starting implicit crosscheck backup at 03-MAR-25

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=3782 device type=DISK

Crosschecked 116 objects

Finished implicit crosscheck backup at 03-MAR-25

Starting implicit crosscheck copy at 03-MAR-25

using channel ORA_DISK_1

Crosschecked 6 objects

Finished implicit crosscheck copy at 03-MAR-25

searching for all files in the recovery area

cataloging files...

cataloging done

List of Cataloged Files

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

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54857_mvx8zjtk_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54858_mvx9n0rd_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54860_mvxboyt7_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54861_mvxboyvj_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54862_mvxc9kv1_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54864_mvxcnfvg_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54867_mvxcwn6g_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54868_mvxcwn7z_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54871_mvxdng31_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54873_mvxf1lqp_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54874_mvxfgpt0_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54875_mvxg9rnq_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54878_mvxgp4yg_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54879_mvxh51p0_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54880_mvxhjfr9_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54881_mvxhxlgx_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54882_mvxjbpkk_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54885_mvxjqv54_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54886_mvxk4z5z_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54887_mvxklhsj_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54888_mvxlslok_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54889_mvxm6q98_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54890_mvxn10db_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54892_mvxnsfqz_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54893_mvxompvh_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54896_mvxpfzcv_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54897_mvxpgbd8_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54899_mvxpv3tw_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54900_mvxpvnt4_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54902_mvxq8869_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54903_mvxqof1x_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54904_mvxqow4b_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54905_mvxr2l5x_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54906_mvxr3y2n_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54907_mvxrwvcz_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54908_mvxsq4fs_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54909_mvxt49b7_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54910_mvxv7z4b_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54911_mvxw27tv_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54912_mvxyy9rv_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54914_mvy490kx_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54916_mvy7vg7n_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54917_mvygfs94_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54918_mvyh83r5_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54919_mvyho7kj_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54920_mvylk5nq_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54848_mvw2fm7k_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54849_mvw8bw98_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54850_mvwhy4jx_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54851_mvwo75l1_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54855_mvx72kf3_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54856_mvx7ymp3_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54857_mvx8zjqq_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54858_mvx9lnqv_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54859_mvxb4grs_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54860_mvxbnlry_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54861_mvxbz2s3_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54862_mvxc85sb_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54863_mvxcfbsy_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54864_mvxcm1t0_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54865_mvxcq8tm_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54866_mvxcrov9_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54867_mvxcv6v3_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54868_mvxcxnv8_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54869_mvxd3kvw_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54870_mvxdksws_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54871_mvxdqsx3_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54872_mvxdzvxg_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54873_mvxfbnyb_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54874_mvxg8cz6_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54875_mvxgfg01_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54876_mvxgh40j_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54877_mvxgn612_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54878_mvxh2x11_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54879_mvxhc81r_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54880_mvxhvd28_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54881_mvxj0q2o_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54882_mvxjhc30_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54883_mvxjk13n_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54884_mvxjox42_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54885_mvxjxf44_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54886_mvxkk34f_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54887_mvxlr054_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54888_mvxm575g_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54889_mvxmpy5n_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54890_mvxn4860_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54891_mvxnmq6x_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54892_mvxogx6y_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54893_mvxp2z7b_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54894_mvxp4y7o_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54895_mvxp817n_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54896_mvxpdn8b_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54897_mvxpl88m_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54898_mvxpqp92_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54899_mvxpsv8z_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54900_mvxpwl97_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54901_mvxq6p9z_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54902_mvxqhwbf_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54903_mvxqn3hn_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54904_mvxqvzj0_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54905_mvxr2kjb_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54906_mvxrs7jr_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54907_mvxsn4k1_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54908_mvxt2lk3_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54909_mvxtc6k5_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54910_mvxvv0kw_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54911_mvxywbl6_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54912_mvy45qmm_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54913_mvy45xnd_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54914_mvy4dz6y_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54915_mvy7mwnl_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54916_mvyg7op0_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54917_mvyh0mp2_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54918_mvyhdspc_.arc

File Name: /fra/DRBACH/archivelog/2025_02_26/o1_mf_1_54919_mvylbw0g_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54921_mvys379j_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54922_mvyy0rd6_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54923_mvz6ngc7_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54924_mvzdso89_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54925_mvzs36hs_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54926_mvzvkz7g_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54927_mvzvz3b6_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54928_mvzx6k82_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54930_mvzyfx4f_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54931_mvzyv2g7_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54933_mvzzmg2r_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54934_mvzzmpvx_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54938_mw00ct98_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54939_mw00ryxp_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54940_mw0164ky_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54941_mw01nfs3_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54942_mw02fjd0_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54943_mw037s2x_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54946_mw03nwr6_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54947_mw03o62d_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54948_mw0420vj_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54949_mw043tsh_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54950_mw04wco0_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54951_mw063rr1_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54952_mw06y1b2_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54953_mw07r9sn_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54954_mw085fwm_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54959_mw08zpc3_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54960_mw09syx9_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54961_mw0b77gw_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54963_mw0bn72y_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54966_mw0c1c69_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54967_mw0c1n37_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54969_mw0cgh9d_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54970_mw0d8qhv_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54971_mw0f2zyj_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54972_mw0gbd7w_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54973_mw0h4nmw_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54974_mw0hyxdb_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54975_mw0lfpst_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54980_mw0nhcwd_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54981_mw0nwhr7_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54982_mw0nwsbn_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54988_mw0o9mxw_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54989_mw0py4xs_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54990_mw12tvnc_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54991_mw137zq9_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54992_mw16ypqd_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54920_mvyrs14w_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54921_mvyxr1y0_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54922_mvz6980o_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54923_mvzdr8h6_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54924_mvzrwykg_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54925_mvzvb9kw_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54926_mvzvw0l5_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54927_mvzx3olr_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54928_mvzxm4m4_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54929_mvzy4omr_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54930_mvzyr2mp_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54931_mvzz1tn0_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54932_mvzzcynr_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54933_mvzzl4nx_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54934_mvzzv7om_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54935_mw005npf_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54936_mw008cq1_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54937_mw00b4q8_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54938_mw00lvqn_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54939_mw012fqo_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54940_mw01m0r8_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54941_mw02cvrn_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54942_mw0360s8_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54943_mw038nsj_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54944_mw03c8ss_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54945_mw03fpsw_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54946_mw03mmsz_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54947_mw03yht8_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54948_mw042ftn_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54949_mw04qjv1_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54950_mw05qdv3_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54951_mw06o0vk_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54952_mw07j3vr_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54953_mw081qw2_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54954_mw08dswh_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54955_mw08g3x0_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54956_mw08h7xk_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54957_mw08jgxn_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54958_mw08r1xy_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54959_mw09jpy2_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54960_mw0b5syf_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54961_mw0bj0ym_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54962_mw0bl5z4_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54963_mw0bsryv_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54964_mw0bwm07_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54965_mw0by60q_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54966_mw0bzz0n_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54967_mw0c3n18_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54968_mw0c621q_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54969_mw0cyq1x_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54970_mw0dt62n_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54971_mw0g1o2w_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54972_mw0gsy37_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54973_mw0hxd3f_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54974_mw0l3f46_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54975_mw0mvl4w_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54976_mw0mwp5b_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54977_mw0mxk60_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54978_mw0my669_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54979_mw0mymyx_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54980_mw0nrt6h_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54981_mw0nvc6o_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54982_mw0nx16x_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54983_mw0ny87k_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54984_mw0nz37t_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54985_mw0nzo89_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54986_mw0nzy8b_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54987_mw0o3l3x_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54988_mw0pqn8n_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54989_mw12mbfy_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54990_mw1316g7_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54991_mw16x99w_.arc

File Name: /fra/DRBACH/archivelog/2025_02_27/o1_mf_1_54992_mw19vbbx_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_54993_mw1b75vt_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_54994_mw1h4pyy_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_54995_mw1r6g7c_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_54996_mw1z64bc_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_54997_mw29dwv9_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_54998_mw32fpot_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_54999_mw3qc7mw_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_55000_mw3qrcpw_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_55001_mw3rlmxz_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_55002_mw3vvo5f_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_54993_mw1gzrkc_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_54994_mw1r50mh_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_54995_mw1z4pnp_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_54996_mw29b6p8_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_54997_mw32chvv_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_54998_mw3pyy1t_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_54999_mw3qf322_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_55000_mw3r9m2f_.arc

File Name: /fra/DRBACH/archivelog/2025_02_28/o1_mf_1_55001_mw3vk339_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55003_mw420sqp_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55004_mw4dox47_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55005_mw4lttkp_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55006_mw4qc7lw_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55007_mw4z4odp_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55008_mw57rcdo_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55009_mw5f30n7_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55010_mw5lfovz_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55011_mw5py2xr_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55012_mw5tn7s6_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55013_mw5yqjrg_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55014_mw620kjj_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55015_mw68lm1m_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55016_mw6c1cmd_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55017_mw6cgs9l_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55018_mw6f3043_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55019_mw6fx8b6_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55020_mw6js4yj_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55002_mw41zc5b_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55003_mw4dhq7j_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55004_mw4lh5bh_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55005_mw4q41bq_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55006_mw4yrgdj_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55007_mw57dnh6_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55008_mw5dvrm2_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55009_mw5l4wqy_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55010_mw5pocrc_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55011_mw5td4s4_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55012_mw5yhvv1_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55013_mw61qgvy_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55014_mw6642wz_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55015_mw6btkz5_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55016_mw6cfb0n_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55017_mw6dqwwp_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55018_mw6frnf4_.arc

File Name: /fra/DRBACH/archivelog/2025_03_01/o1_mf_1_55019_mw6jq4g3_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55021_mw6nh9sn_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55022_mw6qc6hl_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55023_mw6v1cbz_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55024_mw7168vn_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55025_mw75b6pl_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55026_mw79ftv1_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55027_mw7dovkh_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55028_mw7mo171_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55030_mw7qpg6v_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55033_mw7sbyn4_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55035_mw7sr2sx_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55038_mw7tlby1_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55039_mw7tzh27_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55040_mw7vdm50_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55042_mw7vsq8f_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55043_mw7w6vox_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55076_mw849l1y_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55044_mw7w8rbp_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55045_mw7wnrfq_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55047_mw7x13sp_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55050_mw7xsj0f_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55051_mw7y6n3n_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55054_mw802nlz_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55055_mw80hrpc_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55058_mw80wwsr_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55059_mw80xtmd_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55060_mw81b0x5_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55062_mw81q50x_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55063_mw824947_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55065_mw82kf7m_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55066_mw82ykbn_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55069_mw83cog9_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55072_mw83rslf_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55073_mw83sjtg_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55076_mw845xnw_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55077_mw84m1r7_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55079_mw8505vb_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55082_mw85tg43_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55084_mw867lf0_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55085_mw86npd3_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55086_mw87w2of_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55087_mw895342_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55088_mw8c54hc_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55020_mw6n7r25_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55021_mw6q5m2x_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55022_mw6txm3j_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55023_mw70wo4w_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55024_mw758q69_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55025_mw79dc7t_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55094_mw8j6o5r_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55026_mw7dbh8o_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55027_mw7mf2bo_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55028_mw7p9wc7_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55029_mw7qh0cz_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55030_mw7r1ldc_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55031_mw7rfvdt_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55032_mw7rsvff_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55033_mw7sc9fc_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55034_mw7skhg6_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55035_mw7sq0g6_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55036_mw7t0ogw_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55037_mw7th0h9_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55038_mw7twphs_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55039_mw7v7lj2_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55040_mw7vkpk8_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55041_mw7voxl8_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55042_mw7vtzl9_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55043_mw7w78lt_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55044_mw7wm8m3_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55045_mw7wvfm6_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55046_mw7wzcmq_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55047_mw7x4wmo_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55048_mw7xfmn4_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55049_mw7xq8nl_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55050_mw7y4onq_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55051_mw7ywhnx_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55052_mw7zo1oh_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55053_mw7zy4or_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55054_mw805goz_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55055_mw80m7s1_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55056_mw80nxsk_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55057_mw80smsw_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55058_mw80wbt0_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55059_mw8170tb_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55060_mw819nts_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55061_mw81k4v4_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55062_mw81w0vf_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55063_mw827cvk_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55064_mw82cywn_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55065_mw82nvwy_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55066_mw834pxj_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55067_mw836hyd_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55068_mw838kyd_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55077_mw84n22b_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55069_mw83ffys_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55070_mw83k004_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55071_mw83p509_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55072_mw83r10m_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55073_mw83wt0w_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55074_mw83zx1h_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55075_mw843r1s_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55078_mw84ww33_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55079_mw85gp35_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55080_mw85nj3m_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55081_mw85rx3r_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55082_mw85zo3p_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55083_mw865l40_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55084_mw86d445_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55085_mw87lr4b_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55086_mw893m4f_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55087_mw8bw44q_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55091_mw8dpmkj_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55089_mw8dpp56_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55095_mw8ll784_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55096_mw8p2x9x_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55097_mw8ts0dx_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55098_mw8zhdhc_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55099_mw8zw7j8_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55100_mw9187ws_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55101_mw9309y0_.arc

File Name: /fra/DRBACH/archivelog/2025_03_02/o1_mf_1_55102_mw95ygcw_.arc

File Name: /fra/DRBACH/archivelog/2025_03_03/o1_mf_1_55103_mw9b1sg2_.arc

File Name: /fra/DRBACH/archivelog/2025_03_03/o1_mf_1_55104_mw9dzxjg_.arc

File Name: /fra/DRBACH/archivelog/2025_03_03/o1_mf_1_55105_mw9jjplh_.arc

File Name: /fra/DRBACH/archivelog/2025_03_03/o1_mf_1_55106_mw9pdook_.arc

File Name: /fra/DRBACH/archivelog/2025_03_03/o1_mf_1_55107_mw9w8ns2_.arc

File Name: /fra/DRBACH/archivelog/2025_03_03/o1_mf_1_55108_mwb0z0w5_.arc

File Name: /fra/DRBACH/archivelog/2025_03_03/o1_mf_1_55109_mwb9nncq_.arc

File Name: /fra/DRBACH/archivelog/2025_03_03/o1_mf_1_55110_mwbc0jfb_.arc

searching for all files that match the pattern /u03/dpump

List of Files Unknown to the Database

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

File Name: /u03/dpump/BACH_standby.ctl

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

cataloging files...

cataloging done

List of Cataloged Files

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

File Name: /u03/dpump/BACH_standby.ctl

RMAN>

12.Recover these files:

RMAN> recover database;

Starting recover at 03-MAR-25

using channel ORA_DISK_1

channel ORA_DISK_1: starting incremental datafile backup set restore

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

destination for restore of datafile 00156: /u05/app/oracle/oradata/drbach/micrarch/MICRIMG02.DBF

destination for restore of datafile 00158: /u05/app/oracle/oradata/drbach/micrarch/MICRIMG04.DBF

destination for restore of datafile 00182: /u05/app/oracle/oradata/drbach/micrarch/MICRXML06.DBF

destination for restore of datafile 00196: /data01/app/oracle/oradata/drbach/micrarch/CHQIMG05.DBF

channel ORA_DISK_1: reading from backup piece /u03/dpump/bm3jdk94_1_1.rmb

channel ORA_DISK_1: piece handle=/u03/dpump/bm3jdk94_1_1.rmb tag=TAG20250303T095340

channel ORA_DISK_1: restored backup piece 1

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

channel ORA_DISK_1: starting incremental datafile backup set restore

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

destination for restore of datafile 00178: /u05/app/oracle/oradata/drbach/micrarch/MICRXML02.DBF

channel ORA_DISK_1: restored backup piece 1

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

starting media recovery

archived log for thread 1 with sequence 55110 is already on disk as file /fra/DRBACH/archivelog/2025_03_03/o1_mf_1_55110_mwbc0jfb_.arc

archived log file name=/fra/DRBACH/archivelog/2025_03_03/o1_mf_1_55110_mwbc0jfb_.arc thread=1 sequence=55110

media recovery complete, elapsed time: 00:00:02

Finished recover at 03-MAR-25

RMAN>

14.At this point exit RMAN and start managed recovery process:

ecovery Manager complete.

[oracle@drbach dpump]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Mar 3 10:30:55 2025

Connected to:

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

SQL> alter database open;

Database altered.

SQL>

SQL> alter database recover managed standby database using current logfile disconnect;

Tuesday, July 17, 2018

Dataguard Broker

Last login: Mon May 21 18:42:35 2018
[oracle@bach1 ~]$
[oracle@bach1 ~]$ dgmgrl sys@cdb12c
DGMGRL for Linux: Release 12.2.0.1.0 - Production on Mon May 21 23:58:41 2018

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

Welcome to DGMGRL, type "help" for information.
Password:
Connected to "cdb12c"
Connected as SYSDBA.
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> create configuration cdb as primary database is cdb12c connect identifier is cdb12c;
Configuration "cdb" created with primary database "cdb12c"
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> add database cdr12c as connect identifier is cdr12c maintained as physical;
Database "cdr12c" added
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> enable configuration;
Enabled.
DGMGRL> show configuration;

Configuration - cdb

Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database
Warning: ORA-16809: multiple warnings detected for the member

Fast-Start Failover: DISABLED

Configuration Status:
WARNING (status updated 38 seconds ago)

DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 3 minutes (computed 26 seconds ago)
Apply Lag: 3 minutes (computed 26 seconds ago)
Average Apply Rate: 6.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
ORA-16789: standby redo logs configured incorrectly

Database Status:
WARNING

DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 4 minutes (computed 21 seconds ago)
Apply Lag: 4 minutes (computed 21 seconds ago)
Average Apply Rate: 6.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
ORA-16789: standby redo logs configured incorrectly

Database Status:
WARNING

DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 minutes 59 seconds (computed 52 seconds ago)
Apply Lag: 10 minutes 59 seconds (computed 52 seconds ago)
Average Apply Rate: 6.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
ORA-16857: member disconnected from redo source for longer than specified threshold
ORA-16789: standby redo logs configured incorrectly

Database Status:
WARNING

DGMGRL>

DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 hours 16 minutes 4 seconds (computed 47 seconds ago)
Apply Lag: 10 hours 16 minutes 4 seconds (computed 47 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: ON
Instance(s):
cdr12c

Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
ORA-16857: member disconnected from redo source for longer than specified threshold

Database Status:
WARNING

DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 hours 17 minutes 4 seconds (computed 5 seconds ago)
Apply Lag: 10 hours 17 minutes 4 seconds (computed 5 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: ON
Instance(s):
cdr12c

Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold

Database Status:
WARNING

DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 hours 17 minutes 4 seconds (computed 14 seconds ago)
Apply Lag: 10 hours 17 minutes 4 seconds (computed 14 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: ON
Instance(s):
cdr12c

Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold

Database Status:
WARNING

DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 hours 17 minutes 4 seconds (computed 20 seconds ago)
Apply Lag: 10 hours 17 minutes 4 seconds (computed 20 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: ON
Instance(s):
cdr12c

Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold

Database Status:
WARNING

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 hours 20 minutes 5 seconds (computed 20 seconds ago)
Apply Lag: 10 hours 20 minutes 5 seconds (computed 20 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: ON
Instance(s):
cdr12c

Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold

Database Status:
WARNING

DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c StandbyFileManagement;
StandbyFileManagement = 'AUTO'
DGMGRL>
DGMGRL> show database cdb12c StandbyFileManagement;
StandbyFileManagement = 'AUTO'
DGMGRL>
DGMGRL> exit
[oracle@bach1 ~]$
[oracle@bach1 ~]$ dgmgrl sys@cdb12c
DGMGRL for Linux: Release 12.2.0.1.0 - Production on Tue May 22 21:49:27 2018

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

Welcome to DGMGRL, type "help" for information.
Password:
Connected to "cdb12c"
Connected as SYSDBA.
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 hours 31 minutes 5 seconds (computed 51 seconds ago)
Apply Lag: 10 hours 31 minutes 5 seconds (computed 51 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: ON
Instance(s):
cdr12c

Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
ORA-16857: member disconnected from redo source for longer than specified threshold

Database Status:
WARNING

DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 10 hours 37 minutes 6 seconds (computed 19 seconds ago)
Apply Lag: 10 hours 37 minutes 6 seconds (computed 19 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: ON
Instance(s):
cdr12c

Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold

Database Status:
WARNING

DGMGRL>
DGMGRL> help TransportDisconnectedThreshold
Unrecognized command "transportdisconnectedthreshold", try "help"
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

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: 39.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

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: 38.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

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: 38.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 37.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 10.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration

Configuration - cdb

Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS (status updated 31 seconds ago)

DGMGRL>
DGMGRL> show database secondary;
Object "secondary" was not found
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show instance cdb12c

Instance 'cdb12c' of database 'cdb12c'

Instance Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> help

The following commands are available:

@ Execute DGMGRL script file
! Host operating system command
/ Repeat the last command
-- Comment to be ignored by DGMGRL
add Adds a member to the broker configuration
connect Connects to an Oracle database instance
convert Converts a database from one type to another
create Creates a broker configuration
disable Disables a configuration, a member, or fast-start failover
edit Edits a configuration or a member
enable Enables a configuration, a member, or fast-start failover
exit Exits the program
failover Changes a standby database to be the primary database
help Displays description and syntax for a command
host Host operating system command
migrate Migrate a pluggable database from one configuration to another.
quit Exits the program
reinstate Changes a database marked for reinstatement into a viable standby
rem Comment to be ignored by DGMGRL
remove Removes a configuration or a member
set Set a property to a specified value
show Displays information about a configuration or a member
shutdown Shuts down a currently running Oracle database instance
spool store input and output of DGMGRL CLI in a file
sql Executes a SQL statement
start Starts the fast-start failover observer
startup Starts an Oracle database instance
stop Stops the fast-start failover observer
switchover Switches roles between a primary and standby database
validate Performs an exhaustive set of validations for a database

Use "help <command>" to see syntax for individual commands

DGMGRL>
DGMGRL>
DGMGRL> validate database cdb12c

Database Role: Primary database

Ready for Switchover: Yes

Flashback Database Status:
cdb12c: Off

Managed by Clusterware:
cdb12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover

DGMGRL> validate database cdr12c

Database Role: Physical standby database
Primary Database: cdb12c

Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)

Flashback Database Status:
cdb12c: Off
cdr12c: Off

Managed by Clusterware:
cdb12c: NO
cdr12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover

DGMGRL> validate database cdb12c

Database Role: Primary database

Ready for Switchover: Yes

Managed by Clusterware:
cdb12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover

DGMGRL>
DGMGRL> validate database cdr12c

Database Role: Physical standby database
Primary Database: cdb12c

Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)

Flashback Database Status:
cdb12c: On
cdr12c: Off

Managed by Clusterware:
cdb12c: NO
cdr12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover

DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c

Database Status:
SHUTDOWN

DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c

Database Status:
SHUTDOWN

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c

Database Status:
SHUTDOWN

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c

Database Status:
SHUTDOWN

DGMGRL>
DGMGRL>

DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c

Database Status:
SHUTDOWN

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c

Database Status:
SHUTDOWN

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> exit
[oracle@bach1 ~]$
[oracle@bach1 ~]$
[oracle@bach1 ~]$
[oracle@bach1 ~]$
[oracle@bach1 ~]$ dgmgl
bash: dgmgl: command not found...
[oracle@bach1 ~]$
[oracle@bach1 ~]$ dgmgrl
DGMGRL for Linux: Release 12.2.0.1.0 - Production on Wed May 23 00:42:36 2018

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

Welcome to DGMGRL, type "help" for information.
DGMGRL>
DGMGRL> exit
[oracle@bach1 ~]$ dgmgrl sys/Nblcdb12c
DGMGRL for Linux: Release 12.2.0.1.0 - Production on Wed May 23 00:43:11 2018

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

Welcome to DGMGRL, type "help" for information.
Connected to "cdb12c"
Connected as SYSDG.
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL> show database database cdr12c
Object "database" was not found
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c

Database Status:
SHUTDOWN

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: OFFLINE
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
cdr12c

Database Status:
SHUTDOWN

DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 1.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the member setting
Warning: ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting

Database Status:
WARNING

DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 1.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the member setting
Warning: ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting

Database Status:
WARNING

DGMGRL> show database cdr12c

Database - cdr12c

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
Real Time Query: ON
Instance(s):
cdr12c
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the member setting
Warning: ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting

Database Status:
WARNING

DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 1.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the member setting
Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the member setting
Warning: ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting

Database Status:
WARNING

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration

Configuration - cdb

Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database
Warning: ORA-16792: configurable property value is inconsistent with member setting

Fast-Start Failover: DISABLED

Configuration Status:
WARNING (status updated 29 seconds ago)

DGMGRL> show database ‘PRIMARY’ InconsistentProperties
Object "???primary???" was not found
DGMGRL>
DGMGRL> show database 'cdb12c' InconsistentProperties
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE

DGMGRL>
DGMGRL>
DGMGRL> SHOW CONFIGURATION VERBOSE;

Configuration - cdb

Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database
Warning: ORA-16792: configurable property value is inconsistent with member setting

Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
ConfigurationWideServiceName = 'cdb12c_CFG'

Fast-Start Failover: DISABLED

Configuration Status:
WARNING

DGMGRL> show database primary statusreport;
Object "primary" was not found
DGMGRL>
DGMGRL>
DGMGRL> show databsae cdb12c statusreport;
show databsae cdb12c statusreport;
^
Syntax error before or at "databsae"
DGMGRL>
DGMGRL> show database cdb12c statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT

DGMGRL>
DGMGRL> show database cdr12c statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
cdr12c WARNING ORA-16714: the value of property ArchiveLagTarget is inconsistent with the member setting
cdr12c WARNING ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the member setting
cdr12c WARNING ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the member setting
cdr12c WARNING ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting

DGMGRL> show configuration

Configuration - cdb

Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database
Warning: ORA-16809: multiple warnings detected for the member

Fast-Start Failover: DISABLED

Configuration Status:
WARNING (status updated 34 seconds ago)

DGMGRL> show database cdr12c statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
* WARNING ORA-16853: apply lag has exceeded specified threshold
* WARNING ORA-16855: transport lag has exceeded specified threshold
cdr12c WARNING ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting

DGMGRL> show database cdr12c statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
* WARNING ORA-16853: apply lag has exceeded specified threshold
* WARNING ORA-16855: transport lag has exceeded specified threshold

DGMGRL> show database cdr12c statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
* WARNING ORA-16853: apply lag has exceeded specified threshold
* WARNING ORA-16855: transport lag has exceeded specified threshold

DGMGRL>
DGMGRL>
DGMGRL> /
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
* WARNING ORA-16853: apply lag has exceeded specified threshold
* WARNING ORA-16855: transport lag has exceeded specified threshold

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 2 minutes 46 seconds (computed 12 seconds ago)
Apply Lag: 2 minutes 46 seconds (computed 12 seconds ago)
Average Apply Rate: 1.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold

Database Status:
WARNING

DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 2.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 2.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 2.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 2.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

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: 3.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration

Configuration - cdb

Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS (status updated 47 seconds ago)

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration

Configuration - cdb

Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS (status updated 9 seconds ago)

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> validate database cdr12c

Database Role: Physical standby database
Primary Database: cdb12c

Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)

Managed by Clusterware:
cdb12c: NO
cdr12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration

Configuration - cdb

Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS (status updated 30 seconds ago)

DGMGRL>
DGMGRL>
DGMGRL> show configuration

Configuration - cdb

Protection Mode: MaxPerformance
Members:
cdb12c - Primary database
cdr12c - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS (status updated 38 seconds ago)

DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 10.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL> validate database cdr12c

Database Role: Physical standby database
Primary Database: cdb12c

Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)

Managed by Clusterware:
cdb12c: NO
cdr12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> validate database cdr12c

Database Role: Physical standby database
Primary Database: cdb12c

Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)

Managed by Clusterware:
cdb12c: NO
cdr12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> validate database cdb12c

Database Role: Primary database

Ready for Switchover: Yes

Managed by Clusterware:
cdb12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover

DGMGRL>
DGMGRL>
DGMGRL> validate database cdb12c

Database Role: Primary database

Ready for Switchover: Yes

Managed by Clusterware:
cdb12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover

DGMGRL>
DGMGRL> validate database cdr12c

Database Role: Physical standby database
Primary Database: cdb12c

Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)

Managed by Clusterware:
cdb12c: NO
cdr12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> validate database cdr12c

Database Role: Physical standby database
Primary Database: cdb12c

Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)

Managed by Clusterware:
cdb12c: NO
cdr12c: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover

DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL> show database
show database
^
Syntax error before or at "end-of-line"
DGMGRL>
DGMGRL> show database cdb12c

Database - cdb12c

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
cdb12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL> show database cdr12c

Database - cdr12c

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 9.00 KByte/s
Real Time Query: ON
Instance(s):
cdr12c

Database Status:
SUCCESS

DGMGRL>
DGMGRL> exit
[oracle@bach1 ~]$

Configure Oracle 12c Physical standby database

--===================
[oracle@bach1 ~]$
vi $ORACLE_HOME/sqlplus/admin/glogin.sql

and put there following line

SET SQLPROMPT "_user'@'_connect_identifier'> '"
[oracle@bach1 ~]$ export ORACLE_SID=cdb12c

--================

[oracle@bach1 ~]$ sqlplus / as sysdba
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SYS@cdb12c>

[oracle@bach1 ~]$ sqlplus / as sysdba

SQL> SELECT log_mode, open_mode, force_logging
2 FROM v$database;

LOG_MODE OPEN_MODE FORCE_LOGGING
------------ -------------------- ---------------------------------------
ARCHIVELOG READ WRITE NO

SQL> ALTER DATABASE FORCE LOGGING;

LOG_MODE OPEN_MODE FORCE_LOGGING
------------ -------------------- ---------------------------------------
ARCHIVELOG READ WRITE YES

SYS@cdb12c> col name for a30
SYS@cdb12c> col value for a60
SYS@cdb12c>
SYS@cdb12c>
SYS@cdb12c> SELECT name, value FROM v$parameter WHERE name LIKE 'db_recovery%';

NAME VALUE
------------------------------ ------------------------------------------------------------
db_recovery_file_dest /fra/fast_recovery_area/cdb12c
db_recovery_file_dest_size 80530636800

SYS@cdb12c>
SYS@cdb12c> SELECT log_mode, open_mode FROM v$database;

LOG_MODE OPEN_MODE
------------ --------------------
ARCHIVELOG READ WRITE

SYS@cdb12c> set linesize 300
SYS@cdb12c> column REDOLOG_FILE_NAME format a50
SYS@cdb12c> SELECT
2 a.GROUP#,
3 a.THREAD#,
4 a.SEQUENCE#,
5 a.ARCHIVED,
6 a.STATUS,
7 b.MEMBER AS REDOLOG_FILE_NAME,
8 (a.BYTES/1024/1024) AS SIZE_MB
9 FROM v$log a
10 JOIN v$logfile b ON a.Group#=b.Group#
11 ORDER BY a.GROUP# ASC;

GROUP# THREAD# SEQUENCE# ARC STATUS REDOLOG_FILE_NAME SIZE_MB
---------- ---------- ---------- --- ---------------- -------------------------------------------------- ----------
1 1 145 YES ACTIVE /data/oradata/cdb12c/redo01.log 200
2 1 146 NO CURRENT /data/oradata/cdb12c/redo02.log 200
3 1 144 YES ACTIVE /data/oradata/cdb12c/redo03.log 200

SYS@cdb12c>

SYS@cdb12c> SELECT group#, type FROM v$logfile;

GROUP# TYPE
---------- -------
3 ONLINE
2 ONLINE
1 ONLINE

SYS@cdb12c>
SYS@cdb12c>

SYS@cdb12c> ALTER DATABASE ADD STANDBY LOGFILE SIZE 200m;

Database altered.

SYS@cdb12c> ALTER DATABASE ADD STANDBY LOGFILE SIZE 200m;

Database altered.

SYS@cdb12c> ALTER DATABASE ADD STANDBY LOGFILE SIZE 200m;

Database altered.

SYS@cdb12c> ALTER DATABASE ADD STANDBY LOGFILE SIZE 200m;

Database altered.

SYS@cdb12c>

SYS@cdb12c> SELECT group#, type FROM v$logfile;

GROUP# TYPE
---------- -------
3 ONLINE
2 ONLINE
1 ONLINE
4 STANDBY
5 STANDBY
6 STANDBY
7 STANDBY

7 rows selected.

SYS@cdb12c>

SYS@cdb12c> set pagesize 500
SYS@cdb12c> set linesize 500
SYS@cdb12c> col name for a40
SYS@cdb12c> col value for a60
SYS@cdb12c>
SYS@cdb12c> SELECT name, value
2 FROM v$parameter
3 WHERE name IN
4 ( 'db_name',
5 'db_unique_name',
6 'log_archive_format',
7 'remote_login_passwordfile' )
8 ORDER BY NAME;

NAME VALUE
---------------------------------------- ------------------------------------------------------------
db_name cdb12c
db_unique_name cdb12c
log_archive_format %t_%s_%r.dbf
remote_login_passwordfile EXCLUSIVE

SYS@cdb12c>

SYS@cdb12c> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG ='DG_CONFIG=(cdb12c,cdr12c)' SCOPE=BOTH;

System altered.

SYS@cdb12c> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=cdb12c' SCOPE=BOTH;

System altered.

SYS@cdb12c> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=cdr12c ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=cdr12c' SCOPE=BOTH;

System altered.

SYS@cdb12c> show parameter LOG_ARCHIVE_CONFIG

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string DG_CONFIG=(cdb12c,cdr12c)
SYS@cdb12c>
SYS@cdb12c> show parameter LOG_ARCHIVE_DEST_1

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_
DEST VALID_FOR=(ALL_LOGFILES,A
LL_ROLES) DB_UNIQUE_NAME=cdb12
c
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
SYS@cdb12c>
SYS@cdb12c> show parameter LOG_ARCHIVE_DEST_2

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string SERVICE=cdr12c ASYNC VALID_FOR
=(ONLINE_LOGFILES,PRIMARY_ROLE
) DB_UNIQUE_NAME=cdr12c
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
SYS@cdb12c>

SYS@cdb12c> ALTER SYSTEM SET FAL_SERVER = cdr12c SCOPE=BOTH;

System altered.

SYS@cdb12c> ALTER SYSTEM SET DB_FILE_NAME_CONVERT = '/cdr12c/','/cdb12c/' SCOPE=SPFILE;

System altered.

SYS@cdb12c> ALTER SYSTEM SET LOG_FILE_NAME_CONVERT = '/cdr12c/','/cdb12c/' SCOPE=SPFILE;

System altered.

SYS@cdb12c> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT = AUTO SCOPE=BOTH;

System altered.

SYS@cdb12c> STARTUP FORCE;
ORACLE instance started.

Total System Global Area 4.1339E+10 bytes
Fixed Size 19420336 bytes
Variable Size 5905582928 bytes
Database Buffers 3.5299E+10 bytes
Redo Buffers 114794496 bytes
Database mounted.
Database opened.
SYS@cdb12c>
SYS@cdb12c> show parameter FAL_SERVER

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_server string CDR12C
SYS@cdb12c>
SYS@cdb12c> show parameter DB_FILE_NAME_CONVERT

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string /cdr12c/, /cdb12c/
pdb_file_name_convert string
SYS@cdb12c> show parameter LOG_FILE_NAME_CONVERT

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_file_name_convert string /cdr12c/, /cdb12c/
SYS@cdb12c>
SYS@cdb12c> show parameter STANDBY_FILE_MANAGEMENT

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
SYS@cdb12c>

SYS@cdb12c> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/cdr12c.ctl';

Database altered.

SYS@cdb12c>

SYS@cdb12c> CREATE PFILE='/tmp/initCDR12C.ora' FROM SPFILE;

File created.

oracle@bach1 tmp]$ vi initCDR12C.ora
*.audit_file_dest='/u01/app/oracle/admin/cdr12c/adump'
*.audit_trail='db'
*.compatible='12.2.0'
*.control_files='/data/oradata/cdr12c/control01.ctl','/fra/fast_recovery_area/cdr12c/control02.ctl'
*.db_block_size=8192
*.db_domain='nblbd.com'
*.db_file_name_convert='/cdb12c/','/cdr12c/'
*.db_name='cdr12c'
*.db_recovery_file_dest='/fra/fast_recovery_area/cdb12c'
*.db_recovery_file_dest_size=76800m
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=cdb12cXDB)'
*.enable_pluggable_database=true
*.fal_server='CDB12C'
#*.local_listener='LISTENER_CDB12C'
*.log_archive_config='DG_CONFIG=(cdb12c,cdr12c)'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=cdr12c'
*.log_archive_dest_2='SERVICE=cdb12c ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=cdb12c'
*.log_archive_format='%t_%s_%r.dbf'
*.log_file_name_convert='/cdb12c/','/cdr12c/'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=13124m
*.processes=1280
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=30371m
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'

--===Standby server ==
[oracle@bachdbdr ~]$ mkdir -p /u01/app/oracle/admin/cdr12c/adump
[oracle@bachdbdr ~]$
[oracle@bachdbdr ~]$
[oracle@bachdbdr ~]$ cd /u01/app/oracle/admin/cdr12c/adump
[oracle@bachdbdr adump]$
--====End=============

[oracle@bach1 tmp]$ scp initCDR12C.ora oracle@172.31.200.39:$ORACLE_HOME/dbs
oracle@172.31.200.39's password:
initCDR12C.ora 100% 1169 491.2KB/s 00:00
[oracle@bach1 tmp]$

[oracle@bach1 ~]$ scp $ORACLE_HOME/dbs/orapwcdb12c oracle@172.31.200.39:$ORACLE_HOME/dbs/orapwcdr12c
oracle@172.31.200.39's password:
orapwcdb12c 100% 3584 1.4MB/s 00:00
[oracle@bach1 ~]$

--====directories create ===
[oracle@bachdbdr cdr12c]$ mkdir -p /u01/app/oracle/admin/cdr12c/adump
[oracle@bachdbdr cdr12c]$ mkdir -p /u01/app/oracle/admin/cdr12c/dpdump
[oracle@bachdbdr cdr12c]$ mkdir -p /u01/app/oracle/admin/cdr12c/pfile
[oracle@bachdbdr cdr12c]$ mkdir -p /u01/app/oracle/admin/cdr12c/xdb_wallet

[oracle@bachdbdr ~]$ mkdir -p /fra/fast_recovery_area/cdr12c
[oracle@bachdbdr ~]$ mkdir -p /data/oradata/cdr12c
[oracle@bachdbdr ~]$ mkdir -p /data/oradata/cdr12c/pdbseed
[oracle@bachdbdr ~]$ mkdir -p /data/oradata/cdr12c/PORA12C2

[oracle@bach1 admin]$ scp tnsnames.ora oracle@172.31.200.39:$ORACLE_HOME/network/admin
oracle@172.31.200.39's password:
tnsnames.ora 100% 1585 624.5KB/s 00:00
[oracle@bach1 admin]$
[oracle@bach1 admin]$ scp listener.ora oracle@172.31.200.39:$ORACLE_HOME/network/admin
oracle@172.31.200.39's password:
listener.ora 100% 345 178.0KB/s 00:00
[oracle@bach1 admin]$
[oracle@bach1 admin]$

oracle@bachdbdr admin]$ vi listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = cdb12c.nblbd.com)
(ORACLE_HOME = /u01/app/oracle/product/12.2.0.1/dbhome_1)
(SID_NAME = cdb12c)
)
(SID_DESC =
(GLOBAL_DBNAME = cdr12c.nblbd.com)
(ORACLE_HOME = /u01/app/oracle/product/12.2.0.1/dbhome_1)
(SID_NAME = cdr12c)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bachdbdr.nblbd.com)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ADR_BASE_LISTENER = /u01/app/oracle

[oracle@bach1 ~]$ tnsping cdr12c

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 09-MAY-2018 02:00:58

Copyright (c) 1997, 2016, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = bach1.nblbd.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = cdr12c.nblbd.com)))
OK (0 msec)
[oracle@bach1 ~]$
[oracle@bach1 ~]$ tnsping cdb12c

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 09-MAY-2018 02:01:05

Copyright (c) 1997, 2016, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = bach1.nblbd.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = cdb12c.nblbd.com)))
OK (0 msec)
[oracle@bach1 ~]$

[oracle@bachdbdr ~]$ tnsping cdr12c

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 08-MAY-2018 17:57:52

Copyright (c) 1997, 2016, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = bach1.nblbd.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = cdr12c.nblbd.com)))
OK (0 msec)
[oracle@bachdbdr ~]$ tnsping cdb12c

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 08-MAY-2018 17:58:00

Copyright (c) 1997, 2016, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = bach1.nblbd.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = cdb12c.nblbd.com)))
OK (0 msec)
[oracle@bachdbdr ~]$

oracle@bachdbdr dbs]$ mv initCDR12C.ora initcdr12c.ora
[oracle@bachdbdr dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue May 8 18:03:55 2018

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

Connected to an idle instance.

SQL>
SQL> create spfile from pfile;

File created.

SQL>

[oracle@bachdbdr dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue May 8 18:40:29 2018

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

Connected to an idle instance.

SQL> startup nomount pfile='/u01/app/oracle/product/12.2.0.1/dbhome_1/dbs/initcdr12c.ora';
ORACLE instance started.

Total System Global Area 3.1877E+10 bytes
Fixed Size 19428376 bytes
Variable Size 4496296936 bytes
Database Buffers 2.7313E+10 bytes
Redo Buffers 47677440 bytes
SQL>
SQL>

[oracle@bach1 ~]$ rman

Recovery Manager: Release 12.2.0.1.0 - Production on Wed May 9 02:37:29 2018

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

RMAN> CONNECT TARGET sys/Nblcdb12c@cdb12c

connected to target database: CDB12C (DBID=4169099588)

RMAN> CONNECT AUXILIARY sys/Nblcdb12c@cdr12c

connected to auxiliary database (not started)

RMAN> duplicate target database for standby from active database nofilenamecheck dorecover;

--===

SELECT Operations.id, Operations.title, DefOperations.title AS defOpTitle, Operations.isFromUser
FROM Operations LEFT JOIN DefOperations ON Operations.defOpID = DefOperations.id;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION NODELAY;

alter database recover managed standby database cancel

select group#, status from v$standby_log;
select status, error from v$archive_dest where dest_id = 2;

SELECT SUBSTR(NAME,1,25) FILE_NAME, SEQUENCE#, APPLIED FROM V$ARCVHIVED_LOG ORDER BY SEQUENCE#;

--==============command===

SQL> col member for a40
SQL> select * from v$logfile;

select * from v$logfile where type='STANDBY';

--====drop Standby Log file ==

select group#, thread#, status, bytes/1024/1024 from v$standby_log;

select group#, thread#, status, bytes/1024/1024 from v$log;

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='MANUAL';

alter database clear logfile group 4;
alter database clear logfile group 5;
alter database clear logfile group 6;
alter database clear logfile group 7;

alter database drop standby logfile group 4;
alter database drop standby logfile group 5;
alter database drop standby logfile group 6;
alter database drop standby logfile group 7;

--====Add Standby Log file ==

alter database add standby logfile thread 1 GROUP 4 '/data/oradata/cdb12c/redo_std04a.rdo' size 200M reuse;

alter database add standby logfile thread 1 GROUP 5 '/data/oradata/cdb12c/redo_std05a.rdo' size 200M reuse;
alter database add standby logfile thread 1 GROUP 6 '/data/oradata/cdb12c/redo_std06a.rdo' size 200M reuse;
alter database add standby logfile thread 1 GROUP 7 '/data/oradata/cdb12c/redo_std07a.rdo' size 200M reuse;

alter database add standby logfile thread 1 GROUP 4 '/data/oradata/cdr12c/redo_std04a.rdo' size 200M reuse;
alter database add standby logfile thread 1 GROUP 5 '/data/oradata/cdr12c/redo_std05a.rdo' size 200M reuse;
alter database add standby logfile thread 1 GROUP 6 '/data/oradata/cdr12c/redo_std06a.rdo' size 200M reuse;
alter database add standby logfile thread 1 GROUP 7 '/data/oradata/cdr12c/redo_std07a.rdo' size 200M reuse;

alter system set standby_file_management=AUTO scope=both sid='*';

EDIT DATABASE testfo SET PROPERTY TransportDisconnectedThreshold='120';

Primary:
SQL> select thread#, max(sequence#) "Last Primary Seq Generated"
from v$archived_log val, v$database vdb
where val.resetlogs_change# = vdb.resetlogs_change#
group by thread# order by 1;

PhyStdby:
SQL> select thread#, max(sequence#) "Last Standby Seq Received"
from v$archived_log val, v$database vdb
where val.resetlogs_change# = vdb.resetlogs_change#
group by thread# order by 1;

PhyStdby:
SQL>select thread#, max(sequence#) "Last Standby Seq Applied"
from v$archived_log val, v$database vdb
where val.resetlogs_change# = vdb.resetlogs_change#
and val.applied in ('YES','IN-MEMORY')
group by thread# order by 1;

PhyStdby:
SQL> select al.thrd "Thread", almax "Last Seq Received", lhmax "Last Seq Applied" , almax-lhmax "Sequence Difference"
from (select thread# thrd, max(sequence#) almax
from v$archived_log
where resetlogs_change#=(select resetlogs_change# from v$database)
group by thread#) al,
(select thread# thrd, max(sequence#) lhmax
from v$log_history
where resetlogs_change#=(select resetlogs_change# from v$database)
group by thread#) lh
where al.thrd = lh.thrd;

edit database "cdr12c" set state="APPLY-ON";

--================Dataguard broker====

SYS@cdb12c> show parameter dg_broker_start

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start boolean FALSE
SYS@cdb12c>
SYS@cdb12c> alter system set dg_broker_start=true;

System altered.

SYS@cdb12c>
SYS@cdb12c> show parameter dg_broker_start;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start boolean TRUE
SYS@cdb12c>

SYS@cdr12c> show parameter dg_broker_start

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start boolean FALSE
SYS@cdr12c>
SYS@cdr12c>
SYS@cdr12c> alter system set dg_broker_start=true;

System altered.

SYS@cdr12c>
SYS@cdr12c> show parameter dg_broker_start

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start boolean TRUE
SYS@cdr12c>
SYS@cdr12c>

SYS@cdb12c> show parameter log_archive_dest_2;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string SERVICE=cdr12c ASYNC VALID_FOR
=(ONLINE_LOGFILES,PRIMARY_ROLE
) DB_UNIQUE_NAME=cdr12c
log_archive_dest_20 string

SYS@cdb12c> alter system set log_archive_dest_2='';

System altered.

SYS@cdb12c> show parameter log_archive_dest_2;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string
log_archive_dest_20 string

SYS@cdr12c> show parameter log_archive_dest_2;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string SERVICE=cdb12c ASYNC VALID_FOR
=(ONLINE_LOGFILES,PRIMARY_ROLE
) DB_UNIQUE_NAME=cdb12c
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_28 string
log_archive_dest_29 string
SYS@cdr12c>
SYS@cdr12c> alter system set log_archive_dest_2='';

System altered.

SYS@cdr12c> show parameter log_archive_dest_2;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string
log_archive_dest_20 string

[oracle@bach1 ~]$ dgmgrl sys@cdb12c
DGMGRL for Linux: Release 12.2.0.1.0 - Production on Mon May 21 23:58:41 2018

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

Welcome to DGMGRL, type "help" for information.
Password:
Connected to "cdb12c"
Connected as SYSDBA.
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> create configuration cdb as primary database is cdb12c connect identifier is cdb12c;
Configuration "cdb" created with primary database "cdb12c"
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> add database cdr12c as connect identifier is cdr12c maintained as physical;
Database "cdr12c" added
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> enable configuration;
Enabled.
DGMGRL>

Pages

Sunday, March 2, 2025

Resolving Gaps In Data Guard Using Incremental Rman Backup

Tuesday, July 17, 2018

Dataguard Broker

Configure Oracle 12c Physical standby database