Resolving Missing Archive log Gap in Oracle 12.2.0.1 Dataguard Using RMAN

Resolving Missing Archive log Gap Standby Side :-

 Problem : Archive AIRYARCH1_337_984864305.dbf is missing from both the side Primary and standby database side. 
           Reason can be any thing either primary recovered from redo log loss or archive logs manually deleted. 
           Standby database is waiting for AIRYARCH1_337_984864305.dbf to receive/apply and stuck on that point.

 On Primary Side :--

[oraairy@airydba AIRYPRD_Archive]$ ls -ltr

-rw-r----- 1 oraairy oinstall    722432 Mar 20 11:28 AIRYARCH1_330_984864305.dbf

-rw-r----- 1 oraairy oinstall   2508288 Mar 20 11:33 AIRYARCH1_331_984864305.dbf

-rw-r----- 1 oraairy oinstall      2048 Mar 20 11:33 AIRYARCH1_332_984864305.dbf

-rw-r----- 1 oraairy oinstall      2048 Mar 20 11:33 AIRYARCH1_333_984864305.dbf

-rw-r----- 1 oraairy oinstall   1273344 Mar 20 12:00 AIRYARCH1_334_984864305.dbf

-rw-r----- 1 oraairy oinstall      2048 Mar 20 12:00 AIRYARCH1_335_984864305.dbf

-rw-r----- 1 oraairy oinstall      1536 Mar 20 12:00 AIRYARCH1_336_984864305.dbf

-rw-r----- 1 oraairy oinstall      1024 Mar 20 12:28 AIRYARCH1_338_984864305.dbf

-rw-r----- 1 oraairy oinstall   1542656 Mar 20 12:30 AIRYARCH1_339_984864305.dbf

On Standby Side :--

[oraairy@airydbasty AIRYPRD_Archive]$ ls -ltr

-rw-r----- 1 oraairy oinstall   2508288 Mar 20 11:33 AIRYARCH1_331_984864305.dbf

-rw-r----- 1 oraairy oinstall      2048 Mar 20 11:33 AIRYARCH1_332_984864305.dbf

-rw-r----- 1 oraairy oinstall      2048 Mar 20 11:33 AIRYARCH1_333_984864305.dbf

-rw-r----- 1 oraairy oinstall   1273344 Mar 20 12:00 AIRYARCH1_334_984864305.dbf

-rw-r----- 1 oraairy oinstall      2048 Mar 20 12:00 AIRYARCH1_335_984864305.dbf

-rw-r----- 1 oraairy oinstall      1536 Mar 20 12:00 AIRYARCH1_336_984864305.dbf

-rw-r----- 1 oraairy oinstall      1024 Mar 20 12:30 AIRYARCH1_338_984864305.dbf

-rw-r----- 1 oraairy oinstall   1542656 Mar 20 12:30 AIRYARCH1_339_984864305.dbf

[oraairy@airydbasty AIRYPRD_Archive]$ sqlp

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 26 12:55:14 2019

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

Connected to:

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

NAME    DB_UNIQUE_NAME  DATABASE_ROLE    OPEN_MODE  LOG_MODE         PROTECTION_MODE            CURRENT_SCN

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

AIRYPRD  AIRYSTY       PHYSICAL STANDBY  MOUNTED    ARCHIVELOG    MAXIMUM AVAILABILITY  2827626

THREAD# Last_applied_Log

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

1         336

AIRYPRD@AIRYPRM> show parameter log_archive_dest_state_2;

NAME                            TYPE     VALUE

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

log_archive_dest_state_2        string     ENABLE

[oraairy@airydbasty AIRYPRD_Archive]$ rfs

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 26 12:57:31 2019

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

Connected to:

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

NAME    DB_UNIQUE_NAME  DATABASE_ROLE     OPEN_MODE  LOG_MODE        PROTECTION_MODE            CURRENT_SCN

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

AIRYPRD       AIRYSTY   PHYSICAL STANDBY  MOUNTED    ARCHIVELOG   MAXIMUM AVAILABILITY  2827626

PROCESS   STATUS       THREAD#  SEQUENCE# BLOCK#

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

ARCH   CONNECTED          0       0       0

DGRD   ALLOCATED          0       0       0

DGRD   ALLOCATED          0       0       0

ARCH   CLOSING            1    367    8192

ARCH   CLOSING            1    368       1

ARCH   CLOSING            1    369       1

ARCH   CLOSING            1    370       1

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

MRP0   APPLYING_LOG       1    337       1

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               1    371     658

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

44 rows selected.

THREAD# Last_applied_Log

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

1         336

AIRYPRD@AIRYSTY> alter database register logfile '/AIRYPRD_Archive/AIRYARCH1_338_984864305.dbf';

alter database register logfile '/AIRYPRD_Archive/AIRYARCH1_338_984864305.dbf'

*

ERROR at line 1:

ORA-16089: archive log has already been registered

Note: Here MRP process status is showing that it is applying log AIRYARCH1_337_984864305.dbf but actually, 
      AIRYARCH1_337_984864305.dbf does not exist physically in both the side.I have also tried some foolish, 
      as you are seeing above , to register next archive log AIRYARCH1_338_984864305.dbf but not succeeded.

Solution: 

- Need to recover standby database without archive logs,using RMAN incremental backup of primary database.  
- In my this test environment,File system architecture is same on both primary and standby side.

Steps are as under:

- Find CURRENT_SCN on primary and standby DB.
- Cancel media recovery process on standby database.
- Shutdown standby database.
- Take incremental backup of primary database using "from SCN <Standby CURRENT_SCN>".
- Create a new standby control file on primary database.
- SCP this RMAN incremental backup and newly created standby control file from primary to standby side.
- Startup standby database in nomount mode.
- Replace existing standby control file with newly created standby control file from primary DB.
- Put standby database in mount mode.
- Catalog RMAN incremental backup on standby database.
- Recover standby database.
- Clear all standby logfiles on standby database.
- Start the Media recovery process on standby database.
- Checking: Switch log on primary database , it should be apply on standby database.
- Also check alert logs of primary database and standby database for any error.

