Bo's Oracle Station

查看: 1974|回复: 0

第21次:2015-10-22星期四

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2015-10-23 23:25:17 | 显示全部楼层 |阅读模式
192.168.0.1:

  1. ---------------------------------------------- LAB 9b ----------------------------------------------
  2.              9b_当前控制文件损坏_下线user表空间完全恢复_用控制文件脚本_不需备份
  3. ---------------------------------------------- LAB 9b ----------------------------------------------


  4. ******************
  5. 你的主机信息如下:
  6. ******************
  7. 192.168.0.1

  8. station1.example.com

  9. Linux station1.example.com 2.6.39-400.209.1.el5uek #1 SMP Tue Sep 10 20:34:36 PDT 2013 i686 i686 i386 GNU/Linux


  10. Name           Type           Target    State     Host        
  11. ------------------------------------------------------------
  12. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station1   
  13. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station1   
  14. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station1   
  15. ora.asm        ora.asm.type   ONLINE    ONLINE    station1   
  16. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station1   
  17. ora.diskmon    ora....on.type OFFLINE   OFFLINE               
  18. ora.evmd       ora.evm.type   ONLINE    ONLINE    station1   
  19. ora.ons        ora.ons.type   OFFLINE   OFFLINE               
  20. ora.orcl.db    ora....se.type ONLINE    ONLINE    station1   
  21. ora.zren.db    ora....se.type ONLINE    ONLINE    station1   

  22. SQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 23 05:56:55 2015

  23. Copyright (c) 1982, 2011, Oracle.  All rights reserved.

  24. SQL> Connected.
  25. SQL> SQL> SQL> select        * from sys.tname
  26.                    *
  27. ERROR at line 1:
  28. ORA-00942: table or view does not exist


  29. ****************************
  30. The database open mode here:
  31. ****************************

  32. D
  33. -
  34. X

  35. OPEN_MODE
  36. --------------------
  37. READ WRITE
  38. **********************************
  39. The database archivelog mode here:
  40. **********************************
  41. Database log mode               Archive Mode
  42. Automatic archival               Enabled
  43. Archive destination               USE_DB_RECOVERY_FILE_DEST
  44. Oldest online log sequence     6
  45. Next log sequence to archive   8
  46. Current log sequence               8
  47. ***************************
  48. The database datafile here:
  49. ***************************

  50. TABLESPACE_NAME                STATUS
  51. ------------------------------ ---------------
  52. SYSTEM                               ONLINE
  53. SYSAUX                               ONLINE
  54. UNDOTBS1                       ONLINE
  55. TEMP                               ONLINE
  56. USERS                               ONLINE
  57. EXAMPLE                        ONLINE
  58. TBSOCP05_TEST                       ONLINE

  59. NAME                                                                  STATUS
  60. ----------------------------------------------------------------- ---------------
  61. +DATA/orcl/datafile/system.256.890712319                          SYSTEM
  62. +DATA/orcl/datafile/sysaux.257.889998995                          ONLINE
  63. +DATA/orcl/datafile/undotbs1.258.889998995                          ONLINE
  64. +DATA/orcl/datafile/users.259.890545597                           ONLINE
  65. +DATA/orcl/datafile/example.265.889999059                          ONLINE
  66. +DATA/orcl/datafile/tbsocp05_test.267.890714521                   ONLINE
  67. ******************************
  68. The database controlfile here:
  69. ******************************

  70. NAME
  71. -----------------------------------------------------------------
  72. +DATA/orcl/controlfile/current.260.893829007
  73. +FRA/orcl/controlfile/current.256.893829007
  74. **************************
  75. The database logfile here:
  76. **************************

  77. MEMBER
  78. --------------------------------------------------------------------------------
  79. +DATA/orcl/onlinelog/group_1.263.893218409
  80. +FRA/orcl/onlinelog/group_1.259.893218409
  81. +DATA/orcl/onlinelog/group_3.261.893218411
  82. +FRA/orcl/onlinelog/group_3.257.893218411
  83. +DATA/orcl/onlinelog/group_2.262.893218409
  84. +FRA/orcl/onlinelog/group_2.258.893218411
  85. **************************
  86. The database tempfile here:
  87. **************************
  88. *****************
  89. The values found:
  90. *****************

  91.          A
  92. ----------
  93.          1
  94.          2
  95.          3
  96.          4
  97.          5
  98. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
  99. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  100. and Real Application Testing options

  101. THE END
