第21次：2014.09.15

botang

station1-2014-09-15.txt:

1. nnected to an idle instance.
   
2. SQL> startup
   
3. ORACLE instance started.
   
4. 
   
5. Total System Global Area 1073741824 bytes
   
6. Fixed Size                    1264968 bytes
   
7. Variable Size                  276824760 bytes
   
8. Database Buffers          788529152 bytes
   
9. Redo Buffers                    7122944 bytes
   
10. Database mounted.
    
11. Database opened.
    
12. SQL> exit
    
13. Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
    
14. With the Partitioning, OLAP and Data Mining options
    
15. [oracle@station1 ~]$ lsnrctl services
    
16. 
    
17. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 14-SEP-2014 19:18:33
    
18. 
    
19. Copyright (c) 1991, 2005, Oracle.  All rights reserved.
    
20. 
    
21. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.1)(PORT=1521)))
    
22. Services Summary...
    
23. Service "PROD" has 2 instance(s).
    
24.   Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
    
25.     Handler(s):
    
26.       "DEDICATED" established:0 refused:0
    
27.          LOCAL SERVER
    
28.   Instance "PROD", status READY, has 1 handler(s) for this service...
    
29.     Handler(s):
    
30.       "DEDICATED" established:9 refused:0 state:ready
    
31.          LOCAL SERVER
    
32. Service "PROD_DGB" has 1 instance(s).
    
33.   Instance "PROD", status READY, has 1 handler(s) for this service...
    
34.     Handler(s):
    
35.       "DEDICATED" established:9 refused:0 state:ready
    
36.          LOCAL SERVER
    
37. Service "PROD_XPT" has 1 instance(s).
    
38.   Instance "PROD", status READY, has 1 handler(s) for this service...
    
39.     Handler(s):
    
40.       "DEDICATED" established:9 refused:0 state:ready
    
41.          LOCAL SERVER
    
42. The command completed successfully
    
43. [oracle@station1 ~]$ sqlplus /nolog   
    
44. 
    
45. SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 14 19:29:29 2014
    
46. 
    
47. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
    
48. 
    
49. SQL> conn / as sysdba
    
50. Connected.
    
51. SQL> archive log list
    
52. Database log mode               Archive Mode
    
53. Automatic archival               Enabled
    
54. Archive destination               USE_DB_RECOVERY_FILE_DEST
    
55. Oldest online log sequence     5
    
56. Next log sequence to archive   7
    
57. Current log sequence               7
    
58. SQL> exit
    
59. Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
    
60. With the Partitioning, OLAP and Data Mining options
    
61. [oracle@station1 ~]$ cd /u01/app/
    
62. [oracle@station1 app]$ ls
    
63. oracle  oraInventory
    
64. [oracle@station1 app]$ cd oracle
    
65. [oracle@station1 oracle]$ ls
    
66. admin  agent10g  flash_recovery_area  oradata  oraInventory  product
    
67. [oracle@station1 oracle]$ cd flash_recovery_area/
    
68. [oracle@station1 flash_recovery_area]$ ls
    
69. PROD
    
70. [oracle@station1 flash_recovery_area]$ cd PROD/
    
71. [oracle@station1 PROD]$ ls
    
72. archivelog  autobackup  flashback  onlinelog
    
73. [oracle@station1 PROD]$ cd archivelog
    
74. [oracle@station1 archivelog]$ ls
    
75. 2014_08_31  2014_09_04  2014_09_10  2014_09_12  2014_09_14
    
76. [oracle@station1 archivelog]$ cd 2014_09_14
    
77. [oracle@station1 2014_09_14]$ ls
    
78. o1_mf_1_10_b1bn8dcx_.arc  o1_mf_1_23_b1brk0hn_.arc  o1_mf_1_57_b19vqs3f_.arc  o1_mf_1_6_b1bl5jz2_.arc   o1_mf_1_82_b1b4vlyx_.arc
    
