Bo's Oracle Station

查看: 1773|回复: 0

第6-10单:2015-09-19到2015-09-20双休日Section0当时的评分输出

[复制链接]

75

主题

115

帖子

2688

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
2688
发表于 2015-9-26 16:41:42 | 显示全部楼层 |阅读模式
第1-5单时我的输出:
Section0:


  1. ----------------------------------------------------------------------------------------------------
  2. ----------------------------------------------------------------------------------------------------
  3. ----------------------------------------------------------------------------------------------------
  4. ******************** Section0 ********************
  5. ----------------------------------------------------------------------------------------------------
  6. ----------------------------------------------------------------------------------------------------
  7. ----------------------------------------------------------------------------------------------------


  8. ******************** TOPIC 1 ********************
  9. export ORACLE_SID=PROD
  10. .bash_profile OK



  11. # .bash_profile

  12. # Get the aliases and functions
  13. if [ -f ~/.bashrc ]; then
  14.         . ~/.bashrc
  15. fi

  16. # User specific environment and startup programs

  17. PATH=$PATH:$HOME/bin

  18. export PATH
  19. export ORACLE_BASE=/u01/app/oracle
  20. export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
  21. export ORACLE_SID=PROD
  22. export PATH=$ORACLE_HOME/bin:$PATH
  23. export LANG=en_US

  24. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:26 2015

  25. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  26. SQL> Connected.
  27. SQL> SQL>
  28. NAME                                     TYPE         VALUE
  29. ------------------------------------ ----------- ------------------------------
  30. db_name                              string         PROD
  31. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  32. With the Partitioning, OLAP and Data Mining options


  33. R100001=1


  34. A: db_name                              string         PROD

  35. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:26 2015

  36. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  37. SQL> Connected.
  38. SQL> SQL>
  39. NAME                                     TYPE         VALUE
  40. ------------------------------------ ----------- ------------------------------
  41. instance_name                             string         PROD
  42. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  43. With the Partitioning, OLAP and Data Mining options


  44. R100002=19


  45. A: instance_name                             string         PROD


  46. ******************** TOPIC 2 ********************


  47. ******************** TOPIC 2.1 ********************

  48. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:26 2015

  49. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  50. SQL> Connected.
  51. SQL> SQL> SQL> SQL> SQL> SQL> ****************************
  52. SQL> The database open mode here:
  53. SQL> ****************************
  54. SQL> SQL>
  55. D
  56. -
  57. X
  58. SQL>
  59. OPEN_MODE
  60. ----------
  61. READ WRITE
  62. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  63. With the Partitioning, OLAP and Data Mining options


  64. R200101=10


  65. A: READ WRITE

  66. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:27 2015

  67. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  68. SQL> Connected.
  69. SQL> SQL> SQL> SQL> SQL> SQL> ****************************
  70. SQL> The database archivelog mode here:
  71. SQL> **********************************
  72. SQL> SQL> Database log mode               Archive Mode
  73. Automatic archival               Enabled
  74. Archive destination               USE_DB_RECOVERY_FILE_DEST
  75. Oldest online log sequence     3
  76. Next log sequence to archive   5
  77. Current log sequence               5
  78. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  79. With the Partitioning, OLAP and Data Mining options


  80. R200102=0


  81. A: SQL> SQL> Database log mode               Archive Mode

  82. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:27 2015

  83. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  84. SQL> Connected.
  85. SQL> SQL> SQL> SQL> SQL> SQL> ****************************
  86. SQL> The database controlfile here:
  87. SQL> ******************************
  88. SQL> SQL> SQL>
  89. NAME
  90. -----------------------------------------------------------------
  91. /u01/app/oracle/oradata/PROD/Disk1/control01.ctl
  92. /u01/app/oracle/oradata/PROD/Disk2/control02.ctl
  93. /u01/app/oracle/product/10.2.0/db_1/dbs/and
  94. /u01/app/oracle/oradata/PROD/Disk3/control03.ctl
  95. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  96. With the Partitioning, OLAP and Data Mining options


  97. R200103=5


  98. A: /u01/app/oracle/oradata/PROD/Disk1/control01.ctl

  99. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:27 2015

  100. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  101. SQL> Connected.
  102. SQL> SQL> SQL> SQL> SQL> SQL> ****************************
  103. SQL> The database controlfile here:
  104. SQL> ******************************
  105. SQL> SQL> SQL>
  106. NAME
  107. -----------------------------------------------------------------
  108. /u01/app/oracle/oradata/PROD/Disk1/control01.ctl
  109. /u01/app/oracle/oradata/PROD/Disk2/control02.ctl
  110. /u01/app/oracle/product/10.2.0/db_1/dbs/and
  111. /u01/app/oracle/oradata/PROD/Disk3/control03.ctl
  112. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  113. With the Partitioning, OLAP and Data Mining options


  114. R200104=5


  115. A: /u01/app/oracle/oradata/PROD/Disk2/control02.ctl

  116. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:27 2015

  117. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  118. SQL> Connected.
  119. SQL> SQL> SQL> SQL> SQL> SQL> ****************************
  120. SQL> The database controlfile here:
  121. SQL> ******************************
  122. SQL> SQL> SQL>
  123. NAME
  124. -----------------------------------------------------------------
  125. /u01/app/oracle/oradata/PROD/Disk1/control01.ctl
  126. /u01/app/oracle/oradata/PROD/Disk2/control02.ctl
  127. /u01/app/oracle/product/10.2.0/db_1/dbs/and
  128. /u01/app/oracle/oradata/PROD/Disk3/control03.ctl
  129. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  130. With the Partitioning, OLAP and Data Mining options


  131. R200105=5


  132. A: /u01/app/oracle/oradata/PROD/Disk3/control03.ctl


  133. ******************** TOPIC 2.2 ********************

  134. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:27 2015

  135. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  136. SQL> Connected.
  137. SQL> SQL> SQL> SQL> SQL> SQL> ***************************
  138. SQL> The database datafile here:
  139. SQL> ***************************
  140. SQL> SQL> SQL> SQL> SQL>
  141. TABLESPACE_NAME                STATUS
  142. ------------------------------ ---------------
  143. SYSTEM                               ONLINE
  144. SQL>
  145. FILE_NAME                                                          STATUS
  146. ----------------------------------------------------------------- ---------------
  147. /u01/app/oracle/oradata/PROD/Disk1/system01.dbf                   AVAILABLE
  148. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  149. With the Partitioning, OLAP and Data Mining options


  150. R200201=4


  151. A: /u01/app/oracle/oradata/PROD/Disk1/system01.dbf                   AVAILABLE

  152. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:27 2015

  153. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  154. SQL> Connected.
  155. SQL> SQL> SQL> SQL> SQL> SQL> ***************************
  156. SQL> The database datafile here:
  157. SQL> ***************************
  158. SQL> SQL> SQL> SQL> SQL>
  159. TABLESPACE_NAME                STATUS
  160. ------------------------------ ---------------
  161. SYSTEM                               ONLINE
  162. SQL>
  163. FILE_NAME                                                          STATUS
  164. ----------------------------------------------------------------- ---------------
  165. /u01/app/oracle/oradata/PROD/Disk1/system01.dbf                   AVAILABLE
  166. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  167. With the Partitioning, OLAP and Data Mining options


  168. R200202=1


  169. A: SYSTEM                               ONLINE


  170. ******************** TOPIC 2.3 ********************

  171. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:28 2015

  172. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  173. SQL> Connected.
  174. SQL> SQL> SQL> SQL> SQL> SQL> ***************************
  175. SQL> The database datafile here:
  176. SQL> ***************************
  177. SQL> SQL> SQL> SQL> SQL>
  178. TABLESPACE_NAME                STATUS
  179. ------------------------------ ---------------
  180. SYSAUX                               ONLINE
  181. SQL>
  182. FILE_NAME                                                          STATUS
  183. ----------------------------------------------------------------- ---------------
  184. /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf                   AVAILABLE
  185. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  186. With the Partitioning, OLAP and Data Mining options


  187. R200301=4


  188. A: /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf                   AVAILABLE

  189. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:28 2015

  190. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  191. SQL> Connected.
  192. SQL> SQL> SQL> SQL> SQL> SQL> ***************************
  193. SQL> The database datafile here:
  194. SQL> ***************************
  195. SQL> SQL> SQL> SQL> SQL>
  196. TABLESPACE_NAME                STATUS
  197. ------------------------------ ---------------
  198. SYSAUX                               ONLINE
  199. SQL>
  200. FILE_NAME                                                          STATUS
  201. ----------------------------------------------------------------- ---------------
  202. /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf                   AVAILABLE
  203. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  204. With the Partitioning, OLAP and Data Mining options


  205. R200302=1


  206. A: SYSAUX                               ONLINE


  207. ******************** TOPIC 2.4 ********************

  208. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:28 2015

  209. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  210. SQL> Connected.
  211. SQL> SQL> SQL> SQL> SQL> SQL> ***************************
  212. SQL> The database datafile here:
  213. SQL> ***************************
  214. SQL> SQL> SQL> SQL> SQL> SQL> SQL>
  215. TABLESPACE_NAME                STATUS
  216. ------------------------------ ---------------
  217. UNDOTBS1                       ONLINE
  218. SQL>
  219. FILE_NAME                                                          STATUS
  220. ----------------------------------------------------------------- ---------------
  221. /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf                   AVAILABLE
  222. SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  223. With the Partitioning, OLAP and Data Mining options


  224. R200401=4


  225. A: /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf                   AVAILABLE

  226. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:28 2015

  227. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  228. SQL> Connected.
  229. SQL> SQL> SQL> SQL> SQL> SQL> ***************************
  230. SQL> The database datafile here:
  231. SQL> ***************************
  232. SQL> SQL> SQL> SQL> SQL> SQL> SQL>
  233. TABLESPACE_NAME                STATUS
  234. ------------------------------ ---------------
  235. UNDOTBS1                       ONLINE
  236. SQL>
  237. FILE_NAME                                                          STATUS
  238. ----------------------------------------------------------------- ---------------
  239. /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf                   AVAILABLE
  240. SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  241. With the Partitioning, OLAP and Data Mining options


  242. R200402=1


  243. A: UNDOTBS1                       ONLINE


  244. ******************** TOPIC 2.5 ********************

  245. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:28 2015

  246. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  247. SQL> Connected.
  248. SQL> SQL> SQL> SQL> SQL> SQL> **************************
  249. SQL> The database tempfile here:
  250. SQL> **************************
  251. SQL> SQL> SQL>
  252. NAME
  253. --------------------------------------------------------------------------------
  254. /u01/app/oracle/oradata/PROD/Disk5/temp01.dbf
  255. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  256. With the Partitioning, OLAP and Data Mining options


  257. R200500=3


  258. A: /u01/app/oracle/oradata/PROD/Disk5/temp01.dbf


  259. ******************** TOPIC 2.6 ********************

  260. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:29 2015

  261. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  262. SQL> Connected.
  263. SQL> SQL> SQL> SQL> SQL> SQL> **************************
  264. SQL> The database logfile here:
  265. SQL> **************************
  266. SQL> SQL> SQL>
  267. MEMBER
  268. --------------------------------------------------------------------------------
  269. /u01/app/oracle/oradata/PROD/Disk1/redo01a.log
  270. /u01/app/oracle/oradata/PROD/Disk2/redo02a.log
  271. /u01/app/oracle/oradata/PROD/Disk3/redo03a.log
  272. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  273. With the Partitioning, OLAP and Data Mining options


  274. R200601=3


  275. A: /u01/app/oracle/oradata/PROD/Disk1/redo01a.log

  276. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:29 2015

  277. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  278. SQL> Connected.
  279. SQL> SQL> SQL> SQL> SQL> SQL> **************************
  280. SQL> The database logfile here:
  281. SQL> **************************
  282. SQL> SQL> SQL>
  283. MEMBER
  284. --------------------------------------------------------------------------------
  285. /u01/app/oracle/oradata/PROD/Disk1/redo01a.log
  286. /u01/app/oracle/oradata/PROD/Disk2/redo02a.log
  287. /u01/app/oracle/oradata/PROD/Disk3/redo03a.log
  288. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  289. With the Partitioning, OLAP and Data Mining options


  290. R200602=3


  291. A: /u01/app/oracle/oradata/PROD/Disk2/redo02a.log

  292. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:29 2015

  293. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  294. SQL> Connected.
  295. SQL> SQL> SQL> SQL> SQL> SQL> **************************
  296. SQL> The database logfile here:
  297. SQL> **************************
  298. SQL> SQL> SQL>
  299. MEMBER
  300. --------------------------------------------------------------------------------
  301. /u01/app/oracle/oradata/PROD/Disk1/redo01a.log
  302. /u01/app/oracle/oradata/PROD/Disk2/redo02a.log
  303. /u01/app/oracle/oradata/PROD/Disk3/redo03a.log
  304. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  305. With the Partitioning, OLAP and Data Mining options


  306. R200603=3


  307. A: /u01/app/oracle/oradata/PROD/Disk3/redo03a.log


  308. ******************** TOPIC 3 ********************

  309. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:29 2015

  310. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  311. SQL> Connected.
  312. SQL> SQL>
  313. USERNAME
  314. ------------------------------
  315. DBSNMP

  316. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  317. With the Partitioning, OLAP and Data Mining options


  318. R300000=15


  319. A: DBSNMP


  320. ******************** TOPIC 4 ********************

  321. SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:29 2015

  322. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

  323. SQL> Connected.
  324. SQL> SQL> SQL> SQL>
  325. AUT
  326. ---
  327. YES
  328. YES
  329. YES
  330. YES

  331. SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
  332. With the Partitioning, OLAP and Data Mining options


  333. R400000=13


  334. A: 0
  335. ****************************************************************************************************


  336. R100001: 1 full is 1 1
  337. R100002: 19 full is 19 20
  338. R200101: 10 full is 10 30
  339. R200102: 0 full is 0 30
  340. R200103: 5 full is 5 35
  341. R200104: 5 full is 5 40
  342. R200105: 5 full is 5 45
  343. R200201: 4 full is 4 49
  344. R200202: 1 full is 1 50
  345. R200301: 4 full is 4 54
  346. R200302: 1 full is 1 55
  347. R200401: 4 full is 4 59
  348. R200402: 1 full is 1 60
  349. R200500: 3 full is 3 63
  350. R200601: 3 full is 3 66
  351. R200602: 3 full is 3 69
  352. R200603: 3 full is 3 72
  353. R300000: 15 full is 15 87
  354. R400000: 13 full is 13 100
  355. full of this section:
  356. RESULT:
  357. 100


  358. ****************************************************************************************************
复制代码



Section0.zip

11.42 KB, 下载次数: 921

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 02:10 , Processed in 0.046530 second(s), 27 queries .

快速回复 返回顶部 返回列表