收集OracleRAC相关信息
由于公司Oracle RAC 需要通过RAC dg RAC的方式，升级到性能更高的服务器、存储设备，所以第一步收集老RAC库的相关信息是必要的。
compute sum of total_size on report
compute sum avg min max of INST1 on report
clear buffer computes columns breaks
set pagesize 1000 linesize 130
col owner format a25
col COL_SUM for 99999999999999
compute sum of total_size on report
break on report
--- PROD RAC1：192.168.1.11 12c orcl1
--- PROD RAC2：192.168.1.12 12c orcl2
--- NEW1 RAC1：192.168.1.55 ORARAC1
--- NEW2 RAC2：192.168.1.56 ORARAC2
1.收集oracle版本信息
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> set linesize 170
SQL> select * from DBA_REGISTRY_HISTORY
2 /
ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS
---------------- -------------------- ------------------ ---------- ---------- ----------------------------------------
BOOTSTRAP DATAPATCH 12.2.0.1 RDBMS_12.2.0.1.0_LINUX.X64_170125
2.收集ASM磁盘组信息
SQL> set linesize 170
SQL> col DATABASE_COMPATIBILITY for a12
SQL> col COMPATIBILITY for a12
SQL> select name,TOTAL_MB,FREE_MB,TYPE,COMPATIBILITY,DATABASE_COMPATIBILITY,USABLE_FILE_MB from v$asm_diskgroup
2 /
NAME TOTAL_MB FREE_MB TYPE COMPATIBILIT DATABASE_COM USABLE_FILE_MB
------------------------------ ---------- ---------- ------ ------------ ------------ --------------
ARCH 1843200 483192 EXTERN 12.2.0.1.0 10.1.0.0.0 483192
DATA 11324616 3864132 NORMAL 12.2.0.1.0 10.1.0.0.0 988348
FLA 1228800 1215004 EXTERN 12.2.0.1.0 10.1.0.0.0 1215004
OCR 184320 100704 NORMAL 12.2.0.1.0 10.1.0.0.0 19632
收集ASM卷信息
select GROUP_NUMBER,label NAME, PATH, TOTAL_MB, CREATE_DAte from v$asm_disk_stat
order by GROUP_NUMBER
GROUP_NUMBER NAME PATH TOTAL_MB CREATE_DA
------------ -------------------- -------------------------------------------------- ---------- ---------
1 ARCH /dev/oracleasm/disks/ARCH1 614400 30-JUL-18
1 ARCH /dev/oracleasm/disks/ARCH2 614400 30-JUL-18
1 ARCH /dev/oracleasm/disks/ARCH3 614400 29-SEP-20
2 DATA /dev/oracleasm/disks/DATA1 1887436 30-JUL-18
2 DATA /dev/oracleasm/disks/DATA2 1887436 30-JUL-18
2 DATA /dev/oracleasm/disks/DATA3 1887436 30-JUL-18
2 DATA /dev/oracleasm/disks/DATA4 1887436 26-OCT-18
2 DATA /dev/oracleasm/disks/DATA5 1887436 12-JUL-21
2 DATA /dev/oracleasm/disks/DATA6 1887436 12-JUL-21
3 FLA /dev/oracleasm/disks/FLA1 614400 30-JUL-18
3 FLA /dev/oracleasm/disks/FLA2 614400 30-JUL-18
4 OCR /dev/oracleasm/disks/OCR1 61440 26-JUL-18
4 OCR /dev/oracleasm/disks/OCR2 61440 26-JUL-18
4 OCR /dev/oracleasm/disks/OCR3 61440 26-JUL-18
14 rows selected.
查看磁盘组模式（NORMAL正常冗余、EXTERN额外冗余）
select GROUP_NUMBER,NAME,ROUND(TOTAL_MB/1024) as TOTAL_GB,ROUND(FREE_MB/1024) as FREE_GB,ROUND((TOTAL_MB-FREE_MB)/1024) as USED_DB,TYPE from v$asm_diskgroup
GROUP_NUMBER NAME TOTAL_GB FREE_GB USED_DB TYPE
------------ -------------------- ---------- ---------- ---------- ------
1 ARCH 1800 471 1329 EXTERN
2 DATA 11059 3774 7286 NORMAL
3 FLA 1200 1187 13 EXTERN
4 OCR 180 98 82 NORMAL
3.收集CPU、内存、OS信息
[oracle@ORCL1 hhh]$ cat /proc/cpuinfo |grep processor |wc -l
112
[oracle@FXDB1 hhh]$ cat /proc/meminfo
MemTotal: 1058651568 kB
MemFree: 35570044 kB
Buffers: 2446540 kB
Cached: 822762364 kB
SwapCached: 1807348 kB
Active: 577259900 kB
Inactive: 267341604 kB
Active(anon): 541793408 kB
Inactive(anon): 15201076 kB
Active(file): 35466492 kB
Inactive(file): 252140528 kB
Unevictable: 579036 kB
Mlocked: 485016 kB
SwapTotal: 102399992 kB
SwapFree: 67066224 kB
Dirty: 65296 kB
Writeback: 0 kB
AnonPages: 18204304 kB
Mapped: 525350680 kB
Shmem: 537465932 kB
Slab: 8449500 kB
SReclaimable: 8012252 kB
SUnreclaim: 437248 kB
KernelStack: 86096 kB
PageTables: 160754644 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 631725776 kB
Committed_AS: 622583624 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 2858172 kB
VmallocChunk: 33552764592 kB
HardwareCorrupted: 0 kB
AnonHugePages: 6928384 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
DirectMap4k: 56320 kB
DirectMap2M: 1966080 kB
DirectMap1G: 1071644672 kB
[oracle@ORCL1 hhh]$
[root@FXDB1 orabak1]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/rootvg-lvroot
727G 469G 222G 68% /
tmpfs 505G 647M 505G 1% /dev/shm
/dev/sda2 477M 52M 401M 12% /boot
/dev/sda1 500M 304K 500M 1% /boot/efi
/dev/mapper/cdcvg-lvcdc
296G 102G 179G 37% /cdc
/dev/mapper/orabakvg-lvorabak
2.5T 1.6T 760G 68% /orabak1
[root@FXDB1 orabak1]# cat /etc/*release*
LSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
cat: /etc/lsb-release.d: Is a directory
Red Hat Enterprise Linux Server release 6.9 (Santiago)
Red Hat Enterprise Linux Server release 6.9 (Santiago)
cpe:/o:redhat:enterprise_linux:6server:ga:server
[oracle@ORCL1 ~]$ env |grep SID
ORACLE_SID=orcl1
[oracle@FXDB1 ~]$ ps -ef |grep pmon
grid 17422 1 0 2021 ? 00:09:19 asm_pmon_+ASM1
oracle 18507 1 0 2021 ? 01:56:47 ora_pmon_orcl1
oracle 93859 92302 0 11:00 pts/1 00:00:00 grep pmon
grid 154348 1 0 2021 ? 00:09:08 mdb_pmon_-MGMTDB
查看数据库实例中用户名及分别占用的表空间大小
set pagesize 1000 linesize 130
col owner format a25
col COL_SUM for 99999999999999
compute sum of total_size on report
break on report
SELECT a.owner, a.total_size,b.numtab,b.col_sum,round((a.total_size/b.numtab) * 10)/10 AVG
From (SELECT owner,
round(Sum(bytes) * 10 / 1024 / 1024 / 1024) / 10 total_size
FROM dba_segments
GROUP BY owner) a,
(SELECT owner, count(*) numtab,sum(NUM_ROWS) col_sum FROM dba_tables GROUP BY owner) b
WHERE a.owner = b.owner
order by 2 desc
/
OWNER TOTAL_SIZE NUMTAB COL_SUM AVG
------------------------- ---------- ---------- --------------- ----------
TEST1 1708.5 1757 6730515668 1
TEST2 907.3 536 2248857728 1.7
SYS 79.9 1502 83700729 .1
AUDSYS 5.5 1 6478091 5.5
XDB .1 32 761 0
GSMADMIN_INTERNAL 0 39 2 0
OJVMSYS 0 6 20 0
WMSYS 0 38 170 0
SYSTEM 0 191 1582 0
OUTLN 0 3 0 0
CDCUSER 0 4 6 0
DBSNMP 0 20 2396 0
----------
sum 2701.3
12 rows selected.
查看是否开启补充日志
SQL> select SUPPLEMENTAL_LOG_DATA_MIN,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI,FORCE_LOGGING from v$database;
SUPPLEME SUP SUP FORCE_LOGGING
-------- --- --- ---------------------------------------
YES YES YES YES
查看临时表空间数据文件，是否自动扩增
set pagesize 200 linesize 160
col file_name for a60
compute sum of GB on report
select file_name,round(bytes/1024/1024/1024*10)/10 GB,tablespace_name,AUTOEXTENSIBLE from dba_temp_files;
/
FILE_NAME GB TABLESPACE_NAME AUT
------------------------------------------------------------ ---------- ------------------------------ ---
+DATA/ORCL/TEMPFILE/temp.263.982859967 32 TEMP YES
+DATA/ORCL/TEMPFILE/temp02.dbf 32 TEMP NO
+DATA/ORCL/TEMPFILE/temp03.dbf 32 TEMP NO
+DATA/ORCL/TEMPFILE/temp04.dbf 32 TEMP NO
+DATA/ORCL/TEMPFILE/temp05.dbf 32 TEMP NO
+DATA/ORCL/TEMPFILE/temp06.dbf 32 TEMP NO
+DATA/ORCL/TEMPFILE/temp07.dbf 32 TEMP NO
+DATA/ORCL/TEMPFILE/temp08.dbf 32 TEMP NO
----------
sum 256
8 rows selected.
查看表空间组信息（表空间组一般用于临时表空间，详细解释我们会在之后的文章中详细介绍）
SQL> select * from dba_tablespace_groups;
no rows selected
查看表空间及使用率
prompt
prompt ###Tablespace Util%
col TBS_SIZE_MB for 99999999999999
col USE_SIZE_MB for 99999999999999
select TABLESPACE_NAME,
round(USED_SPACE * b.value / 1024 / 1024, 1) USE_SIZE_MB,
round(TABLESPACE_SIZE * b.value / 1024 / 1024, 1) TBS_SIZE_MB,
round(USED_PERCENT, 2) USED_PERCENT
from DBA_TABLESPACE_USAGE_METRICS a, v$parameter b
where b.name = 'db_block_size'
order by USED_PERCENT;
TABLESPACE_NAME USE_SIZE_MB TBS_SIZE_MB USED_PERCENT
------------------------------ --------------- --------------- ------------
TEMP 832 262137 .32
SYSTEM 1086 65535 1.66
SYSAUX 26762 53248 50.26
USERS 2678665 3181807 84.19
查看redo日志文件
SQL> col MEMBER for a50
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- ----------
1 1 87174 1073741824 512 2 NO CURRENT 2.0617E+11 06-JAN-22 1.8447E+19 0
2 1 87171 209715200 512 2 YES INACTIVE 2.0616E+11 06-JAN-22 2.0616E+11 06-JAN-22 0
3 1 87173 1073741824 512 2 YES ACTIVE 2.0616E+11 06-JAN-22 2.0617E+11 06-JAN-22 0
4 2 95021 209715200 512 2 YES INACTIVE 2.0616E+11 06-JAN-22 2.0616E+11 06-JAN-22 0
5 2 95022 1073741824 512 2 YES INACTIVE 2.0616E+11 06-JAN-22 2.0616E+11 06-JAN-22 0
6 2 95024 1073741824 512 2 YES ACTIVE 2.0616E+11 06-JAN-22 2.0617E+11 06-JAN-22 0
7 1 87170 1073741824 512 2 YES INACTIVE 2.0616E+11 06-JAN-22 2.0616E+11 06-JAs 7 1 87170 1073741824 512 2 YES INACTIVE 2.0616E+11 06-JAN-22 2.0616E+11 06-JAN-22 0
8 2 95025 1073741824 512 2 NO CURRENT 2.0617E+11 06-JAN-22 1.8447E+19 0
9 1 87172 1073741824 512 2 YES INACTIVE 2.0616E+11 06-JAN-22 2.0616E+11 06-JAN-22 0
10 2 95023 1073741824 512 2 YES INACTIVE 2.0616E+11 06-JAN-22 2.0616E+11 06-JAN-22 0
10 rows selected.
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_ CON_ID
---------- ------- ------- -------------------------------------------------- --- ----------
1 ONLINE +DATA/ORCL/ONLINELOG/group1_1 NO 0
1 ONLINE +FLA/ORCL/ONLINELOG/group1_2 NO 0
2 ONLINE +DATA/ORCL/ONLINELOG/group_2.259.982859961 NO 0
2 ONLINE +FLA/ORCL/ONLINELOG/group_2.258.982859963 YES 0
3 ONLINE +DATA/ORCL/ONLINELOG/group3_1 NO 0
3 ONLINE +FLA/ORCL/ONLINELOG/group3_2 NO 0
4 ONLINE +DATA/ORCL/ONLINELOG/group_4.267.982860845 NO 0
4 ONLINE +FLA/ORCL/ONLINELOG/group_4.260.982860847 YES 0
5 ONLINE +DATA/ORCL/ONLINELOG/group5_1 NO 0
5 ONLINE +FLA/ORCL/ONLINELOG/group5_2 NO 0
6 ONLINE +DATA/ORCL/ONLINELOG/group6_1 NO 0
6 ONLINE +FLA/ORCL/ONLINELOG/group6_2 NO 0
7 ONLINE +DATA/ORCL/ONLINELOG/group7_1 NO 0
7 ONLINE +FLA/ORCL/ONLINELOG/group7_2 NO 0
8 ONLINE +DATA/ORCL/ONLINELOG/group8_1 NO 0
8 ONLINE +FLA/ORCL/ONLINELOG/group8_2 NO 0
9 ONLINE +DATA/ORCL/ONLINELOG/group9_1 NO 0
9 ONLINE +FLA/ORCL/ONLINELOG/group9_2 NO 0
10 ONLINE +DATA/ORCL/ONLINELOG/group10_1 NO 0
10 ONLINE +FLA/ORCL/ONLINELOG/group10_2 NO 0
11 STANDBY +DATA/orcl/ONLINELOG/group11_1 NO 0
12 STANDBY +DATA/ORCL/ONLINELOG/group12_1 NO 0
13 STANDBY +DATA/ORCL/ONLINELOG/group13_1 NO 0
14 STANDBY +DATA/ORCL/ONLINELOG/group14_1 NO 0
15 STANDBY +DATA/ORCL/ONLINELOG/group15_1 NO 0
16 STANDBY +DATA/ORCL/ONLINELOG/group16_1 NO 0
17 STANDBY +DATA/ORCL/ONLINELOG/group17_1 NO 0
18 STANDBY +DATA/ORCL/ONLINELOG/group18_1 NO 0
19 STANDBY +DATA/ORCL/ONLINELOG/group19_1 NO 0
20 STANDBY +DATA/ORCL/ONLINELOG/group20_1 NO 0
21 STANDBY +DATA/ORCL/ONLINELOG/group21_1 NO 0
22 STANDBY +DATA/ORCL/ONLINELOG/group22_1 NO 0
32 rows selected.
SQL> show parameter log_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_syslog_level string
commit_logging string
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
enable_ddl_logging boolean FALSE
log_archive_config string DG_CONFIG=(orcl,ora)
log_archive_dest string
log_archive_dest_1 string location=+ARCH/orcl
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string service=ora LGWR ASYNC NOAFFIRM valid_for=(online_logfiles,primary_role) db_unique_name=ora
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string DEFER
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
log_buffer big integer 479976K
log_checkpoint_interval integer 0
log_checkpoint_timeout integer 1800
log_checkpoints_to_alert boolean FALSE
log_file_name_convert string +DATA/ORCL/ONLINELOG, +DATA/ORA/ONLINELOG, +FLA/ORCL/ONLINELOG,+FLA/ORA/ONLINELOG
remote_login_passwordfile string EXCLUSIVE
sec_case_sensitive_logon boolean TRUE
sec_max_failed_login_attempts integer 3
uniform_log_timestamp_format boolean TRUE
SQL>
--- big obj
set pagesize 1000
set linesize 170
col owner format a20
col segment_name format a40
col tablespace_name for a25
compute sum of GB on report
break on report
查看用户下面的对象及所占用的段大小
select GB,owner,segment_name,segment_type,tablespace_name from
(select round(10*sum(bytes)/1024/1024/1024)/10 GB,owner,segment_name,segment_type,tablespace_name
from dba_segments
group by owner,segment_name,segment_type,tablespace_name
order by 1 )
where gb>1;
GB OWNER SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME
---------- -------------------- ---------------------------------------- ------------------ -------------------------
...............
...............
37 TEST1 KCT05 TABLE USERS
45.1 TEST2 I_KCT02_1_LOG_L_3 INDEX PARTITION USERS
46.8 TEST2 SYS_LOB00010170$$ LOBSEGMENT USERS
50.7 TEST2 I_KCT04_1_LOG_L_2 INDEX PARTITION USERS
61.8 TEST1 XST01 TABLE USERS
75.1 TEST1 KCT02 TABLE PARTITION USERS
117.4 TEST1 KHM01 TABLE USERS
293.6 TEST2 KCT01_LOG TABLE PARTITION USERS
----------
2416.7
335 rows selected.
--- archive
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
set pagesize 1000
col hour for a25
查看每小时的归档量
select trunc(COMPLETION_TIME,'HH') Hour,count(*),round(10*sum(blocks*block_size)/1024/1024/1024)/10 GB
from v$archived_log
where COMPLETION_TIME>sysdate-7 and dest_id=1
group by trunc(COMPLETION_TIME,'HH') order by 1;
HOUR COUNT(*) GB
------------------------- ---------- ----------
2021-12-30 11:00:00 32 12.1
2021-12-30 12:00:00 36 14
2021-12-30 13:00:00 26 10.1
2021-12-30 14:00:00 65 25.8
2021-12-30 15:00:00 96 38
2021-12-30 16:00:00 35 13.5
2021-12-30 17:00:00 29 11.8
2021-12-30 18:00:00 30 11.8
2021-12-30 19:00:00 27 10.2
2021-12-30 20:00:00 27 10.9
2021-12-30 21:00:00 24 9.5
2021-12-30 22:00:00 21 8.4
2021-12-30 23:00:00 24 9.6
2021-12-31 00:00:00 24 9.8
2021-12-31 01:00:00 26 8.2
2021-12-31 02:00:00 23 8.7
2021-12-31 03:00:00 22 8.2
2021-12-31 04:00:00 21 8.5
2021-12-31 05:00:00 37 14.5
2021-12-31 06:00:00 45 17.3
2021-12-31 07:00:00 46 18.5
2021-12-31 08:00:00 49 18.6
2021-12-31 09:00:00 49 18.8
2021-12-31 10:00:00 41 16.3
2021-12-31 11:00:00 30 12.2
2021-12-31 12:00:00 28 11.4
2021-12-31 13:00:00 22 8.1
2021-12-31 14:00:00 25 10.3
2021-12-31 15:00:00 31 12
2021-12-31 16:00:00 31 12.7
2021-12-31 17:00:00 25 10
2021-12-31 18:00:00 24 9.4
2021-12-31 19:00:00 24 9.5
2021-12-31 20:00:00 22 8.5
2021-12-31 21:00:00 20 7.9
2021-12-31 22:00:00 20 7.9
2021-12-31 23:00:00 24 9.4
2022-01-01 00:00:00 21 8.7
2022-01-01 01:00:00 22 6.1
2022-01-01 02:00:00 32 12.1
2022-01-01 03:00:00 23 8.5
2022-01-01 04:00:00 24 9.9
2022-01-01 05:00:00 19 7.2
2022-01-01 06:00:00 40 16.2
2022-01-01 07:00:00 44 17.5
2022-01-01 08:00:00 46 17.9
2022-01-01 09:00:00 45 17.8
2022-01-01 10:00:00 47 17.9
2022-01-01 11:00:00 40 15.5
2022-01-01 12:00:00 27 10.2
2022-01-01 13:00:00 20 7.8
2022-01-01 14:00:00 25 9.4
2022-01-01 15:00:00 23 8.7
2022-01-01 16:00:00 25 10.2
2022-01-01 17:00:00 23 8.6
2022-01-01 18:00:00 22 8.8
2022-01-01 19:00:00 19 7.7
2022-01-01 20:00:00 22 9.1
2022-01-01 21:00:00 23 8.9
2022-01-01 22:00:00 20 7.9
2022-01-01 23:00:00 23 8.3
2022-01-02 00:00:00 24 9.3
2022-01-02 01:00:00 26 8.3
2022-01-02 02:00:00 28 10.7
2022-01-02 03:00:00 25 9.9
2022-01-02 04:00:00 28 10.3
2022-01-02 05:00:00 39 14.6
2022-01-02 06:00:00 43 17.2
2022-01-02 07:00:00 48 18.3
2022-01-02 08:00:00 48 18.6
2022-01-02 09:00:00 47 17.8
2022-01-02 10:00:00 48 18.3
2022-01-02 11:00:00 46 18
2022-01-02 12:00:00 48 18.8
2022-01-02 13:00:00 48 19
2022-01-02 14:00:00 48 19.3
2022-01-02 15:00:00 45 18.4
2022-01-02 16:00:00 40 15
2022-01-02 17:00:00 24 9.5
2022-01-02 18:00:00 26 9.7
2022-01-02 19:00:00 26 10.1
2022-01-02 20:00:00 29 11.3
2022-01-02 21:00:00 28 11.2
2022-01-02 22:00:00 29 11
2022-01-02 23:00:00 29 10.8
2022-01-03 00:00:00 23 9
2022-01-03 01:00:00 20 5.7
2022-01-03 02:00:00 19 8
2022-01-03 03:00:00 20 7.4
2022-01-03 04:00:00 20 8
2022-01-03 05:00:00 19 6.8
2022-01-03 06:00:00 23 8
2022-01-03 07:00:00 45 17.2
2022-01-03 08:00:00 41 16.4
2022-01-03 09:00:00 45 17.8
2022-01-03 10:00:00 49 18.7
2022-01-03 11:00:00 44 17.5
2022-01-03 12:00:00 43 17.4
2022-01-03 13:00:00 44 17.6
2022-01-03 14:00:00 46 18.1
2022-01-03 15:00:00 37 14.6
2022-01-03 16:00:00 26 9.9
2022-01-03 17:00:00 20 8.4
2022-01-03 18:00:00 23 9.2
2022-01-03 19:00:00 20 8
2022-01-03 20:00:00 23 8.9
2022-01-03 21:00:00 17 6.7
2022-01-03 22:00:00 16 6.2
2022-01-03 23:00:00 20 7.4
2022-01-04 00:00:00 20 8.3
2022-01-04 01:00:00 15 5.7
2022-01-04 02:00:00 23 8.7
2022-01-04 03:00:00 18 7
2022-01-04 04:00:00 16 6
2022-01-04 05:00:00 12 4.6
2022-01-04 06:00:00 14 5
2022-01-04 07:00:00 27 10.5
2022-01-04 08:00:00 41 15.9
2022-01-04 09:00:00 42 16.9
2022-01-04 10:00:00 45 17.4
2022-01-04 11:00:00 50 18.3
2022-01-04 12:00:00 46 17.3
2022-01-04 13:00:00 45 18.3
2022-01-04 14:00:00 46 17.9
2022-01-04 15:00:00 40 16.6
2022-01-04 16:00:00 35 14.1
2022-01-04 17:00:00 25 9.9
2022-01-04 18:00:00 26 10.5
2022-01-04 19:00:00 24 9
2022-01-04 20:00:00 20 7.7
2022-01-04 21:00:00 16 6.3
2022-01-04 22:00:00 41 16
2022-01-04 23:00:00 42 17.7
2022-01-05 00:00:00 16 6.3
2022-01-05 01:00:00 20 5.4
2022-01-05 02:00:00 18 7.5
2022-01-05 03:00:00 17 7.1
2022-01-05 04:00:00 18 6.5
2022-01-05 05:00:00 12 4.7
2022-01-05 06:00:00 12 4.4
2022-01-05 07:00:00 48 17.3
2022-01-05 08:00:00 48 16.7
2022-01-05 09:00:00 57 19.8
2022-01-05 10:00:00 47 17.7
2022-01-05 11:00:00 51 19.4
2022-01-05 12:00:00 49 18.3
2022-01-05 13:00:00 51 19.2
2022-01-05 14:00:00 41 14.7
2022-01-05 15:00:00 24 9.3
2022-01-05 16:00:00 24 9
2022-01-05 17:00:00 22 8.5
2022-01-05 18:00:00 20 7.9
2022-01-05 19:00:00 34 13.3
2022-01-05 20:00:00 33 12.7
2022-01-05 21:00:00 27 10.9
2022-01-05 22:00:00 19 7.4
2022-01-05 23:00:00 22 8.8
2022-01-06 00:00:00 18 6.9
2022-01-06 01:00:00 18 5.4
2022-01-06 02:00:00 15 5.9
2022-01-06 03:00:00 13 4.9
2022-01-06 04:00:00 12 4.5
2022-01-06 05:00:00 33 12.9
2022-01-06 06:00:00 43 16.7
2022-01-06 07:00:00 44 17.2
2022-01-06 08:00:00 41 16.1
2022-01-06 09:00:00 47 18.8
2022-01-06 10:00:00 48 18.7
2022-01-06 11:00:00 7 2.7
----------
sum 2020.7
169 rows selected.
select DBID,INSTANCE_NUMBER,CON_DBID,CON_ID,STAT_ID from DBA_HIST_SYS_TIME_MODEL where stat_name='DB time' GROUP BY DBID,INSTANCE_NUMBER,CON_DBID,CON_ID,STAT_ID ;
prompt ###RMAN Collection###
set termout off
set echo off
set feedback off
set verify off
set wrap on
set trimspool on
set serveroutput on
set escape on
set pagesize 50000
set linesize 300
set long 2000000000
clear buffer computes columns breaks
COLUMN backup_name FORMAT a20 HEADING 'Backup Name' ENTMAP off
COLUMN start_time FORMAT a20 HEADING 'Start Time' ENTMAP off
COLUMN elapsed_time FORMAT a20 HEADING 'Elapsed Time' ENTMAP off
COLUMN status FORMAT a30 HEADING 'Status' ENTMAP off
COLUMN input_type HEADING 'Input Type' ENTMAP off
COLUMN output_device_type HEADING 'Output Devices' ENTMAP off
COLUMN input_size format a10 HEADING 'Input Size' ENTMAP off
COLUMN output_size format a10 HEADING 'Output Size' ENTMAP off
COLUMN output_rate_per_sec format a10 HEADING 'Output Rate Per Sec' ENTMAP off
SELECT r.command_id backup_name,
TO_CHAR(r.start_time, 'mm/dd/yyyy HH24:MI:SS') start_time,
r.time_taken_display elapsed_time,
DECODE(r.status,
'COMPLETED',
r.status,
'RUNNING',
r.status,
'FAILED',
r.status,
r.status) status,
r.input_type input_type,
r.output_device_type output_device_type,
r.input_bytes_display input_size,
r.output_bytes_display output_size,
r.output_bytes_per_sec_display output_rate_per_sec
FROM (select command_id,
start_time,
time_taken_display,
status,
input_type,
output_device_type,
input_bytes_display,
output_bytes_display,
output_bytes_per_sec_display
from v$rman_backup_job_details
order by start_time DESC) r
order by 1;
Backup Name Start Time Elapsed Time Status Input Type Output Devices Input Size Output Siz Output Rat
-------------------- -------------------- -------------------- ------------------------------ ------------- ----------------- ---------- ---------- ----------
2021-11-13T01:00:09 11/13/2021 01:00:13 01:32:31 COMPLETED ARCHIVELOG SBT_TAPE 576.32G 576.34G 106.32M
2021-11-13T01:00:19 11/13/2021 01:00:22 00:49:26 COMPLETED DB INCR SBT_TAPE 2.89T 250.26G 86.40M
2021-11-13T01:49:59 11/13/2021 01:50:05 01:04:22 FAILED ARCHIVELOG SBT_TAPE 643.70G 643.72G 170.68M
2021-11-15T10:57:18 11/15/2021 10:57:21 01:26:03 FAILED ARCHIVELOG SBT_TAPE 599.63G 599.65G 118.93M
2021-11-15T10:57:18 11/15/2021 10:57:23 01:15:08 COMPLETED ARCHIVELOG SBT_TAPE 461.13G 461.15G 104.75M
2021-11-15T12:43:57 11/15/2021 12:44:00 00:07:11 COMPLETED ARCHIVELOG SBT_TAPE 58.88G 58.88G 139.89M
2021-11-16T01:00:10 11/16/2021 01:00:13 01:14:53 COMPLETED ARCHIVELOG SBT_TAPE 832.08G 832.11G 189.65M
2021-11-16T01:00:18 11/16/2021 01:00:21 03:42:41 COMPLETED DB INCR SBT_TAPE 2.89T 2.76T 216.70M
2021-11-16T04:43:21 11/16/2021 04:43:25 01:16:28 COMPLETED ARCHIVELOG SBT_TAPE 856.50G 856.54G 191.17M
2021-11-17T01:00:05 11/17/2021 01:00:08 01:16:34 COMPLETED ARCHIVELOG SBT_TAPE 593.55G 593.57G 132.31M
2021-11-17T01:00:13 11/17/2021 01:00:16 00:42:10 COMPLETED DB INCR SBT_TAPE 2.89T 101.28G 40.99M
2021-11-17T01:42:38 11/17/2021 01:42:43 01:14:44 COMPLETED ARCHIVELOG SBT_TAPE 709.58G 709.62G 162.05M
2021-11-18T01:00:22 11/18/2021 01:00:25 01:11:57 COMPLETED ARCHIVELOG SBT_TAPE 652.89G 652.92G 154.87M
2021-11-18T01:00:30 11/18/2021 01:00:33 00:44:15 COMPLETED DB INCR SBT_TAPE 2.98T 109.94G 42.40M
2021-11-18T01:45:06 11/18/2021 01:45:13 01:11:07 COMPLETED ARCHIVELOG SBT_TAPE 731.87G 731.90G 175.64M
2021-11-19T01:00:06 11/19/2021 01:00:09 01:10:57 COMPLETED WITH WARNINGS ARCHIVELOG SBT_TAPE 775.98G 776.02G 186.67M
2021-11-19T01:00:14 11/19/2021 01:00:18 00:43:23 FAILED DB INCR SBT_TAPE 2.98T 140.04G 55.09M
2021-11-19T02:04:59 11/19/2021 02:05:02 00:05:46 COMPLETED DB INCR SBT_TAPE 229.61G 1.12G 3.32M
2021-11-19T02:11:00 11/19/2021 02:11:06 01:11:20 COMPLETED ARCHIVELOG SBT_TAPE 784.76G 784.80G 187.76M
2021-11-20T01:00:04 11/20/2021 01:00:07 01:16:07 FAILED ARCHIVELOG SBT_TAPE 629.36G 629.39G 141.12M
2021-11-20T01:00:13 11/20/2021 01:00:16 00:44:20 COMPLETED DB INCR SBT_TAPE 2.98T 98.33G 37.85M
2021-11-20T01:44:53 11/20/2021 01:44:57 01:15:59 COMPLETED ARCHIVELOG SBT_TAPE 712.19G 712.23G 159.97M
2021-11-20T02:37:19 11/20/2021 02:37:22 00:03:59 COMPLETED ARCHIVELOG SBT_TAPE 15.84G 15.84G 67.88M
2021-11-21T01:00:21 11/21/2021 01:00:24 01:18:59 COMPLETED ARCHIVELOG SBT_TAPE 576.62G 576.64G 124.60M
2021-11-21T01:00:47 11/21/2021 01:00:50 00:42:26 COMPLETED WITH WARNINGS DB INCR SBT_TAPE 2.98T 105.57G 42.46M
2021-11-21T01:43:28 11/21/2021 01:43:34 01:17:56 COMPLETED ARCHIVELOG SBT_TAPE 719.22G 719.25G 157.51M
2021-11-22T01:00:16 11/22/2021 01:00:22 01:29:23 COMPLETED ARCHIVELOG SBT_TAPE 504.11G 504.13G 96.26M
2021-11-22T01:00:28 11/22/2021 01:00:32 00:44:31 COMPLETED DB INCR SBT_TAPE 2.98T 102.27G 39.21M
2021-11-22T01:45:15 11/22/2021 01:45:20 01:27:04 COMPLETED ARCHIVELOG SBT_TAPE 707.44G 707.47G 138.68M
2021-11-23T01:00:06 11/23/2021 01:00:10 01:37:59 COMPLETED ARCHIVELOG SBT_TAPE 957.05G 957.10G 166.71M
2021-11-23T01:00:16 11/23/2021 01:00:19 03:53:33 COMPLETED DB INCR SBT_TAPE 2.76T 2.60T 194.73M
2021-11-23T04:54:10 11/23/2021 04:54:15 01:42:46 COMPLETED ARCHIVELOG SBT_TAPE 974.71G 974.75G 161.88M
2021-11-24T01:00:26 11/24/2021 01:00:31 00:46:31 COMPLETED DB INCR SBT_TAPE 2.98T 135.12G 49.58M
2021-11-24T01:00:54 11/24/2021 01:00:59 01:57:39 COMPLETED ARCHIVELOG SBT_TAPE 465.45G 465.47G 67.52M
2021-11-24T01:47:14 11/24/2021 01:47:20 01:56:42 COMPLETED ARCHIVELOG SBT_TAPE 726.74G 726.78G 106.29M
2021-11-25T01:00:02 11/25/2021 01:00:06 01:51:04 COMPLETED ARCHIVELOG SBT_TAPE 474.91G 474.93G 72.98M
2021-11-25T01:00:10 11/25/2021 01:00:13 00:45:30 COMPLETED DB INCR SBT_TAPE 2.98T 101.04G 37.90M
2021-11-25T01:45:55 11/25/2021 01:46:00 01:51:21 COMPLETED ARCHIVELOG SBT_TAPE 735.90G 735.93G 112.80M
2021-11-26T01:00:00 11/26/2021 01:00:04 01:46:38 COMPLETED ARCHIVELOG SBT_TAPE 469.33G 469.35G 75.12M
2021-11-26T01:00:02 11/26/2021 01:00:05 00:45:35 COMPLETED DB INCR SBT_TAPE 2.98T 86.44G 32.37M
2021-11-26T01:45:51 11/26/2021 01:45:57 01:45:36 COMPLETED ARCHIVELOG SBT_TAPE 743.83G 743.87G 120.22M
2021-11-27T01:00:00 11/27/2021 01:00:04 01:43:13 COMPLETED ARCHIVELOG SBT_TAPE 473.78G 473.81G 78.34M
2021-11-27T01:00:08 11/27/2021 01:00:11 00:46:32 COMPLETED DB INCR SBT_TAPE 2.98T 100.80G 36.97M
2021-11-27T01:46:54 11/27/2021 01:47:00 01:41:44 COMPLETED ARCHIVELOG SBT_TAPE 767.18G 767.21G 128.71M
2021-11-28T01:00:13 11/28/2021 01:00:17 01:24:17 FAILED ARCHIVELOG SBT_TAPE 589.18G 589.21G 119.31M
2021-11-28T01:00:22 11/28/2021 01:00:25 00:47:07 COMPLETED DB INCR SBT_TAPE 2.98T 115.55G 41.85M
2021-11-28T01:47:51 11/28/2021 01:47:57 01:27:02 COMPLETED ARCHIVELOG SBT_TAPE 762.36G 762.39G 149.50M
2021-11-28T02:45:44 11/28/2021 02:45:47 00:05:20 COMPLETED ARCHIVELOG SBT_TAPE 11.61G 11.62G 37.17M
2021-11-29T01:00:06 11/29/2021 01:00:10 01:30:22 COMPLETED ARCHIVELOG SBT_TAPE 739.21G 739.24G 139.61M
2021-11-29T01:00:14 11/29/2021 01:00:18 00:42:14 FAILED DB INCR SBT_TAPE 2.98T 104.40G 42.19M
2021-11-29T02:03:09 11/29/2021 02:03:12 00:06:38 COMPLETED DB INCR SBT_TAPE 374.69M 376.00M 967.40K
2021-11-29T02:10:01 11/29/2021 02:10:05 01:27:49 COMPLETED ARCHIVELOG SBT_TAPE 888.15G 888.19G 172.61M
2021-11-30T01:00:18 11/30/2021 01:00:22 01:29:54 COMPLETED ARCHIVELOG SBT_TAPE 992.10G 992.15G 188.35M
2021-11-30T01:00:27 11/30/2021 01:00:30 04:11:41 COMPLETED DB INCR SBT_TAPE 2.86T 2.68T 185.96M
2021-11-30T05:12:26 11/30/2021 05:12:31 01:41:06 COMPLETED ARCHIVELOG SBT_TAPE 1009.49G 1009.54G 170.42M
2021-12-01T01:00:13 12/01/2021 01:00:17 01:29:08 COMPLETED ARCHIVELOG SBT_TAPE 523.25G 523.28G 100.19M
2021-12-01T01:00:21 12/01/2021 01:00:24 00:46:30 COMPLETED DB INCR SBT_TAPE 3.10T 81.52G 29.92M
2021-12-01T01:47:13 12/01/2021 01:47:20 01:25:49 COMPLETED ARCHIVELOG SBT_TAPE 749.99G 750.03G 149.16M
2021-12-02T01:00:08 12/02/2021 01:00:11 01:30:38 COMPLETED ARCHIVELOG SBT_TAPE 533.10G 533.13G 100.39M
2021-12-02T01:00:17 12/02/2021 01:00:21 00:47:37 COMPLETED DB INCR SBT_TAPE 3.10T 97.84G 35.07M
2021-12-02T01:48:14 12/02/2021 01:48:18 01:28:39 COMPLETED ARCHIVELOG SBT_TAPE 749.83G 749.86G 144.36M
2021-12-03T01:00:09 12/03/2021 01:00:13 01:25:36 COMPLETED ARCHIVELOG SBT_TAPE 567.23G 567.26G 113.10M
2021-12-03T01:00:17 12/03/2021 01:00:20 00:47:54 COMPLETED DB INCR SBT_TAPE 3.10T 97.24G 34.65M
2021-12-03T01:48:28 12/03/2021 01:48:32 01:23:34 COMPLETED ARCHIVELOG SBT_TAPE 756.51G 756.54G 154.51M
2021-12-04T01:00:09 12/04/2021 01:00:13 01:18:14 COMPLETED ARCHIVELOG SBT_TAPE 625.27G 625.30G 136.41M
2021-12-04T01:00:13 12/04/2021 01:00:17 00:47:55 COMPLETED DB INCR SBT_TAPE 3.10T 117.66G 41.91M
2021-12-04T01:48:24 12/04/2021 01:48:29 01:16:42 COMPLETED ARCHIVELOG SBT_TAPE 751.38G 751.41G 167.20M
2021-12-05T01:00:00 12/05/2021 01:00:04 01:17:31 COMPLETED ARCHIVELOG SBT_TAPE 642.47G 642.50G 141.46M
2021-12-05T01:00:03 12/05/2021 01:00:06 00:48:52 COMPLETED DB INCR SBT_TAPE 3.10T 126.65G 44.23M
2021-12-05T01:49:11 12/05/2021 01:49:17 01:16:44 COMPLETED ARCHIVELOG SBT_TAPE 758.28G 758.31G 168.66M
2021-12-06T01:00:12 12/06/2021 01:00:17 01:12:23 COMPLETED ARCHIVELOG SBT_TAPE 706.07G 706.10G 166.49M
2021-12-06T01:00:25 12/06/2021 01:00:28 00:49:05 COMPLETED DB INCR SBT_TAPE 3.10T 102.88G 35.77M
2021-12-06T01:49:43 12/06/2021 01:49:50 01:05:01 COMPLETED WITH WARNINGS ARCHIVELOG SBT_TAPE 721.24G 721.27G 189.33M
2021-12-07T01:00:07 12/07/2021 01:00:12 01:05:19 COMPLETED ARCHIVELOG SBT_TAPE 687.89G 687.92G 179.75M
2021-12-07T01:00:16 12/07/2021 01:00:20 03:57:12 COMPLETED DB INCR SBT_TAPE 3.10T 2.90T 213.89M
2021-12-07T04:57:44 12/07/2021 04:57:48 01:05:44 COMPLETED ARCHIVELOG SBT_TAPE 700.70G 700.73G 181.93M
2021-12-08T01:00:02 12/08/2021 01:00:05 01:04:48 COMPLETED ARCHIVELOG SBT_TAPE 688.20G 688.23G 181.26M
2021-12-08T01:00:10 12/08/2021 01:00:14 00:45:25 COMPLETED DB INCR SBT_TAPE 3.10T 89.60G 33.67M
2021-12-08T01:45:50 12/08/2021 01:45:57 01:04:52 COMPLETED ARCHIVELOG SBT_TAPE 690.47G 690.50G 181.67M
2021-12-09T01:00:13 12/09/2021 01:00:17 01:12:34 COMPLETED ARCHIVELOG SBT_TAPE 671.94G 671.97G 158.04M
2021-12-09T01:00:21 12/09/2021 01:00:24 00:45:46 COMPLETED DB INCR SBT_TAPE 3.10T 93.33G 34.80M
2021-12-09T01:46:22 12/09/2021 01:46:27 01:11:22 COMPLETED ARCHIVELOG SBT_TAPE 750.72G 750.75G 179.54M
2021-12-10T01:00:11 12/10/2021 01:00:14 01:15:11 COMPLETED ARCHIVELOG SBT_TAPE 661.93G 661.95G 150.26M
2021-12-10T01:00:19 12/10/2021 01:00:22 00:46:22 COMPLETED DB INCR SBT_TAPE 3.10T 83.44G 30.71M
2021-12-10T01:46:55 12/10/2021 01:47:00 01:13:58 COMPLETED ARCHIVELOG SBT_TAPE 753.11G 753.14G 173.77M
2021-12-11T01:00:06 12/11/2021 01:00:09 01:17:55 COMPLETED ARCHIVELOG SBT_TAPE 623.87G 623.89G 136.66M
2021-12-11T01:00:15 12/11/2021 01:00:18 00:46:58 COMPLETED DB INCR SBT_TAPE 3.10T 108.44G 39.40M
2021-12-11T01:47:34 12/11/2021 01:47:39 01:15:56 COMPLETED ARCHIVELOG SBT_TAPE 753.74G 753.77G 169.42M
2021-12-12T00:59:59 12/12/2021 01:00:02 01:26:02 COMPLETED ARCHIVELOG SBT_TAPE 575.53G 575.56G 114.18M
2021-12-12T01:00:08 12/12/2021 01:00:12 00:47:34 COMPLETED DB INCR SBT_TAPE 3.10T 102.85G 36.90M
2021-12-12T01:47:58 12/12/2021 01:48:04 01:22:46 COMPLETED ARCHIVELOG SBT_TAPE 747.57G 747.60G 154.16M
2021-12-13T01:00:02 12/13/2021 01:00:06 01:26:49 FAILED ARCHIVELOG SBT_TAPE 590.37G 590.39G 116.06M
2021-12-13T01:00:13 12/13/2021 01:00:16 00:48:47 COMPLETED DB INCR SBT_TAPE 3.10T 137.88G 48.24M
2021-12-13T01:49:19 12/13/2021 01:49:23 01:27:43 COMPLETED ARCHIVELOG SBT_TAPE 749.70G 749.73G 145.87M
2021-12-13T02:47:27 12/13/2021 02:47:31 00:05:13 COMPLETED ARCHIVELOG SBT_TAPE 9.43G 9.43G 30.85M
2021-12-14T01:00:14 12/14/2021 01:00:17 01:31:51 COMPLETED ARCHIVELOG SBT_TAPE 984.03G 984.07G 182.85M
2021-12-14T01:00:23 12/14/2021 01:00:27 04:14:40 COMPLETED DB INCR SBT_TAPE 2.86T 2.75T 188.83M
2021-12-14T05:15:21 12/14/2021 05:15:27 01:40:18 COMPLETED ARCHIVELOG SBT_TAPE 1014.35G 1014.40G 172.61M
2021-12-15T01:00:01 12/15/2021 01:00:06 01:39:22 COMPLETED ARCHIVELOG SBT_TAPE 488.50G 488.53G 83.91M
2021-12-15T01:00:23 12/15/2021 01:00:27 00:46:17 COMPLETED DB INCR SBT_TAPE 3.10T 131.31G 48.42M
2021-12-15T01:47:04 12/15/2021 01:47:09 01:36:29 COMPLETED ARCHIVELOG SBT_TAPE 747.96G 748.00G 132.31M
2021-12-16T01:00:02 12/16/2021 01:00:05 01:44:43 COMPLETED ARCHIVELOG SBT_TAPE 488.16G 488.18G 79.56M
2021-12-16T01:00:11 12/16/2021 01:00:14 00:47:23 COMPLETED DB INCR SBT_TAPE 3.10T 152.83G 55.05M
2021-12-16T01:47:48 12/16/2021 01:47:55 01:42:55 COMPLETED ARCHIVELOG SBT_TAPE 760.39G 760.42G 126.10M
2021-12-17T01:00:03 12/17/2021 01:00:07 01:46:50 COMPLETED ARCHIVELOG SBT_TAPE 490.87G 490.89G 78.42M
2021-12-17T01:00:13 12/17/2021 01:00:17 00:46:49 COMPLETED DB INCR SBT_TAPE 3.10T 109.97G 40.09M
2021-12-17T01:47:20 12/17/2021 01:47:27 01:45:53 COMPLETED ARCHIVELOG SBT_TAPE 747.18G 747.21G 120.44M
2021-12-18T01:00:02 12/18/2021 01:00:06 01:52:48 COMPLETED ARCHIVELOG SBT_TAPE 468.64G 468.66G 70.91M
2021-12-18T01:00:12 12/18/2021 01:00:16 00:48:00 COMPLETED DB INCR SBT_TAPE 3.10T 148.03G 52.63M
2021-12-18T01:48:28 12/18/2021 01:48:35 01:49:46 COMPLETED ARCHIVELOG SBT_TAPE 735.37G 735.40G 114.34M
2021-12-19T01:00:04 12/19/2021 01:00:07 01:55:49 COMPLETED ARCHIVELOG SBT_TAPE 468.94G 468.96G 69.11M
2021-12-19T01:00:13 12/19/2021 01:00:17 00:49:07 COMPLETED DB INCR SBT_TAPE 3.10T 100.73G 35.00M
2021-12-19T01:49:35 12/19/2021 01:49:42 01:54:19 COMPLETED ARCHIVELOG SBT_TAPE 727.64G 727.68G 108.64M
2021-12-20T00:59:55 12/20/2021 00:59:58 01:53:29 COMPLETED ARCHIVELOG SBT_TAPE 459.59G 459.61G 69.12M
2021-12-20T01:00:09 12/20/2021 01:00:12 00:49:35 COMPLETED DB INCR SBT_TAPE 3.10T 120.40G 41.44M
2021-12-20T01:50:05 12/20/2021 01:50:11 01:51:45 COMPLETED ARCHIVELOG SBT_TAPE 746.99G 747.03G 114.09M
2021-12-21T01:00:04 12/21/2021 01:00:08 01:52:54 COMPLETED ARCHIVELOG SBT_TAPE 959.71G 959.75G 145.08M
2021-12-21T01:00:16 12/21/2021 01:00:19 04:29:29 COMPLETED DB INCR SBT_TAPE 2.86T 2.78T 180.20M
2021-12-21T05:30:02 12/21/2021 05:30:10 02:40:12 FAILED ARCHIVELOG SBT_TAPE 980.61G 980.65G 104.47M
2021-12-21T08:31:15 12/21/2021 08:31:22 00:15:28 COMPLETED ARCHIVELOG SBT_TAPE 97.20G 97.21G 107.26M
2021-12-22T01:00:01 12/22/2021 01:00:05 02:00:31 COMPLETED ARCHIVELOG SBT_TAPE 512.11G 512.13G 72.52M
2021-12-22T01:00:14 12/22/2021 01:00:18 00:43:54 FAILED DB INCR SBT_TAPE 3.10T 126.83G 49.31M
2021-12-22T02:05:28 12/22/2021 02:05:31 00:07:37 COMPLETED DB INCR SBT_TAPE 251.11G 904.00M 1.98M
2021-12-22T02:13:19 12/22/2021 02:13:27 01:59:07 COMPLETED ARCHIVELOG SBT_TAPE 870.12G 870.16G 124.67M
2021-12-23T00:59:54 12/23/2021 00:59:58 02:10:19 COMPLETED ARCHIVELOG SBT_TAPE 478.16G 478.19G 62.63M
2021-12-23T01:00:04 12/23/2021 01:00:08 00:49:16 COMPLETED DB INCR SBT_TAPE 3.10T 147.92G 51.24M
2021-12-23T01:49:41 12/23/2021 01:49:46 02:06:08 COMPLETED ARCHIVELOG SBT_TAPE 732.17G 732.21G 99.07M
2021-12-24T01:00:00 12/24/2021 01:00:04 02:09:46 COMPLETED ARCHIVELOG SBT_TAPE 482.80G 482.83G 63.50M
2021-12-24T01:00:10 12/24/2021 01:00:14 00:50:22 COMPLETED DB INCR SBT_TAPE 3.10T 197.16G 66.81M
2021-12-24T01:50:55 12/24/2021 01:51:01 02:03:06 FAILED ARCHIVELOG SBT_TAPE 762.05G 762.08G 105.66M
2021-12-24T04:15:07 12/24/2021 04:15:12 00:02:00 FAILED ARCHIVELOG SBT_TAPE 19.48G 19.48G 166.24M
2021-12-24T04:38:10 12/24/2021 04:38:15 00:04:48 COMPLETED ARCHIVELOG SBT_TAPE 3.38G 3.38G 12.03M
2021-12-25T01:00:01 12/25/2021 01:00:05 02:09:09 COMPLETED ARCHIVELOG SBT_TAPE 475.68G 475.70G 62.86M
2021-12-25T01:10:10 12/25/2021 01:10:14 00:49:19 COMPLETED DB INCR SBT_TAPE 3.11T 146.08G 50.55M
2021-12-25T01:59:53 12/25/2021 02:00:00 02:10:09 COMPLETED ARCHIVELOG SBT_TAPE 810.05G 810.09G 106.23M
2021-12-26T01:00:01 12/26/2021 01:00:04 02:10:45 COMPLETED ARCHIVELOG SBT_TAPE 485.20G 485.22G 63.34M
2021-12-26T01:10:24 12/26/2021 01:10:27 00:50:25 COMPLETED DB INCR SBT_TAPE 3.13T 168.54G 57.05M
2021-12-26T02:01:04 12/26/2021 02:01:10 02:05:00 COMPLETED ARCHIVELOG SBT_TAPE 803.24G 803.27G 109.67M
2021-12-27T01:00:08 12/27/2021 01:00:13 01:55:44 FAILED ARCHIVELOG SBT_TAPE 499.18G 499.20G 73.62M
2021-12-27T01:00:28 12/27/2021 01:00:31 00:56:52 COMPLETED DB INCR SBT_TAPE 3.29T 168.69G 50.63M
2021-12-27T01:58:22 12/27/2021 01:58:29 01:56:59 COMPLETED ARCHIVELOG SBT_TAPE 784.08G 784.11G 114.39M
2021-12-27T03:16:58 12/27/2021 03:17:03 00:07:10 COMPLETED ARCHIVELOG SBT_TAPE 16.57G 16.58G 39.47M
2021-12-28T01:00:05 12/28/2021 01:00:08 01:41:45 FAILED ARCHIVELOG SBT_TAPE 920.66G 920.69G 154.43M
2021-12-28T01:00:16 12/28/2021 01:00:19 01:34:08 FAILED DB INCR SBT_TAPE 979.65G 971.37G 176.11M
2021-12-28T07:37:56 12/28/2021 07:38:00 00:35:24 COMPLETED ARCHIVELOG SBT_TAPE 235.97G 235.98G 113.77M
2021-12-28T07:37:58 12/28/2021 07:38:02 04:38:33 COMPLETED DB INCR SBT_TAPE 2.61T 2.41T 151.24M
2021-12-28T12:16:56 12/28/2021 12:17:01 00:35:13 FAILED ARCHIVELOG SBT_TAPE 116.26G 116.26G 56.34M
2021-12-28T13:12:36 12/28/2021 13:12:41 00:12:52 FAILED ARCHIVELOG SBT_TAPE 25.83G 25.83G 34.26M
2021-12-28T13:46:30 12/28/2021 13:46:36 02:29:20 COMPLETED ARCHIVELOG SBT_TAPE 948.88G 948.92G 108.45M
2021-12-29T01:00:04 12/29/2021 01:00:08 01:56:21 COMPLETED ARCHIVELOG SBT_TAPE 476.44G 476.47G 69.89M
2021-12-29T01:00:07 12/29/2021 01:00:10 00:50:08 COMPLETED DB INCR SBT_TAPE 3.29T 103.04G 35.08M
2021-12-29T01:50:29 12/29/2021 01:50:36 01:53:09 COMPLETED WITH WARNINGS ARCHIVELOG SBT_TAPE 747.90G 747.93G 112.81M
2021-12-30T01:00:00 12/30/2021 01:00:04 02:01:17 COMPLETED ARCHIVELOG SBT_TAPE 487.02G 487.04G 68.54M
2021-12-30T01:00:02 12/30/2021 01:00:06 00:54:16 COMPLETED DB INCR SBT_TAPE 3.29T 134.54G 42.31M
2021-12-30T01:54:41 12/30/2021 01:54:47 02:06:41 COMPLETED ARCHIVELOG SBT_TAPE 769.27G 769.31G 103.64M
2021-12-31T01:00:03 12/31/2021 01:00:07 01:52:09 COMPLETED WITH WARNINGS ARCHIVELOG SBT_TAPE 497.47G 497.49G 75.71M
2021-12-31T01:00:05 12/31/2021 01:00:08 00:53:08 COMPLETED DB INCR SBT_TAPE 3.29T 153.29G 49.24M
2021-12-31T01:53:27 12/31/2021 01:53:32 01:57:48 COMPLETED ARCHIVELOG SBT_TAPE 777.31G 777.35G 112.62M
2022-01-01T01:00:03 01/01/2022 01:00:08 02:03:05 COMPLETED ARCHIVELOG SBT_TAPE 485.03G 485.06G 67.26M
2022-01-01T01:00:05 01/01/2022 01:00:09 00:54:06 COMPLETED DB INCR SBT_TAPE 3.29T 183.16G 57.78M
2022-01-01T01:54:31 01/01/2022 01:54:36 02:04:39 COMPLETED ARCHIVELOG SBT_TAPE 793.96G 793.99G 108.71M
2022-01-02T01:00:02 01/02/2022 01:00:06 01:59:26 COMPLETED ARCHIVELOG SBT_TAPE 476.36G 476.38G 68.07M
2022-01-02T01:00:04 01/02/2022 01:00:07 00:53:19 COMPLETED DB INCR SBT_TAPE 3.29T 107.81G 34.51M
2022-01-02T01:53:41 01/02/2022 01:53:47 02:04:45 COMPLETED ARCHIVELOG SBT_TAPE 774.11G 774.14G 105.91M
2022-01-03T00:59:57 01/03/2022 01:00:01 02:06:17 COMPLETED ARCHIVELOG SBT_TAPE 466.69G 466.71G 63.07M
2022-01-03T00:59:59 01/03/2022 01:00:03 00:54:20 COMPLETED DB INCR SBT_TAPE 3.29T 141.44G 44.43M
2022-01-03T01:54:34 01/03/2022 01:54:40 02:02:40 COMPLETED ARCHIVELOG SBT_TAPE 770.92G 770.95G 107.26M
2022-01-04T01:00:05 01/04/2022 01:00:09 01:51:14 FAILED ARCHIVELOG SBT_TAPE 990.55G 990.59G 151.99M
2022-01-04T01:00:07 01/04/2022 01:00:11 01:50:54 FAILED DB INCR SBT_TAPE 948.96G 940.73G 144.77M
2022-01-04T07:26:06 01/04/2022 07:26:10 00:14:45 COMPLETED ARCHIVELOG SBT_TAPE 82.34G 82.35G 95.28M
2022-01-04T07:26:08 01/04/2022 07:26:12 03:12:19 FAILED DB INCR SBT_TAPE 2.39T 2.21T 200.47M
2022-01-04T10:59:56 01/04/2022 11:00:00 00:05:53 COMPLETED DB INCR SBT_TAPE 374.69M 376.00M 1.07M
2022-01-04T11:06:06 01/04/2022 11:06:12 00:55:30 FAILED ARCHIVELOG SBT_TAPE 186.44G 186.45G 57.34M
2022-01-04T12:22:50 01/04/2022 12:22:56 02:51:33 COMPLETED ARCHIVELOG SBT_TAPE 973.62G 973.67G 96.87M
2022-01-05T01:00:02 01/05/2022 01:00:07 02:04:00 COMPLETED ARCHIVELOG SBT_TAPE 479.97G 479.99G 66.06M
2022-01-05T01:00:30 01/05/2022 01:00:34 00:53:28 COMPLETED DB INCR SBT_TAPE 3.29T 125.66G 40.11M
2022-01-05T01:54:13 01/05/2022 01:54:19 02:02:48 COMPLETED ARCHIVELOG SBT_TAPE 755.48G 755.51G 105.00M
2022-01-06T00:59:52 01/06/2022 00:59:56 02:05:23 COMPLETED ARCHIVELOG SBT_TAPE 480.90G 480.92G 65.46M
2022-01-06T01:00:37 01/06/2022 01:00:40 00:51:43 COMPLETED DB INCR SBT_TAPE 3.29T 125.63G 41.46M
2022-01-06T01:52:40 01/06/2022 01:52:44 02:05:12 COMPLETED ARCHIVELOG SBT_TAPE 747.00G 747.04G 101.83M
--- DB Time
compute sum avg min max of INST1 on report
compute sum avg min max of INST2 on report
compute sum avg min max of INST3 on report
compute sum avg min max of INST4 on report
break on report
spool &crtime._&dbname._dbtime.csv
查看RAC一周之内，每个节点每小时的DBtime
SELECT case when to_number(to_char(c.end_interval_time, 'mi'))<15 or to_number(to_char(c.end_interval_time, 'mi'))>=45
then to_char(round(c.end_interval_time, 'hh24'),'yyyy-mm-dd hh24:mi')
else to_char(c.end_interval_time, 'yyyy-mm-dd hh24')||':30'
end end_time,
case when max(decode(a.instance_number, 1, round((a.value - b.value)/1000000/60,2), null))<0 then null
else max(decode(a.instance_number, 1, round((a.value - b.value)/1000000/60,2), null))
end INST1,
case when max(decode(a.instance_number, 2, round((a.value - b.value)/1000000/60,2), null))<0 then null
else max(decode(a.instance_number, 2, round((a.value - b.value)/1000000/60,2), null))
end INST2,
case when max(decode(a.instance_number, 3, round((a.value - b.value)/1000000/60,2), null))<0 then null
else max(decode(a.instance_number, 3, round((a.value - b.value)/1000000/60,2), null))
end INST3,
case when max(decode(a.instance_number, 4, round((a.value - b.value)/1000000/60,2), null))<0 then null
else max(decode(a.instance_number, 4, round((a.value - b.value)/1000000/60,2), null))
end INST4
FROM DBA_HIST_SYS_TIME_MODEL a, DBA_HIST_SYS_TIME_MODEL b, sys.wrm$_snapshot c ,v$database d
WHERE a.STAT_id = 3649082374
AND b.stat_id = a.stat_id
AND a.snap_id = b.snap_id + 1
AND a.snap_id = c.snap_id
and a.dbid = d.dbid
and c.end_interval_time > sysdate-30
and b.dbid = a.dbid
and c.dbid = a.dbid
and a.instance_number = b.instance_number
and a.instance_number = c.instance_number
group by a.snap_id, case when to_number(to_char(c.end_interval_time, 'mi'))<15 or to_number(to_char(c.end_interval_time, 'mi'))>=45
then to_char(round(c.end_interval_time, 'hh24'),'yyyy-mm-dd hh24:mi')
else to_char(c.end_interval_time, 'yyyy-mm-dd hh24')||':30'
end
ORDER BY a.snap_id;
spool off
END_TIME INST1 INST2 INST3 INST4
---------------- ---------- ---------- ---------- ----------
2021-12-29 09:00 1711.54 1352.38
2021-12-29 10:00 1813.8 1699.86
2021-12-29 11:00 2098.71 2206.61
2021-12-29 12:00 2129.75 2213.82
2021-12-29 13:00 2034.99 2018.72
2021-12-29 14:00 2302.46 2193.58
2021-12-29 15:00 2301.93 2164.29
2021-12-29 16:00 2456.84 2127.16
2021-12-29 17:00 2477.41 2246.21
2021-12-29 18:00 1906.55 2115.1
2021-12-29 19:00 1776 2125.36
2021-12-29 20:00 1903.63 1879.46
2021-12-29 21:00 2076.97 2039.44
2021-12-29 22:00 1723.07 1632.48
2021-12-29 23:00 1185.59 1025.19
2021-12-30 00:00 1119.23 1096.06
2021-12-30 01:00 1097.38 1218.6
2021-12-30 02:00 1117.76 1041.34
2021-12-30 03:00 1114.81 1003.79
2021-12-30 04:00 1117.01 875.26
2021-12-30 05:00 1182.56 1012.38
2021-12-30 06:00 1436.71 1222.06
2021-12-30 07:00 1477.51 1235.2
2021-12-30 08:00 1436.29 1464.23
2021-12-30 09:00 1406.62 1354.42
2021-12-30 10:00 1726.18 1576
2021-12-30 11:00 1901.5 2123.25
2021-12-30 12:00 1983.78 2167.24
2021-12-30 13:00 1801.62 2017.46
2021-12-30 14:00 1937.24 2051.8
2021-12-30 15:00 2710.73 3459.74
2021-12-30 16:00 2363.02 2749.49
2021-12-30 17:00 2197.78 3210.48
2021-12-30 18:00 2018.84 2506.01
2021-12-30 19:00 1963.69 2400.72
2021-12-30 20:00 1877.18 2400.5
2021-12-30 21:00 2025.68 2471.03
2021-12-30 22:00 1665.56 1861.85
2021-12-30 23:00 1189.03 1189.96
2021-12-31 00:00 1114.9 1029.26
2021-12-31 01:00 1181.98 1115.51
2021-12-31 02:00 1018.53 988.42
2021-12-31 03:00 1002.31 1032.56
2021-12-31 04:00 1023.92 990.65
2021-12-31 05:00 1026.86 1074.98
2021-12-31 06:00 1440.06 1293.83
2021-12-31 07:00 1608.05 1362.26
2021-12-31 08:00 1835.84 1389.04
2021-12-31 09:00 1487.69 1670.52
2021-12-31 10:00 1698.66 2045.29
2021-12-31 11:00 2578.01 2686.67
2021-12-31 12:00 1872.7 2009.01
2021-12-31 13:00 1679.99 1921.25
2021-12-31 14:00 1703.92 2264.33
2021-12-31 15:00 1944.99 2224.43
2021-12-31 16:00 2191.99 2403.99
2021-12-31 17:00 2257.65 2478.82
2021-12-31 18:00 2174.2 2462.8
2021-12-31 19:00 2254.16 2610.35
2021-12-31 20:00 2205.52 2159.78
2021-12-31 21:00 2198 2386.54
2021-12-31 22:00 2302.32 2572.26
2021-12-31 23:00 1942.49 2264.38
2022-01-01 00:00 1623.75 2048.64
2022-01-01 01:00 1338.49 1715.54
2022-01-01 02:00 1029.55 1304.89
2022-01-01 03:00 1260.07 1232.2
2022-01-01 04:00 1025.94 1144.02
2022-01-01 05:00 1030.55 989.96
2022-01-01 06:00 1021.78 901.13
2022-01-01 07:00 1320.44 1209.12
2022-01-01 08:00 1443.87 1270.43
2022-01-01 09:00 1430.52 1205.6
2022-01-01 10:00 1656.1 1542.32
2022-01-01 11:00 1943.25 1994.91
2022-01-01 12:00 1931.12 1925.59
2022-01-01 13:00 1713.58 1774.3
2022-01-01 14:00 1597.67 1822.82
2022-01-01 15:00 1655.4 1884.08
2022-01-01 16:00 1865.72 1795.73
2022-01-01 17:00 1716.42 1844.69
2022-01-01 18:00 1646.24 1756.66
2022-01-01 19:00 1655.73 1894.24
2022-01-01 20:00 1612.54 1864.94
2022-01-01 21:00 1535.48 1886.81
2022-01-01 22:00 1949.28 1876.99
2022-01-01 23:00 1371 1361.14
2022-01-02 00:00 1355.84 1159.08
2022-01-02 01:00 1210.46 996.06
2022-01-02 02:00 1033.33 948.88
2022-01-02 03:00 1124.38 944.42
2022-01-02 04:00 1004 1016.18
2022-01-02 05:00 1125.51 957.43
2022-01-02 06:00 1442.1 1072.88
2022-01-02 07:00 1362 1162.8
2022-01-02 08:00 1668.9 1158.94
2022-01-02 09:00 1514.17 1206.59
2022-01-02 10:00 1587.37 1457.48
2022-01-02 11:00 1864.71 1673.35
2022-01-02 12:00 2016.88 1787.98
2022-01-02 13:00 2081.18 1677.34
2022-01-02 14:00 1903.19 1748.96
2022-01-02 15:00 2035.72 1820.61
2022-01-02 16:00 2127.82 1766.55
2022-01-02 17:00 1815.05 1964.37
2022-01-02 18:00 1598.05 1807.78
2022-01-02 19:00 1709.78 1726.32
2022-01-02 20:00 2003.2 1784.64
2022-01-02 21:00 1994.1 1958.45
2022-01-02 22:00 1770.55 1721.01
2022-01-02 23:00 1630.86 1131.27
2022-01-03 00:00 1468.23 1159.9
2022-01-03 01:00 1330.76 1006.36
2022-01-03 02:00 1043.68 922.04
2022-01-03 03:00 1142.96 861.25
2022-01-03 04:00 924.38 926.93
2022-01-03 05:00 928.8 835.1
2022-01-03 06:00 789.16 867.17
2022-01-03 07:00 853.82 891.52
2022-01-03 08:00 1472.26 1068.24
2022-01-03 09:00 1278.24 1057.29
2022-01-03 10:00 1695.3 1211.28
2022-01-03 11:00 1920.96 1612.36
2022-01-03 12:00 1829.81 1807.63
2022-01-03 13:00 1815.05 1716.15
2022-01-03 14:00 1993.97 1903.65
2022-01-03 15:00 2237.03 2046.36
2022-01-03 16:00 1969.54 1959.95
2022-01-03 17:00 1764.54 1776.06
2022-01-03 18:00 1769.5 1808.62
2022-01-03 19:00 1713.61 1845.17
2022-01-03 20:00 1637.78 1770.38
2022-01-03 21:00 1722.84 1720.46
2022-01-03 22:00 1570.14 1386.33
2022-01-03 23:00 1005.32 1082.72
2022-01-04 00:00 974.82 987.2
2022-01-04 01:00 1094.21 915.17
2022-01-04 02:00 927.35 879.4
2022-01-04 03:00 931.92 869.39
2022-01-04 04:00 860.56 824.84
2022-01-04 05:00 847.42 777.89
2022-01-04 06:00 967.4 695.41
2022-01-04 07:00 887.83 736.45
2022-01-04 08:00 1247.94 914.56
2022-01-04 09:00 1296.75 1211
2022-01-04 10:00 1664.83 1286.61
2022-01-04 11:00 2038.37 1866.07
2022-01-04 12:00 2328.29 2353.65
2022-01-04 13:00 1799.61 1974.57
2022-01-04 14:00 2075.66 2212.26
2022-01-04 15:00 2302.23 2162.45
2022-01-04 16:00 2184.47 2425.35
2022-01-04 17:00 2301.02 2210.38
2022-01-04 18:00 1897.65 2050.19
2022-01-04 19:00 1871.59 1771.27
2022-01-04 20:00 1760.7 1625.2
2022-01-04 21:00 1525.5 1717.53
2022-01-04 22:00 1333.67 1400.87
2022-01-04 23:00 1312.85 1007.64
2022-01-05 00:00 1454.56 1189.34
2022-01-05 01:00 1096.29 1186.86
2022-01-05 02:00 1050.63 1115.02
2022-01-05 03:00 1156.6 1123.54
2022-01-05 04:00 1112.54 1190.03
2022-01-05 05:00 1000.66 846.23
2022-01-05 06:00 1072.54 717.49
2022-01-05 07:00 980.43 785.55
2022-01-05 08:00 1161.61 1556.19
2022-01-05 09:00 1429.82 1529.73
2022-01-05 10:00 2075.49 1786.19
2022-01-05 11:00 2315.16 1864.23
2022-01-05 12:00 2173.15 1940.68
2022-01-05 13:00 2024.17 1696.12
2022-01-05 14:00 2256.66 2139.91
2022-01-05 15:00 2202.93 2290.98
2022-01-05 16:00 2034.29 2177.81
2022-01-05 17:00 1931.06 2208.3
2022-01-05 18:00 1735.26 2060.12
2022-01-05 19:00 1870.56 1921.87
2022-01-05 20:00 1907.98 1812.29
2022-01-05 21:00 1766.05 1831.97
2022-01-05 22:00 1623.38 1459.76
2022-01-05 23:00 1327.85 1154.63
2022-01-06 00:00 1198.44 1130.51
2022-01-06 01:00 1252.84 967.86
2022-01-06 02:00 1072.8 1094.33
2022-01-06 03:00 1112.64 1017.5
2022-01-06 04:00 847.31 896.66
2022-01-06 05:00 828.25 968.48
2022-01-06 06:00 1177.55 1056.85
2022-01-06 07:00 1363.36 1107.54
2022-01-06 08:00 1567.79 1111.25
2022-01-06 09:00 1520.75 1108.92
2022-01-06 10:00 1672.25 1434.13
2022-01-06 11:00 2017.1 1599.92
---------- ---------- ---------- ----------
avg 1608.03282 1586.04431
minimum 789.16 695.41
maximum 2710.73 3459.74
sum 313566.4 309278.64
195 rows selected.
###
SQL> show parameter nls
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_calendar string
nls_comp string BINARY
nls_currency string
nls_date_format string
nls_date_language string
nls_dual_currency string
nls_iso_currency string
nls_language string AMERICAN
nls_length_semantics string BYTE
nls_nchar_conv_excp string FALSE
nls_numeric_characters string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_sort string
nls_territory string AMERICA
nls_time_format string
nls_time_tz_format string
nls_timestamp_format string
nls_timestamp_tz_format string
SQL>
查看数据库实例的字符集
select * from nls_database_parameters;
PARAMETER VALUE
---------------------------------------- ----------------------------------------
NLS_RDBMS_VERSION 12.2.0.1.0
NLS_NCHAR_CONV_EXCP FALSE
NLS_LENGTH_SEMANTICS BYTE
NLS_COMP BINARY
NLS_DUAL_CURRENCY $
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_SORT BINARY
NLS_DATE_LANGUAGE AMERICAN
NLS_DATE_FORMAT DD-MON-RR
NLS_CALENDAR GREGORIAN
NLS_NUMERIC_CHARACTERS .,
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET ZHS16GBK
NLS_ISO_CURRENCY AMERICA
NLS_CURRENCY $
NLS_TERRITORY AMERICA
NLS_LANGUAGE AMERICAN
20 rows selected.
######### new 环境（ORARAC环境）
[root@ORARAC1 oracle]# cat /etc/*release*
CentOS Linux release 7.9.2009 (Core)
Derived from Red Hat Enterprise Linux 7.8 (Source)
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"
CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"
CentOS Linux release 7.9.2009 (Core)
CentOS Linux release 7.9.2009 (Core)
cpe:/o:centos:centos:7
[root@ORARAC1 oracle]# cat /proc/cpuinfo |grep "processor" |wc -l
96
[root@MPSRAC1 oracle]# cat /proc/meminfo
MemTotal: 1056057512 kB
MemFree: 1015276824 kB
MemAvailable: 1024333092 kB
Buffers: 16416 kB
Cached: 10272300 kB
SwapCached: 0 kB
Active: 4756308 kB
Inactive: 5783508 kB
Active(anon): 261204 kB
Inactive(anon): 29000 kB
Active(file): 4495104 kB
Inactive(file): 5754508 kB
Unevictable: 15232 kB
Mlocked: 15232 kB
SwapTotal: 94371836 kB
SwapFree: 94371836 kB
Dirty: 0 kB
Writeback: 0 kB
AnonPages: 267212 kB
Mapped: 110392 kB
Shmem: 32620 kB
Slab: 653684 kB
SReclaimable: 387032 kB
SUnreclaim: 266652 kB
KernelStack: 25520 kB
PageTables: 19860 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 622400592 kB
Committed_AS: 3172028 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 2020584 kB
VmallocChunk: 33552064508 kB
Percpu: 117760 kB
HardwareCorrupted: 0 kB
AnonHugePages: 73728 kB
CmaTotal: 0 kB
CmaFree: 0 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
DirectMap4k: 1435648 kB
DirectMap2M: 15839232 kB
DirectMap1G: 1058013184 kB
[root@ORARAC1 oracle]#
[root@ORARAC2 ~]# cat /proc/cpuinfo |grep processor |wc -l
96
[root@MPSRAC2 ~]# cat /proc/meminfo
MemTotal: 1056057512 kB
MemFree: 1014297732 kB
MemAvailable: 1024051656 kB
Buffers: 8364 kB
Cached: 10971760 kB
SwapCached: 0 kB
Active: 2206120 kB
Inactive: 9298156 kB
Active(anon): 533932 kB
Inactive(anon): 29316 kB
Active(file): 1672188 kB
Inactive(file): 9268840 kB
Unevictable: 13776 kB
Mlocked: 13776 kB
SwapTotal: 94367740 kB
SwapFree: 94367740 kB
Dirty: 0 kB
Writeback: 0 kB
AnonPages: 538152 kB
Mapped: 149336 kB
Shmem: 32736 kB
Slab: 664180 kB
SReclaimable: 393344 kB
SUnreclaim: 270836 kB
KernelStack: 27168 kB
PageTables: 32940 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 622396496 kB
Committed_AS: 4902352 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 2018480 kB
VmallocChunk: 33552064508 kB
Percpu: 110080 kB
HardwareCorrupted: 0 kB
AnonHugePages: 202752 kB
CmaTotal: 0 kB
CmaFree: 0 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
DirectMap4k: 1484800 kB
DirectMap2M: 19984384 kB
DirectMap1G: 1053818880 kB
[root@ORARAC2 ~]#
[root@ORARAC1 oracle]# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 504G 0 504G 0% /dev
tmpfs 504G 0 504G 0% /dev/shm
tmpfs 504G 29M 504G 1% /run
tmpfs 504G 0 504G 0% /sys/fs/cgroup
/dev/mapper/centos-root 745G 15G 731G 2% /
/dev/sda1 1014M 186M 829M 19% /boot
tmpfs 101G 12K 101G 1% /run/user/42
/dev/mapper/ORACDCDISK-lvmpscdcdisk 299G 33M 299G 1% /cdcdisk
/dev/mapper/ORAORABAK-lvmpsorabak 3.0T 33M 3.0T 1% /orabak
tmpfs 101G 0 101G 0% /run/user/0
[root@ORARAC1 oracle]#
[root@ORARAC2 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 504G 0 504G 0% /dev
tmpfs 504G 0 504G 0% /dev/shm
tmpfs 504G 21M 504G 1% /run
tmpfs 504G 0 504G 0% /sys/fs/cgroup
/dev/mapper/centos-root 745G 15G 731G 2% /
/dev/sda1 1014M 186M 829M 19% /boot
tmpfs 101G 36K 101G 1% /run/user/0
[root@ORARAC2 ~]#
[root@ORARAC1 oracle]# multipath -l （因为EMC存储是双控制器、连接FC交换机，所以使用multipath做了四条路径的多路径绑定）
ORAData005 (36000144000000010f0234e982ca6000c) dm-5 EMC ,Invista
size=900G features='1 queue_if_no_path' hwhandler='0' wp=rw
`-+- policy='service-time 0' prio=0 status=active
|- 15:0:0:12 sdn 8:208 active undef running
|- 15:0:3:12 sdbh 67:176 active undef running
|- 16:0:0:12 sdaw 67:0 active undef running
`- 16:0:1:12 sdcq 69:224 active undef running
ORAData004 (36000144000000010f0234e982ca6000b) dm-6 EMC ,Invista
size=900G features='1 queue_if_no_path' hwhandler='0' wp=rw
`-+- policy='service-time 0' prio=0 status=active
|- 15:0:0:11 sdm 8:192 active undef running
|- 15:0:3:11 sdbf 67:144 active undef running
|- 16:0:0:11 sdau 66:224 active undef running
`- 16:0:1:11 sdcp 69:208 active undef running
ORAorabak3 (36000144000000010f0234e982ca6000d) dm-3 EMC ,Invista
size=1.0T features='1 queue_if_no_path' hwhandler='0' wp=rw
`-+- policy='service-time 0' prio=0 status=active
|- 15:0:0:4 sdf 8:80 active undef running
|- 15:0:3:4 sdap 66:144 active undef running
|- 16:0:0:4 sdag 66:0 active undef running
`- 16:0:1:4 sdcf 69:48 active undef running
ORAData003 (36000144000000010f0234e982ca60007) dm-13 EMC ,Invista
size=900G features='1 queue_if_no_path' hwhandler='0' wp=rw
`-+- policy='service-time 0' prio=0 status=active
|- 15:0:0:10 sdl 8:176 active undef running
|- 15:0:3:10 sdbd 67:112 active undef running
|- 16:0:0:10 sdas 66:192 active undef running
`- 16:0:1:10 sdco 69:192 active undef running
ORAData002 (36000144000000010f0234e982ca60009) dm-22 EMC ,Invista
size=900G features='1 queue_if_no_path' hwhandler='0' wp=rw
`-+- policy='service-time 0' prio=0 status=active
|- 15:0:0:9 sdk 8:160 active undef running
|- 15:0:3:9 sdbc 67:96 active undef running
|- 16:0:0:9 sdaq 66:160 active undef running
`- 16:0:1:9 sdcn 69:176 active undef running
ORAorabak2 (36000144000000010f0234e982ca60008) dm-12 EMC ,Invista
size=1.0T features='1 queue_if_no_path' hwhandler='0' wp=rw
`-+- policy='service-time 0' prio=0 status=active
|- 15:0:0:3 sde 8:64 active undef running
|- 15:0:3:3 sdao 66:128 active undef running
|- 16:0:0:3 sdaf 65:240 active undef running
`- 16:0:1:3 sdcd 69:16 active undef running
ORAData001 (36000144000000010f0234e982ca6000e) dm-31 EMC ,Invista
size=900G features='1 queue_if_no_path' hwhandler='0' wp=rw
`-+- policy='service-time 0' prio=0 status=active
|- 15:0:0:8 sdj 8:144 active undef running
|- 15:0:3:8 sdaz 67:48 active undef running
|- 16:0:0:8 sdan 66:112 active undef running
`- 16:0:1:8 sdcl 69:144 active undef running
ORAorabak1 (36000144000000010f0234e982ca60003) dm-11 EMC ,Invista
size=1.0T features='1 queue_if_no_path' hwhandler='0' wp=rw
`-+- policy='service-time 0' prio=0 status=active
|- 15:0:0:2 sdd 8:48 active undef running
|- 15:0:3:2 sdal 66:80 active undef running
|- 16:0:0:2 sdad 65:208 active undef running
`- 16:0:1:2 sdcb 68:240 active undef running
ORAData014 (36000144000000010f0234e982ca60002) dm-14 EMC ,Invista
size=900G features='1 queue_if_no_path' hwhandler='0' wp=rw
`-+- policy='service-time 0' prio=0 status=active
|- 15:0:0:21 sdw 65:96 active undef running
|- 15:0:3:21 sdca 68:224 active undef running
|- 16:0:0:21 sdbl 67:240 active undef running
`- 16:0:1:21 sdcz 70:112 active undef running
ORAData013 (36000144000000010f0234e982ca6000a) dm-9 EMC ,Invista
size=900G features='1 queue_if_no_path' hwhandler='0' wp=rw
`-+- policy='service-time 0' prio=0 status=active
|- 15:0:0:20 sdv 65:80 active undef running
|- 15:0:3:20 sdby 68:192 active undef running
|- 16:0:0:20 sdbj 67:208 active undef running
`- 16:0:1:20 sdcy 70:96 active undef running
ORAData012 (36000144000000010f0234e982ca60001) dm-18 EMC ,Invista
size=900G features='1 queue_if_no_path' hwhandler='0' wp=rw
`-+- policy='service-time 0' prio=0 status=active
|- 15:0:0:19 sdu 65:64 active undef running
|- 15:0:3:19 sdbw 68:160 active undef running
|- 16:0:0:19 sdbi 67:192 active undef running
`- 16:0:1:19 sdcx 70:80 active undef running
......以下省略.....
ORA
[root@ORARAC1 oracle]#
查看OS用户
[root@ORARAC1 oracle]# cat /etc/passwd
root:x:0:0:root:/root:/bin/bash
bin:x:1:1:bin:/bin:/sbin/nologin
daemon:x:2:2:daemon:/sbin:/sbin/nologin
adm:x:3:4:adm:/var/adm:/sbin/nologin
lp:x:4:7:lp:/var/spool/lpd:/sbin/nologin
sync:x:5:0:sync:/sbin:/bin/sync
shutdown:x:6:0:shutdown:/sbin:/sbin/shutdown
halt:x:7:0:halt:/sbin:/sbin/halt
mail:x:8:12:mail:/var/spool/mail:/sbin/nologin
operator:x:11:0:operator:/root:/sbin/nologin
games:x:12:100:games:/usr/games:/sbin/nologin
ftp:x:14:50:FTP User:/var/ftp:/sbin/nologin
nobody:x:99:99:Nobody:/:/sbin/nologin
systemd-network:x:192:192:systemd Network Management:/:/sbin/nologin
dbus:x:81:81:System message bus:/:/sbin/nologin
polkitd:x:999:998:User for polkitd:/:/sbin/nologin
libstoragemgmt:x:998:995:daemon account for libstoragemgmt:/var/run/lsm:/sbin/nologin
colord:x:997:994:User for colord:/var/lib/colord:/sbin/nologin
rpc:x:32:32:Rpcbind Daemon:/var/lib/rpcbind:/sbin/nologin
saned:x:996:993:SANE scanner daemon user:/usr/share/sane:/sbin/nologin
gluster:x:995:992:GlusterFS daemons:/run/gluster:/sbin/nologin
saslauth:x:994:76:Saslauthd user:/run/saslauthd:/sbin/nologin
abrt:x:173:173::/etc/abrt:/sbin/nologin
setroubleshoot:x:993:990::/var/lib/setroubleshoot:/sbin/nologin
rtkit:x:172:172:RealtimeKit:/proc:/sbin/nologin
pulse:x:171:171:PulseAudio System Daemon:/var/run/pulse:/sbin/nologin
radvd:x:75:75:radvd user:/:/sbin/nologin
chrony:x:992:987::/var/lib/chrony:/sbin/nologin
unbound:x:991:986:Unbound DNS resolver:/etc/unbound:/sbin/nologin
qemu:x:107:107:qemu user:/:/sbin/nologin
tss:x:59:59:Account used by the trousers package to sandbox the tcsd daemon:/dev/null:/sbin/nologin
sssd:x:990:984:User for sssd:/:/sbin/nologin
usbmuxd:x:113:113:usbmuxd user:/:/sbin/nologin
geoclue:x:989:983:User for geoclue:/var/lib/geoclue:/sbin/nologin
ntp:x:38:38::/etc/ntp:/sbin/nologin
gdm:x:42:42::/var/lib/gdm:/sbin/nologin
rpcuser:x:29:29:RPC Service User:/var/lib/nfs:/sbin/nologin
nfsnobody:x:65534:65534:Anonymous NFS User:/var/lib/nfs:/sbin/nologin
gnome-initial-setup:x:988:982::/run/gnome-initial-setup/:/sbin/nologin
sshd:x:74:74:Privilege-separated SSH:/var/empty/sshd:/sbin/nologin
avahi:x:70:70:Avahi mDNS/DNS-SD Stack:/var/run/avahi-daemon:/sbin/nologin
postfix:x:89:89::/var/spool/postfix:/sbin/nologin
tcpdump:x:72:72::/:/sbin/nologin
oracle:x:502:501:oracle:/home/oracle:/bin/bash
grid:x:501:501::/home/grid:/bin/bash