79. o1_mf_1_11_b1bn8xo3_.arc  o1_mf_1_24_b1bsdhcb_.arc  o1_mf_1_58_b19vrnjy_.arc  o1_mf_1_6_b1by8fn1_.arc   o1_mf_1_83_b1b4vm7t_.arc
    
80. o1_mf_1_12_b1bn91gy_.arc  o1_mf_1_25_b1bsdhj2_.arc  o1_mf_1_59_b19vsfvj_.arc  o1_mf_1_70_b1b03wmf_.arc  o1_mf_1_84_b1b4vs79_.arc
    
81. o1_mf_1_13_b1bn9415_.arc  o1_mf_1_26_b1bsdtf7_.arc  o1_mf_1_5_b1bl40n3_.arc   o1_mf_1_71_b1b03x1c_.arc  o1_mf_1_85_b1b4vso0_.arc
    
82. o1_mf_1_14_b1bnf07z_.arc  o1_mf_1_28_b1bsf0gg_.arc  o1_mf_1_5_b1by5zkd_.arc   o1_mf_1_72_b1b0nvow_.arc  o1_mf_1_86_b1bh5pjh_.arc
    
83. o1_mf_1_15_b1bnf0tz_.arc  o1_mf_1_29_b1bsf0kh_.arc  o1_mf_1_60_b19w3c4k_.arc  o1_mf_1_73_b1b46jgo_.arc  o1_mf_1_87_b1bhcwkh_.arc
    
84. o1_mf_1_16_b1bnf3jz_.arc  o1_mf_1_2_b1bhzrrb_.arc   o1_mf_1_61_b19w5p1v_.arc  o1_mf_1_74_b1b46jrk_.arc  o1_mf_1_88_b1bhcwm5_.arc
    
85. o1_mf_1_17_b1bnfdlw_.arc  o1_mf_1_2_b1btd2rm_.arc   o1_mf_1_62_b19wh1l5_.arc  o1_mf_1_75_b1b46vw1_.arc  o1_mf_1_89_b1bhd6sx_.arc
    
86. o1_mf_1_18_b1bnlzpv_.arc  o1_mf_1_30_b1bsr5pd_.arc  o1_mf_1_63_b19whr28_.arc  o1_mf_1_76_b1b46w3t_.arc  o1_mf_1_8_b1bmft1y_.arc
    
87. o1_mf_1_19_b1bnmls3_.arc  o1_mf_1_3_b1bksmyd_.arc   o1_mf_1_64_b19wj5br_.arc  o1_mf_1_77_b1b471ch_.arc  o1_mf_1_91_b1bhddss_.arc
    
88. o1_mf_1_1_b1bhtf6n_.arc   o1_mf_1_3_b1by5hrn_.arc   o1_mf_1_65_b19wpdyt_.arc  o1_mf_1_78_b1b471wx_.arc  o1_mf_1_92_b1bhdf5b_.arc
    
89. o1_mf_1_1_b1bsrcmt_.arc   o1_mf_1_4_b1bl0nqm_.arc   o1_mf_1_66_b1b03k7l_.arc  o1_mf_1_79_b1b4ovf2_.arc  o1_mf_1_93_b1bhsz37_.arc
    
90. o1_mf_1_20_b1bno1xk_.arc  o1_mf_1_4_b1by5zft_.arc   o1_mf_1_67_b1b03kjs_.arc  o1_mf_1_7_b1bmfghf_.arc   o1_mf_1_9_b1bmg92r_.arc
    
91. o1_mf_1_21_b1bqc6pd_.arc  o1_mf_1_55_b19vqfm9_.arc  o1_mf_1_68_b1b03pt6_.arc  o1_mf_1_80_b1b4v8gt_.arc
    
92. o1_mf_1_22_b1bqcbrh_.arc  o1_mf_1_56_b19vqkrn_.arc  o1_mf_1_69_b1b03q5r_.arc  o1_mf_1_81_b1b4v8t3_.arc
    