Practical Approach :

1: Find CURRENT_SCN on primary and standby DB :

On Primary Side :--

[oraairy@airydba AIRYPRD_Archive]$ sqlp

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 26 13:14:22 2019

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

Connected to:

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

NAME    DB_UNIQUE_NAME  DATABASE_ROLE  OPEN_MODE  LOG_MODE  PROTECTION_MODE      CURRENT_SCN

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

AIRYPRD  AIRYPRM        PRIMARY     READ WRITE ARCHIVELOG   MAXIMUM AVAILABILITY  3001970

Database log mode             Archive Mode

Automatic archival            Enabled

Archive destination           /AIRYPRD_Archive/AIRYARCH

Oldest online log sequence     368

Next log sequence to archive   371

Current log sequence          371

AIRYPRD@AIRYPRM>select current_scn from gv$database;

CURRENT_SCN

-----------

3001985

On Standby Side :--

[oraairy@airydbasty AIRYPRD_Archive]$ sqlp

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 26 13:13:44 2019

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

Connected to:

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

NAME    DB_UNIQUE_NAME  DATABASE_ROLE    OPEN_MODE  LOG_MODE      PROTECTION_MODE     CURRENT_SCN

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

AIRYPRD  AIRYSTY       PHYSICAL STANDBY  MOUNTED   ARCHIVELOG MAXIMUM AVAILABILITY  2827626

THREAD# Last_applied_Log

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

1         336

AIRYPRD@AIRYSTY>select current_scn from gv$database;

CURRENT_SCN

-----------

2827626