复制代码


192.168.0.20:

  1. ---------------------------------------------- LAB 9b ----------------------------------------------
  2.              9b_当前控制文件损坏_下线user表空间完全恢复_用控制文件脚本_不需备份
  3. ---------------------------------------------- LAB 9b ----------------------------------------------


  4. ******************
  5. 你的主机信息如下:
  6. ******************
  7. 192.168.0.20

  8. station20.example.com

  9. Linux station20.example.com 2.6.39-400.209.1.el5uek #1 SMP Tue Sep 10 20:34:36 PDT 2013 i686 i686 i386 GNU/Linux


  10. Name           Type           Target    State     Host        
  11. ------------------------------------------------------------
  12. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station20   
  13. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station20   
  14. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station20   
  15. ora.asm        ora.asm.type   ONLINE    ONLINE    station20   
  16. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station20   
  17. ora.diskmon    ora....on.type ONLINE    ONLINE    station20   
  18. ora.orcl.db    ora....se.type ONLINE    ONLINE    station20   

  19. SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 22 21:57:18 2015

  20. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  21. SQL> Connected.
  22. SQL> SQL> SQL> select        * from sys.tname
  23.                    *
  24. ERROR at line 1:
  25. ORA-00942: table or view does not exist


  26. ****************************
  27. The database open mode here:
  28. ****************************

  29. D
  30. -
  31. X

  32. OPEN_MODE
  33. --------------------
  34. READ WRITE
  35. **********************************
  36. The database archivelog mode here:
  37. **********************************
  38. Database log mode               Archive Mode
  39. Automatic archival               Enabled
  40. Archive destination               USE_DB_RECOVERY_FILE_DEST
  41. Oldest online log sequence     6
  42. Next log sequence to archive   8
  43. Current log sequence               8
  44. ***************************
  45. The database datafile here:
  46. ***************************

  47. TABLESPACE_NAME                STATUS
  48. ------------------------------ ---------------
  49. SYSTEM                               ONLINE
  50. SYSAUX                               ONLINE
  51. UNDOTBS1                       ONLINE
  52. TEMP                               ONLINE
  53. USERS                               ONLINE
  54. EXAMPLE                        ONLINE
  55. TBSOCP05_TEST                       ONLINE

  56. NAME                                                                  STATUS
  57. ----------------------------------------------------------------- ---------------
  58. +DATA/orcl/datafile/system.256.890683637                          SYSTEM
  59. +DATA/orcl/datafile/sysaux.257.832197065                          ONLINE
  60. +DATA/orcl/datafile/undotbs1.258.832197065                          ONLINE
  61. +DATA/orcl/datafile/users.259.890516569                           ONLINE
  62. +DATA/orcl/datafile/example.265.832197353                          ONLINE
  63. +DATA/orcl/datafile/tbsocp05_test.267.890685725                   ONLINE
  64. ******************************
  65. The database controlfile here:
  66. ******************************

  67. NAME
  68. -----------------------------------------------------------------
  69. +DATA/orcl/controlfile/current.260.893800489
  70. +FRA/orcl/controlfile/current.256.893800497
  71. **************************
  72. The database logfile here:
  73. **************************

  74. MEMBER
  75. --------------------------------------------------------------------------------
  76. +DATA/orcl/onlinelog/group_1.263.893189681
  77. +FRA/orcl/onlinelog/group_1.259.893189693
  78. +DATA/orcl/onlinelog/group_3.261.893189721
  79. +FRA/orcl/onlinelog/group_3.257.893189731
  80. +DATA/orcl/onlinelog/group_2.262.893189703
  81. +FRA/orcl/onlinelog/group_2.258.893189715
  82. **************************
  83. The database tempfile here:
  84. **************************
  85. *****************
  86. The values found:
  87. *****************

  88.          A
  89. ----------
  90.          1
  91.          2
  92.          3
  93.          4
  94.          5
  95. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
  96. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  97. and Real Application Testing options

  98. THE END
复制代码

