第19次：2015-11-13星期五做完全恢复

botang

实验4：

1. ecovery Manager complete.
   
2. [oracle@station90 ~]$ sqlplus /nolog
   
3. 
   
4. SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 13 21:54:42 2015
   
5. 
   
6. Copyright (c) 1982, 2011, Oracle.  All rights reserved.
   
7. 
   
8. SQL> conn / as sysdba
   
9. Connected.
   
10. SQL> create table ttestbotang_4 (a number) tablespace tbsocp05_test
    
11.   2  ;
    
12. create table ttestbotang_4 (a number) tablespace tbsocp05_test
    
13. *
    
14. ERROR at line 1:
    
15. ORA-01542: tablespace 'TBSOCP05_TEST' is offline, cannot allocate space in it
    
16. 
    
17. 
    
18. SQL> alter tablespace TBSOCP05_TEST  online;
    
19. alter tablespace TBSOCP05_TEST        online
    
20. *
    
21. ERROR at line 1:
    
22. ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
    
23. ORA-01110: data file 6: '+DATA/orcl/datafile/tbsocp05_test.267.895701167'
    
24. 
    
25. 
    
26. SQL> alter database create datafile '+DATA/orcl/datafile/tbsocp05_test.267.895701167';
    
27. 
    
28. Database altered.
    
29. 
    
30. SQL> recover datafile 6;
    
31. ORA-00283: recovery session canceled due to errors
    
32. ORA-01110: data file 6: '+DATA/orcl/datafile/tbsocp05_test.267.895701167'
    
33. ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
    
34. ORA-01110: data file 6: '+DATA/orcl/datafile/tbsocp05_test.267.895701167'
    
35. 
    
36. 
    
37. SQL>  alter database create datafile '+DATA/orcl/datafile/tbsocp05_test.267.895701167'  as new;
    
38. 
    
39. Database altered.
    
40. 
    
41. SQL> recover datafile 6;
    
42. ORA-00279: change 2091251 generated at 11/13/2015 21:52:47 needed for thread 1
    
43. ORA-00289: suggestion :
    
44. +FRA/orcl/archivelog/2015_11_13/thread_1_seq_135.295.895701171
    
45. ORA-00280: change 2091251 for thread 1 is in sequence #135
    
46. 
    
47. 
    
48. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    
49. 
    
50. ORA-00279: change 2091530 generated at 11/13/2015 21:52:49 needed for thread 1
    
51. ORA-00289: suggestion :
    
52. +FRA/orcl/archivelog/2015_11_13/thread_1_seq_136.294.895701171
    
53. ORA-00280: change 2091530 for thread 1 is in sequence #136
    
54. 
    
55. 
    
56. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    
57. auto
    
58. ORA-00279: change 2091547 generated at 11/13/2015 21:52:50 needed for thread 1
    
59. ORA-00289: suggestion :
    
60. +FRA/orcl/archivelog/2015_11_13/thread_1_seq_137.293.895701171
    
61. ORA-00280: change 2091547 for thread 1 is in sequence #137
    
62. 
    
63. 
    
64. ORA-00279: change 2091576 generated at 11/13/2015 21:52:51 needed for thread 1
    
65. ORA-00289: suggestion :
    
66. +FRA/orcl/archivelog/2015_11_13/thread_1_seq_138.292.895701171
    
67. ORA-00280: change 2091576 for thread 1 is in sequence #138
    
68. 
    
69. 
    
70. Log applied.
    
71. Media recovery complete.
    
72. SQL> select  tablespace_name , status from dba_tablespaces;
    
73. 
    
74. TABLESPACE_NAME                STATUS
    
75. ------------------------------ ---------
    
76. SYSTEM                               ONLINE
    
77. SYSAUX                               ONLINE
    
78. UNDOTBS1                       ONLINE
    
79. TEMP                               ONLINE
    
80. USERS                               ONLINE
    
81. EXAMPLE                        ONLINE
    
82. TBSOCP05_TEST                       OFFLINE
    
83. 
    
84. 7 rows selected.
    
85. 
    
86. SQL> alter tablespace TBSOCP05_TEST online;
    
87. 
    
88. Tablespace altered.
    
89. 
    
90. SQL>
    

复制代码