课程第13/14次（2016-11-27星期日上下午）

botang

上完1Z0-052第14章（Oracle数据库的热备份，表空间级的检查点）
（052共19章，053共21章，063多租户共9章，49-8）

2016-11-27.sql：

1. select   d.CHECKPOINT_CHANGE# , d.CURRENT_SCN   from
   
2. v_$database  d;
   
3. 
   
4. 
   
5. select  df.FILE#,  df.CHECKPOINT_CHANGE#, status
   
6.   from v_$datafile df;
   
7.   
   
8.   select   * from dba_data_files;
   
9.    
   
10.   
    
11.   alter  tablespace  sysaux offline ;
    
12.   
    
13.   alter system checkpoint;
    
14.   
    
15.   alter tablespace sysaux online;
    
16.   ---------
    
17.   
    
18.   alter database datafile 2 offline ;
    
19.   
    
20.     alter database datafile 2 online ;
    
21.     ----
    
22. 
    
23. select   * from v$datafile ;
    
24. 
    
25. alter database datafile 2 online;
    
26. 
    
27. alter tablespace sysaux online;
    
28. 
    
29. select   * from v$datafile;
    
30. 
    
31. ----
    
32. select  * from v$log;
    
33. ----
    
34. 
    
35. select  * from v$logfile;
    
36. alter database drop logfile group 3;
    
37. 
    
38. alter system switch logfile;
    
39. ----
    
40. select   * from v$datafile ;
    
41. 
    
42. alter database datafile 2 online;
    
43. 
    
44. alter tablespace sysaux online;
    
45. 
    
46. select   * from v$datafile;
    
47. 
    
48. ----
    
49. select  * from v$log;
    
50. ----
    
51. 
    
52. select  * from v$logfile;
    
53. alter database drop logfile group 3;
    
54. 
    
55. alter database add logfile group 3 size 60M ;
    
56. 
    
57. alter database drop logfile group 1;
    
58. 
    
59. alter database add logfile group 1 size 60M ;
    
60. 
    
61. 
    
62. alter database drop logfile group 2;
    
63. 
    
64. alter system switch logfile;
    
65. 
    
66. alter system checkpoint;
    
67. alter database drop logfile group 2;
    
68. 
    
69. alter database add logfile group 2 size 60M ;
    
70. 
    
71. alter  database add logfile member '/u01/app/oracle/redo01c.log' to group 1;
    
72. 
    
73. alter  database add logfile member '/u01/app/oracle/redo02c.log' to group 2;
    
74. 
    
75. alter database drop logfile  member '/u01/app/oracle/redo01c.log';
    
76. 
    
77. alter  database drop logfile member '/u01/app/oracle/redo02c.log';
    
78. 
    
79. select  resetlogs_change#, checkpoint_change# , current_scn from v$database;
    
80. 
    
81. select  * from v$database_incarnation;
    
82. 
    
83. select  * from v$logfile;
    
84. 
    
85. 
    
86. select  * from v$log;
    
87. 
    
88. alter database add logfile group 4  ('/u01/app/oracle/redo04a.log','/u01/app/oracle/redo04b.log')
    
89.   size 60M  ;
    
90.   
    
91.   alter system archive log current;
    
92.   
    
93.   alter database drop logfile member '/u01/app/oracle/redo04b.log';
    
94.   
    
95.   alter database add logfile member '/u01/app/oracle/redo04b.log' to group 4;
    
96.   ---
    
97.   
    
98.   select  * from v$archived_log;
    
99.   
    
100.   
     
101.   
     
102.    

复制代码

rcat换控制文件：

1. [oracle@station90 oracle]$ . oraenv
   
2. ORACLE_SID = [orcl] ? rcat
   
3. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
   
4. [oracle@station90 oracle]$ sqlplus /nolog
   
5. 
   
6. SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 27 16:41:27 2016
   
7. 
   
8. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
9. 
   
10. SQL> conn / as sysdba
    
11. Connected.
    
12. SQL> show parameter db_recovery
    
13. 
    
14. NAME                                     TYPE         VALUE
    
15. ------------------------------------ ----------- ------------------------------
    
16. db_recovery_file_dest                     string         /u01/app/oracle/flash_recovery
    
17.                                                  _area
    
18. db_recovery_file_dest_size             big integer 3882M
    
19. SQL> exit
    
20. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
21. With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
22. [oracle@station90 oracle]$ cd /u01/app/oracle/flash_recovery_area/
    
