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;
No comments:
Post a Comment