|
第1-5单时我的输出:
Section0:
- ----------------------------------------------------------------------------------------------------
- ----------------------------------------------------------------------------------------------------
- ----------------------------------------------------------------------------------------------------
- ******************** Section0 ********************
- ----------------------------------------------------------------------------------------------------
- ----------------------------------------------------------------------------------------------------
- ----------------------------------------------------------------------------------------------------
- ******************** TOPIC 1 ********************
- export ORACLE_SID=PROD
- .bash_profile OK
- # .bash_profile
- # Get the aliases and functions
- if [ -f ~/.bashrc ]; then
- . ~/.bashrc
- fi
- # User specific environment and startup programs
- PATH=$PATH:$HOME/bin
- export PATH
- export ORACLE_BASE=/u01/app/oracle
- export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
- export ORACLE_SID=PROD
- export PATH=$ORACLE_HOME/bin:$PATH
- export LANG=en_US
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:26 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL>
- NAME TYPE VALUE
- ------------------------------------ ----------- ------------------------------
- db_name string PROD
- 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
- With the Partitioning, OLAP and Data Mining options
- R100001=1
- A: db_name string PROD
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:26 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL>
- NAME TYPE VALUE
- ------------------------------------ ----------- ------------------------------
- instance_name string PROD
- 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
- With the Partitioning, OLAP and Data Mining options
- R100002=19
- A: instance_name string PROD
- ******************** TOPIC 2 ********************
- ******************** TOPIC 2.1 ********************
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:26 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> ****************************
- SQL> The database open mode here:
- SQL> ****************************
- SQL> SQL>
- D
- -
- X
- SQL>
- OPEN_MODE
- ----------
- READ WRITE
- 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
- With the Partitioning, OLAP and Data Mining options
- R200101=10
- A: READ WRITE
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:27 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> ****************************
- SQL> The database archivelog mode here:
- SQL> **********************************
- SQL> SQL> Database log mode Archive Mode
- Automatic archival Enabled
- Archive destination USE_DB_RECOVERY_FILE_DEST
- Oldest online log sequence 3
- Next log sequence to archive 5
- Current log sequence 5
- 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
- With the Partitioning, OLAP and Data Mining options
- R200102=0
- A: SQL> SQL> Database log mode Archive Mode
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:27 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> ****************************
- SQL> The database controlfile here:
- SQL> ******************************
- SQL> SQL> SQL>
- NAME
- -----------------------------------------------------------------
- /u01/app/oracle/oradata/PROD/Disk1/control01.ctl
- /u01/app/oracle/oradata/PROD/Disk2/control02.ctl
- /u01/app/oracle/product/10.2.0/db_1/dbs/and
- /u01/app/oracle/oradata/PROD/Disk3/control03.ctl
- 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
- With the Partitioning, OLAP and Data Mining options
- R200103=5
- A: /u01/app/oracle/oradata/PROD/Disk1/control01.ctl
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:27 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> ****************************
- SQL> The database controlfile here:
- SQL> ******************************
- SQL> SQL> SQL>
- NAME
- -----------------------------------------------------------------
- /u01/app/oracle/oradata/PROD/Disk1/control01.ctl
- /u01/app/oracle/oradata/PROD/Disk2/control02.ctl
- /u01/app/oracle/product/10.2.0/db_1/dbs/and
- /u01/app/oracle/oradata/PROD/Disk3/control03.ctl
- 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
- With the Partitioning, OLAP and Data Mining options
- R200104=5
- A: /u01/app/oracle/oradata/PROD/Disk2/control02.ctl
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:27 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> ****************************
- SQL> The database controlfile here:
- SQL> ******************************
- SQL> SQL> SQL>
- NAME
- -----------------------------------------------------------------
- /u01/app/oracle/oradata/PROD/Disk1/control01.ctl
- /u01/app/oracle/oradata/PROD/Disk2/control02.ctl
- /u01/app/oracle/product/10.2.0/db_1/dbs/and
- /u01/app/oracle/oradata/PROD/Disk3/control03.ctl
- 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
- With the Partitioning, OLAP and Data Mining options
- R200105=5
- A: /u01/app/oracle/oradata/PROD/Disk3/control03.ctl
- ******************** TOPIC 2.2 ********************
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:27 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> ***************************
- SQL> The database datafile here:
- SQL> ***************************
- SQL> SQL> SQL> SQL> SQL>
- TABLESPACE_NAME STATUS
- ------------------------------ ---------------
- SYSTEM ONLINE
- SQL>
- FILE_NAME STATUS
- ----------------------------------------------------------------- ---------------
- /u01/app/oracle/oradata/PROD/Disk1/system01.dbf AVAILABLE
- SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
- With the Partitioning, OLAP and Data Mining options
- R200201=4
- A: /u01/app/oracle/oradata/PROD/Disk1/system01.dbf AVAILABLE
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:27 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> ***************************
- SQL> The database datafile here:
- SQL> ***************************
- SQL> SQL> SQL> SQL> SQL>
- TABLESPACE_NAME STATUS
- ------------------------------ ---------------
- SYSTEM ONLINE
- SQL>
- FILE_NAME STATUS
- ----------------------------------------------------------------- ---------------
- /u01/app/oracle/oradata/PROD/Disk1/system01.dbf AVAILABLE
- SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
- With the Partitioning, OLAP and Data Mining options
- R200202=1
- A: SYSTEM ONLINE
- ******************** TOPIC 2.3 ********************
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:28 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> ***************************
- SQL> The database datafile here:
- SQL> ***************************
- SQL> SQL> SQL> SQL> SQL>
- TABLESPACE_NAME STATUS
- ------------------------------ ---------------
- SYSAUX ONLINE
- SQL>
- FILE_NAME STATUS
- ----------------------------------------------------------------- ---------------
- /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf AVAILABLE
- SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
- With the Partitioning, OLAP and Data Mining options
- R200301=4
- A: /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf AVAILABLE
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:28 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> ***************************
- SQL> The database datafile here:
- SQL> ***************************
- SQL> SQL> SQL> SQL> SQL>
- TABLESPACE_NAME STATUS
- ------------------------------ ---------------
- SYSAUX ONLINE
- SQL>
- FILE_NAME STATUS
- ----------------------------------------------------------------- ---------------
- /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf AVAILABLE
- SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
- With the Partitioning, OLAP and Data Mining options
- R200302=1
- A: SYSAUX ONLINE
- ******************** TOPIC 2.4 ********************
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:28 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> ***************************
- SQL> The database datafile here:
- SQL> ***************************
- SQL> SQL> SQL> SQL> SQL> SQL> SQL>
- TABLESPACE_NAME STATUS
- ------------------------------ ---------------
- UNDOTBS1 ONLINE
- SQL>
- FILE_NAME STATUS
- ----------------------------------------------------------------- ---------------
- /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf AVAILABLE
- SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
- With the Partitioning, OLAP and Data Mining options
- R200401=4
- A: /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf AVAILABLE
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:28 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> ***************************
- SQL> The database datafile here:
- SQL> ***************************
- SQL> SQL> SQL> SQL> SQL> SQL> SQL>
- TABLESPACE_NAME STATUS
- ------------------------------ ---------------
- UNDOTBS1 ONLINE
- SQL>
- FILE_NAME STATUS
- ----------------------------------------------------------------- ---------------
- /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf AVAILABLE
- SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
- With the Partitioning, OLAP and Data Mining options
- R200402=1
- A: UNDOTBS1 ONLINE
- ******************** TOPIC 2.5 ********************
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:28 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> **************************
- SQL> The database tempfile here:
- SQL> **************************
- SQL> SQL> SQL>
- NAME
- --------------------------------------------------------------------------------
- /u01/app/oracle/oradata/PROD/Disk5/temp01.dbf
- 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
- With the Partitioning, OLAP and Data Mining options
- R200500=3
- A: /u01/app/oracle/oradata/PROD/Disk5/temp01.dbf
- ******************** TOPIC 2.6 ********************
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:29 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> **************************
- SQL> The database logfile here:
- SQL> **************************
- SQL> SQL> SQL>
- MEMBER
- --------------------------------------------------------------------------------
- /u01/app/oracle/oradata/PROD/Disk1/redo01a.log
- /u01/app/oracle/oradata/PROD/Disk2/redo02a.log
- /u01/app/oracle/oradata/PROD/Disk3/redo03a.log
- 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
- With the Partitioning, OLAP and Data Mining options
- R200601=3
- A: /u01/app/oracle/oradata/PROD/Disk1/redo01a.log
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:29 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> **************************
- SQL> The database logfile here:
- SQL> **************************
- SQL> SQL> SQL>
- MEMBER
- --------------------------------------------------------------------------------
- /u01/app/oracle/oradata/PROD/Disk1/redo01a.log
- /u01/app/oracle/oradata/PROD/Disk2/redo02a.log
- /u01/app/oracle/oradata/PROD/Disk3/redo03a.log
- 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
- With the Partitioning, OLAP and Data Mining options
- R200602=3
- A: /u01/app/oracle/oradata/PROD/Disk2/redo02a.log
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:29 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL> SQL> SQL> **************************
- SQL> The database logfile here:
- SQL> **************************
- SQL> SQL> SQL>
- MEMBER
- --------------------------------------------------------------------------------
- /u01/app/oracle/oradata/PROD/Disk1/redo01a.log
- /u01/app/oracle/oradata/PROD/Disk2/redo02a.log
- /u01/app/oracle/oradata/PROD/Disk3/redo03a.log
- 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
- With the Partitioning, OLAP and Data Mining options
- R200603=3
- A: /u01/app/oracle/oradata/PROD/Disk3/redo03a.log
- ******************** TOPIC 3 ********************
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:29 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL>
- USERNAME
- ------------------------------
- DBSNMP
- 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
- With the Partitioning, OLAP and Data Mining options
- R300000=15
- A: DBSNMP
- ******************** TOPIC 4 ********************
- SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 11:32:29 2015
- Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
- SQL> Connected.
- SQL> SQL> SQL> SQL>
- AUT
- ---
- YES
- YES
- YES
- YES
- 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
- With the Partitioning, OLAP and Data Mining options
- R400000=13
- A: 0
- ****************************************************************************************************
- R100001: 1 full is 1 1
- R100002: 19 full is 19 20
- R200101: 10 full is 10 30
- R200102: 0 full is 0 30
- R200103: 5 full is 5 35
- R200104: 5 full is 5 40
- R200105: 5 full is 5 45
- R200201: 4 full is 4 49
- R200202: 1 full is 1 50
- R200301: 4 full is 4 54
- R200302: 1 full is 1 55
- R200401: 4 full is 4 59
- R200402: 1 full is 1 60
- R200500: 3 full is 3 63
- R200601: 3 full is 3 66
- R200602: 3 full is 3 69
- R200603: 3 full is 3 72
- R300000: 15 full is 15 87
- R400000: 13 full is 13 100
- full of this section:
- RESULT:
- 100
- ****************************************************************************************************
复制代码
|
|