23. [oracle@station90 flash_recovery_area]$ LS
    
24. -bash: LS: command not found
    
25. [oracle@station90 flash_recovery_area]$ ls
    
26. rcat  RCAT
    
27. [oracle@station90 flash_recovery_area]$ cd RCAT
    
28. [oracle@station90 RCAT]$ ls
    
29. onlinelog
    
30. [oracle@station90 RCAT]$ sqlplus /nolog
    
31. 
    
32. SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 27 16:47:38 2016
    
33. 
    
34. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
35. 
    
36. SQL> conn / as sysdba
    
37. Connected.
    
38. SQL> show parameter db_create_file_dest
    
39. 
    
40. NAME                                     TYPE         VALUE
    
41. ------------------------------------ ----------- ------------------------------
    
42. db_create_file_dest                     string         /u01/app/oracle/oradata
    
43. SQL> exit
    
44. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
45. With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
46. [oracle@station90 RCAT]$ cd /u01/app/oracle/oradata/
    
47. [oracle@station90 oradata]$ ls
    
48. rcat  RCAT
    
49. [oracle@station90 oradata]$ cd RCAT
    
50. [oracle@station90 RCAT]$ ls
    
51. datafile
    
52. [oracle@station90 RCAT]$ cd datafile/
    
53. [oracle@station90 datafile]$ ls
    
54. o1_mf_botangtb_d2y1ddb3_.dbf  o1_mf_botangtb_d2y1dgbs_.dbf
    
55. [oracle@station90 datafile]$ cd
    
56. [oracle@station90 ~]$ sqlplus /nolog
    
57. 
    
58. SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 27 16:50:20 2016
    
59. 
    
60. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
61. 
    
62. SQL> conn / as sysdba
    
63. Connected.
    
64. SQL> create tablespace tbs1 ;
    
65. 
    
66. Tablespace created.
    
67. 
    
68. SQL> exit
    
69. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
70. With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
71. [oracle@station90 ~]$ ls
    
72. afiedt.buf               oradiag_oracle        reset_JSON                                   shrink.sh                 公共的
    
73. apex                     oraInventory          reset_rest                                   shrink_undo.sql           模板
    
74. app                      ords                  reset_soup                                   sqldeveloper              视频
    
75. copytape-root.sh         ords.sh               reset_soup_apex_only                         s_rest.zip                图片
    
76. create_t04209_uname.sql  osb.txt               reset_sqldev                                 sysaux01.dbf              文档
    
77. derby.log                pdb_open_says_me.sql  reset_xmldb                                  tnsnames.ora              下载
    
78. mail                     p.sql                 restclient-ui-3.1-jar-with-dependencies.jar  ttio.rcv                  音乐
    
79. one_time_setup.sql       rac_tns               revertape-root.sh                            update2_t04209_uname.sql  桌面
    
80. oracle                   reset_apex            select_t04209_uname.sql                      update_t04209_uname.sql
    
81. [oracle@station90 ~]$ cd /u01/app/oracle/oradata/
    
82. [oracle@station90 oradata]$ ls
    
83. rcat  RCAT
    
84. [oracle@station90 oradata]$ cd RCAT/
    
85. [oracle@station90 RCAT]$ ls
    
86. datafile
    
87. [oracle@station90 RCAT]$ cd datafile/
    
88. [oracle@station90 datafile]$ ls
    
89. o1_mf_botangtb_d2y1ddb3_.dbf  o1_mf_botangtb_d2y1dgbs_.dbf  o1_mf_tbs1_d3o7ln9p_.dbf
    
90. [oracle@station90 datafile]$ du -sh o1_mf_tbs1_d3o7ln9p_.dbf
    
91. 101M        o1_mf_tbs1_d3o7ln9p_.dbf
    
92. [oracle@station90 datafile]$ sqlplus /nolog
    
93. 
    
94. SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 27 16:51:41 2016
    
95. 
    
96. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
97. 
    
98. SQL> conn / as sysdba
    
99. Connected.
    
100. SQL> show parameter db_create
     
101. 
     
102. NAME                                     TYPE         VALUE
     
103. ------------------------------------ ----------- ------------------------------
     
104. db_create_file_dest                     string         /u01/app/oracle/oradata
     
105. db_create_online_log_dest_1             string
     
106. db_create_online_log_dest_2             string
     
107. db_create_online_log_dest_3             string
     
108. db_create_online_log_dest_4             string
     
109. db_create_online_log_dest_5             string
     
