Tips of ORACLE 12C ADRCI- veteran driver
Daily article of DBA skills category
Do you still need to find the directory yourself when you check the database log? just learn to use ADRCI. How do I usually use it? you might as well try it. Adrci actually has a lot of places we can study, and help can be self-taught.
AdrciADRCI: Release 12.1.0.2.0-Production on Sat Dec 16 22:16:44 2017Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.ADR base = "/ u01/app/oracle" adrci > show homeADR Homes: diag/rdbms/orcl/orcldiag/clients/user_oracle/host_530034364_82diag/tnslsnr/roidb01/listeneradrci > set home diag/rdbms/orcl/orcladrci > show homeADR Homes: diag/rdbms/orcl/orcladrci > show alert-tail-f 2017-12-16 22 purge 04adrci 40.567000 + 08:00Thread 1 advanced to log sequence 214 (LGWR switch) Current log# 2 seq# 214 mem# 0: + DATADG/ORCL/ONLINELOG/group_2.263. 954623037ARC3: Standby redo logfile selected for thread 1 sequence 209 for destination LOG_ARCHIVE_DEST_2Archived Log entry 1130 added for thread 1 sequence 213 ID 0x58d68eb4 dest 1:ARC2: Standby redo logfile selected for thread 1 sequence 213 for destination LOG_ARCHIVE_DEST_22017-12-16 22 sequence 06 Standby redo logfile selected for thread 43.285000 + 08:00Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZEDLGWR: Standby redo logfile selected for thread 1 sequence 215 for destination LOG_ARCHIVE_DEST_2Thread 1 advanced to log sequence 215 (LGWR switch) Current log# 3 seq# 215 mem# 0: + DATADG/ ORCL/ONLINELOG/group_3.264.954623041Archived Log entry 1135 added for thread 1 sequence 214 ID 0x58d68eb4 dest 12017-12-16 22 sequence 06 ID 0x58d68eb4 dest 51.692000 + 08:00Thread 1 cannot allocate new log Sequence 216Checkpoint not complete Current log# 3 seq# 215 mem# 0: + DATADG/ORCL/ONLINELOG/group_3.264.9546230412017-12-16 22 mem# 06 seq# 53.389000 + 08:00LGWR: Standby redo logfile selected for thread 1 sequence 216 for destination LOG_ARCHIVE_DEST_2Thread 1 advanced to log sequence 216 (LGWR switch) Current log# 1 seq# 216 mem# 0: + DATADG/ORCL/ONLINELOG/group_1.262.954623021Thread 1 cannot allocate new log Sequence 217Checkpoint not complete Current log# 1 seq# 216 mem# 0: + DATADG/ORCL/ONLINELOG/group_1.262.954623021Archived Log entry 1137 added for thread 1 sequence 215 ID 0x58d68eb4 dest 12017-12-16 22 mem# 06Parade 56.405000 + 08:00LGWR: Standby redo logfile selected for thread 1 sequence 217 for destination LOG_ARCHIVE_DEST_2Thread 1 advanced to log sequence 217 (LGWR switch) Current log# 2 seq# 217 mem# 0: + DATADG/ORCL/ONLINELOG/group_2.263.954623037LGWR: Standby redo logfile selected for thread 1 sequence 218 for destination LOG_ARCHIVE_DEST_2Thread 1 advanced to log sequence 218 (LGWR switch) Current log# 3 seq# 218 mem# 0: + DATADG/ORCL/ONLINELOG/group_3.264.954623041Archived Log entry 1140 added for thread 1 sequence ID 0x58d68eb4 dest 1:Archived Log entry 1141 added for thread 1 sequence 217 ID 0x58d68eb4 dest 1: ^ CDIA-48223: Interrupt Requested-Fetch Aborted-Return Code [1] [ALERT_EXT] adrci > exit$adrciADRCI: Release 12.1.0.2.0-Production on Sat Dec 16 22:17:47 2017Copyright (c) 1982 2014, Oracle and/or its affiliates. All rights reserved.ADR base = "/ u01/app/oracle" adrci > show alert-tail-fDIA-48449: Tail alert can only apply to single ADR homeadrci > show homeADR Homes: diag/rdbms/orcl/orcldiag/clients/user_oracle/host_530034364_82diag/tnslsnr/roidb01/listeneradrci > set home diag/rdbms/orcl/orcladrci > show alert-tail-f 2017-12-16 22 adrci 40.567000 + 08:00Thread 1 advanced to log sequence 214 (LGWR switch) Current log# 2 seq# 214 mem# 0: + DATADG/ORCL/ONLINELOG/ Group_2.263.954623037ARC3: Standby redo logfile selected for thread 1 sequence 209 for destination LOG_ARCHIVE_DEST_2Archived Log entry 1130 added for thread 1 sequence 213 ID 0x58d68eb4 dest 1:ARC2: Standby redo logfile selected for thread 1 sequence 213 for destination LOG_ARCHIVE_DEST_22017-12-16 22 for destination LOG_ARCHIVE_DEST_2Archived Log entry 06 sequence 43.285000 + 08:00Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZEDLGWR: Standby redo logfile selected for thread 1 sequence 215 for destination LOG_ARCHIVE_DEST_2Thread 1 advanced to log sequence 215 (LGWR switch) Current log# 3 seq# 215 Mem# 0: + DATADG/ORCL/ONLINELOG/group_3.264.954623041Archived Log entry 1135 added for thread 1 sequence 214 ID 0x58d68eb4 dest 1 ID 0x58d68eb4 dest 2017-12-16 22 added for thread 06sequence 51.692000 + 08:00Thread 1 cannot allocate new log Sequence 216Checkpoint not complete Current log# 3 seq# 215 mem# 0: + DATADG/ORCL/ONLINELOG/group_3.264.9546230412017-12-16 22 mem# 06 seq# 53.389000 + 08:00LGWR: Standby redo logfile selected for thread 1 sequence 216 for destination LOG_ARCHIVE_DEST_2Thread 1 advanced to log sequence 216 (LGWR switch) Current log# 1 seq# 216 mem# 0: + DATADG/ORCL/ONLINELOG/group_1.262.954623021Thread 1 cannot allocate new log Sequence 217Checkpoint not complete Current log# 1 seq# 216 mem# 0: + DATADG/ORCL/ONLINELOG/group_1.262.954623021Archived Log entry 1137 added for thread 1 sequence 215 ID 0x58d68eb4 dest 12017-12-16 22 mem# 06Parade 56.405000 + 08:00LGWR: Standby redo logfile selected for thread 1 sequence 217 for destination LOG_ARCHIVE_DEST_2Thread 1 advanced to log sequence 217 (LGWR switch) Current log# 2 seq# 217 mem# 0: + DATADG/ORCL/ONLINELOG/group_2.263.954623037LGWR: Standby redo logfile selected for thread 1 sequence 218 for destination LOG_ARCHIVE_DEST_2Thread 1 advanced to log sequence 218 (LGWR switch) Current log# 3 seq# 218 mem# 0: + DATADG/ORCL/ONLINELOG/group_3.264.954623041Archived Log entry 1140 added for thread 1 sequence 216ID 0x58d68eb4 dest 1:Archived Log entry 1141 added for thread 1 sequence 217 ID 0x58d68eb4 dest 1:
