start and stop rac database

Sdílet
Vložit
  • čas přidán 18. 11. 2017
  • Start and stop RAC 11g database using srvctl utility.
  • Věda a technologie

Komentáře • 3

  • @ravindrakulkarni6546
    @ravindrakulkarni6546 Před 3 lety

    This is very good demo on start stop db. Can you post some videos which will guide DBA to see
    1. log/alert /error viewing
    2. oracle monitoring tool usage (OEM) for db status, performance, error,log, long running qry

    • @MrAlanKendall
      @MrAlanKendall Před 9 měsíci

      I use the following to display errors in the alert log from today.
      col ORIGINATING_TIMESTAMP for a18
      set wrap off
      set lines 200
      select INST_ID, ORIGINATING_TIMESTAMP, MESSAGE_TEXT from V$DIAG_ALERT_EXT
      where ORIGINATING_TIMESTAMP > sysdate - 1
      and substr(ORIGINATING_TIMESTAMP,1,9)=to_char(sysdate,'DD-MON-YY')
      and message_text not like '%CONNECT_DATA%'
      and message_text not like '%service_update%'
      and message_text not like '%* ping *%'
      and message_text not like '% drop file %'
      and message_text not like '%ALTER SYSTEM ARCHIVE LOG%'
      and message_text not like '%RCHIV%'
      and message_text not like '%rchiv%'
      -- AND UPPER(message_text)LIKE UPPER('%%')
      order by ORIGINATING_TIMESTAMP;

  • @muddasirbakhtiar1596
    @muddasirbakhtiar1596 Před 4 lety

    Your voice is not audible