????????????????????
????Oracle??????????????????????????????????????????????????????????????????????????????????????
?????????????????????????Oracle???????????????????????????????????????????????????????????洢?????????????????洢??ADR??????????????洢???У????????????????????????????????з?????
??????????????????????
????????????????????
???????????
?????????????????????????????ж?
??????????????????
?????????????????
????????Oracle Support????
??????????????????????????????
??????ι??????????????????
?????????????????ι????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????“?????”???м???????????????????????????????????????????????????????????洢????????????洢???????????洢???У?????????????????????????????????????ó?????????????????????
???????????????
???????????????????б???????????DBA??Oracle??????????????鶴????????????????????????????????????????
???????????
???????????????????????????????????????λ????????????飬???????????и??????????????????????????????????????????????????????????????????????????????????????????????????????????????DBA???????????????????????????Щ?????????顣
??????????????IPS?????????
????IPS??????????????????????????????????????????鱨???????????????????????????????????????????????Oracle????????????????????????????????????????и??????????????????????????????????????????????????????????; ????????????????????????????????????zip??????????zip???????IPS??????????????????????????????????м???????С???????洢????????洢???С??????????????Щ???????????????????????????????????????????????ú?????д???zip??????????Щ??????????zip????????Oracle Support??
??????????????
????????????????????????????????????RMAN???????????????????????????????????????????????????????????????????????????????п?????????????????????????????
????SQL??????????????
???????????SQL????????????????????????????????????????????SQL???????????????????????Щ???????????????????????й?????????????????????????????Щ???????????????????Oracle Support???????????????????????????
????????????????????????
????1????????洢??ADR??
????ADR?????????????????????????????????????????洢?????????????????????????????????????????棬?????????????????????????????????????????????洢???κ??????????????????????????????????????????????????????Oracle Database 11g R1??????????????洢?????ASM?????????????CRS????????Oracle?????????洢????????????ADR?????????????????洢??????ADR?????μ???????????????磬????й???洢??ASM??Real Application Clusters?????У?????????????????ASM?????ADR?????????????? ADR???????????????????????μ?????????????????????????????Oracle?????????????????????????????????ADR?????????ADR????????????λ????DIAGNOSTIC_DEST???ó???????????????????????????null??????????????·??????DIAGNOSTIC_DEST?????????????ORACLE_BASE???????DIAGNOSTIC_DEST????? $ ORACLE_BASE?????????????ORACLE_BASEδ?????DIAGNOSTIC_DEST????? $ ORACLE_HOME/log??
???????
???????11g Oracle????????????????????????????????????????洢??ADR?У??????????BACKGROUND_DUMP_DEST??USER_DUMP_DEST??????á??????????????????DIAGNOSTIC_DEST????????ADR??λ?á?
??????????????洢??????????ADR?????????·??

????
SQL> select * from v$version;
????BANNER
????--------------------------------------------------------------------------------
????Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
????SQL> show parameter diag;   --??ADR????
????NAME                                 TYPE        VALUE
????------------------------------------ ----------- ------------------------------
????diagnostic_dest                      string      /app/oracle/ora11g
????SQL> select 'Leshami' Author??'http://blog.csdn.net/leshami' Blog??
????  2  '645746311' QQ from dual;
????AUTHOR  BLOG                         QQ
????------- ---------------------------- ---------
????Leshami http://blog.csdn.net/leshami 645746311
????SQL> select * from v$diag_info;    --????????ADR???·??
????   INST_ID NAME                   VALUE
????---------- ---------------------- ----------------------------------------------------------------------
????         1 Diag Enabled           TRUE
????         1 ADR Base               /app/oracle/ora11g
????         1 ADR Home               /app/oracle/ora11g/diag/rdbms/ora11g/ora11g
????         1 Diag Trace             /app/oracle/ora11g/diag/rdbms/ora11g/ora11g/trace
????         1 Diag Alert             /app/oracle/ora11g/diag/rdbms/ora11g/ora11g/alert
????         1 Diag Incident          /app/oracle/ora11g/diag/rdbms/ora11g/ora11g/incident
????         1 Diag Cdump             /app/oracle/ora11g/diag/rdbms/ora11g/ora11g/cdump
????         1 Health Monitor         /app/oracle/ora11g/diag/rdbms/ora11g/ora11g/hm
????         1 Default Trace File     /app/oracle/ora11g/diag/rdbms/ora11g/ora11g/trace/ora11g_ora_13535.trc
????         1 Active Problem Count   1
????         1 Active Incident Count  5