AIRYPRD@AIRYSTY>select min (checkpoint_change#) from v$datafile_header;

MIN(CHECKPOINT_CHANGE#)

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

2827627

2: Cancel media recovery process on standby database :

On Standby Side :--

AIRYPRD@AIRYSTY> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Database altered.

3: Shutdown standby database :

On Standby Side :--

AIRYPRD@AIRYSTY> shut immediate;

ORA-01109: database not open

Database dismounted.

4: Take RMAN incremental backup of primary database using "from SCN" :

On Primary Side :--

[oraairy@airydba backup]$ pwd

/oracle/AIRYPRD/backup

[oraairy@airydba backup]$ ll

total 0

[oraairy@airydba backup]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Tue Mar 26 13:22:44 2019

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

connected to target database: AIRYPRD (DBID=1510430767)

RMAN> run {

allocate channel CH1 device type disk;

BACKUP INCREMENTAL FROM SCN 2827626 DATABASE FORMAT '/oracle/AIRYPRD/backup/standby_%d_%t_%c_%p.rmb' tag 'FORSTANDBYGAP';

release channel CH1;

}

allocated channel: CH1

channel CH1: SID=115 device type=DISK

Starting backup at 26-MAR-19

channel CH1: starting full datafile backup set

channel CH1: specifying datafile(s) in backup set

input datafile file number=00001 name=/oracle/AIRYPRD/data/system01.dbf

input datafile file number=00003 name=/oracle/AIRYPRD/data/sysaux01.dbf

input datafile file number=00004 name=/oracle/AIRYPRD/data/undotbs01.dbf

input datafile file number=00007 name=/oracle/AIRYPRD/data/users01.dbf

channel CH1: starting piece 1 at 26-MAR-19

channel CH1: finished piece 1 at 26-MAR-19

piece handle=/oracle/AIRYPRD/backup/standby_AIRYPRD_1003930184_1_1.rmb tag=FORSTANDBYGAP comment=NONE

channel CH1: backup set complete, elapsed time: 00:00:35

channel CH1: starting full datafile backup set

channel CH1: specifying datafile(s) in backup set

including current control file in backup set

channel CH1: starting piece 1 at 26-MAR-19

channel CH1: finished piece 1 at 26-MAR-19

piece handle=/oracle/AIRYPRD/backup/standby_AIRYPRD_1003930219_1_1.rmb tag=FORSTANDBYGAP comment=NONE

channel CH1: backup set complete, elapsed time: 00:00:01

Finished backup at 26-MAR-19

released channel: CH1

RMAN> exit

Recovery Manager complete.

[oraairy@airydba backup]$ ll

total 44152

-rw-r----- 1 oraairy oinstall 33955840 Mar 26 13:30 standby_AIRYPRD_1003930184_1_1.rmb

-rw-r----- 1 oraairy oinstall 11255808 Mar 26 13:30 standby_AIRYPRD_1003930219_1_1.rmb

5: Create a new standby control file on primary database :

On Primary Side :--

[oraairy@airydba backup]$ sqlp

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 26 13:30:37 2019

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

Connected to:

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

NAME    DB_UNIQUE_NAME  DATABASE_ROLE  OPEN_MODE   LOG_MODE PROTECTION_MODE     CURRENT_SCN

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

AIRYPRD  AIRYPRM        PRIMARY       READ WRITE  ARCHIVELOG  MAXIMUM AVAILABILITY  3004210

Database log mode             Archive Mode

Automatic archival            Enabled

Archive destination           /AIRYPRD_Archive/AIRYARCH

Oldest online log sequence     369

Next log sequence to archive   372

Current log sequence          372

AIRYPRD@AIRYPRM> alter database create standby controlfile as '/oracle/AIRYPRD/backup/standby.ctl';

Database altered.

AIRYPRD@AIRYPRM>exit

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

6: SCP this RMAN incremental backup and newly created standby control file from primary to standby side :

On Primary Side :--

[oraairy@airydba backup]$ ll

total 55080

-rw-r----- 1 oraairy oinstall 11190272 Mar 26 13:31 standby.ctl

-rw-r----- 1 oraairy oinstall 33955840 Mar 26 13:30 standby_AIRYPRD_1003930184_1_1.rmb

-rw-r----- 1 oraairy oinstall 11255808 Mar 26 13:30 standby_AIRYPRD_1003930219_1_1.rmb

[oraairy@airydba backup]$ scp *.* oraairy@192.168.75.110:/oracle/AIRYPRD/backup

oraairy@192.168.75.110's password:

standby.ctl                               100%   11MB  10.7MB/s   00:01

standby_AIRYPRD_1003930184_1_1.rmb   100%   32MB  32.4MB/s   00:00

standby_AIRYPRD_1003930219_1_1.rmb   100%   11MB  10.7MB/s   00:01

7: Startup standby database in nomount mode :

On Standby Side :--

[oraairy@airydbasty backup]$ pwd

/oracle/AIRYPRD/backup

[oraairy@airydbasty backup]$ ll

total 55080
-rw-r----- 1 oraairy oinstall 11190272 Mar 26 13:34 standby.ctl

-rw-r----- 1 oraairy oinstall 33955840 Mar 26 13:34 standby_AIRYPRD_1003930184_1_1.rmb

-rw-r----- 1 oraairy oinstall 11255808 Mar 26 13:34 standby_AIRYPRD_1003930219_1_1.rmb

[oraairy@airydbasty backup]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 26 13:35:32 2019

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

Connected to an idle instance.

AIRYPRD@AIRYSTY> startup nomount;

ORACLE instance started.

Total System Global Area  847249408 bytes

Fixed Size                 8626336 bytes

Variable Size             327159648 bytes

Database Buffers                507510784 bytes

Redo Buffers             3952640 bytes

8: Replace existing standby control file with newly created standby control file from primary DB :

On Standby Side :--

Identify the location of control file in standby database.

AIRYPRD@AIRYSTY> show parameter control_files;

NAME                            TYPE     VALUE
------------------------------- ---------  ------------------------------

control_files                   string     /oracle/AIRYPRD/data/control01.ctl,                                                        /oracle/AIRYPRD/data/control02.ctl

AIRYPRD@AIRYSTY>exit

[oraairy@airydbasty backup]$ ll

total 55080

-rw-r----- 1 oraairy oinstall 11190272 Mar 26 13:34 standby.ctl

-rw-r----- 1 oraairy oinstall 33955840 Mar 26 13:34 standby_AIRYPRD_1003930184_1_1.rmb

-rw-r----- 1 oraairy oinstall 11255808 Mar 26 13:34 standby_AIRYPRD_1003930219_1_1.rmb

[oraairy@airydbasty backup]$ cp standby.ctl /oracle/AIRYPRD/data/

[oraairy@airydbasty backup]$ cd /oracle/AIRYPRD/data

[oraairy@airydbasty data]$ ll

total 1610800

-rw-r----- 1 oraairy oinstall  11190272 Mar 26 13:15 control01.ctl

-rw-r----- 1 oraairy oinstall  11190272 Mar 26 13:15 control02.ctl

-rw-r----- 1 oraairy oinstall  11190272 Mar 26 13:38 standby.ctl

-rw-r----- 1 oraairy oinstall 692068352 Mar 26 12:56 sysaux01.dbf

-rw-r----- 1 oraairy oinstall 859840512 Mar 26 12:56 system01.dbf

-rw-r----- 1 oraairy oinstall  20979712 Nov 25 11:49 temp01.dbf

-rw-r----- 1 oraairy oinstall  57679872 Mar 26 12:56 undotbs01.dbf

-rw-r----- 1 oraairy oinstall   5251072 Mar 26 12:56 users01.dbf

Rename the existing control files of standby database.

[oraairy@airydbasty data]$ mv control01.ctl control01_old.ctl

[oraairy@airydbasty data]$ mv control02.ctl control02_old.ctl

Replace existing control files with newly created standby.ctl

[oraairy@airydbasty data]$ cp standby.ctl control01.ctl

[oraairy@airydbasty data]$ cp standby.ctl control02.ctl

[oraairy@airydbasty data]$ ll

total 1632656

-rw-r----- 1 oraairy oinstall  11190272 Mar 26 13:39 control01.ctl

-rw-r----- 1 oraairy oinstall  11190272 Mar 26 13:15 control01_old.ctl

-rw-r----- 1 oraairy oinstall  11190272 Mar 26 13:40 control02.ctl

-rw-r----- 1 oraairy oinstall  11190272 Mar 26 13:15 control02_old.ctl

-rw-r----- 1 oraairy oinstall  11190272 Mar 26 13:38 standby.ctl

-rw-r----- 1 oraairy oinstall 692068352 Mar 26 12:56 sysaux01.dbf

-rw-r----- 1 oraairy oinstall 859840512 Mar 26 12:56 system01.dbf

-rw-r----- 1 oraairy oinstall  20979712 Nov 25 11:49 temp01.dbf

-rw-r----- 1 oraairy oinstall  57679872 Mar 26 12:56 undotbs01.dbf

-rw-r----- 1 oraairy oinstall   5251072 Mar 26 12:56 users01.dbf

[oraairy@airydbasty data]$ cd /oracle/AIRYPRD/backup

[oraairy@airydbasty backup]$ ll

total 55080

-rw-r----- 1 oraairy oinstall 11190272 Mar 26 13:34 standby.ctl

-rw-r----- 1 oraairy oinstall 33955840 Mar 26 13:34 standby_AIRYPRD_1003930184_1_1.rmb

-rw-r----- 1 oraairy oinstall 11255808 Mar 26 13:34 standby_AIRYPRD_1003930219_1_1.rmb

[oraairy@airydbasty backup]$ rm standby.ctl

[oraairy@airydbasty backup]$ ll

total 44152

-rw-r----- 1 oraairy oinstall 33955840 Mar 26 13:34 standby_AIRYPRD_1003930184_1_1.rmb

-rw-r----- 1 oraairy oinstall 11255808 Mar 26 13:34 standby_AIRYPRD_1003930219_1_1.rmb

9: Put standby database in mount mode :

On Standby Side :--

[oraairy@airydbasty backup]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 26 13:41:32 2019
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> alter database mount;

Database altered.

SQL> exit

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

10 : Catalog RMAN incremental backup on standby database :

On Standby Side :--

[oraairy@airydbasty backup]$ pwd

/oracle/AIRYPRD/backup

[oraairy@airydbasty backup]$ ll

total 44152

-rw-r----- 1 oraairy oinstall 33955840 Mar 26 13:34 standby_AIRYPRD_1003930184_1_1.rmb

-rw-r----- 1 oraairy oinstall 11255808 Mar 26 13:34 standby_AIRYPRD_1003930219_1_1.rmb

[oraairy@airydbasty backup]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Tue Mar 26 13:41:52 2019

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

connected to target database: AIRYPRD (DBID=1510430767, not open)

RMAN> catalog start with '/oracle/AIRYPRD/backup';

 11 : Recover standby database :

On Standby Side :--

RMAN> recover database noredo;

Starting recover at 26-MAR-19

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=72 device type=DISK

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 00001: /oracle/AIRYPRD/data/system01.dbf

destination for restore of datafile 00003: /oracle/AIRYPRD/data/sysaux01.dbf

destination for restore of datafile 00004: /oracle/AIRYPRD/data/undotbs01.dbf

destination for restore of datafile 00007: /oracle/AIRYPRD/data/users01.dbf

channel ORA_DISK_1: reading from backup piece /oracle/AIRYPRD/backup/standby_AIRYPRD_1003930184_1_1.rmb

channel ORA_DISK_1: piece handle=/oracle/AIRYPRD/backup/standby_AIRYPRD_1003930184_1_1.rmb tag=FORSTANDBYGAP

channel ORA_DISK_1: restored backup piece 1

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

Finished recover at 26-MAR-19

RMAN> exit

12: Clear all standby logfiles on standby database :

On Standby Side :--

[oraairy@airydbasty backup]$ sqlp

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 26 13:45:46 2019

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

Connected to:

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

NAME    DB_UNIQUE_NAME  DATABASE_ROLE    OPEN_MODE  LOG_MODE      PROTECTION_MODE      CURRENT_SCN

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

AIRYPRD  AIRYSTY      PHYSICAL STANDBY  MOUNTED   ARCHIVELOG  MAXIMUM AVAILABILITY  3004504

THREAD# Last_applied_Log

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

1         371

AIRYPRD@AIRYSTY> set pagesize 100

col MEMBER for a50

select Group#,MEMBER,TYPE,status from v$logfile;

GROUP# MEMBER                                TYPE    STATUS

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

4 /oracle/AIRYPRD/logs/origlog/redosty04.log         ONLINE

4 /oracle/AIRYPRD/logs/mirrlog/redosty04.log         ONLINE

3 /oracle/AIRYPRD/logs/origlog/redosty03.log         ONLINE

3 /oracle/AIRYPRD/logs/mirrlog/redosty03.log         ONLINE

2 /oracle/AIRYPRD/logs/origlog/redosty02.log         ONLINE

2 /oracle/AIRYPRD/logs/mirrlog/redosty02.log         ONLINE

1 /oracle/AIRYPRD/logs/origlog/redosty01.log         ONLINE

1 /oracle/AIRYPRD/logs/mirrlog/redosty01.log         ONLINE

7 /oracle/AIRYPRD/logs/origlog/redostysty01.log       STANDBY

7 /oracle/AIRYPRD/logs/mirrlog/redostysty01.log       STANDBY

8 /oracle/AIRYPRD/logs/origlog/redostysty02.log       STANDBY

8 /oracle/AIRYPRD/logs/mirrlog/redostysty02.log       STANDBY

9 /oracle/AIRYPRD/logs/origlog/redostysty03.log       STANDBY

9 /oracle/AIRYPRD/logs/mirrlog/redostysty03.log       STANDBY

10 /oracle/AIRYPRD/logs/origlog/redostysty04.log       STANDBY

10 /oracle/AIRYPRD/logs/mirrlog/redostysty04.log       STANDBY

11 /oracle/AIRYPRD/logs/origlog/redostysty05.log       STANDBY

11 /oracle/AIRYPRD/logs/mirrlog/redostysty05.log       STANDBY

12 /oracle/AIRYPRD/logs/origlog/redostysty06.log       STANDBY

12 /oracle/AIRYPRD/logs/mirrlog/redostysty06.log       STANDBY

20 rows selected.

AIRYPRD@AIRYSTY>select GROUP#,MEMBERS,BYTES,STATUS from v$log;

GROUP#    MEMBERS    BYTES STATUS

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

1       2  524288000 INACTIVE

4       2  524288000 INACTIVE

3       2  524288000 CURRENT

2       2  524288000 INACTIVE

AIRYPRD@AIRYSTY>select GROUP#,BYTES,status from v$standby_log;

GROUP# BYTES STATUS

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

7  524288000 ACTIVE

8  524288000 UNASSIGNED

9  524288000 UNASSIGNED

10  524288000 UNASSIGNED

11  524288000 UNASSIGNED

12  524288000 UNASSIGNED

6 rows selected.

AIRYPRD@AIRYSTY>ALTER DATABASE CLEAR LOGFILE GROUP 7;

Database altered.

AIRYPRD@AIRYSTY>ALTER DATABASE CLEAR LOGFILE GROUP 8;

Database altered.

AIRYPRD@AIRYSTY>ALTER DATABASE CLEAR LOGFILE GROUP 9;

Database altered.

AIRYPRD@AIRYSTY>ALTER DATABASE CLEAR LOGFILE GROUP 10;

Database altered.

AIRYPRD@AIRYSTY>ALTER DATABASE CLEAR LOGFILE GROUP 11;

Database altered.

AIRYPRD@AIRYSTY>ALTER DATABASE CLEAR LOGFILE GROUP 12;

Database altered.

AIRYPRD@AIRYSTY>exit

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

[oraairy@airydbasty backup]$ cd /AIRYPRD_Archive/

[oraairy@airydbasty AIRYPRD_Archive]$ ls -ltr

total 2038288

-rw-r----- 1 oraairy oinstall    292864 Mar 26 12:03 AIRYARCH1_366_984864305.dbf

-rw-r----- 1 oraairy oinstall   4692480 Mar 26 12:46 AIRYARCH1_367_984864305.dbf

-rw-r----- 1 oraairy oinstall     22528 Mar 26 12:47 AIRYARCH1_368_984864305.dbf

-rw-r----- 1 oraairy oinstall      2048 Mar 26 12:47 AIRYARCH1_369_984864305.dbf

-rw-r----- 1 oraairy oinstall     11264 Mar 26 12:47 AIRYARCH1_370_984864305.dbf

-rw-r----- 1 oraairy oinstall      8192 Mar 26 13:43 AIRYARCH1_373_984864305.dbf

-rw-r----- 1 oraairy oinstall   4058624 Mar 26 13:43 AIRYARCH1_372_984864305.dbf

-rw-r----- 1 oraairy oinstall      5120 Mar 26 13:44 AIRYARCH1_374_984864305.dbf

-rw-r----- 1 oraairy oinstall    528896 Mar 26 13:49 AIRYARCH1_375_984864305.dbf

On Primary Side :--

[oraairy@airydba backup]$ cd /AIRYPRD_Archive/

[oraairy@airydba AIRYPRD_Archive]$ ls -ltr

total 2039844

-rw-r----- 1 oraairy oinstall    507904 Mar 26 11:46 AIRYARCH1_360_984864305.dbf

-rw-r----- 1 oraairy oinstall      3072 Mar 26 11:46 AIRYARCH1_361_984864305.dbf

-rw-r----- 1 oraairy oinstall    180224 Mar 26 11:52 AIRYARCH1_362_984864305.dbf

-rw-r----- 1 oraairy oinstall     11264 Mar 26 11:52 AIRYARCH1_363_984864305.dbf

-rw-r----- 1 oraairy oinstall    167424 Mar 26 11:58 AIRYARCH1_364_984864305.dbf

-rw-r----- 1 oraairy oinstall      7168 Mar 26 11:58 AIRYARCH1_365_984864305.dbf

-rw-r----- 1 oraairy oinstall    292864 Mar 26 12:03 AIRYARCH1_366_984864305.dbf

-rw-r----- 1 oraairy oinstall   4692480 Mar 26 12:46 AIRYARCH1_367_984864305.dbf

-rw-r----- 1 oraairy oinstall     22528 Mar 26 12:47 AIRYARCH1_368_984864305.dbf

-rw-r----- 1 oraairy oinstall      2048 Mar 26 12:47 AIRYARCH1_369_984864305.dbf

-rw-r----- 1 oraairy oinstall     11264 Mar 26 12:47 AIRYARCH1_370_984864305.dbf

-rw-r----- 1 oraairy oinstall   1057792 Mar 26 13:15 AIRYARCH1_371_984864305.dbf

-rw-r----- 1 oraairy oinstall   4058624 Mar 26 13:43 AIRYARCH1_372_984864305.dbf

-rw-r----- 1 oraairy oinstall      8192 Mar 26 13:43 AIRYARCH1_373_984864305.dbf

-rw-r----- 1 oraairy oinstall      5120 Mar 26 13:44 AIRYARCH1_374_984864305.dbf

-rw-r----- 1 oraairy oinstall    528896 Mar 26 13:49 AIRYARCH1_375_984864305.dbf

[oraairy@airydba AIRYPRD_Archive]$ sqlp

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 26 13:51:30 2019

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

Connected to:

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

NAME    DB_UNIQUE_NAME  DATABASE_ROLE  OPEN_MODE  LOG_MODE  PROTECTION_MODE      CURRENT_SCN

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

AIRYPRD  AIRYPRM        PRIMARY     READ WRITE  ARCHIVELOG   MAXIMUM AVAILABILITY  3007543

Database log mode             Archive Mode

Automatic archival            Enabled

Archive destination           /AIRYPRD_Archive/AIRYARCH

Oldest online log sequence     373

Next log sequence to archive   376

Current log sequence          376

13: Start the Media recovery process on standby database :

On Standby Side :--

AIRYPRD@AIRYSTY>alter database recover managed standby database disconnect;

Database altered.

AIRYPRD@AIRYSTY>exit

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

[oraairy@airydbasty AIRYPRD_Archive]$ rfs

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 26 13:53:24 2019

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

Connected to:

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

NAME    DB_UNIQUE_NAME  DATABASE_ROLE    OPEN_MODE  LOG_MODE      PROTECTION_MODE      CURRENT_SCN

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

AIRYPRD  AIRYSTY       PHYSICAL STANDBY  MOUNTED   ARCHIVELOG   MAXIMUM AVAILABILITY  3005956

PROCESS   STATUS            THREAD#  SEQUENCE# BLOCK#

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

ARCH   CONNECTED          0       0       0

DGRD   ALLOCATED          0       0       0

DGRD   ALLOCATED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CLOSING            1    374       1

ARCH   CLOSING            1    375       1

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

MRP0   WAIT_FOR_LOG       1    376       0

DGRD   ALLOCATED          0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

37 rows selected.

THREAD# Last_applied_Log

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

1         375

14 : Checking: Switch log on primary database , it should be apply on standby database :

On Primary Side :--

[oraairy@airydba AIRYPRD_Archive]$ sqlp

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 26 14:26:05 2019

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

Connected to:

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

NAME    DB_UNIQUE_NAME  DATABASE_ROLE  OPEN_MODE   LOG_MODE PROTECTION_MODE  CURRENT_SCN

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

AIRYPRD  AIRYPRM        PRIMARY      READ WRITE  ARCHIVELOG   MAXIMUM AVAILABILITY    3012029

Database log mode             Archive Mode

Automatic archival            Enabled

Archive destination           /AIRYPRD_Archive/AIRYARCH

Oldest online log sequence     375

Next log sequence to archive   378

Current log sequence          378

AIRYPRD@AIRYPRM> alter system switch logfile;

System altered.

AIRYPRD@AIRYPRM>/

System altered.

AIRYPRD@AIRYPRM>/

System altered.

AIRYPRD@AIRYPRM>archive log list;

Database log mode             Archive Mode

Automatic archival            Enabled

Archive destination           /AIRYPRD_Archive/AIRYARCH

Oldest online log sequence     378

Next log sequence to archive   381

Current log sequence          381

On Standby Side :--

[oraairy@airydbasty AIRYPRD_Archive]$ sqlp

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 26 14:26:45 2019

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

Connected to:

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

NAME    DB_UNIQUE_NAME  DATABASE_ROLE     OPEN_MODE   LOG_MODE       PROTECTION_MODE            CURRENT_SCN

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

AIRYPRD  AIRYSTY        PHYSICAL STANDBY  MOUNTED     ARCHIVELOG  MAXIMUM AVAILABILITY  3012062

THREAD# Last_applied_Log

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

1         380

AIRYPRD@AIRYSTY>exit

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

[oraairy@airydbasty AIRYPRD_Archive]$ rfs

SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 26 14:27:04 2019

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

Connected to:

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

NAME    DB_UNIQUE_NAME  DATABASE_ROLE    OPEN_MODE  LOG_MODE        PROTECTION_MODE      CURRENT_SCN

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

AIRYPRD  AIRYSTY       PHYSICAL STANDBY  MOUNTED    ARCHIVELOG   MAXIMUM AVAILABILITY  3012062

PROCESS   STATUS       THREAD#  SEQUENCE# BLOCK#

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

ARCH   CONNECTED          0       0       0

DGRD   ALLOCATED          0       0       0

DGRD   ALLOCATED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CLOSING            1    373       1

ARCH   CLOSING            1    374       1

ARCH   CLOSING            1    377       1

ARCH   CONNECTED          0       0       0

ARCH   CLOSING            1    378    2048

ARCH   CONNECTED          0       0       0

ARCH   CLOSING            1    379       1

ARCH   CONNECTED          0       0       0

ARCH   CLOSING            1    380       1

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

ARCH   CONNECTED          0       0       0

MRP0   APPLYING_LOG       1    381      45

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               1    381      45

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

RFS    IDLE               0       0       0

44 rows selected.

THREAD# Last_applied_Log

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

1         380

15: Check alert logs of primary database and standby database for any error : No Error found

On Primary side:

2019-03-26T15:58:51.198885+05:30

LGWR: Standby redo logfile selected to archive thread 1 sequence 382

LGWR: Standby redo logfile selected for thread 1 sequence 382 for destination LOG_ARCHIVE_DEST_2

2019-03-26T15:58:51.249664+05:30

Thread 1 advanced to log sequence 382 (LGWR switch)

Current log# 1 seq# 382 mem# 0: /oracle/GPCPRD/logs/origlog/redo01.log

Current log# 1 seq# 382 mem# 1: /oracle/GPCPRD/logs/mirrlog/redo01.log

2019-03-26T15:58:52.203495+05:30

Archived Log entry 612 added for T-1.S-381 ID 0x5a06932f LAD:1

2019-03-26T15:58:52.672486+05:30

LGWR: Standby redo logfile selected to archive thread 1 sequence 383

LGWR: Standby redo logfile selected for thread 1 sequence 383 for destination LOG_ARCHIVE_DEST_2

2019-03-26T15:58:52.704818+05:30

Thread 1 advanced to log sequence 383 (LGWR switch)

Current log# 2 seq# 383 mem# 0: /oracle/GPCPRD/logs/origlog/redo02.log

Current log# 2 seq# 383 mem# 1: /oracle/GPCPRD/logs/mirrlog/redo02.log

2019-03-26T15:58:52.773352+05:30

Archived Log entry 614 added for T-1.S-382 ID 0x5a06932f LAD:1

2019-03-26T15:58:53.784963+05:30

LGWR: Standby redo logfile selected to archive thread 1 sequence 384

LGWR: Standby redo logfile selected for thread 1 sequence 384 for destination LOG_ARCHIVE_DEST_2

2019-03-26T15:58:53.863908+05:30

Thread 1 advanced to log sequence 384 (LGWR switch)

Current log# 3 seq# 384 mem# 0: /oracle/GPCPRD/logs/origlog/redo03.log

Current log# 3 seq# 384 mem# 1: /oracle/GPCPRD/logs/mirrlog/redo03.log

2019-03-26T15:58:53.960753+05:30

Archived Log entry 616 added for T-1.S-383 ID 0x5a06932f LAD:1

2019-03-26T15:58:54.705229+05:30

Thread 1 cannot allocate new log, sequence 385

Checkpoint not complete

Current log# 3 seq# 384 mem# 0: /oracle/GPCPRD/logs/origlog/redo03.log

Current log# 3 seq# 384 mem# 1: /oracle/GPCPRD/logs/mirrlog/redo03.log

2019-03-26T15:58:57.889128+05:30

LGWR: Standby redo logfile selected to archive thread 1 sequence 385

LGWR: Standby redo logfile selected for thread 1 sequence 385 for destination LOG_ARCHIVE_DEST_2

2019-03-26T15:58:57.944677+05:30

Thread 1 advanced to log sequence 385 (LGWR switch)

Current log# 4 seq# 385 mem# 0: /oracle/GPCPRD/logs/origlog/redo04.log

Current log# 4 seq# 385 mem# 1: /oracle/GPCPRD/logs/mirrlog/redo04.log

2019-03-26T15:58:57.970867+05:30

Archived Log entry 618 added for T-1.S-384 ID 0x5a06932f LAD:1

2019-03-26T15:58:59.013892+05:30

LGWR: Standby redo logfile selected to archive thread 1 sequence 386

LGWR: Standby redo logfile selected for thread 1 sequence 386 for destination LOG_ARCHIVE_DEST_2

2019-03-26T15:58:59.058135+05:30

Thread 1 advanced to log sequence 386 (LGWR switch)

Current log# 1 seq# 386 mem# 0: /oracle/GPCPRD/logs/origlog/redo01.log

Current log# 1 seq# 386 mem# 1: /oracle/GPCPRD/logs/mirrlog/redo01.log

2019-03-26T15:58:59.166737+05:30

Archived Log entry 620 added for T-1.S-385 ID 0x5a06932f LAD:1

2019-03-26T15:59:00.363840+05:30

LGWR: Standby redo logfile selected to archive thread 1 sequence 387

LGWR: Standby redo logfile selected for thread 1 sequence 387 for destination LOG_ARCHIVE_DEST_2

2019-03-26T15:59:00.413355+05:30

Thread 1 advanced to log sequence 387 (LGWR switch)

Current log# 2 seq# 387 mem# 0: /oracle/GPCPRD/logs/origlog/redo02.log

Current log# 2 seq# 387 mem# 1: /oracle/GPCPRD/logs/mirrlog/redo02.log

2019-03-26T15:59:00.484169+05:30

Archived Log entry 622 added for T-1.S-386 ID 0x5a06932f LAD:1

2019-03-26T15:59:01.358430+05:30

LGWR: Standby redo logfile selected to archive thread 1 sequence 388

LGWR: Standby redo logfile selected for thread 1 sequence 388 for destination LOG_ARCHIVE_DEST_2

2019-03-26T15:59:01.389078+05:30

Thread 1 advanced to log sequence 388 (LGWR switch)

Current log# 3 seq# 388 mem# 0: /oracle/GPCPRD/logs/origlog/redo03.log

Current log# 3 seq# 388 mem# 1: /oracle/GPCPRD/logs/mirrlog/redo03.log

2019-03-26T15:59:01.815645+05:30

Archived Log entry 624 added for T-1.S-387 ID 0x5a06932f LAD:1

2019-03-26T15:59:02.598905+05:30

LGWR: Standby redo logfile selected to archive thread 1 sequence 389

LGWR: Standby redo logfile selected for thread 1 sequence 389 for destination LOG_ARCHIVE_DEST_2

2019-03-26T15:59:02.636019+05:30

Thread 1 advanced to log sequence 389 (LGWR switch)

Current log# 4 seq# 389 mem# 0: /oracle/GPCPRD/logs/origlog/redo04.log

Current log# 4 seq# 389 mem# 1: /oracle/GPCPRD/logs/mirrlog/redo04.log

2019-03-26T15:59:02.657736+05:30

Archived Log entry 626 added for T-1.S-388 ID 0x5a06932f LAD:1

On Standby Side :

Media Recovery Waiting for thread 1 sequence 380 (in transit)

2019-03-26T14:26:20.640974+05:30

Recovery of Online Redo Log: Thread 1 Group 8 Seq 380 Reading mem 0

Mem# 0: /oracle/GPCPRD/logs/origlog/redostysty02.log

Mem# 1: /oracle/GPCPRD/logs/mirrlog/redostysty02.log

2019-03-26T14:26:21.582931+05:30

Standby controlfile consistent with primary

RFS[3]: Selected log 7 for T-1.S-381 dbid 1510430767 branch 984864305

2019-03-26T14:26:21.636157+05:30

Archived Log entry 9 added for T-1.S-380 ID 0x5a06932f LAD:1

2019-03-26T14:26:21.699217+05:30

Media Recovery Waiting for thread 1 sequence 381 (in transit)

2019-03-26T14:26:21.701530+05:30

Recovery of Online Redo Log: Thread 1 Group 7 Seq 381 Reading mem 0

Mem# 0: /oracle/GPCPRD/logs/origlog/redostysty01.log

Mem# 1: /oracle/GPCPRD/logs/mirrlog/redostysty01.log

2019-03-26T15:58:51.072186+05:30

Standby controlfile consistent with primary

RFS[3]: Selected log 8 for T-1.S-382 dbid 1510430767 branch 984864305

2019-03-26T15:58:51.199225+05:30

Media Recovery Waiting for thread 1 sequence 382 (in transit)

2019-03-26T15:58:51.587011+05:30

Archived Log entry 10 added for T-1.S-381 ID 0x5a06932f LAD:1

2019-03-26T15:58:52.523131+05:30

Recovery of Online Redo Log: Thread 1 Group 8 Seq 382 Reading mem 0

Mem# 0: /oracle/GPCPRD/logs/origlog/redostysty02.log

Mem# 1: /oracle/GPCPRD/logs/mirrlog/redostysty02.log

2019-03-26T15:58:52.657289+05:30

Standby controlfile consistent with primary

RFS[3]: Selected log 7 for T-1.S-383 dbid 1510430767 branch 984864305

2019-03-26T15:58:52.676146+05:30

Archived Log entry 11 added for T-1.S-382 ID 0x5a06932f LAD:1

2019-03-26T15:58:52.698459+05:30

Media Recovery Waiting for thread 1 sequence 383 (in transit)

2019-03-26T15:58:52.698730+05:30

Recovery of Online Redo Log: Thread 1 Group 7 Seq 383 Reading mem 0

Mem# 0: /oracle/GPCPRD/logs/origlog/redostysty01.log

Mem# 1: /oracle/GPCPRD/logs/mirrlog/redostysty01.log

2019-03-26T15:58:53.753132+05:30

Standby controlfile consistent with primary

RFS[3]: Selected log 8 for T-1.S-384 dbid 1510430767 branch 984864305

2019-03-26T15:58:53.827779+05:30

Archived Log entry 12 added for T-1.S-383 ID 0x5a06932f LAD:1

2019-03-26T15:58:53.853874+05:30

Media Recovery Waiting for thread 1 sequence 384 (in transit)

2019-03-26T15:58:53.854476+05:30

Recovery of Online Redo Log: Thread 1 Group 8 Seq 384 Reading mem 0

Mem# 0: /oracle/GPCPRD/logs/origlog/redostysty02.log

Mem# 1: /oracle/GPCPRD/logs/mirrlog/redostysty02.log

2019-03-26T15:58:57.860916+05:30

Standby controlfile consistent with primary

RFS[3]: Selected log 7 for T-1.S-385 dbid 1510430767 branch 984864305

2019-03-26T15:58:57.906465+05:30

Archived Log entry 13 added for T-1.S-384 ID 0x5a06932f LAD:1

2019-03-26T15:58:57.937176+05:30

Media Recovery Waiting for thread 1 sequence 385 (in transit)

2019-03-26T15:58:57.937566+05:30

Recovery of Online Redo Log: Thread 1 Group 7 Seq 385 Reading mem 0

Mem# 0: /oracle/GPCPRD/logs/origlog/redostysty01.log

Mem# 1: /oracle/GPCPRD/logs/mirrlog/redostysty01.log

2019-03-26T15:58:59.000858+05:30

Standby controlfile consistent with primary

RFS[3]: Selected log 8 for T-1.S-386 dbid 1510430767 branch 984864305

2019-03-26T15:58:59.037911+05:30

Archived Log entry 14 added for T-1.S-385 ID 0x5a06932f LAD:1

2019-03-26T15:58:59.050885+05:30

Media Recovery Waiting for thread 1 sequence 386 (in transit)

2019-03-26T15:58:59.051181+05:30

Recovery of Online Redo Log: Thread 1 Group 8 Seq 386 Reading mem 0

Mem# 0: /oracle/GPCPRD/logs/origlog/redostysty02.log

Mem# 1: /oracle/GPCPRD/logs/mirrlog/redostysty02.log

2019-03-26T15:59:00.351987+05:30

Standby controlfile consistent with primary

RFS[3]: Selected log 7 for T-1.S-387 dbid 1510430767 branch 984864305

2019-03-26T15:59:00.393364+05:30

Archived Log entry 15 added for T-1.S-386 ID 0x5a06932f LAD:1

2019-03-26T15:59:00.407205+05:30

Media Recovery Waiting for thread 1 sequence 387 (in transit)

2019-03-26T15:59:00.407626+05:30

Recovery of Online Redo Log: Thread 1 Group 7 Seq 387 Reading mem 0

Mem# 0: /oracle/GPCPRD/logs/origlog/redostysty01.log

Mem# 1: /oracle/GPCPRD/logs/mirrlog/redostysty01.log

2019-03-26T15:59:01.346401+05:30

Standby controlfile consistent with primary

RFS[3]: Selected log 8 for T-1.S-388 dbid 1510430767 branch 984864305

2019-03-26T15:59:01.359001+05:30

Archived Log entry 16 added for T-1.S-387 ID 0x5a06932f LAD:1

2019-03-26T15:59:01.381953+05:30

Media Recovery Waiting for thread 1 sequence 388 (in transit)

2019-03-26T15:59:01.382377+05:30

Recovery of Online Redo Log: Thread 1 Group 8 Seq 388 Reading mem 0

Mem# 0: /oracle/GPCPRD/logs/origlog/redostysty02.log

Mem# 1: /oracle/GPCPRD/logs/mirrlog/redostysty02.log

2019-03-26T15:59:02.571260+05:30

Standby controlfile consistent with primary

RFS[3]: Selected log 7 for T-1.S-389 dbid 1510430767 branch 984864305

2019-03-26T15:59:02.613542+05:30

Archived Log entry 17 added for T-1.S-388 ID 0x5a06932f LAD:1

2019-03-26T15:59:02.627310+05:30

Media Recovery Waiting for thread 1 sequence 389 (in transit)

2019-03-26T15:59:02.627713+05:30

Recovery of Online Redo Log: Thread 1 Group 7 Seq 389 Reading mem 0

Mem# 0: /oracle/GPCPRD/logs/origlog/redostysty01.log

Mem# 1: /oracle/GPCPRD/logs/mirrlog/redostysty01.log

[oragpc@airydba ~]$ cat rfs 

set line 100
col DB_UNIQUE_NAME for a15
col OPEN_MODE for a10
select name,DB_UNIQUE_NAME,DATABASE_ROLE,OPEN_MODE,LOG_MODE,PROTECTION_MODE,CURRENT_SCN from v$database;
select process,status,thread#,sequence#,block# from v$managed_standby;
select thread#,max(sequence#) as "Last_applied_Log" from v$log_history group by thread#;

[oragpc@airydba ~]$ cat sqlp 

set line 100
col DB_UNIQUE_NAME for a15
col OPEN_MODE for a10
select name,DB_UNIQUE_NAME,DATABASE_ROLE,OPEN_MODE,LOG_MODE,PROTECTION_MODE,CURRENT_SCN from v$database;
archive log list;

Thank you for reading… This is Airy…Enjoy Learning

 

#archive-log-gap, #dataguard, #oracle-12c