Thứ Tư, 12 tháng 4, 2017

[ORACLE 11G] adrci show alert -tail -f

[oracle@fccnode1:/home/oracle]# adrci

ADRCI: Release 11.2.0.4.0 - Production on Thu Apr 13 11:10:57 2017

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

ADR base = "/u01/app/oracle"
adrci> show homes
ADR Homes:
diag/rdbms/fccprod/FCCPROD1
diag/rdbms/fccprod/FLEXPROD1
diag/rdbms/fccprod/FLEXPROD_DR
diag/rdbms/flexprod_dr/FLEXPROD_DR
diag/tnslsnr/fccnode1/listener
adrci> set homes diag/rdbms/fccprod/FCCPROD1
adrci> show alert -tail -f

-----

ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/fccprod/FCCPROD1/trace/FCCPROD1_lgwr_9306700.trc:
ORA-00313: open failed for members of log group 14 of thread 1
ORA-00312: online log 14 thread 1: '/datafs/BORPT02/stb_redo05.f'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/fccprod/FCCPROD1/trace/FCCPROD1_lgwr_9306700.trc:
ORA-00313: open failed for members of log group 14 of thread 1
ORA-00312: online log 14 thread 1: '/datafs/BORPT02/stb_redo05.f'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/fccprod/FCCPROD1/trace/FCCPROD1_lgwr_9306700.trc:


-----

CTRL + C to exit