Monday, June 9, 2014

Directories used by Data Recovery Advisor

1. Information on automatic diagnostic repositry(ADR) directories used by Data recovery advisor stored outside the database
SQL> select name,value from v$diag_info;
NAME                                                             VALUE
---------------------------------------------------------------- --------------------------------------------------
Diag Enabled                                                     TRUE
ADR Base                                                         /u01/app/orcl/oracle
ADR Home                                                         /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman
Diag Trace                                                       /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/trac
                                                                 e

Diag Alert                                                       /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/aler
                                                                 t

Diag Incident                                                    /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/inci
                                                                 dent

Diag Cdump                                                       /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/cdum
                                                                 p

Health Monitor                                                   /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/hm
Default Trace File                                               /u01/app/orcl/oracle/diag/rdbms/cvrman/cvrman/trac
                                                                 e/cvrman_ora_2407.trc

Active Problem Count                                             0
Active Incident Count                                            0

11 rows selected.


No comments: