大佬教程收集整理的这篇文章主要介绍了ORACLE 12C ADRCI-老司机的小技巧,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
查看数据库日志的时候你还需要自己去找目录么,学会使用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 @R_262_10943@kpoint 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 @R_262_10943@kpoint 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,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 217 @R_262_10943@kpoint 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:
以上是大佬教程为你收集整理的ORACLE 12C ADRCI-老司机的小技巧全部内容,希望文章能够帮你解决ORACLE 12C ADRCI-老司机的小技巧所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。