192.168.0.65:


  1. ---------------------------------------------- LAB 9b ----------------------------------------------
  2.              9b_当前控制文件损坏_下线user表空间完全恢复_用控制文件脚本_不需备份
  3. ---------------------------------------------- LAB 9b ----------------------------------------------


  4. ******************
  5. 你的主机信息如下:
  6. ******************
  7. 192.168.0.65

  8. station65.example.com

  9. Linux station65.example.com 2.6.18-398.el5 #1 SMP Mon Sep 15 22:54:56 PDT 2014 i686 i686 i386 GNU/Linux


  10. Name           Type           Target    State     Host        
  11. ------------------------------------------------------------
  12. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station65   
  13. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station65   
  14. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station65   
  15. ora.asm        ora.asm.type   ONLINE    ONLINE    station65   
  16. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station65   
  17. ora.diskmon    ora....on.type ONLINE    ONLINE    station65   
  18. ora.orcl.db    ora....se.type ONLINE    ONLINE    station65   
  19. ora.u65.db     ora....se.type ONLINE    ONLINE    station65   

  20. SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 22 21:57:10 2015

  21. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  22. SQL> Connected.
  23. SQL> SQL> SQL> select        * from sys.tname
  24.                    *
  25. ERROR at line 1:
  26. ORA-00942: table or view does not exist


  27. ****************************
  28. The database open mode here:
  29. ****************************

  30. D
  31. -
  32. X

  33. OPEN_MODE
  34. --------------------
  35. READ WRITE
  36. **********************************
  37. The database archivelog mode here:
  38. **********************************
  39. Database log mode               Archive Mode
  40. Automatic archival               Enabled
  41. Archive destination               USE_DB_RECOVERY_FILE_DEST
  42. Oldest online log sequence     6
  43. Next log sequence to archive   8
  44. Current log sequence               8
  45. ***************************
  46. The database datafile here:
  47. ***************************

  48. TABLESPACE_NAME                STATUS
  49. ------------------------------ ---------------
  50. SYSTEM                               ONLINE
  51. SYSAUX                               ONLINE
  52. UNDOTBS1                       ONLINE
  53. TEMP                               ONLINE
  54. USERS                               ONLINE
  55. EXAMPLE                        ONLINE
  56. TBSOCP05_TEST                       ONLINE

  57. NAME                                                                  STATUS
  58. ----------------------------------------------------------------- ---------------
  59. +DATA/orcl/datafile/system.256.890683581                          SYSTEM
  60. +DATA/orcl/datafile/sysaux.257.832197065                          ONLINE
  61. +DATA/orcl/datafile/undotbs1.258.832197065                          ONLINE
  62. +DATA/orcl/datafile/users.259.890516937                           ONLINE
  63. +DATA/orcl/datafile/example.265.832197353                          ONLINE
  64. +DATA/orcl/datafile/tbsocp05_test.273.890685743                   ONLINE
  65. ******************************
  66. The database controlfile here:
  67. ******************************

  68. NAME
  69. -----------------------------------------------------------------
  70. +DATA/orcl/controlfile/current.286.893800317
  71. +FRA/orcl/controlfile/current.293.893800319
  72. **************************
  73. The database logfile here:
  74. **************************

  75. MEMBER
  76. --------------------------------------------------------------------------------
  77. +DATA/orcl/onlinelog/group_1.271.889850609
  78. +FRA/orcl/onlinelog/group_1.327.889850613
  79. +DATA/orcl/onlinelog/group_3.263.832197301
  80. +FRA/orcl/onlinelog/group_3.259.832197305
  81. +DATA/orcl/onlinelog/group_2.272.889850617
  82. +FRA/orcl/onlinelog/group_2.326.889850621
  83. **************************
  84. The database tempfile here:
  85. **************************

  86. NAME
  87. --------------------------------------------------------------------------------
  88. +DATA/orcl/tempfile/temp.285.893800591
  89. *****************
  90. The values found:
  91. *****************

  92.          A
  93. ----------
  94.          1
  95.          2
  96.          3
  97.          4
  98.          5
  99. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
  100. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  101. and Real Application Testing options

  102. THE END
复制代码

