课程第24次（2016-12-16星期五）

botang · 发表于 2016-12-17 10:26:39

磁带机查异步IO：

SQL> select device_type, type , bytes from v$backup_async_io;
DEVICE_TYPE TYPE BYTES
----------------- --------- ----------
DISK AGGREGATE 9830400
DISK INPUT 9830400
DISK OUTPUT 9912320
DISK AGGREGATE 234872832
DISK INPUT 234872832
SBT_TAPE OUTPUT 176685056
SBT_TAPE OUTPUT 0
DISK AGGREGATE 12066816
DISK INPUT 12066816
SBT_TAPE OUTPUT 12320768
DISK AGGREGATE 83369984
DEVICE_TYPE TYPE BYTES
----------------- --------- ----------
DISK INPUT 83369984
SBT_TAPE OUTPUT 73138176
DISK AGGREGATE 5242880
DISK INPUT 5242880
SBT_TAPE OUTPUT 3670016
SBT_TAPE OUTPUT 0
DISK AGGREGATE 710942720
DISK INPUT 710942720
SBT_TAPE OUTPUT 621019136
DISK AGGREGATE 547889152
DISK INPUT 547889152
DEVICE_TYPE TYPE BYTES
----------------- --------- ----------
SBT_TAPE OUTPUT 435421184
DISK AGGREGATE 15212544
DISK INPUT 15212544
SBT_TAPE OUTPUT 15466496
DISK AGGREGATE 83369984
DISK INPUT 83369984
SBT_TAPE OUTPUT 73138176
DISK AGGREGATE 5242880
DISK INPUT 5242880
SBT_TAPE OUTPUT 3670016
32 rows selected.

复制代码

查看表空间什么时候删除的：

adrci> show alert -p "message_text like '%drop tablespace users%'"
Choose the alert log from the following homes to view:
1: diag/rdbms/orcl/orcl
2: diag/rdbms/rcat/rcat
3: diag/asm/+asm/+ASM
4: diag/tnslsnr/station90/listener
Q: to quit
Please select option: 1
Output the results to file: /tmp/alert_3749_14019_orcl_1.ado
Please select option:

复制代码

闪回到删除表空间前，数据文件的现象：

/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00004

复制代码

obtool的常用命令：