110. SQL> alter system set db_create_file_dest='';
     
111. 
     
112. System altered.
     
113. 
     
114. SQL> create tablespace tbs2 ;
     
115. create tablespace tbs2
     
116.                       *
     
117. ERROR at line 1:
     
118. ORA-02199: missing DATAFILE/TEMPFILE clause
     
119. 
     
120. 
     
121. SQL> exit
     
122. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
123. With the Partitioning, OLAP, Data Mining and Real Application Testing options
     
124. [oracle@station90 datafile]$ rman target /
     
125. 
     
126. Recovery Manager: Release 11.2.0.1.0 - Production on Sun Nov 27 16:52:23 2016
     
127. 
     
128. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
129. 
     
130. connected to target database: RCAT (DBID=590260915)
     
131. 
     
132. RMAN> backup tablespace sysaux ;
     
133. 
     
134. Starting backup at 27-NOV-16
     
135. using target database control file instead of recovery catalog
     
136. allocated channel: ORA_DISK_1
     
137. channel ORA_DISK_1: SID=623 device type=DISK
     
138. channel ORA_DISK_1: starting full datafile backup set
     
139. channel ORA_DISK_1: specifying datafile(s) in backup set
     
140. input datafile file number=00002 name=/u01/app/oracle/oradata/rcat/sysaux01.dbf
     
141. channel ORA_DISK_1: starting piece 1 at 27-NOV-16
     
142. channel ORA_DISK_1: finished piece 1 at 27-NOV-16
     
143. piece handle=/u01/app/oracle/flash_recovery_area/RCAT/backupset/2016_11_27/o1_mf_nnndf_TAG20161127T165231_d3o7phr4_.bkp tag=TAG20161127T165231 comment=NONE
     
144. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
     
145. Finished backup at 27-NOV-16
     
146. 
     
147. RMAN> exit
     
148. 
     
149. 
     
150. Recovery Manager complete.
     
151. [oracle@station90 datafile]$ cd /u01/app/
     
152. [oracle@station90 app]$ ls
     
153. oracle  oraInventory
     
154. [oracle@station90 app]$ cd oracle/
     
155. [oracle@station90 oracle]$ ls
     
156. admin        cfgtoollogs  diag                 man_recovery_area      oradata  redo01c.log  temp02.dbf
     
157. botangdir01  checkpoints  flash_recovery_area  man_recovery_area.11g  product  redo02c.log  wallet
     
158. [oracle@station90 oracle]$ cd flash_recovery_area/
     
159. [oracle@station90 flash_recovery_area]$ ls
     
160. rcat  RCAT
     
161. [oracle@station90 flash_recovery_area]$ cd RCAT/
     
162. [oracle@station90 RCAT]$ ls
     
163. backupset  onlinelog
     
164. [oracle@station90 RCAT]$ sqlplus /nolog
     
165. 
     
166. SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 27 16:53:15 2016
     
167. 
     
168. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
169. 
     
170. SQL> conn / as sysdba
     
171. Connected.
     
172. SQL> alter system switch logfile;
     
173. 
     
174. System altered.
     
175. 
     
176. SQL> exit
     
177. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
178. With the Partitioning, OLAP, Data Mining and Real Application Testing options
     
179. [oracle@station90 RCAT]$ ls
     
180. archivelog  backupset  onlinelog
     
181. [oracle@station90 RCAT]$ cd archivelog
     
182. [oracle@station90 archivelog]$ ls
     
183. 2016_11_27
     
184. [oracle@station90 archivelog]$ cd 2016_11_27
     
185. [oracle@station90 2016_11_27]$ ls
     
186. o1_mf_1_18_d3o7r6cn_.arc
     
187. [oracle@station90 2016_11_27]$ sqlplus /nolog
     
188. 
     
189. SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 27 16:55:15 2016
     
190. 
     
191. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
192. 
     
193. SQL> conn / as sysdba
     
194. Connected.
     
195. SQL> set linesize 1000
     
196. SQL> select  * from v$log;
     
197. 
     
198.     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE          MEMBERS ARC STATUS               FIRST_CHANGE# FIRST_TIME         NEXT_CHANGE# NEXT_TIME
     
199. ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ ------------ ------------------
     
200.          1            1              19   52428800           512                1 NO  CURRENT                     1391912 27-NOV-16                  2.8147E+14
     
201.          2            1              17   52428800           512                1 YES INACTIVE                     1365146 26-NOV-16                     1379922 27-NOV-16
     
