课程第37次
$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jan 4 03:33:56 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
connected to target database: ORCL (DBID=1554722616)
RMAN> backup validate database;
Starting backup at 2020-01-04:03:34:09
using target database control file instead of recovery catalog
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=15 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=204 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
channel ORA_SBT_TAPE_1: starting full datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
input datafile file number=00004 name=+DATA/orcl/datafile/users.265.1028025845
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.281.1026941797
channel ORA_SBT_TAPE_2: starting full datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.282.1026941797
input datafile file number=00005 name=+DATA/orcl/datafile/tbstrans1.261.1027718433
input datafile file number=00006 name=+DATA/orcl/datafile/tbstrans2.262.1027718497
input datafile file number=00007 name=+DATA/orcl/datafile/tbslog.289.1028028559
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:16
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 14686 96010 1762376
File Name: +DATA/orcl/datafile/system.283.1026941797
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 64276
Index 0 13250
Other 0 3788
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3 OK 0 1 14083 1762381
File Name: +DATA/orcl/datafile/undotbs1.281.1026941797
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 14079
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4 OK 1 9 643 1760094
File Name: +DATA/orcl/datafile/users.265.1028025845
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 49
Index 0 4
Other 0 578
channel ORA_SBT_TAPE_1: starting full datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:16
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2 OK 0 22887 89644 1762381
File Name: +DATA/orcl/datafile/sysaux.282.1026941797
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 20147
Index 0 15138
Other 0 31428
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5 OK 0 1145 1280 1425175
File Name: +DATA/orcl/datafile/tbstrans1.261.1027718433
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 5
Index 0 0
Other 0 130
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 1145 1280 1425175
File Name: +DATA/orcl/datafile/tbstrans2.262.1027718497
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 5
Index 0 0
Other 0 130
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7 OK 1 56 1281 1670938
File Name: +DATA/orcl/datafile/tbslog.289.1028028559
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 5
Index 0 0
Other 0 1219
channel ORA_SBT_TAPE_2: starting full datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
Control File OK 0 600
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE OK 0 2
Finished backup at 2020-01-04:03:34:57
RMAN>
select* from v$backup_corruption;
select* from v$database_block_corruption;
select* from v$copy_corruption;
FILE#BLOCK#BLOCKSCORRUPTION_CHANGE#CORRUPTION_TYPE
1419810CORRUPT
2713611670906NOLOGGING
Oracle默认由于参数原因,对逻辑坏块是“睁一只眼,闭一只眼的”:
SQL> conn / as sysdba
Connected.
SQL> show parameter db_block_checking
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_block_checking string FALSE
SQL> show parameter ultra
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_ultra_safe string OFF
SQL> 物理坏块是incident,是problem,也是failure:
RMAN> list failure;
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------------- -------
3162 HIGH OPEN 2019-12-26:10:47:58 Datafile 4: '+DATA/orcl/datafile/users.265.1028025845' contains one or more corrupt blocks
RMAN> 修复:
RMAN> advise failure;
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------------- -------
3162 HIGH OPEN 2019-12-26:10:47:58 Datafile 4: '+DATA/orcl/datafile/users.265.1028025845' contains one or more corrupt blocks
analyzing automatic repair options; this may take some time
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=143 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=137 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=73 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=19 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=79 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=130 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=202 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=14 device type=DISK
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
analyzing automatic repair options complete
Mandatory Manual Actions
========================
no manual actions available
Optional Manual Actions
=======================
no manual actions available
Automated Repair Options
========================
Option Repair Description
------ ------------------
1 Perform block media recovery of block 198 in file 4
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_144479743.hm
RMAN> repair failure preview;
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_144479743.hm
contents of repair script:
# block media recovery
recover datafile 4 block 198;
RMAN> recovercorruption list;
Starting recover at 2020-01-04:03:56:23
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_1: restoring block(s)
channel ORA_SBT_TAPE_1: specifying block(s) to restore from backup set
restoring blocks of datafile 00004
channel ORA_SBT_TAPE_1: reading from backup piece /home/oracle/clone1/4fukc5mu_1_1
channel ORA_SBT_TAPE_1: piece handle=/home/oracle/clone1/4fukc5mu_1_1 tag=TAG20191226T043226
channel ORA_SBT_TAPE_1: restored block(s) from backup piece 1
channel ORA_SBT_TAPE_1: block restore complete, elapsed time: 00:00:01
starting media recovery
archived log for thread 1 with sequence 30 is already on disk as file +FRA/orcl/archivelog/2019_12_26/thread_1_seq_30.268.1028003569
archived log for thread 1 with sequence 31 is already on disk as file +FRA/orcl/archivelog/2019_12_26/thread_1_seq_31.480.1028019613
archived log for thread 1 with sequence 32 is already on disk as file +FRA/orcl/archivelog/2019_12_26/thread_1_seq_32.475.1028025907
archived log for thread 1 with sequence 33 is already on disk as file +FRA/orcl/archivelog/2019_12_26/thread_1_seq_33.474.1028033415
archived log for thread 1 with sequence 34 is already on disk as file +FRA/orcl/archivelog/2019_12_30/thread_1_seq_34.473.1028389949
archived log for thread 1 with sequence 35 is already on disk as file +FRA/orcl/archivelog/2019_12_30/thread_1_seq_35.472.1028390449
archived log for thread 1 with sequence 36 is already on disk as file +FRA/orcl/archivelog/2019_12_30/thread_1_seq_36.471.1028391747
archived log for thread 1 with sequence 37 is already on disk as file +FRA/orcl/archivelog/2019_12_30/thread_1_seq_37.470.1028394159
archived log for thread 1 with sequence 38 is already on disk as file +FRA/orcl/archivelog/2020_01_04/thread_1_seq_38.469.1028772761
archived log for thread 1 with sequence 39 is already on disk as file +FRA/orcl/archivelog/2020_01_04/thread_1_seq_39.260.1028773409
archived log for thread 1 with sequence 40 is already on disk as file +FRA/orcl/archivelog/2020_01_04/thread_1_seq_40.261.1028773605
archived log for thread 1 with sequence 41 is already on disk as file +FRA/orcl/archivelog/2020_01_04/thread_1_seq_41.468.1028774577
archived log for thread 1 with sequence 42 is already on disk as file +FRA/orcl/archivelog/2020_01_04/thread_1_seq_42.467.1028774605
archived log for thread 1 with sequence 43 is already on disk as file +FRA/orcl/archivelog/2020_01_04/thread_1_seq_43.492.1028775637
media recovery complete, elapsed time: 00:00:15
Finished recover at 2020-01-04:03:56:46
RMAN> 修复完了之后,列表会自动清理:
select* from v$database_block_corruption;
FILE#BLOCK#BLOCKSCORRUPTION_CHANGE#CORRUPTION_TYPE
1713611670906NOLOGGING
访问Support Workbench的文本状态的“浏览器”:
adrci> show alert -p "message_text like '%incident%'"
ADR Home = /u01/app/oracle/product/11.2.0/dbhome_1/station76.example.com_orcl/sysman/emd/state/diag/rdbms/orcl/orcl:
*************************************************************************
Output the results to file: /tmp/alert_13566_1396_orcl_1.ado
2019-12-26 10:47:43.767000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_14511.trc(incident=20777):
ORA-01578: ORACLE data block corrupted (file # 4, block # 198)
ORA-01110: data file 4: '+DATA/orcl/datafile/users.265.1028025845'
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_20777/orcl_ora_14511_i20777.trc
2019-12-26 10:47:56.324000 +08:00
Dumping diagnostic data in directory=, requested by (instance=1, osid=14511), summary=.
2019-12-26 10:54:47.623000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_14511.trc(incident=20778):
ORA-01578: ORACLE data block corrupted (file # 4, block # 198)
ORA-01110: data file 4: '+DATA/orcl/datafile/users.265.1028025845'
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_20778/orcl_ora_14511_i20778.trc
2019-12-26 10:54:54.586000 +08:00
Dumping diagnostic data in directory=, requested by (instance=1, osid=14511), summary=.
2019-12-26 11:32:26.942000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_20827.trc(incident=20593):
ORA-01578: ORACLE data block corrupted (file # 7, block # 136)
ORA-01110: data file 7: '+DATA/orcl/datafile/tbslog.289.1028028559'
ORA-26040: Data block was loaded using the NOLOGGING option
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_20593/orcl_ora_20827_i20593.trc
2019-12-26 11:32:33.635000 +08:00
Dumping diagnostic data in directory=, requested by (instance=1, osid=20827), summary=.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_20827.trc(incident=20594):
ORA-01578: ORACLE data block corrupted (file # 7, block # 136)
ORA-01110: data file 7: '+DATA/orcl/datafile/tbslog.289.1028028559'
ORA-26040: Data block was loaded using the NOLOGGING option
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_20594/orcl_ora_20827_i20594.trc
2019-12-26 11:32:40.600000 +08:00
Dumping diagnostic data in directory=, requested by (instance=1, osid=20827), summary=.
2019-12-26 11:42:24.690000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_20827.trc(incident=20595):
ORA-01578: ORACLE data block corrupted (file # 7, block # 136)
ORA-01110: data file 7: '+DATA/orcl/datafile/tbslog.289.1028028559'
ORA-26040: Data block was loaded using the NOLOGGING option
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_20595/orcl_ora_20827_i20595.trc
2019-12-26 11:42:31.087000 +08:00
adrci>
ADRCI打MOS日志包的命令:
$ adrci
ADRCI: Release 11.2.0.4.0 - Production on Sat Jan 4 04:03:38 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
ADR base = "/u01/app/oracle"
adrci> help
HELP
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 SHOW HOMES
Usage: SHOW HOMES | HOME | HOMEPATH
[-ALL | -base <base_str> | homepath_str1 ... ]
Purpose: Show the ADR homes in the current ADRCI session.
Options:
[-ALL]: If it is specified, the ADR homes under the current base
setting will be displayed.
[-base <base_str>]: It is for showing all the homes under <base_str>,
where <base_str> is a system-dependent directory path string.
<homepath_str1 ...>: The paths of the home, relative to the ADR base.
Examples:
show homes -all
show homes -base /temp
show homes rdbms
show homes
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>set homepath diag/rdbms/orcl/orcl
adrci> show incident
ADR Home = /u01/app/oracle/diag/rdbms/orcl/orcl:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
20777 ORA 1578 2019-12-26 10:47:43.767000 +08:00
20778 ORA 1578 2019-12-26 10:54:47.623000 +08:00
20593 ORA 1578 2019-12-26 11:32:26.942000 +08:00
20594 ORA 1578 2019-12-26 11:32:34.373000 +08:00
20595 ORA 1578 2019-12-26 11:42:24.690000 +08:00
30411 ORA 1578 2020-01-04 02:13:13.865000 +08:00
30412 ORA 1578 2020-01-04 02:13:31.366000 +08:00
30413 ORA 1578 2020-01-04 02:13:48.196000 +08:00
30414 ORA 1578 2020-01-04 02:55:38.110000 +08:00
30415 ORA 1578 2020-01-04 02:56:13.541000 +08:00
10 rows fetched
adrci> show problem
ADR Home = /u01/app/oracle/diag/rdbms/orcl/orcl:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1 ORA 1578 30415 2020-01-04 02:56:13.541000 +08:00
1 rows fetched
adrci> help
HELP
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
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_20191226115728
PACKAGE_DESCRIPTION ABCDEFG
DRIVING_PROBLEM 1
DRIVING_PROBLEM_KEY ORA 1578
DRIVING_INCIDENT 20777
DRIVING_INCIDENT_TIME2019-12-26 10:47:43.767000 +08:00
STATUS Generated (4)
CORRELATION_LEVEL Typical (2)
PROBLEMS 1 main problems, 0 correlated problems
INCIDENTS 5 main incidents, 0 correlated incidents
INCLUDED_FILES 124
adrci> help CREATE PACKAGE
DIA-48433: Unknown help topic
adrci> help ips CREATE PACKAGE
Usage:IPS CREATE PACKAGE
[INCIDENT <incid> | PROBLEM <prob_id> | PROBLEMKEY <prob_key> |
SECONDS <seconds> | TIME <start_time> TO <end_time>]
Purpose: Create a package, and optionally select contents for the package.
Arguments:
<incid>: ID of incident to use for selecting package contents.
<prob_id>: ID of problem to use for selecting package contents.
<prob_key>: Problem key to use for selecting package contents.
<seconds>: Number of seconds before now for selecting package contents.
<start_time>: Start of time range to look for incidents in.
<end_time>: End of time range to look for incidents in.
Options:
CORRELATE BASIC: The package will include the incident dumps, and the
incident process trace files.
Additional incidents can be included automatically,
if they share relevant correlation keys.
CORRELATE TYPICAL: The package will include the incident dumps, and all
trace files that were modified in a time window around
each incident.
Additional incidents can be included automatically,
if they share relevant correlation keys, or occurred
in a time window around the main incidents.
CORRELATE ALL: The package will include the incident dumps, and all
trace files that were modified between the first
selected incident and the last selected incident.
Additional incidents can be included automatically,
if they occurred in the same time range.
Notes:
If no package contents are specified (incident, problem, etc), an empty
package will be created. Files and incidents can be added later.
If no correlation level is specified, the default level is used.
The default is normally TYPICAL, but it can be changed using the command
IPS SET CONFIGURATION.
Example:
ips create package incident 861;
ips create package time '2006-12-31 23:59:59.00 -07:00' to
'2007-01-01 01:01:01.00 -07:00';
adrci> IPS CREATE PACKAGEPROBLEM 1
Created package 2 based on problem id 1, correlation level typical
adrci> help ips FINALIZE PACKAGE
Usage:IPS FINALIZE PACKAGE <package_id>
Purpose: Get a package ready for shipping by automatically including
correlated contents.
Arguments:
<package_id>: ID of package to finalize.
Example:
ips finalize package 12
adrci> ips show package
PACKAGE_ID 1
PACKAGE_NAME ORA1578_20191226115728
PACKAGE_DESCRIPTION ABCDEFG
DRIVING_PROBLEM 1
DRIVING_PROBLEM_KEY ORA 1578
DRIVING_INCIDENT 20777
DRIVING_INCIDENT_TIME2019-12-26 10:47:43.767000 +08:00
STATUS Generated (4)
CORRELATION_LEVEL Typical (2)
PROBLEMS 1 main problems, 0 correlated problems
INCIDENTS 5 main incidents, 0 correlated incidents
INCLUDED_FILES 124
PACKAGE_ID 2
PACKAGE_NAME ORA1578_20200104040553
PACKAGE_DESCRIPTION
DRIVING_PROBLEM 1
DRIVING_PROBLEM_KEY ORA 1578
DRIVING_INCIDENT 20777
DRIVING_INCIDENT_TIME2019-12-26 10:47:43.767000 +08:00
STATUS New (0)
CORRELATION_LEVEL Typical (2)
PROBLEMS 1 main problems, 1 correlated problems
INCIDENTS 6 main incidents, 4 correlated incidents
INCLUDED_FILES 30
adrci>IPS FINALIZE PACKAGE 2;
Finalized package 2
adrci> adrci> adrci> adrci> adrci>
adrci>
adrci> ips show package
PACKAGE_ID 1
PACKAGE_NAME ORA1578_20191226115728
PACKAGE_DESCRIPTION ABCDEFG
DRIVING_PROBLEM 1
DRIVING_PROBLEM_KEY ORA 1578
DRIVING_INCIDENT 20777
DRIVING_INCIDENT_TIME2019-12-26 10:47:43.767000 +08:00
STATUS Generated (4)
CORRELATION_LEVEL Typical (2)
PROBLEMS 1 main problems, 0 correlated problems
INCIDENTS 5 main incidents, 0 correlated incidents
INCLUDED_FILES 124
PACKAGE_ID 2
PACKAGE_NAME ORA1578_20200104040553
PACKAGE_DESCRIPTION
DRIVING_PROBLEM 1
DRIVING_PROBLEM_KEY ORA 1578
DRIVING_INCIDENT 20777
DRIVING_INCIDENT_TIME2019-12-26 10:47:43.767000 +08:00
STATUS Finalized (2)
CORRELATION_LEVEL Typical (2)
PROBLEMS 1 main problems, 1 correlated problems
INCIDENTS 6 main incidents, 4 correlated incidents
INCLUDED_FILES 198
adrci> ips GENERATE PACKAGE 2;
Generated package 2 in file /home/oracle/ORA1578_20200104040553_COM_1.zip, mode complete
adrci>
-----------------------------------
select* from v$hm_check;
begin
dbms_hm.run_check(check_name => 'Data Block Integrity Check',
run_name =>'MY2',
input_params =>'BLC_DF_NUM=7;BLC_BL_NUM=136');
end;
select dbms_hm.get_run_report('MY2') from dual;
**********************************************************
HM RUN RECORD 27
**********************************************************
RUN_ID 3584
RUN_NAME MY2
CHECK_NAME Data Block Integrity Check
NAME_ID 3
MODE 0
START_TIME 2020-01-04 04:27:42.668137 +08:00
RESUME_TIME <NULL>
END_TIME 2020-01-04 04:27:43.392835 +08:00
MODIFIED_TIME 2020-01-04 04:28:38.992340 +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_MY2.hm
27 rows fetched
adrci> help
HELP
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 SHOW REPORT
Usage:SHOW REPORT <report_type> <report_id>
Purpose: Show a report for the specified report type and ID.
Currently we only support report type of hm_run.
Arguments:
<report_type>: The type of the requested report.
<report_id>: The requested report ID.
Notes:
If currently there is no browser set, the report contents will be
displayed through ADRCI channels (terminal or spool file). To get
the report displayed through some browser, use command " set browser".
For example:
"set browser mozilla"
Example:
show report hm_run <hm_run_name>
adrci> show report hm_run MY2
<?xml version="1.0" encoding="US-ASCII"?>
<HM-REPORT REPORT_ID="MY2">
<TITLE>HM Report: MY2</TITLE>
<RUN_INFO>
<CHECK_NAME>Data Block Integrity Check</CHECK_NAME>
<RUN_ID>3584</RUN_ID>
<RUN_NAME>MY2</RUN_NAME>
<RUN_MODE>MANUAL</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>2020-01-04 04:27:42.668137 +08:00</RUN_START_TIME>
<RUN_END_TIME>2020-01-04 04:27:43.392835 +08:00</RUN_END_TIME>
</RUN_INFO>
<RUN_PARAMETERS>
<RUN_PARAMETER>BLC_DF_NUM=7</RUN_PARAMETER>
<RUN_PARAMETER>BLC_BL_NUM=136</RUN_PARAMETER>
</RUN_PARAMETERS>
<RUN-FINDINGS/>
</HM-REPORT>
adrci>
页:
[1]