93. [oracle@station1 2014_09_14]$ ls -ltr o1_mf_1_1_*
    
94. -rw-r----- 1 oracle oinstall 1024 Sep 14 15:10 o1_mf_1_1_b1bhtf6n_.arc
    
95. -rw-r----- 1 oracle oinstall 1024 Sep 14 17:59 o1_mf_1_1_b1bsrcmt_.arc
    
96. [oracle@station1 2014_09_14]$ md5sum  o1_mf_1_12_b1bn91gy_.arc
    
97. 37a6e8dbcb683aee59e50eb64f29e9e1  o1_mf_1_12_b1bn91gy_.arc
    
98. [oracle@station1 2014_09_14]$ sqlplus /nolog
    
99. 
    
100. SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 14 19:34:15 2014
     
101. 
     
102. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
103. 
     
104. SQL> conn / as sysdba
     
105. Connected.
     
106. SQL> show parameter log_Archive_format
     
107. 
     
108. NAME                                     TYPE         VALUE
     
109. ------------------------------------ ----------- ------------------------------
     
110. log_archive_format                     string         %t_%s_%r.dbf
     
111. SQL> exit
     
112. Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
     
113. With the Partitioning, OLAP and Data Mining options
     
114. [oracle@station1 2014_09_14]$ scp o1_mf_1_1_b1bsrcmt_.arc  station2:/u01/app/oracle/stdbyarch/LOGSTDBY/
     
115. oracle@station2's password:
     
116. o1_mf_1_1_b1bsrcmt_.arc                                                                                            100% 1024     1.0KB/s   00:00   
     
117. [oracle@station1 2014_09_14]$ sqlplus /nolog
     
118. 
     
119. SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 14 19:42:36 2014
     
120. 
     
121. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
     
122. 
     
123. SQL> conn hr/hr
     
124. Connected.
     
125. SQL> select  *  from tab;
     
126. 
     
127. TNAME                               TABTYPE        CLUSTERID
     
128. ------------------------------ ------- ----------
     
129. T762                               TABLE
     
130. T1351                               TABLE
     
131. 
     
132. SQL> select  * from T1351;
     
133. 
     
134.          A
     
135. ----------
     
136.          1
     
137. 
     
138. SQL> update T1351 set a=2 ;
     
139. 
     
140. 1 row updated.
     
141. 
     
142. SQL> commit;
     
143. 
     
144. Commit complete.
     
145. 
     
146. SQL> select  * from T1351;
     
147. 
     
148.          A
     
149. ----------
     
150.          2
     
151. 
     
152. SQL> update T1351 set a=3;
     
153. 
     
154. 1 row updated.
     
155. 
     
156. SQL> commit;
     
157. 
     
158. Commit complete.
     
159. 
     
160. SQL>
     

复制代码

station2-2014-09-15.txt:

1. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
   
2. 
   
3. SQL> conn / as sysdba
   
4. Connected to an idle instance.
   
5. SQL> startup
   
6. ORACLE instance started.
   
7. 
   
8. Total System Global Area 1073741824 bytes
   
9. Fixed Size                    1264968 bytes
   
10. Variable Size                  260047544 bytes
    
11. Database Buffers          805306368 bytes
    
12. Redo Buffers                    7122944 bytes
    
13. Database mounted.
    
14. Database opened.
    
15. SQL> exit
    
16. Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
    
17. With the Partitioning, OLAP and Data Mining options
    
18. [oracle@station2 ~]$ lsnrctl services
    
19. 
    
20. LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 14-SEP-2014 19:18:59
    
21. 
    
22. Copyright (c) 1991, 2005, Oracle.  All rights reserved.
    
23. 
    
24. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.2)(PORT=1521)))
    
25. Services Summary...
    
26. Service "EMREP" has 1 instance(s).
    
27.   Instance "EMREP", status READY, has 1 handler(s) for this service...
    
28.     Handler(s):
    
29.       "DEDICATED" established:17 refused:0 state:ready
    
30.          LOCAL SERVER
    