202.          3            1              18   52428800           512                1 YES ACTIVE                     1379922 27-NOV-16                     1391912 27-NOV-16
     
203. 
     
204. SQL> select  member from v$logfile;
     
205. 
     
206. MEMBER
     
207. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
208. /u01/app/oracle/oradata/rcat/redo03.log
     
209. /u01/app/oracle/oradata/rcat/redo02.log
     
210. /u01/app/oracle/oradata/rcat/redo01.log
     
211. 
     
212. SQL> alter database add logfile group 4 size 52428800;
     
213. 
     
214. Database altered.
     
215. 
     
216. SQL> select  member from v$logfile;
     
217. 
     
218. MEMBER
     
219. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
220. /u01/app/oracle/oradata/rcat/redo03.log
     
221. /u01/app/oracle/oradata/rcat/redo02.log
     
222. /u01/app/oracle/oradata/rcat/redo01.log
     
223. /u01/app/oracle/flash_recovery_area/RCAT/onlinelog/o1_mf_4_d3o7xbf6_.log
     
224. 
     
225. SQL> show parameter db_create
     
226. 
     
227. NAME                                     TYPE         VALUE
     
228. ------------------------------------ ----------- ------------------------------
     
229. db_create_file_dest                     string
     
230. db_create_online_log_dest_1             string
     
231. db_create_online_log_dest_2             string
     
232. db_create_online_log_dest_3             string
     
233. db_create_online_log_dest_4             string
     
234. db_create_online_log_dest_5             string
     
235. SQL> alter database add logfile group 5 ('/u01/app/oracle/redo05a.log','/u01/app/oracle/redo05b.log') size 52428800;
     
236. 
     
237. Database altered.
     
238. 
     
239. SQL> select  member from v$logfile;
     
240. 
     
241. MEMBER
     
242. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     
243. /u01/app/oracle/oradata/rcat/redo03.log
     
244. /u01/app/oracle/oradata/rcat/redo02.log
     
245. /u01/app/oracle/oradata/rcat/redo01.log
     
246. /u01/app/oracle/flash_recovery_area/RCAT/onlinelog/o1_mf_4_d3o7xbf6_.log
     
247. /u01/app/oracle/redo05a.log
     
248. /u01/app/oracle/redo05b.log
     
249. 
     
250. 6 rows selected.
     
251. 
     
252. SQL> show parameter control
     
253. 
     
254. NAME                                     TYPE         VALUE
     
255. ------------------------------------ ----------- ------------------------------
     
256. control_file_record_keep_time             integer         7
     
257. control_files                             string         /u01/app/oracle/oradata/rcat/c
     
258.                                                  ontrol01.ctl, /u01/app/oracle/
     
259.                                                  flash_recovery_area/rcat/contr
     
260.                                                  ol02.ctl
     
261. control_management_pack_access             string         DIAGNOSTIC+TUNING
     
262. SQL> alter system set control_files='/u01/app/oracle/oradata/rcat/control01.ctl','/u01/app/oracle/flash_recovery_area/rcat/control02.ctl','/u01/app/oracle/control03.ctl'  ;
     
263. alter system set control_files='/u01/app/oracle/oradata/rcat/control01.ctl','/u01/app/oracle/flash_recovery_area/rcat/control02.ctl','/u01/app/oracle/control03.ctl'
     
264.                  *
     
265. ERROR at line 1:
     
266. ORA-02095: specified initialization parameter cannot be modified
     
267. 
     
268. 
     
269. SQL> alter system set control_files='/u01/app/oracle/oradata/rcat/control01.ctl','/u01/app/oracle/flash_recovery_area/rcat/control02.ctl','/u01/app/oracle/control03.ctl'  scope=spfile;
     
270. 
     
271. System altered.
     
272. 
     
273. SQL> shutdown abort
     
274. ORACLE instance shut down.
     
275. SQL> exit
     
276. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
277. With the Partitioning, OLAP, Data Mining and Real Application Testing options
     
278. [oracle@station90 2016_11_27]$ cp /u01/app/oracle/oradata/rcat/control01.ctl   /u01/app/oracle/control03.ctl
     
279. [oracle@station90 2016_11_27]$ sqlplus /nolog
     
280. 
     
281. SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 27 17:04:02 2016
     
282. 
     
283. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
284. 
     
285. SQL> conn / as sysdba
     
286. Connected to an idle instance.
     
287. SQL> startup
     
288. ORACLE instance started.
     
289. 
     
