ORACLE 12C ADRCI-老司机的小技巧

2024-04-02 19:55

短信预约 -IT技能 免费直播动态提醒

DBA技巧类每日一文

查看数据库日志的时候你还需要自己去找目录么，学会使用ADRCI就好了。我一般会怎么用的，不妨你也试试啊。adrci 其实有很多我们可以研究的地方，help一下可以自学哦。

<roidb01:orcl:/home/oracle>$adrci

ADRCI: Release 12.1.0.2.0 - Production on Sat Dec 16 22:16:44 2017

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

ADR base = "/u01/app/oracle"
adrci> show home
ADR Homes: 
diag/rdbms/orcl/orcl
diag/clients/user_oracle/host_530034364_82
diag/tnslsnr/roidb01/listener
adrci> set home diag/rdbms/orcl/orcl
adrci> show home
ADR Homes: 
diag/rdbms/orcl/orcl
adrci> show alert -tail -f 
2017-12-16 22:04:40.567000 +08:00
Thread 1 advanced to log sequence 214 (LGWR switch)
  Current log# 2 seq# 214 mem# 0: +DATADG/ORCL/ONLINELOG/group_2.263.954623037
ARC3: Standby redo logfile selected for thread 1 sequence 209 for destination LOG_ARCHIVE_DEST_2
Archived 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_2
2017-12-16 22:06:43.285000 +08:00
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED
LGWR: Standby redo logfile selected for thread 1 sequence 215 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 215 (LGWR switch)
  Current log# 3 seq# 215 mem# 0: +DATADG/ORCL/ONLINELOG/group_3.264.954623041
Archived Log entry 1135 added for thread 1 sequence 214 ID 0x58d68eb4 dest 1:
2017-12-16 22:06:51.692000 +08:00
Thread 1 cannot allocate new log, sequence 216
Checkpoint not complete
  Current log# 3 seq# 215 mem# 0: +DATADG/ORCL/ONLINELOG/group_3.264.954623041
2017-12-16 22:06:53.389000 +08:00
LGWR: Standby redo logfile selected for thread 1 sequence 216 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 216 (LGWR switch)
  Current log# 1 seq# 216 mem# 0: +DATADG/ORCL/ONLINELOG/group_1.262.954623021
Thread 1 cannot allocate new log, sequence 217
Checkpoint not complete
  Current log# 1 seq# 216 mem# 0: +DATADG/ORCL/ONLINELOG/group_1.262.954623021
Archived Log entry 1137 added for thread 1 sequence 215 ID 0x58d68eb4 dest 1:
2017-12-16 22:06:56.405000 +08:00
LGWR: Standby redo logfile selected for thread 1 sequence 217 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 217 (LGWR switch)
  Current log# 2 seq# 217 mem# 0: +DATADG/ORCL/ONLINELOG/group_2.263.954623037
LGWR: Standby redo logfile selected for thread 1 sequence 218 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 218 (LGWR switch)
  Current log# 3 seq# 218 mem# 0: +DATADG/ORCL/ONLINELOG/group_3.264.954623041
Archived Log entry 1140 added for thread 1 sequence 216 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> 
adrci> 
adrci> exit
<roidb01:orcl:/home/oracle>$adrci

ADRCI: Release 12.1.0.2.0 - Production on Sat Dec 16 22:17:47 2017

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

ADR base = "/u01/app/oracle"
adrci> show alert -tail -f
DIA-48449: Tail alert can only apply to single ADR home

adrci> show home
ADR Homes: 
diag/rdbms/orcl/orcl
diag/clients/user_oracle/host_530034364_82
diag/tnslsnr/roidb01/listener
adrci> set home diag/rdbms/orcl/orcl
adrci> show alert -tail -f
2017-12-16 22:04:40.567000 +08:00
Thread 1 advanced to log sequence 214 (LGWR switch)
  Current log# 2 seq# 214 mem# 0: +DATADG/ORCL/ONLINELOG/group_2.263.954623037
ARC3: Standby redo logfile selected for thread 1 sequence 209 for destination LOG_ARCHIVE_DEST_2
Archived 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_2
2017-12-16 22:06:43.285000 +08:00
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED
LGWR: Standby redo logfile selected for thread 1 sequence 215 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 215 (LGWR switch)
  Current log# 3 seq# 215 mem# 0: +DATADG/ORCL/ONLINELOG/group_3.264.954623041
Archived Log entry 1135 added for thread 1 sequence 214 ID 0x58d68eb4 dest 1:
2017-12-16 22:06:51.692000 +08:00
Thread 1 cannot allocate new log, sequence 216
Checkpoint not complete
  Current log# 3 seq# 215 mem# 0: +DATADG/ORCL/ONLINELOG/group_3.264.954623041
2017-12-16 22:06:53.389000 +08:00
LGWR: Standby redo logfile selected for thread 1 sequence 216 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 216 (LGWR switch)
  Current log# 1 seq# 216 mem# 0: +DATADG/ORCL/ONLINELOG/group_1.262.954623021
Thread 1 cannot allocate new log, sequence 217
Checkpoint not complete
  Current log# 1 seq# 216 mem# 0: +DATADG/ORCL/ONLINELOG/group_1.262.954623021
Archived Log entry 1137 added for thread 1 sequence 215 ID 0x58d68eb4 dest 1:
2017-12-16 22:06:56.405000 +08:00
LGWR: Standby redo logfile selected for thread 1 sequence 217 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 217 (LGWR switch)
  Current log# 2 seq# 217 mem# 0: +DATADG/ORCL/ONLINELOG/group_2.263.954623037
LGWR: Standby redo logfile selected for thread 1 sequence 218 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 218 (LGWR switch)
  Current log# 3 seq# 218 mem# 0: +DATADG/ORCL/ONLINELOG/group_3.264.954623041
Archived Log entry 1140 added for thread 1 sequence 216 ID 0x58d68eb4 dest 1:
Archived Log entry 1141 added for thread 1 sequence 217 ID 0x58d68eb4 dest 1:

免责声明：

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的，并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据，供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

阅读原文内容投诉