31. Service "EMREP_XPT" has 1 instance(s).
    
32.   Instance "EMREP", status READY, has 1 handler(s) for this service...
    
33.     Handler(s):
    
34.       "DEDICATED" established:17 refused:0 state:ready
    
35.          LOCAL SERVER
    
36. Service "LOGSTDBY" has 1 instance(s).
    
37.   Instance "LOGSTDBY", status READY, has 1 handler(s) for this service...
    
38.     Handler(s):
    
39.       "DEDICATED" established:9 refused:0 state:ready
    
40.          LOCAL SERVER
    
41. Service "LOGSTDBY_DGB" has 1 instance(s).
    
42.   Instance "LOGSTDBY", status READY, has 1 handler(s) for this service...
    
43.     Handler(s):
    
44.       "DEDICATED" established:9 refused:0 state:ready
    
45.          LOCAL SERVER
    
46. Service "LOGSTDBY_DGMGRL" has 1 instance(s).
    
47.   Instance "LOGSTDBY", status UNKNOWN, has 1 handler(s) for this service...
    
48.     Handler(s):
    
49.       "DEDICATED" established:8 refused:0
    
50.          LOCAL SERVER
    
51. Service "LOGSTDBY_XPT" has 1 instance(s).
    
52.   Instance "LOGSTDBY", status READY, has 1 handler(s) for this service...
    
53.     Handler(s):
    
54.       "DEDICATED" established:9 refused:0 state:ready
    
55.          LOCAL SERVER
    
56. Service "STDBY_DGMGRL" has 1 instance(s).
    
57.   Instance "STDBY", status UNKNOWN, has 1 handler(s) for this service...
    
58.     Handler(s):
    
59.       "DEDICATED" established:0 refused:0
    
60.          LOCAL SERVER
    
61. The command completed successfully
    
62. [oracle@station2 ~]$ cd /u01/app/
    
63. [oracle@station2 app]$ ls
    
64. oracle  oraInventory
    
65. [oracle@station2 app]$ cd oracle/
    
66. [oracle@station2 oracle]$ ls
    
67. admin  flash_recovery_area  OracleHomes  oradata  oraInventory  product  stdbyarch
    
68. [oracle@station2 oracle]$ cd stdbyarch
    
69. [oracle@station2 stdbyarch]$ ls
    
70. LOGSTDBY
    
71. [oracle@station2 stdbyarch]$ cd LOGSTDBY/
    
72. [oracle@station2 LOGSTDBY]$ ls
    
73. 1_10_858265791.dbf  1_12_858265791.dbf  1_14_858265791.dbf  1_24_858265791.dbf  1_26_858265791.dbf  1_28_858265791.dbf  1_6_858275973.dbf
    
74. 1_11_858265791.dbf  1_13_858265791.dbf  1_1_858275973.dbf   1_25_858265791.dbf  1_27_858265791.dbf  1_29_858265791.dbf  dgarc
    
75. [oracle@station2 LOGSTDBY]$ pwd
    
76. /u01/app/oracle/stdbyarch/LOGSTDBY
    
77. [oracle@station2 LOGSTDBY]$ md5sum 1_12_858265791.dbf
    
78. 37a6e8dbcb683aee59e50eb64f29e9e1  1_12_858265791.dbf
    
79. [oracle@station2 LOGSTDBY]$ ls
    
80. 1_10_858265791.dbf  1_12_858265791.dbf  1_14_858265791.dbf  1_24_858265791.dbf  1_26_858265791.dbf  1_28_858265791.dbf  1_6_858275973.dbf
    
81. 1_11_858265791.dbf  1_13_858265791.dbf  1_1_858275973.dbf   1_25_858265791.dbf  1_27_858265791.dbf  1_29_858265791.dbf  dgarc
    
82. [oracle@station2 LOGSTDBY]$ pwd
    
83. /u01/app/oracle/stdbyarch/LOGSTDBY
    