290. Total System Global Area 1603411968 bytes
     
291. Fixed Size                    2213776 bytes
     
292. Variable Size                  503318640 bytes
     
293. Database Buffers         1090519040 bytes
     
294. Redo Buffers                    7360512 bytes
     
295. Database mounted.
     
296. Database opened.
     
297. SQL> show paramter control
     
298. SP2-0158: unknown SHOW option "paramter"
     
299. SP2-0158: unknown SHOW option "control"
     
300. SQL> show parameter control
     
301. 
     
302. NAME                                     TYPE         VALUE
     
303. ------------------------------------ ----------- ------------------------------
     
304. control_file_record_keep_time             integer         7
     
305. control_files                             string         /u01/app/oracle/oradata/rcat/c
     
306.                                                  ontrol01.ctl, /u01/app/oracle/
     
307.                                                  flash_recovery_area/rcat/contr
     
308.                                                  ol02.ctl, /u01/app/oracle/cont
     
309.                                                  rol03.ctl
     
310. control_management_pack_access             string         DIAGNOSTIC+TUNING
     
311. SQL> shutdown immediate
     
312. Database closed.
     
313. Database dismounted.
     
314. ORACLE instance shut down.
     
315. SQL> exit
     
316. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
317. With the Partitioning, OLAP, Data Mining and Real Application Testing options
     
318. [oracle@station90 2016_11_27]$ rm /u01/app/oracle/control03.ctl
     
319. [oracle@station90 2016_11_27]$ sqlplus /nolog
     
320. 
     
321. SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 27 17:04:59 2016
     
322. 
     
323. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
324. 
     
325. SQL> conn / as sysdba
     
326. Connected to an idle instance.
     
327. SQL> startup
     
328. ORACLE instance started.
     
329. 
     
330. Total System Global Area 1603411968 bytes
     
331. Fixed Size                    2213776 bytes
     
332. Variable Size                  503318640 bytes
     
333. Database Buffers         1090519040 bytes
     
334. Redo Buffers                    7360512 bytes
     
335. ORA-00205: error in identifying control file, check alert log for more info
     
336. 
     
337. 
     
338. SQL> exit
     
339. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
340. With the Partitioning, OLAP, Data Mining and Real Application Testing options
     
341. [oracle@station90 2016_11_27]$ cp /u01/app/oracle/oradata/rcat/control01.ctl   /u01/app/oracle/control03.ctl
     
342. [oracle@station90 2016_11_27]$ sqlplus /nolog
     
343. 
     
344. SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 27 17:05:54 2016
     
345. 
     
346. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
347. 
     
348. SQL> conn / as sysdba
     
349. Connected.
     
350. SQL> alter database mount;
     
351. 
     
352. Database altered.
     
353. 
     
354. SQL> alter database open ;
     
355. 
     
356. Database altered.
     
357. 
     
358. SQL> exit
     
359. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
360. With the Partitioning, OLAP, Data Mining and Real Application Testing options
     
361. [oracle@station90 2016_11_27]$ cd /u01/app/oracle/
     
362. [oracle@station90 oracle]$ ls
     
363. admin         cfgtoollogs    control_orcl.ctl     man_recovery_area      product      redo04a.log  redo05b.log
     
364. archived_log  checkpoints    diag                 man_recovery_area.11g  redo01c.log  redo04b.log  temp02.dbf
     
365. botangdir01   control03.ctl  flash_recovery_area  oradata                redo02c.log  redo05a.log  wallet
     
366. [oracle@station90 oracle]$ cd archived_log/
     
367. [oracle@station90 archived_log]$ ls
     
368. 1_149_816169635.dbf
     
369. [oracle@station90 archived_log]$
     

复制代码

ASM命令：

1. [root@station90 桌面]# su - oracle
   
2. [oracle@station90 ~]$ . oraenv
   
3. ORACLE_SID = [orcl] ? +ASM
   
4. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
   
5. [oracle@station90 ~]$ sqlplus /nolog
   
6. 
   
7. SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 27 16:43:27 2016
   
8. 
   
9. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
10. 
    
11. SQL> conn /  as sysdba
    
12. Connected.
    
13. SQL> desc v$asm_diskgroup
    
14. Name                                           Null?    Type
    
15. ----------------------------------------- -------- ----------------------------
    
16. GROUP_NUMBER                                            NUMBER
    
17. NAME                                                    VARCHAR2(30)
    
18. SECTOR_SIZE                                            NUMBER
    