192.168.0.72:


  1. ---------------------------------------------- LAB 9b ----------------------------------------------
  2.              9b_当前控制文件损坏_下线user表空间完全恢复_用控制文件脚本_不需备份
  3. ---------------------------------------------- LAB 9b ----------------------------------------------


  4. ******************
  5. 你的主机信息如下:
  6. ******************
  7. 192.168.0.72

  8. station72.example.com

  9. Linux station72.example.com 2.6.18-238.el5 #1 SMP Sun Dec 19 14:24:47 EST 2010 i686 i686 i386 GNU/Linux


  10. Name           Type           Target    State     Host        
  11. ------------------------------------------------------------
  12. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station72   
  13. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station72   
  14. ora.asm        ora.asm.type   ONLINE    ONLINE    station72   
  15. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station72   
  16. ora.diskmon    ora....on.type OFFLINE   OFFLINE               
  17. ora.evmd       ora.evm.type   ONLINE    ONLINE    station72   
  18. ora.ons        ora.ons.type   OFFLINE   OFFLINE               
  19. ora.orcl.db    ora....se.type ONLINE    ONLINE    station72   
  20. ora.rcat72.db  ora....se.type ONLINE    ONLINE    station72   

  21. SQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 23 05:59:59 2015

  22. Copyright (c) 1982, 2011, Oracle.  All rights reserved.

  23. SQL> Connected.
  24. SQL> SQL> SQL>
  25. WULONGWU
  26. ----------------------------------------------------------------------------------------------------
  27. |-----|
  28. |    |
  29. |-----|
  30. ----------
  31.     |
  32.     |
  33. ----------
  34.    / \
  35.   /   \
  36. /     \
  37. /        \
  38. ****************************
  39. The database open mode here:
  40. ****************************

  41. DUM
  42. ---
  43. X

  44. OPEN_MODE
  45. ------------------------------------------------------------
  46. READ WRITE
  47. **********************************
  48. The database archivelog mode here:
  49. **********************************
  50. Database log mode               Archive Mode
  51. Automatic archival               Enabled
  52. Archive destination               USE_DB_RECOVERY_FILE_DEST
  53. Oldest online log sequence     6
  54. Next log sequence to archive   8
  55. Current log sequence               8
  56. ***************************
  57. The database datafile here:
  58. ***************************

  59. TABLESPACE_NAME
  60. ------------------------------------------------------------------------------------------
  61. STATUS
  62. ---------------
  63. SYSTEM
  64. ONLINE

  65. SYSAUX
  66. ONLINE

  67. UNDOTBS1
  68. ONLINE


  69. TABLESPACE_NAME
  70. ------------------------------------------------------------------------------------------
  71. STATUS
  72. ---------------
  73. TEMP
  74. ONLINE

  75. USERS
  76. ONLINE

  77. EXAMPLE
  78. ONLINE


  79. TABLESPACE_NAME
  80. ------------------------------------------------------------------------------------------
  81. STATUS
  82. ---------------
  83. TBSOCP05_TEST
  84. ONLINE


  85. NAME                                                                  STATUS
  86. ----------------------------------------------------------------- ---------------
  87. +DATA/orcl/datafile/system.256.890713065                          SYSTEM
  88. +DATA/orcl/datafile/sysaux.257.890025707                          ONLINE
  89. +DATA/orcl/datafile/undotbs1.258.890025707                          ONLINE
  90. +DATA/orcl/datafile/users.259.890545553                           ONLINE
  91. +DATA/orcl/datafile/example.265.890025909                          ONLINE
  92. +DATA/orcl/datafile/tbsocp05_test.267.890714853                   ONLINE
  93. ******************************
  94. The database controlfile here:
  95. ******************************

  96. NAME
  97. -----------------------------------------------------------------
  98. +DATA/orcl/controlfile/current.260.893829245
  99. +FRA/orcl/controlfile/current.256.893829245
  100. **************************
  101. The database logfile here:
  102. **************************

  103. MEMBER
  104. --------------------------------------------------------------------------------
  105. +DATA/orcl/onlinelog/group_1.261.890025867
  106. +FRA/orcl/onlinelog/group_1.257.890025869
  107. +DATA/orcl/onlinelog/group_3.263.890025873
  108. +FRA/orcl/onlinelog/group_3.259.890025875
  109. +DATA/orcl/onlinelog/group_2.262.890025871
  110. +FRA/orcl/onlinelog/group_2.258.890025873
  111. **************************
  112. The database tempfile here:
  113. **************************

  114. NAME
  115. --------------------------------------------------------------------------------
  116. +DATA/orcl/tempfile/temp.279.893829353
  117. *****************
  118. The values found:
  119. *****************

  120.          A
  121. ----------
  122.          1
  123.          2
  124.          3
  125.          4
  126.          5
  127. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
  128. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  129. and Real Application Testing options

  130. THE END
复制代码