84. [oracle@station2 LOGSTDBY]$ ls
    
85. 1_10_858265791.dbf  1_13_858265791.dbf  1_24_858265791.dbf  1_27_858265791.dbf  1_6_858275973.dbf
    
86. 1_11_858265791.dbf  1_14_858265791.dbf  1_25_858265791.dbf  1_28_858265791.dbf  dgarc
    
87. 1_12_858265791.dbf  1_1_858275973.dbf   1_26_858265791.dbf  1_29_858265791.dbf  o1_mf_1_1_b1bsrcmt_.arc
    
88. [oracle@station2 LOGSTDBY]$ pwd
    
89. /u01/app/oracle/stdbyarch/LOGSTDBY
    
90. [oracle@station2 LOGSTDBY]$ . oraenv
    
91. ORACLE_SID = [LOGSTDBY] ?
    
92. [oracle@station2 LOGSTDBY]$ sqlplus /nolog
    
93. 
    
94. SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 14 19:37:06 2014
    
95. 
    
96. Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
    
97. 
    
98. SQL> conn / as sysdba
    
99. Connected.
    
100. SQL> alter database register logical logfile '/u01/app/oracle/stdbyarch/LOGSTDBY/o1_mf_1_1_b1bsrcmt_.arc';
     
101. 
     
102. Database altered.
     
103. 
     
104. SQL> alter database start logical apply immediate;
     
105. alter database start logical apply immediate
     
106.                              *
     
107. ERROR at line 1:
     
108. ORA-00905: missing keyword
     
109. 
     
110. 
     
111. SQL>  alter database start logical standby apply immediate;
     
112. alter database start logical standby apply immediate
     
113. *
     
114. ERROR at line 1:
     
115. ORA-16103: Logical Standby apply must be stopped to allow this operation
     
116. 
     
117. 
     
118. SQL>  alter database stop logical standby apply ;
     
119. 
     
120. Database altered.
     
121. 
     
122. SQL> alter database start logical standby apply immediate;
     
123. 
     
124. Database altered.
     
125. 
     
126. SQL> conn hr/hr
     
127. Connected.
     
128. SQL> select  * from t1351;
     
129. 
     
130.          A
     
131. ----------
     
132.          1
     
133. 
     
134. SQL> /
     
135. 
     
136.          A
     
137. ----------
     
138.          1
     
139. 
     
140. SQL> /
     
141. 
     
142.          A
     
143. ----------
     
144.          1
     
145. 
     
146. SQL> /
     
147. 
     
148.          A
     
149. ----------
     
150.          2
     
151. 
     
152. SQL> /
     
153. 
     
154.          A
     
155. ----------
     
156.          2
     
157. 
     
158. SQL> /
     
159. 
     
160.          A
     
161. ----------
     
162.          2
     
163. 
     
164. SQL> /
     
165. 
     
166.          A
     
167. ----------
     
168.          2
     
169. 
     
170. SQL> /
     
171. 
     
172.          A
     
173. ----------
     
174.          3
     
175. 
     
176. SQL>
     

复制代码

2014-09-15.sql:

1. select  * from dba_logstdby_events  order by event_time desc;
   
2. 
   
3. select  * from v$logstdby_process;
   
4. 
   
5. select  * from dba_logstdby_log;
   
6. 
   
7. select * from v$logstdby_state;
   
8. 
   
9. select  * from v$logstdby_progress;
   
10. 
    
11. select  * from dba_logstdby_parameters;
    
12. 
    
13. 
    
14. begin
    
15.    dbms_logstdby.apply_set('LOG_AUTO_DELETE','FALSE');
    
16. end;

复制代码

2014-09-15.txt:

1. select  * from dba_logstdby_events  order by event_time desc;
   
2. 
   
3. select  * from v$logstdby_process;
   
4. 
   
5. select  * from dba_logstdby_log;
   
6. 
   
7. select * from v$logstdby_state;
   
8. 
   
9. select  * from v$logstdby_progress;

复制代码