19. BLOCK_SIZE                                            NUMBER
    
20. ALLOCATION_UNIT_SIZE                                    NUMBER
    
21. STATE                                                    VARCHAR2(11)
    
22. TYPE                                                    VARCHAR2(6)
    
23. TOTAL_MB                                            NUMBER
    
24. FREE_MB                                            NUMBER
    
25. HOT_USED_MB                                            NUMBER
    
26. COLD_USED_MB                                            NUMBER
    
27. REQUIRED_MIRROR_FREE_MB                            NUMBER
    
28. USABLE_FILE_MB                                     NUMBER
    
29. OFFLINE_DISKS                                            NUMBER
    
30. COMPATIBILITY                                            VARCHAR2(60)
    
31. DATABASE_COMPATIBILITY                             VARCHAR2(60)
    
32. VOTING_FILES                                            VARCHAR2(1)
    
33. 
    
34. SQL> select USABLE_FILE_MB , GROUP_NUMBER  , NAME  from v$asm_diskgroup;
    
35. 
    
36. USABLE_FILE_MB GROUP_NUMBER
    
37. -------------- ------------
    
38. NAME
    
39. --------------------------------------------------------------------------------
    
40.            426                  1
    
41. DATA
    
42. 
    
43.            441                  2
    
44. FRA
    
45. 
    
46. 
    
47. SQL> select USABLE_FILE_MB , TOTAL_MB,    GROUP_NUMBER  , NAME  from v$asm_diskgroup;
    
48. 
    
49. USABLE_FILE_MB         TOTAL_MB GROUP_NUMBER
    
50. -------------- ---------- ------------
    
51. NAME
    
52. --------------------------------------------------------------------------------
    
53.            426             5784             1
    
54. DATA
    
55. 
    
56.            441             2892             2
    
57. FRA
    
58. 
    
59. 
    
60. SQL> select USABLE_FILE_MB , TOTAL_MB,  FREE_MB,     GROUP_NUMBER  , NAME  from v$asm_diskgroup;
    
61. 
    
62. USABLE_FILE_MB         TOTAL_MB    FREE_MB GROUP_NUMBER
    
63. -------------- ---------- ---------- ------------
    
64. NAME
    
65. --------------------------------------------------------------------------------
    
66.            426             5784        1566                1
    
67. DATA
    
68. 
    
69.            441             2892         441                2
    
70. FRA
    
71. 
    
72. 
    
73. SQL> select USABLE_FILE_MB , TOTAL_MB,  FREE_MB,     GROUP_NUMBER  , NAME , TYPE  from v$asm_diskgroup;
    
74. 
    
75. USABLE_FILE_MB         TOTAL_MB    FREE_MB GROUP_NUMBER
    
76. -------------- ---------- ---------- ------------
    
77. NAME
    
78. --------------------------------------------------------------------------------
    
79. TYPE
    
80. ------------------
    
81.            426             5784        1566                1
    
82. DATA
    
83. NORMAL
    
84. 
    
85.            441             2892         441                2
    
86. FRA
    
87. EXTERN
    
88. 
    
89. USABLE_FILE_MB         TOTAL_MB    FREE_MB GROUP_NUMBER
    
90. -------------- ---------- ---------- ------------
    
91. NAME
    
92. --------------------------------------------------------------------------------
    
93. TYPE
    
94. ------------------
    
95. 
    
96. 
    
97. SQL> exit
    
98. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
99. With the Automatic Storage Management option
    
100. [oracle@station90 ~]$ asmcmd
     
101. ASMCMD> ls
     
102. DATA/
     
103. FRA/
     
104. ASMCMD> cd FRA/
     
105. ASMCMD> ls
     
106. ORCL/
     
107. ASMCMD> cd ORCL/
     
108. ASMCMD> ls
     
109. ARCHIVELOG/
     
110. AUTOBACKUP/
     
111. CHANGETRACKING/
     
112. CONTROLFILE/
     
113. ONLINELOG/
     
114. ASMCMD> cd CONTROLFILE/
     
115. ASMCMD> ls
     
116. Current.256.816169633
     
117. ASMCMD> cp Current.256.816169633  /u01/app/oracle/control_orcl.ctl
     
118. copying +FRA/ORCL/CONTROLFILE/Current.256.816169633 -> /u01/app/oracle/control_orcl.ctl
     
119. ASMCMD> cd +DATA
     
120. ASMCMD> ls
     
121. ASM/
     
122. ORCL/
     