ob> lsjob
Job ID Sched time Contents State
---------------- ----------- ------------------------------ ---------------------------------------
oracle/121 none database orcl (dbid=1343950367) processed; Oracle job(s) scheduled
oracle/121.7 none datafile backup running since 2016/12/16.21:40
oracle/121.8 none datafile backup running since 2016/12/16.21:40
oracle/121.9 none datafile backup pending resource availability
oracle/121.10 none datafile backup pending resource availability
oracle/121.11 none datafile backup pending resource availability
ob> lsvol -L lib01 -l
Inventory of library lib01:
in 1: vacant
in 2: vacant
in 3: barcode E01003L4, oid 215, 0 kb remaining
in 4: barcode E01004L4, oid 217, 0 kb remaining
in 5: barcode E01005L4, oid 104
in 6: barcode E01006L4, oid 105
in 7: barcode E01007L4, oid 106
in 8: barcode E01008L4, oid 107
in 9: barcode E01009L4, oid 108
in 10: barcode E01010L4, oid 109
in 11: barcode E01011L4, oid 110
in 12: barcode E01012L4, oid 111
in 13: barcode E01013L4, oid 112
in 14: barcode E01014L4, oid 113
in 15: barcode E01015L4, oid 114
in 16: barcode E01016L4, oid 115
in 17: barcode E01017L4, oid 116
in 18: barcode E01018L4, oid 117
in 19: barcode E01019L4, oid 118
in 20: barcode E01020L4, oid 119
in 21: vacant
in 22: barcode CLN101L4, oid 120
in 23: barcode CLN102L5, oid 121
in 24: vacant
in 25: vacant
in 26: vacant
in 27: vacant
in 28: vacant
in 29: vacant
in 30: barcode F01030L5, oid 122
in 31: barcode F01031L5, oid 123
in 32: barcode F01032L5, oid 124
in 33: barcode F01033L5, oid 125
in 34: barcode F01034L5, oid 126
in 35: barcode F01035L5, oid 127
in 36: barcode F01036L5, oid 128
in 37: barcode F01037L5, oid 129
in 38: barcode F01038L5, oid 130
in 39: barcode F01039L5, oid 131
in iee1: vacant
in iee2: vacant
in iee3: vacant
in iee4: vacant
in dte1: vacant
in dte2: vacant
in dte3: volume station90-000010, barcode E01002L4, oid 219, 5927936 kb remaining, content manages reuse, lastse 2
in dte4: volume station90-000009, barcode E01001L4, oid 218, 7442432 kb remaining, content manages reuse, lastse 1
ob> lsjob
Job ID Sched time Contents State
---------------- ----------- ------------------------------ ---------------------------------------
oracle/122 none database orcl (dbid=1343950367) processed; Oracle job(s) scheduled
oracle/122.1 none controlfile autobackup running since 2016/12/16.21:42
ob> lsjob
Job ID Sched time Contents State
---------------- ----------- ------------------------------ ---------------------------------------
oracle/122 none database orcl (dbid=1343950367) processed; Oracle job(s) scheduled
oracle/122.1 none controlfile autobackup running since 2016/12/16.21:42
ob> lspiece
POID Database Content Copy Created Host Piece name
229 orcl archivelog 0 2013/10/20 station90 01omt44q_1_1
230 orcl incremental 0 2013/10/20 station90 05omt45l_1_1
231 orcl incremental 0 2013/10/20 station90 02omt45k_1_1
232 orcl incremental 0 2013/10/20 station90 06omt45l_1_1
233 orcl incremental 0 2013/10/20 station90 03omt45k_1_1
234 orcl incremental 0 2013/10/20 station90 04omt45k_1_1
235 orcl archivelog 0 2013/10/20 station90 07omt48b_1_1
236 orcl autobackup 0 2013/10/20 station90 c-1343950367-20131020-00
237 orcl archivelog 0 2013/10/20 station90 09omt4bk_1_1
238 orcl incremental 0 2013/10/20 station90 0aomt4ce_1_1
239 orcl incremental 0 2013/10/20 station90 0comt4ce_1_1
240 orcl incremental 0 2013/10/20 station90 0eomt4ce_1_1
241 orcl incremental 0 2013/10/20 station90 0domt4ce_1_1
242 orcl incremental 0 2013/10/20 station90 0bomt4ce_1_1
243 orcl archivelog 0 2013/10/20 station90 0fomt4eg_1_1
244 orcl autobackup 0 2013/10/20 station90 c-1343950367-20131020-01
245 orcl archivelog 0 2013/10/20 station90 0homt4ha_1_1
246 orcl incremental 0 2013/10/20 station90 0iomt4hq_1_1
247 orcl incremental 0 2013/10/20 station90 0jomt4hq_1_1
248 orcl incremental 0 2013/10/20 station90 0lomt4hq_1_1
249 orcl incremental 0 2013/10/20 station90 0komt4hq_1_1
250 orcl incremental 0 2013/10/20 station90 0momt4hr_1_1
251 orcl archivelog 0 2013/10/20 station90 0nomt4ji_1_1
252 orcl autobackup 0 2013/10/20 station90 c-1343950367-20131020-02
253 orcl archivelog 0 12/12.16:03 station90 0prn9uf2_1_1
254 orcl archivelog 0 12/12.16:03 station90 0qrn9uf3_1_1
255 orcl archivelog 0 12/12.16:12 station90 0prn9uun_1_1
256 orcl archivelog 0 12/12.16:12 station90 0qrn9uun_1_1
257 orcl full 0 12/12.16:12 station90 0vrn9uvi_1_1
258 orcl full 0 12/12.16:12 station90 0rrn9uvh_1_1
259 orcl full 0 12/12.16:13 station90 0trn9uvh_1_1
260 orcl full 0 12/12.16:13 station90 0srn9uvh_1_1
261 orcl full 0 12/12.16:14 station90 0urn9uvi_1_1
262 orcl autobackup 0 12/12.16:14 station90 c-1343950367-20161212-00
263 orcl full 0 12/16.19:26 station90 17rnkrqb_1_1
264 orcl full 0 12/16.19:26 station90 15rnkrqb_1_1
265 orcl full 0 12/16.19:27 station90 16rnkrqb_1_1
266 orcl full 0 12/16.19:26 station90 18rnkrqb_1_1
267 orcl full 0 12/16.19:27 station90 19rnkrqb_1_1
268 orcl autobackup 0 12/16.19:28 station90 c-1343950367-20161216-00
269 orcl full 0 12/16.20:38 station90 1brnl016_1_1
270 orcl full 0 12/16.20:46 station90 1drnl0gi_1_1
271 orcl autobackup 0 12/16.20:47 station90 c-1343950367-20161216-02
272 orcl full 0 12/16.21:38 station90 1mrnl3ff_1_1
273 orcl full 0 12/16.21:39 station90 1nrnl3ff_1_1
274 orcl full 0 12/16.21:40 station90 1srnl3kl_1_1
275 orcl full 0 12/16.21:40 station90 1prnl3kl_1_1
276 orcl full 0 12/16.21:40 station90 1rrnl3kl_1_1
277 orcl full 0 12/16.21:41 station90 1qrnl3kl_1_1
278 orcl full 0 12/16.21:41 station90 1trnl3km_1_1
279 orcl autobackup 0 12/16.21:42 station90 c-1343950367-20161216-06

复制代码

化身的查看：

[oracle@station90 ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Dec 16 22:12:45 2016
connected to target database: ORCL (DBID=1343950367)
RMAN> list incarnation of database;
using target database control file instead of recovery catalog
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ORCL 1343950367 PARENT 1 15-AUG-09
2 2 ORCL 1343950367 PARENT 945184 23-MAY-13
3 3 ORCL 1343950367 ORPHAN 1081654 14-DEC-16
4 4 ORCL 1343950367 ORPHAN 1081654 14-DEC-16
5 5 ORCL 1343950367 PARENT 1081658 14-DEC-16
6 6 ORCL 1343950367 PARENT 1188230 16-DEC-16
7 7 ORCL 1343950367 ORPHAN 1188232 16-DEC-16
8 8 ORCL 1343950367 PARENT 1188232 16-DEC-16
9 9 ORCL 1343950367 CURRENT 1201233 16-DEC-16

复制代码

bcpserver上，做练习的IP列表：

/tmp/botang-config-xshare/course/general/v_botang_all_ipsshd_open

复制代码