Oracle DBA Daily Checklist
发布时间：2023-02-17 09:22:34 所属栏目：Oracle 来源：互联网
导读：There are several routine checklist and tasks to do in Oracle database by DBA ( Database Administrator ). This checklist and tasks are as follows. All scripts are valid for Single and RAC Database and Exadata. If you dont use RAC,then you
|
TEMP TEMPORARY 393,214.828 7.000 393,207.828 .00 .984 .00 0 12 DEFAULTTBS PERMANENT 278,171.938 98,217.375 179,954.563 35.31 33,276,260.039 .29 0 1 UNDOTBS1 UNDO 22,180.000 314.063 21,865.938 1.42 141,659.922 .19 0 5 SYSAUX PERMANENT 13,670.000 12,562.313 1,107.688 91.90 19,097.984 38.34 0 1 SYstem PERMANENT 7,880.000 7,113.375 766.625 90.27 57,655.969 10.85 0 2 8 rows selected. sql> 5- Check the Recovery Size Area Use the following script to check Recovery Size Area set pagesize 1000 line 200 col "db_recovery_file_dest" for a32; col size_m for 999,999; col used_m for 999,999; col pct_used for 999; select name "db_recovery_file_dest",ceil(space_limit/1024/1024) TOTAL_MB,ceil( space_used /1024/1024) USED_MB,decode( nvl(space_used,ceil(( space_used /space_limit) * 100)) PERCENTAGE(%) from v$recovery_file_dest order by 1; exit; sql> set pagesize 1000 line 200 sql> col "db_recovery_file_dest" for a32; sql> col size_m for 999,999; sql> col used_m for 999,999; sql> col pct_used for 999; sql> select name "db_recovery_file_dest",2 decode( nvl(space_used,ceil(( space_used /space_limit) * 100)) PERCENTAGE 3 from v$recovery_file_dest 4 order by 1; exit; db_recovery_file_dest TOTAL_MB USED_MB PERCENTAGE(%) -------------------------------- ---------- ---------- ---------- +DATAC1 2048000 79 1 sql> sql> 6-Check the alert log if a vital error exists or not ( Corruption ) Use the following script to check alertlog set linesize 150 set pagesize 150 SELECT SUBSTR (MESSAGE_TEXT,1,300) MESSAGE_TEXT,COUNT (*) cnt FROM X$DBgalERTEXT WHERE (MESSAGE_TEXT LIKE '%ORA-%' OR UPPER (MESSAGE_TEXT) LIKE '%ERROR%') AND CAST (ORIGINATING_TIMESTAMP AS DATE) > SYSDATE - 1 GROUP BY SUBSTR (MESSAGE_TEXT,300); exit sql> SELECT SUBSTR (MESSAGE_TEXT,COUNT (*) cnt 2 FROM X$DBgalERTEXT 3 WHERE (MESSAGE_TEXT LIKE '%ORA-%' OR UPPER (MESSAGE_TEXT) LIKE '%ERROR%') 4 AND CAST (ORIGINATING_TIMESTAMP AS DATE) > SYSDATE - 1 5 GROUP BY SUBSTR (MESSAGE_TEXT,300); MESSAGE_TEXT -------------------------------------------------------------------------------- CNT ---------- Fatal NI connect error 12170. 63 Errors in file /u01/app/oracle/diag/rdbms/MSDB/MSDB/trace/MSDB_j000_33284.trc (incident=663845): ORA-01578: ORACLE data block corrupted (file # 7,block # 2241925) ORA-01110: data file 7: '+DATATEST/MSDB/DATAFILE/default_tbs.298.1031185857' ORA-26040: Data block was loaded using the NOLOGGING o MESSAGE_TEXT -------------------------------------------------------------------------------- CNT ---------- 1 7- Check the latest Archivelog and Full Backup are done or not Use the following script to check Backups. SELECT TO_CHAR (start_time,'DD-MM-YYYY HH24:MI:SS') start_time,input_type,status,ROUND (elapsed_seconds / 3600,1) time_hr,INPUT_BYTES/1024/1024/1024 IN_GB,OUTPUT_BYTES/1024/1024/1024 OUT_GB,OUTPUT_DEVICE_TYPE FROM v$rman_backup_job_details WHERE START_TIME > SYSDATE - 3 ORDER BY start_time DESC; sql> set pagesize 1000 line 200 sql> sql> SELECT TO_CHAR (start_time,'DD-MM-YYYY HH24:MI:SS') start_time,OUTPUT_BYTES/1024/1024/1024 OUT_GB,OUTPUT_DEVICE_TYPE FROM 2 v$rman_backup_job_details WHERE START_TIME > SYSDATE - 3 ORDER BY start_time DESC; START_TIME INPUT_TYPE STATUS TIME_HR IN_GB OUT_GB OUTPUT_DEVICE_TYP -------------------- ------------- ----------------------- ---------- ---------- ---------- ----------------- 10-03-2020 14:38:40 ARCHIVELOG COMPLETED 0 .874987602 .876464844 SBT_TAPE （编辑：甘南站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