123. ASMCMD> help
     
124.         asmcmd [-vV] [-a <sysasm|sysdba>] [-p] [command]
     
125. 
     
126.         The environment variables ORACLE_HOME and ORACLE_SID determine the
     
127.         instance to which the program connects, and ASMCMD establishes a
     
128.         bequeath connection to it, in the same manner as a SQLPLUS / AS
     
129.         SYSASM.  The user must be a member of the OSASM group.
     
130. 
     
131.         Specifying the -V option prints the asmcmd version number and
     
132.         exits immediately.
     
133. 
     
134.         Specifying the -v option prints extra information that can help
     
135.         advanced users diagnose problems.
     
136. 
     
137.         Specify the -a option to choose the type of connection. There are
     
138.         only two possibilities: connecting as SYSASM or as SYSDBA.
     
139.         The default value if this option is unspecified is SYSASM.
     
140. 
     
141.         Specifying the -p option allows the current directory to be displayed
     
142.         in the command prompt, like so:
     
143. 
     
144.         ASMCMD [+DATA/ORCL/CONTROLFILE] >
     
145. 
     
146.         [command] specifies one of the following commands, along with its
     
147.         parameters.
     
148. 
     
149.         Type "help [command]" to get help on a specific ASMCMD command.
     
150. 
     
151.         commands:
     
152.         --------
     
153. 
     
154.         md_backup, md_restore
     
155. 
     
156.         lsattr, setattr
     
157. 
     
158.         cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias
     
159.         mkdir, pwd, rm, rmalias
     
160. 
     
161.         chdg, chkdg, dropdg, iostat, lsdsk, lsod, mkdg, mount
     
162.         offline, online, rebal, remap, umount
     
163. 
     
164.         dsget, dsset, lsop, shutdown, spbackup, spcopy, spget
     
165.         spmove, spset, startup
     
166. 
     
167.         chtmpl, lstmpl, mktmpl, rmtmpl
     
168. 
     
169.         chgrp, chmod, chown, groups, grpmod, lsgrp, lspwusr, lsusr
     
170.         mkgrp, mkusr, orapwusr, passwd, rmgrp, rmusr
     
171. 
     
172.         volcreate, voldelete, voldisable, volenable, volinfo
     
173.         volresize, volset, volstat
     
174. 
     
175. ASMCMD> ls
     
176. ASM/
     
177. ORCL/
     
178. ASMCMD> cd orcl
     
179. ASMCMD> ls
     
180. CONTROLFILE/
     
181. DATAFILE/
     
182. ONLINELOG/
     
183. PARAMETERFILE/
     
184. TEMPFILE/
     
185. spfileorcl.ora
     
186. ASMCMD> cd ONLINELOG/
     
187. ASMCMD> ls
     
188. group_1.261.929017499
     
189. group_2.262.929017663
     
190. group_3.263.929017431
     
191. ASMCMD> rm group_3.263.929017431
     
192. ORA-15032: not all alterations performed
     
193. ORA-15028: ASM file '+DATA/orcl/ONLINELOG/group_3.263.929017431' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
     
194. ASMCMD>
     
195. ASMCMD> ls
     
196. group_1.261.929017499
     
197. group_2.262.929017663
     
198. group_3.263.929017431
     
199. ASMCMD> cd ..
     
200. ASMCMD> ls
     
201. CONTROLFILE/
     
202. DATAFILE/
     
203. ONLINELOG/
     
204. PARAMETERFILE/
     
205. TEMPFILE/
     
206. spfileorcl.ora
     
207. ASMCMD> cd ..
     
208. ASMCMD> ls
     
209. ASM/
     
210. ORCL/
     
211. ASMCMD> cd ..
     
212. ASMCMD> ls
     
213. DATA/
     
214. FRA/
     
215. ASMCMD> cd FRA
     
216. ASMCMD> ls
     
217. ORCL/
     
218. ASMCMD> cd orcl
     
219. ASMCMD> ls
     
220. ARCHIVELOG/
     
221. AUTOBACKUP/
     
222. CHANGETRACKING/
     
223. CONTROLFILE/
     
224. ONLINELOG/
     
225. ASMCMD> cd ARCHIVELOG/
     
226. ASMCMD> ls
     
227. 2013_12_11/
     
228. 2016_11_14/
     
229. 2016_11_15/
     
230. 2016_11_16/
     
231. 2016_11_17/
     
232. 2016_11_18/
     
233. 2016_11_19/
     
234. 2016_11_20/
     
