|
1Z0-053第9章/1Z0-052第18章
1Z0-052共19章(上完13章),1Z0-053共21章(上完13章)和1Z0-063多租户部分共9章(上完0章)
总共上完全部49章中的26章
- select * from v$database_block_corruption;
- select * from dba_indexes i where i.table_owner='HR'
- and i.table_name='TLOGICAL';
-
- select * from v$hm_check;
-
- select * from v$hm_run order by start_time desc;
-
- begin
- dbms_hm.run_check(check_name => 'Data Block Integrity Check',
- run_name => 'MYRUN2',
- timeout => 0,
- input_params => 'BLC_DF_NUM=6;BLC_BL_NUM=136');
- end;
复制代码- [root@station90 ~]# crs_stat -t
- Name Type Target State Host
- ------------------------------------------------------------
- ora.DATA.dg ora....up.type ONLINE ONLINE station90
- ora.FRA.dg ora....up.type ONLINE ONLINE station90
- ora....ER.lsnr ora....er.type ONLINE ONLINE station90
- ora.asm ora.asm.type ONLINE ONLINE station90
- ora.cssd ora.cssd.type ONLINE ONLINE station90
- ora.diskmon ora....on.type OFFLINE OFFLINE
- ora.evmd ora.evm.type ONLINE ONLINE station90
- ora.ons ora.ons.type OFFLINE OFFLINE
- ora.orcl.db ora....se.type ONLINE ONLINE station90
- [root@station90 ~]# su - oracle
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.3.0 Production on Thu Sep 28 19:27:07 2017
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
- SQL> conn hr/oracle_4U
- Connected.
- SQL> select * from tlogical;
- ERROR:
- ORA-01578: ORACLE data block corrupted (file # 6, block # 136)
- ORA-01110: data file 6: '+DATA/orcl/datafile/tbslogical.267.955745025'
- ORA-26040: Data block was loaded using the NOLOGGING option
- no rows selected
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
- [oracle@station90 ~]$ adrci
- ADRCI: Release 11.2.0.3.0 - Production on Thu Sep 28 20:09:14 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- ADR base = "/u01/app/oracle"
- adrci> help
- HELP [topic]
- Available Topics:
- CREATE REPORT
- ECHO
- EXIT
- HELP
- HOST
- IPS
- PURGE
- RUN
- SET BASE
- SET BROWSER
- SET CONTROL
- SET ECHO
- SET EDITOR
- SET HOMES | HOME | HOMEPATH
- SET TERMOUT
- SHOW ALERT
- SHOW BASE
- SHOW CONTROL
- SHOW HM_RUN
- SHOW HOMES | HOME | HOMEPATH
- SHOW INCDIR
- SHOW INCIDENT
- SHOW PROBLEM
- SHOW REPORT
- SHOW TRACEFILE
- SPOOL
- There are other commands intended to be used directly by Oracle, type
- "HELP EXTENDED" to see the list
- adrci> help SET HOMES
- Usage: SET HOMES | HOME| HOMEPATH <homepath_str1 homepath_str2 ...>
- Purpose: Set the ADR homes to query in the current ADRCI session.
- Arguments:
- <homepath_str1 homepath_str2 ...>: The paths of the home,
- relative to the ADR base.
- Note:
- The "diag" directory name can be omitted from the homepath_str.
- If the specified path contains multiple homes, for instance, it is
- set to the database ID which is running RAC. All of the ADR homes
- corresponding to the instances of the database will be added to the
- current ADRCI home settings.
- Example:
- set homepath diag/rdbms/aime3/aime3 diag/rdbms/aime3/aime32
- set homepath rdbms/aime3
- adrci>
- adrci> set homepath diag/rdbms/orcl/orcl
- adrci> SHOW INCIDENT
- ADR Home = /u01/app/oracle/diag/rdbms/orcl/orcl:
- *************************************************************************
- INCIDENT_ID PROBLEM_KEY CREATE_TIME
- -------------------- ----------------------------------------------------------- ----------------------------------------
- 12201 ORA 600 [1433] 2014-08-06 17:29:11.284000 +08:00
- 12081 ORA 600 [1433] 2014-08-06 17:29:13.939000 +08:00
- 13449 ORA 600 [1433] 2014-08-06 17:33:35.241000 +08:00
- 13513 ORA 600 [1433] 2014-08-06 17:33:36.220000 +08:00
- 13561 ORA 600 [1433] 2014-08-06 17:33:40.303000 +08:00
- 13562 ORA 603 2014-08-06 17:33:42.361000 +08:00
- 13505 ORA 600 [1433] 2014-08-06 17:34:13.830000 +08:00
- 13506 ORA 603 2014-08-06 17:34:15.747000 +08:00
- 13465 ORA 600 [1433] 2014-08-06 17:34:37.378000 +08:00
- 27928 ORA 1578 2017-09-26 20:20:55.029000 +08:00
- 27929 ORA 1578 2017-09-26 20:22:32.236000 +08:00
- 27930 ORA 1578 2017-09-26 20:23:08.151000 +08:00
- 27931 ORA 1578 2017-09-26 20:24:20.550000 +08:00
- 27816 ORA 1578 2017-09-26 20:57:47.664000 +08:00
- 29157 ORA 1578 2017-09-26 21:30:01.712000 +08:00
- 30222 ORA 1578 2017-09-26 21:35:11.561000 +08:00
- 31526 ORA 1578 2017-09-26 21:40:48.228000 +08:00
- 32798 ORA 1578 2017-09-26 21:44:00.679000 +08:00
- 35247 ORA 1578 2017-09-28 19:27:18.887000 +08:00
- 35248 ORA 1578 2017-09-28 19:27:20.445000 +08:00
- 20 rows fetched
- adrci> SHOW PROBLEM
- ADR Home = /u01/app/oracle/diag/rdbms/orcl/orcl:
- *************************************************************************
- PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
- -------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
- 2 ORA 603 13506 2014-08-06 17:34:15.747000 +08:00
- 1 ORA 600 [1433] 13281 2014-08-06 17:36:00.102000 +08:00
- 3 ORA 1578 35248 2017-09-28 19:27:20.445000 +08:00
- 3 rows fetched
- adrci> help show problem
- Usage: SHOW PROBLEM [-p <predicate_string>]
- [-last <num> | -all]
- [-orderby (field1, field2, ...) [ASC|DSC]]
- Purpose: Show the problem information. By default, this command will
- only show the last 50 problems.
- Options:
- [-p <predicate_string>]: The predicate string must be double-quoted.
- The field names that users can specify in the predicate are:
- PROBLEM_ID number
- PROBLEM_KEY text(550)
- FIRST_INCIDENT number
- FIRSTINC_TIME timestamp
- LAST_INCIDENT number
- LASTINC_TIME timestamp
- IMPACT1 number
- IMPACT2 number
- IMPACT3 number
- IMPACT4 number
- SERVICE_REQUEST text(64)
- BUG_NUMBER text(64)
- [-last <num> | -all]: This option allows users to either select
- the last <num> of qualified problems to show or to show all the
- qualified problems. If this option is not specified, this command
- will only show 50 incidents.
- [-orderby (field1, field2, ...) [ASC|DSC]]: If specified, the results
- will be ordered by the specified fields' values. By default, it will be
- in the ascending order unless "DSC" is specified. Note that the field
- names that can be specified here are from the "PROBLEM" relation.
- Examples:
- show problem
- show problem -p "problem_id>123"
- adrci> help
- HELP [topic]
- Available Topics:
- CREATE REPORT
- ECHO
- EXIT
- HELP
- HOST
- IPS
- PURGE
- RUN
- SET BASE
- SET BROWSER
- SET CONTROL
- SET ECHO
- SET EDITOR
- SET HOMES | HOME | HOMEPATH
- SET TERMOUT
- SHOW ALERT
- SHOW BASE
- SHOW CONTROL
- SHOW HM_RUN
- SHOW HOMES | HOME | HOMEPATH
- SHOW INCDIR
- SHOW INCIDENT
- SHOW PROBLEM
- SHOW REPORT
- SHOW TRACEFILE
- SPOOL
- There are other commands intended to be used directly by Oracle, type
- "HELP EXTENDED" to see the list
- adrci> help ips
- HELP IPS [topic]
- Available Topics:
- ADD
- ADD FILE
- ADD NEW INCIDENTS
- CHECK REMOTE KEYS
- COPY IN FILE
- COPY OUT FILE
- CREATE PACKAGE
- DELETE PACKAGE
- FINALIZE PACKAGE
- GENERATE PACKAGE
- GET MANIFEST
- GET METADATA
- GET REMOTE KEYS
- PACK
- REMOVE
- REMOVE FILE
- SET CONFIGURATION
- SHOW CONFIGURATION
- SHOW FILES
- SHOW INCIDENTS
- SHOW PACKAGE
- UNPACK FILE
- UNPACK PACKAGE
- USE REMOTE KEYS
- adrci> ips show package
- PACKAGE_ID 1
- PACKAGE_NAME ORA1578_20170928201600
- PACKAGE_DESCRIPTION XXXX
- DRIVING_PROBLEM 3
- DRIVING_PROBLEM_KEY ORA 1578
- DRIVING_INCIDENT 27928
- DRIVING_INCIDENT_TIME 2017-09-26 20:20:55.029000 +08:00
- STATUS Generated (4)
- CORRELATION_LEVEL Typical (2)
- PROBLEMS 1 main problems, 1 correlated problems
- INCIDENTS 6 main incidents, 2 correlated incidents
- INCLUDED_FILES 277
- adrci> ips show package
- PACKAGE_ID 1
- PACKAGE_NAME ORA1578_20170928201600
- PACKAGE_DESCRIPTION XXXX
- DRIVING_PROBLEM 3
- DRIVING_PROBLEM_KEY ORA 1578
- DRIVING_INCIDENT 27928
- DRIVING_INCIDENT_TIME 2017-09-26 20:20:55.029000 +08:00
- STATUS Generated (4)
- CORRELATION_LEVEL Typical (2)
- PROBLEMS 1 main problems, 1 correlated problems
- INCIDENTS 6 main incidents, 2 correlated incidents
- INCLUDED_FILES 311
- adrci> ips show package
- PACKAGE_ID 1
- PACKAGE_NAME ORA1578_20170928201600
- PACKAGE_DESCRIPTION XXXX
- DRIVING_PROBLEM 3
- DRIVING_PROBLEM_KEY ORA 1578
- DRIVING_INCIDENT 27928
- DRIVING_INCIDENT_TIME 2017-09-26 20:20:55.029000 +08:00
- STATUS Generated (4)
- CORRELATION_LEVEL Typical (2)
- PROBLEMS 1 main problems, 1 correlated problems
- INCIDENTS 6 main incidents, 2 correlated incidents
- INCLUDED_FILES 311
- adrci> show hm_run
- ADR Home = /u01/app/oracle/diag/rdbms/orcl/orcl:
- *************************************************************************
- **********************************************************
- HM RUN RECORD 1
- **********************************************************
- RUN_ID 1
- RUN_NAME HM_RUN_1
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2013-05-23 09:47:15.526684 +08:00
- RESUME_TIME <NULL>
- END_TIME 2013-05-23 09:47:17.322008 +08:00
- MODIFIED_TIME 2013-05-23 09:47:17.322008 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE <NULL>
- **********************************************************
- HM RUN RECORD 2
- **********************************************************
- RUN_ID 41
- RUN_NAME HM_RUN_41
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2014-08-06 17:23:30.457152 +08:00
- RESUME_TIME <NULL>
- END_TIME 2014-08-06 17:23:30.678148 +08:00
- MODIFIED_TIME 2014-08-06 17:23:30.678148 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE <NULL>
- **********************************************************
- HM RUN RECORD 3
- **********************************************************
- RUN_ID 61
- RUN_NAME HM_RUN_61
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2014-08-06 17:24:30.449936 +08:00
- RESUME_TIME <NULL>
- END_TIME 2014-08-06 17:24:30.639177 +08:00
- MODIFIED_TIME 2014-08-06 17:24:30.639177 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE <NULL>
- **********************************************************
- HM RUN RECORD 4
- **********************************************************
- RUN_ID 81
- RUN_NAME HM_RUN_81
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2014-08-06 17:25:31.333712 +08:00
- RESUME_TIME <NULL>
- END_TIME 2014-08-06 17:25:32.152792 +08:00
- MODIFIED_TIME 2014-08-06 17:25:32.152792 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE <NULL>
- **********************************************************
- HM RUN RECORD 5
- **********************************************************
- RUN_ID 101
- RUN_NAME HM_RUN_101
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2014-08-06 17:29:40.731026 +08:00
- RESUME_TIME <NULL>
- END_TIME 2014-08-06 17:29:40.963195 +08:00
- MODIFIED_TIME 2014-08-06 17:29:40.963195 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE <NULL>
- **********************************************************
- HM RUN RECORD 6
- **********************************************************
- RUN_ID 121
- RUN_NAME HM_RUN_121
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2014-08-06 17:30:52.309421 +08:00
- RESUME_TIME <NULL>
- END_TIME 2014-08-06 17:30:52.519712 +08:00
- MODIFIED_TIME 2014-08-06 17:30:52.519712 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE <NULL>
- **********************************************************
- HM RUN RECORD 7
- **********************************************************
- RUN_ID 141
- RUN_NAME HM_RUN_141
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2014-08-06 17:38:53.508989 +08:00
- RESUME_TIME <NULL>
- END_TIME <NULL>
- MODIFIED_TIME 2014-08-06 17:38:53.508989 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 1
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE <NULL>
- **********************************************************
- HM RUN RECORD 8
- **********************************************************
- RUN_ID 441
- RUN_NAME HM_RUN_441
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 20:17:20.253561 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 20:17:20.737577 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.351806 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_441.hm
- **********************************************************
- HM RUN RECORD 9
- **********************************************************
- RUN_ID 461
- RUN_NAME HM_RUN_461
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 20:18:35.221179 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 20:18:35.443198 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.365612 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_461.hm
- **********************************************************
- HM RUN RECORD 10
- **********************************************************
- RUN_ID 501
- RUN_NAME HM_RUN_501
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 20:20:11.341395 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 20:20:11.457759 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.378340 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_501.hm
- **********************************************************
- HM RUN RECORD 11
- **********************************************************
- RUN_ID 581
- RUN_NAME HM_RUN_581
- CHECK_NAME Data Block Integrity Check
- NAME_ID 3
- MODE 2
- START_TIME 2017-09-26 20:20:56.728663 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 20:20:57.343643 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.392483 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 27928
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_581.hm
- **********************************************************
- HM RUN RECORD 12
- **********************************************************
- RUN_ID 601
- RUN_NAME HM_RUN_601
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 20:22:32.213140 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 20:22:32.276259 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.405370 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_601.hm
- **********************************************************
- HM RUN RECORD 13
- **********************************************************
- RUN_ID 621
- RUN_NAME HM_RUN_621
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 20:24:20.522068 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 20:24:20.592262 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.417340 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_621.hm
- **********************************************************
- HM RUN RECORD 14
- **********************************************************
- RUN_ID 681
- RUN_NAME HM_RUN_681
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 20:55:24.068545 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 20:55:24.300312 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.432864 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_681.hm
- **********************************************************
- HM RUN RECORD 15
- **********************************************************
- RUN_ID 701
- RUN_NAME HM_RUN_701
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 20:57:47.650496 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 20:57:47.717614 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.445601 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_701.hm
- **********************************************************
- HM RUN RECORD 16
- **********************************************************
- RUN_ID 721
- RUN_NAME HM_RUN_721
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 21:03:05.251697 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:03:05.396248 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.463198 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_721.hm
- **********************************************************
- HM RUN RECORD 17
- **********************************************************
- RUN_ID 741
- RUN_NAME HM_RUN_741
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 21:03:05.414377 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:03:05.449687 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.480907 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_741.hm
- **********************************************************
- HM RUN RECORD 18
- **********************************************************
- RUN_ID 861
- RUN_NAME MYRUN1
- CHECK_NAME Data Block Integrity Check
- NAME_ID 3
- MODE 0
- START_TIME 2017-09-26 21:17:06.359595 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:17:06.721305 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.498125 +08:00
- TIMEOUT 100000
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_MYRUN1.hm
- **********************************************************
- HM RUN RECORD 19
- **********************************************************
- RUN_ID 881
- RUN_NAME MYRUN2
- CHECK_NAME Data Block Integrity Check
- NAME_ID 3
- MODE 0
- START_TIME 2017-09-26 21:19:07.600290 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:19:07.943468 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.515356 +08:00
- TIMEOUT 10000
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_MYRUN2.hm
- **********************************************************
- HM RUN RECORD 20
- **********************************************************
- RUN_ID 904
- RUN_NAME MYRUN3
- CHECK_NAME Data Block Integrity Check
- NAME_ID 3
- MODE 0
- START_TIME 2017-09-26 21:27:02.210962 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:27:02.534798 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.531019 +08:00
- TIMEOUT 10000
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_MYRUN3.hm
- **********************************************************
- HM RUN RECORD 21
- **********************************************************
- RUN_ID 944
- RUN_NAME HM_RUN_944
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 21:28:20.645674 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:28:20.770048 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.546253 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_944.hm
- **********************************************************
- HM RUN RECORD 22
- **********************************************************
- RUN_ID 1024
- RUN_NAME HM_RUN_1024
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 21:30:01.692307 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:30:01.787426 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.561984 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_1024.hm
- **********************************************************
- HM RUN RECORD 23
- **********************************************************
- RUN_ID 1044
- RUN_NAME HM_RUN_1044
- CHECK_NAME Data Block Integrity Check
- NAME_ID 3
- MODE 2
- START_TIME 2017-09-26 21:30:03.380460 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:30:04.024025 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.579142 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 29157
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_1044.hm
- **********************************************************
- HM RUN RECORD 24
- **********************************************************
- RUN_ID 1184
- RUN_NAME HM_RUN_1184
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 21:35:11.527444 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:35:11.594048 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.592548 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_1184.hm
- **********************************************************
- HM RUN RECORD 25
- **********************************************************
- RUN_ID 1204
- RUN_NAME HM_RUN_1204
- CHECK_NAME Data Block Integrity Check
- NAME_ID 3
- MODE 2
- START_TIME 2017-09-26 21:35:13.259094 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:35:13.704350 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.606102 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 30222
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_1204.hm
- **********************************************************
- HM RUN RECORD 26
- **********************************************************
- RUN_ID 1244
- RUN_NAME HM_RUN_1244
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 21:39:43.703672 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:39:43.823675 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.619378 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_1244.hm
- **********************************************************
- HM RUN RECORD 27
- **********************************************************
- RUN_ID 1324
- RUN_NAME HM_RUN_1324
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 21:40:48.209058 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:40:48.283130 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.631908 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_1324.hm
- **********************************************************
- HM RUN RECORD 28
- **********************************************************
- RUN_ID 1344
- RUN_NAME HM_RUN_1344
- CHECK_NAME Data Block Integrity Check
- NAME_ID 3
- MODE 2
- START_TIME 2017-09-26 21:40:49.974216 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:40:50.538886 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.645938 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 31526
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_1344.hm
- **********************************************************
- HM RUN RECORD 29
- **********************************************************
- RUN_ID 1384
- RUN_NAME HM_RUN_1384
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-26 21:43:04.713721 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:43:04.861793 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.659703 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_1384.hm
- **********************************************************
- HM RUN RECORD 30
- **********************************************************
- RUN_ID 1464
- RUN_NAME HM_RUN_1464
- CHECK_NAME Data Block Integrity Check
- NAME_ID 3
- MODE 2
- START_TIME 2017-09-26 21:44:02.500602 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-26 21:44:03.079214 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.675693 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 32798
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_1464.hm
- **********************************************************
- HM RUN RECORD 31
- **********************************************************
- RUN_ID 1484
- RUN_NAME HM_RUN_1484
- CHECK_NAME DB Structure Integrity Check
- NAME_ID 2
- MODE 2
- START_TIME 2017-09-28 19:27:18.757188 +08:00
- RESUME_TIME <NULL>
- END_TIME 2017-09-28 19:27:18.842418 +08:00
- MODIFIED_TIME 2017-09-28 20:24:48.690006 +08:00
- TIMEOUT 0
- FLAGS 0
- STATUS 5
- SRC_INCIDENT_ID 0
- NUM_INCIDENTS 0
- ERR_NUMBER 0
- REPORT_FILE /u01/app/oracle/diag/rdbms/orcl/orcl/hm/HMREPORT_HM_RUN_1484.hm
- 31 rows fetched
- adrci> create report hm_run HM_RUN_1484;
- adrci> show report hm_run HM_RUN_1484
- <?xml version="1.0" encoding="US-ASCII"?>
- <HM-REPORT REPORT_ID="HM_RUN_1484">
- <TITLE>HM Report: HM_RUN_1484</TITLE>
- <RUN_INFO>
- <CHECK_NAME>DB Structure Integrity Check</CHECK_NAME>
- <RUN_ID>1484</RUN_ID>
- <RUN_NAME>HM_RUN_1484</RUN_NAME>
- <RUN_MODE>REACTIVE</RUN_MODE>
- <RUN_STATUS>COMPLETED</RUN_STATUS>
- <RUN_ERROR_NUM>0</RUN_ERROR_NUM>
- <SOURCE_INCIDENT_ID>0</SOURCE_INCIDENT_ID>
- <NUM_INCIDENTS_CREATED>0</NUM_INCIDENTS_CREATED>
- <RUN_START_TIME>2017-09-28 19:27:18.757188 +08:00</RUN_START_TIME>
- <RUN_END_TIME>2017-09-28 19:27:18.842418 +08:00</RUN_END_TIME>
- </RUN_INFO>
- <RUN_PARAMETERS/>
- <RUN-FINDINGS/>
- </HM-REPORT>
- adrci>
复制代码
- BEGIN
- DBMS_REPAIR.ADMIN_TABLES (
- table_name => 'REPAIR_TABLE',
- table_type => DBMS_REPAIR.REPAIR_TABLE,
- action => DBMS_REPAIR.CREATE_ACTION,
- tablespace => 'USERS');
- END;
- select * from REPAIR_TABLE;
- BEGIN
- DBMS_REPAIR.ADMIN_TABLES (
- table_name => 'ORPHAN_KEY_TABLE',
- table_type => DBMS_REPAIR.ORPHAN_TABLE,
- action => DBMS_REPAIR.CREATE_ACTION,
- tablespace => 'USERS');
- END;
- select * from ORPHAN_KEY_TABLE;
- DECLARE
- num_corrupt INT;
- BEGIN
- num_corrupt := 0;
- DBMS_REPAIR.CHECK_OBJECT (
- schema_name => 'HR',
- object_name => 'TLOGICAL',
- repair_table_name => 'REPAIR_TABLE',
- corrupt_count => num_corrupt);
- dbms_output.put_line( 'Find '|| num_corrupt||' Bolcks.' );
- END;
- select * from REPAIR_TABLE;
- ----
- DECLARE
- num_fix INT;
- BEGIN
- num_fix := 0;
- DBMS_REPAIR.FIX_CORRUPT_BLOCKS (
- schema_name => 'HR',
- object_name => 'TLOGICAL',
- object_type => DBMS_REPAIR.TABLE_OBJECT,
- repair_table_name => 'REPAIR_TABLE',
- fix_count => num_fix);
- dbms_output.put_line( 'Find '|| num_fix||' Bolcks.' );
- END;
- ----
- DECLARE
- num_orphans INT;
- BEGIN
- num_orphans := 0;
- DBMS_REPAIR.DUMP_ORPHAN_KEYS (
- schema_name => 'HR',
- object_name => 'ILOGICAL_B',
- object_type => DBMS_REPAIR.INDEX_OBJECT,
- repair_table_name => 'REPAIR_TABLE',
- orphan_table_name => 'ORPHAN_KEY_TABLE',
- key_count => num_orphans);
- DBMS_OUTPUT.PUT_LINE('orphan key count: ' || TO_CHAR(num_orphans));
- END;
- select * from ORPHAN_KEY_TABLE where keyrowid||' '='AAATrIAIgAAAIABAAA'||' '
- and index_name='ILOGICAL_B';
复制代码
|
|