192.168.0.90:

  1. ---------------------------------------------- LAB 9b ----------------------------------------------
  2.              9b_当前控制文件损坏_下线user表空间完全恢复_用控制文件脚本_不需备份
  3. ---------------------------------------------- LAB 9b ----------------------------------------------


  4. ******************
  5. 你的主机信息如下:
  6. ******************
  7. 192.168.0.87

  8. station90.example.com

  9. Linux station90.example.com 3.6.2 #2 SMP Tue Aug 11 07:54:45 CST 2015 x86_64 x86_64 x86_64 GNU/Linux


  10. Name           Type           Target    State     Host        
  11. ------------------------------------------------------------
  12. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station90   
  13. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station90   
  14. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station90   
  15. ora.asm        ora.asm.type   ONLINE    ONLINE    station90   
  16. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station90   
  17. ora.diskmon    ora....on.type OFFLINE   OFFLINE               
  18. ora.evmd       ora.evm.type   ONLINE    ONLINE    station90   
  19. ora.ons        ora.ons.type   OFFLINE   OFFLINE               
  20. ora.orcl.db    ora....se.type ONLINE    ONLINE    station90   
  21. Name           Type           Target    State     Host        
  22. ------------------------------------------------------------
  23. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station90   
  24. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station90   
  25. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station90   
  26. ora.asm        ora.asm.type   ONLINE    ONLINE    station90   
  27. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station90   
  28. ora.diskmon    ora....on.type OFFLINE   OFFLINE               
  29. ora.evmd       ora.evm.type   ONLINE    ONLINE    station90   
  30. ora.ons        ora.ons.type   OFFLINE   OFFLINE               
  31. ora.orcl.db    ora....se.type ONLINE    ONLINE    station90   

  32. SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 22 21:56:47 2015

  33. Copyright (c) 1982, 2011, Oracle.  All rights reserved.

  34. SQL> Connected.
  35. SQL> SQL> SQL>
  36. A
  37. --------------------
  38. Botang
  39. ****************************
  40. The database open mode here:
  41. ****************************

  42. D
  43. -
  44. X

  45. OPEN_MODE
  46. --------------------
  47. READ WRITE
  48. **********************************
  49. The database archivelog mode here:
  50. **********************************
  51. Database log mode               Archive Mode
  52. Automatic archival               Enabled
  53. Archive destination               USE_DB_RECOVERY_FILE_DEST
  54. Oldest online log sequence     6
  55. Next log sequence to archive   8
  56. Current log sequence               8
  57. ***************************
  58. The database datafile here:
  59. ***************************

  60. TABLESPACE_NAME                STATUS
  61. ------------------------------ ---------------
  62. SYSTEM                               ONLINE
  63. SYSAUX                               ONLINE
  64. UNDOTBS1                       ONLINE
  65. TEMP                               ONLINE
  66. USERS                               ONLINE
  67. EXAMPLE                        ONLINE

  68. NAME                                                                  STATUS
  69. ----------------------------------------------------------------- ---------------
  70. +DATA/orcl/datafile/system.256.816169553                          SYSTEM
  71. +DATA/orcl/datafile/sysaux.257.816169553                          ONLINE
  72. +DATA/orcl/datafile/undotbs1.258.816169553                          ONLINE
  73. +DATA/orcl/datafile/users.259.816169553                           ONLINE
  74. +DATA/orcl/datafile/example.265.816169651                          ONLINE
  75. ******************************
  76. The database controlfile here:
  77. ******************************

  78. NAME
  79. -----------------------------------------------------------------
  80. +DATA/orcl/controlfile/current.260.893799313
  81. +FRA/orcl/controlfile/current.324.893799315
  82. **************************
  83. The database logfile here:
  84. **************************

  85. MEMBER
  86. --------------------------------------------------------------------------------
  87. +DATA/orcl/onlinelog/group_1.263.893188987
  88. +FRA/orcl/onlinelog/group_1.259.893188987
  89. +DATA/orcl/onlinelog/group_3.261.893188991
  90. +FRA/orcl/onlinelog/group_3.257.893188991
  91. +DATA/orcl/onlinelog/group_2.262.893188989
  92. +FRA/orcl/onlinelog/group_2.258.893188989
  93. **************************
  94. The database tempfile here:
  95. **************************

  96. NAME
  97. --------------------------------------------------------------------------------
  98. +DATA/orcl/tempfile/temp.268.893799873
  99. *****************
  100. The values found:
  101. *****************

  102.          A
  103. ----------
  104.          1
  105.          2
  106.          3
  107.          4
  108.          5
  109. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  110. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  111. and Real Application Testing options

  112. THE END
复制代码









回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-5-3 17:41 , Processed in 0.040830 second(s), 24 queries .

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