235. 2016_11_21/
     
236. 2016_11_22/
     
237. 2016_11_23/
     
238. 2016_11_24/
     
239. 2016_11_25/
     
240. 2016_11_26/
     
241. 2016_11_27/
     
242. ASMCMD> ls  
     
243. 2016_11_26/
     
244. 2016_11_27/
     
245. ASMCMD> ls
     
246. 2016_11_26/
     
247. 2016_11_27/
     
248. ASMCMD> ls
     
249. 2016_11_26/
     
250. 2016_11_27/
     
251. ASMCMD> ls
     
252. 2016_11_27/
     
253. ASMCMD> ls
     
254. 2016_11_27/
     
255. ASMCMD> ls
     
256. 2016_11_27/
     
257. ASMCMD> l;s
     
258.         commands:
     
259.         --------
     
260. 
     
261.         md_backup, md_restore
     
262. 
     
263.         lsattr, setattr
     
264. 
     
265.         cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias
     
266.         mkdir, pwd, rm, rmalias
     
267. 
     
268.         chdg, chkdg, dropdg, iostat, lsdsk, lsod, mkdg, mount
     
269.         offline, online, rebal, remap, umount
     
270. 
     
271.         dsget, dsset, lsop, shutdown, spbackup, spcopy, spget
     
272.         spmove, spset, startup
     
273. 
     
274.         chtmpl, lstmpl, mktmpl, rmtmpl
     
275. 
     
276.         chgrp, chmod, chown, groups, grpmod, lsgrp, lspwusr, lsusr
     
277.         mkgrp, mkusr, orapwusr, passwd, rmgrp, rmusr
     
278. 
     
279.         volcreate, voldelete, voldisable, volenable, volinfo
     
280.         volresize, volset, volstat
     
281. 
     
282. ASMCMD> ls
     
283. ASMCMD-08002: entry 'ARCHIVELOG' does not exist in directory '+FRA/orcl/'
     
284. ASMCMD> ls
     
285. ASMCMD-08002: entry 'ARCHIVELOG' does not exist in directory '+FRA/orcl/'
     
286. ASMCMD> ls
     
287. 2016_11_27/
     
288. ASMCMD> cd ..
     
289. ASMCMD> ls
     
290. ARCHIVELOG/
     
291. AUTOBACKUP/
     
292. CHANGETRACKING/
     
293. CONTROLFILE/
     
294. ONLINELOG/
     
295. ASMCMD> pwd
     
296. +FRA/orcl
     
297. ASMCMD> ls
     
298. ARCHIVELOG/
     
299. AUTOBACKUP/
     
300. CHANGETRACKING/
     
301. CONTROLFILE/
     
302. ONLINELOG/
     
303. ASMCMD> cd ARCHIVELOG/
     
304. ASMCMD> ls
     
305. 2016_11_27/
     
306. ASMCMD> cd 2016_11_27/
     
307. ASMCMD> ls
     
308. thread_1_seq_141.392.929035007
     
309. thread_1_seq_142.390.929035009
     
310. thread_1_seq_143.389.929035009
     
311. thread_1_seq_144.388.929035009
     
312. thread_1_seq_145.387.929035065
     
313. thread_1_seq_146.386.929035073
     
314. thread_1_seq_147.385.929035077
     
315. thread_1_seq_148.384.929035193
     
316. ASMCMD> ls
     
317. thread_1_seq_141.392.929035007
     
318. thread_1_seq_142.390.929035009
     
319. thread_1_seq_143.389.929035009
     
320. thread_1_seq_144.388.929035009
     
321. thread_1_seq_145.387.929035065
     
322. thread_1_seq_146.386.929035073
     
323. thread_1_seq_147.385.929035077
     
324. thread_1_seq_148.384.929035193
     
325. thread_1_seq_149.382.929037395
     
326. ASMCMD>
     

复制代码

第二路归档：

1. NAME                                     TYPE         VALUE
   
2. ------------------------------------ ----------- ------------------------------
   
3. log_archive_duplex_dest              string
   
4. SQL> alter system set log_archive_dest_1='location=use_db_recovery_file_dest';
   
5. 
   
6. System altered.
   
7. 
   
8. SQL> alter system set log_archive_dest_2='location=/u01/app/oracle/archived_log';
   
9. 
   
10. System altered.
    
11. 
    
12. SQL> alter system archive log current ;
    
13. 
    
14. System altered.
    
15. 
    
16. SQL>
    

复制代码