课程第14次（2018-06-26星期二）

botang

从文件系统进ASM：

1. select  * from v$log;
   
2. 
   
3. alter database drop logfile group 3;
   
4. 
   
5. alter database add logfile group 3 size 50M;
   
6. 
   
7. select  member from v$logfile;
   
8. 
   
9. alter database drop logfile group 1;
   
10. 
    
11. 
    
12. alter database add logfile group 1 size 50M;
    
13. 
    
14. alter system switch logfile;
    
15. 
    
16. alter system checkpoint;
    
17. 
    
18. alter database drop logfile group 2;
    
19. 
    
20. alter database add logfile group 2 size 50M;
    
21. 
    
22. ------------------------------------------------------------------
    
23. 
    

复制代码

1. SQL> startup mount
   
2. ORACLE instance started.
   
3. 
   
4. Total System Global Area 1046224896 bytes
   
5. Fixed Size                    1341140 bytes
   
6. Variable Size                  603982124 bytes
   
7. Database Buffers          436207616 bytes
   
8. Redo Buffers                    4694016 bytes
   
9. ORA-00205: error in identifying control file, check alert log for more info
   
10. 
    
11. 
    
12. SQL> show parameter control
    
13. 
    
14. NAME                                     TYPE
    
15. ------------------------------------ ---------------------------------
    
16. VALUE
    
17. ------------------------------
    
18. control_file_record_keep_time             integer
    
19. 7
    
20. control_files                             string
    
21. /u01/app/oracle/product/11.2.0
    
22. /dbhome_1/dbs/cntrlorcl.dbf
    
23. control_management_pack_access             string
    
24. DIAGNOSTIC+TUNING
    
25. SQL> alter system set control_files='/u01/app/oracle/oradata/orcl/control01.ctl' scope=spfile;
    
26. 
    
27. System altered.
    
28. 
    
29. SQL> shutdown immediate
    
30. ORA-01507: database not mounted
    
31. 
    
32. 
    
33. ORACLE instance shut down.
    
34. SQL> startup mount
    
35. ORACLE instance started.
    
36. 
    
37. Total System Global Area 1046224896 bytes
    
38. Fixed Size                    1341140 bytes
    
39. Variable Size                  603982124 bytes
    
40. Database Buffers          436207616 bytes
    
41. Redo Buffers                    4694016 bytes
    
42. Database mounted.
    
43. SQL> exit
    
44. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
    
45. With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
46. [oracle@station86 dbs]$ rman target /
    
47. 
    
48. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 26 19:54:12 2018
    
49. 
    
50. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
51. 
    
52. connected to target database: ORCL (DBID=1359978017, not open)
    
53. 
    
54. RMAN> exit
    
55. 
    
56. 
    
57. Recovery Manager complete.
    
58. [oracle@station86 dbs]$ sqlplus /nolog
    
59. 
    
60. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 26 19:54:56 2018
    
61. 
    
62. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
63. 
    
64. SQL> conn / as sysdba
    
65. Connected.
    
66. SQL> show parameter db_recovery
    
67. 
    
68. NAME                                     TYPE         VALUE
    
69. ------------------------------------ ----------- ------------------------------
    
70. db_recovery_file_dest                     string         +FRA
    
71. db_recovery_file_dest_size             big integer 4G
    
72. SQL> alter system set db_recovery_file_dest='+DATA';
    
73. 
    
74. System altered.
    
75. 
    
76. SQL> exit
    
77. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
    
78. With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
79. [oracle@station86 dbs]$ rman target /
    
80. 
    
81. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 26 19:55:20 2018
    
82. 
    
83. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
84. 
    
85. connected to target database: ORCL (DBID=1359978017, not open)
    
86. 
    
87. RMAN> backup as copy database;
    
88. 
    
89. Starting backup at 2018-06-26:19:55:49
    
90. using target database control file instead of recovery catalog
    
91. allocated channel: ORA_DISK_1
    
92. channel ORA_DISK_1: SID=136 device type=DISK
    
93. allocated channel: ORA_DISK_2
    
94. channel ORA_DISK_2: SID=7 device type=DISK
    
95. allocated channel: ORA_DISK_3
    
96. channel ORA_DISK_3: SID=49 device type=DISK
    
97. allocated channel: ORA_DISK_4
    
98. channel ORA_DISK_4: SID=93 device type=DISK
    
99. allocated channel: ORA_DISK_5
    
100. channel ORA_DISK_5: SID=137 device type=DISK
     
101. allocated channel: ORA_DISK_6
     
102. channel ORA_DISK_6: SID=8 device type=DISK
     
103. allocated channel: ORA_DISK_7
     
104. channel ORA_DISK_7: SID=50 device type=DISK
     
105. allocated channel: ORA_DISK_8
     
106. channel ORA_DISK_8: SID=94 device type=DISK
     
107. channel ORA_DISK_1: starting datafile copy
     
108. input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
     
109. channel ORA_DISK_2: starting datafile copy
     
110. input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
     
111. channel ORA_DISK_3: starting datafile copy
     
112. input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs1.dbf
     
113. channel ORA_DISK_4: starting datafile copy
     
114. input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
     
115. channel ORA_DISK_5: starting datafile copy
     
116. input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
     
117. channel ORA_DISK_6: starting datafile copy
     
118. input datafile file number=00006 name=/u01/app/oracle/oradata/orcl/tbs1.dbf
     
119. channel ORA_DISK_7: starting datafile copy
     
120. input datafile file number=00007 name=/u01/app/oracle/oradata/orcl/tbs2.dbf
     
121. output file name=+DATA/orcl/datafile/users.265.979847755 tag=TAG20180626T195551 RECID=17 STAMP=979847767
     
122. channel ORA_DISK_5: datafile copy complete, elapsed time: 00:00:25
     
123. output file name=+DATA/orcl/datafile/tbs1.256.979847755 tag=TAG20180626T195551 RECID=15 STAMP=979847764
     
124. channel ORA_DISK_6: datafile copy complete, elapsed time: 00:00:25
     
125. output file name=+DATA/orcl/datafile/tbs2.257.979847755 tag=TAG20180626T195551 RECID=16 STAMP=979847765
     
126. channel ORA_DISK_7: datafile copy complete, elapsed time: 00:00:26
     
127. output file name=+DATA/orcl/datafile/undotbs1.258.979847755 tag=TAG20180626T195551 RECID=19 STAMP=979847811
     
128. channel ORA_DISK_3: datafile copy complete, elapsed time: 00:01:07
     
129. output file name=+DATA/orcl/datafile/example.259.979847765 tag=TAG20180626T195551 RECID=18 STAMP=979847810
     
130. channel ORA_DISK_4: datafile copy complete, elapsed time: 00:01:07
     
131. output file name=+DATA/orcl/datafile/sysaux.267.979847755 tag=TAG20180626T195551 RECID=20 STAMP=979847825
     
132. channel ORA_DISK_2: datafile copy complete, elapsed time: 00:01:19
     
133. output file name=+DATA/orcl/datafile/system.268.979847755 tag=TAG20180626T195551 RECID=21 STAMP=979847830
     
134. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:29
     
135. Finished backup at 2018-06-26:19:57:20
     
136. 
     
137. Starting Control File and SPFILE Autobackup at 2018-06-26:19:57:20
     
138. piece handle=+DATA/orcl/autobackup/2018_06_26/s_979847323.263.979847841 comment=NONE
     
139. Finished Control File and SPFILE Autobackup at 2018-06-26:19:57:21
     
140. 
     
141. RMAN> switch database to copy ;
     
142. 
     
143. datafile 1 switched to datafile copy "+DATA/orcl/datafile/system.268.979847755"
     
144. datafile 2 switched to datafile copy "+DATA/orcl/datafile/sysaux.267.979847755"
     
145. datafile 3 switched to datafile copy "+DATA/orcl/datafile/undotbs1.258.979847755"
     
146. datafile 4 switched to datafile copy "+DATA/orcl/datafile/users.265.979847755"
     
147. datafile 5 switched to datafile copy "+DATA/orcl/datafile/example.259.979847765"
     
148. datafile 6 switched to datafile copy "+DATA/orcl/datafile/tbs1.256.979847755"
     
149. datafile 7 switched to datafile copy "+DATA/orcl/datafile/tbs2.257.979847755"
     
150. 
     
151. RMAN> exit
     
152. 
     
153. 
     
154. Recovery Manager complete.
     
155. [oracle@station86 dbs]$ sqlplus /nolog
     
156. 
     
157. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 26 19:57:44 2018
     
158. 
     
159. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
160. 
     
161. SQL> conn / as sysdba
     
162. Connected.
     
163. SQL> show parameter db_recovery
     
164. 
     
165. NAME                                     TYPE         VALUE
     
166. ------------------------------------ ----------- ------------------------------
     
167. db_recovery_file_dest                     string         +DATA
     
168. db_recovery_file_dest_size             big integer 4G
     
169. SQL> alter system set db_recovery_file_dest='+FRA';
     
170. 
     
171. System altered.
     
172. 
     
173. SQL>
     

复制代码

1. SQL>
   
2. SQL> alter database backup controlfile to trace as '/home/oracle/control8c-2.sql'
   
3.   2  ;
   
4. 
   
5. Database altered.
   
6. 
   
7. SQL> exit
   

复制代码

control8c-2.sql：

1. CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS  ARCHIVELOG
   
2.     MAXLOGFILES 16
   
3.     MAXLOGMEMBERS 3
   
4.     MAXDATAFILES 100
   
5.     MAXINSTANCES 8
   
6.     MAXLOGHISTORY 292
   
7. LOGFILE
   
8.   GROUP 1 (
   
9.     '+DATA/orcl/onlinelog/group_1.264.979847063',
   
10.     '+FRA/orcl/onlinelog/group_1.320.979847065'
    
11.   ) SIZE 50M BLOCKSIZE 512,
    
12.   GROUP 2 (
    
13.     '+DATA/orcl/onlinelog/group_2.260.979847183',
    
14.     '+FRA/orcl/onlinelog/group_2.350.979847185'
    
15.   ) SIZE 50M BLOCKSIZE 512,
    
16.   GROUP 3 (
    
17.     '+DATA/orcl/onlinelog/group_3.266.979846987',
    
18.     '+FRA/orcl/onlinelog/group_3.294.979846989'
    
19.   ) SIZE 50M BLOCKSIZE 512
    
20. DATAFILE
    
21.   '+DATA/orcl/datafile/system.268.979847755',
    
22.   '+DATA/orcl/datafile/sysaux.267.979847755',
    
23.   '+DATA/orcl/datafile/undotbs1.258.979847755',
    
24.   '+DATA/orcl/datafile/users.265.979847755',
    
25.   '+DATA/orcl/datafile/example.259.979847765',
    
26.   '+DATA/orcl/datafile/tbs1.256.979847755',
    
27.   '+DATA/orcl/datafile/tbs2.257.979847755'
    
28. CHARACTER SET AL32UTF8
    
29. ;
    
30. 
    
31. -- Configure RMAN configuration record 1
    
32. VARIABLE RECNO NUMBER;
    
33. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('RETENTION POLICY','TO RECOVERY WINDOW OF 1 DAYS');
    
34. -- Configure RMAN configuration record 2
    
35. VARIABLE RECNO NUMBER;
    
36. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('BACKUP OPTIMIZATION','ON');
    
37. -- Configure RMAN configuration record 3
    
38. VARIABLE RECNO NUMBER;
    
39. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','ON');
    
40. -- Configure RMAN configuration record 4
    
41. VARIABLE RECNO NUMBER;
    
42. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEVICE TYPE','DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET');
    
43. -- Configure RMAN configuration record 5
    
44. VARIABLE RECNO NUMBER;
    
45. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEFAULT DEVICE TYPE TO','DISK');
    
46. -- Configure RMAN configuration record 6
    
47. VARIABLE RECNO NUMBER;
    
48. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('DEVICE TYPE','''SBT_TAPE'' PARALLELISM 2 BACKUP TYPE TO BACKUPSET');
    
49. -- Configure RMAN configuration record 7
    
50. VARIABLE RECNO NUMBER;
    
51. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','1 DEVICE TYPE ''SBT_TAPE'' PARMS  ''ENV=(OB_MEDIA_FAMILY=station86)''');
    
52. -- Configure RMAN configuration record 8
    
53. VARIABLE RECNO NUMBER;
    
54. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','2 DEVICE TYPE ''SBT_TAPE'' PARMS  ''ENV=(OB_MEDIA_FAMILY=station86)''');
    
55. -- Configure RMAN configuration record 9
    
56. VARIABLE RECNO NUMBER;
    
57. EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','DEVICE TYPE ''SBT_TAPE'' PARMS  ''ENV=(OB_MEDIA_FAMILY=station86)''');
    

复制代码

1. [oracle@station86 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 26 20:02:48 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn  / as sysdba
   
8. Connected.
   
9. SQL> show parameter control
   
10. 
    
11. NAME                                     TYPE         VALUE
    
12. ------------------------------------ ----------- ------------------------------
    
13. control_file_record_keep_time             integer         7
    
14. control_files                             string         /u01/app/oracle/oradata/orcl/c
    
15.                                                  ontrol01.ctl
    
16. control_management_pack_access             string         DIAGNOSTIC+TUNING
    
17. SQL> alter system set control_files='+DATA','+FRA' scope=spfile;
    
18. 
    
19. System altered.
    
20. 
    
21. SQL> shutdown immediate
    
22. ORA-01109: database not open
    
23. 
    
24. 
    
25. Database dismounted.
    
26. ORACLE instance shut down.
    
27. SQL> startup nomount
    
28. ORACLE instance started.
    
29. 
    
30. Total System Global Area 1046224896 bytes
    
31. Fixed Size                    1341140 bytes
    
32. Variable Size                  603982124 bytes
    
33. Database Buffers          436207616 bytes
    
34. Redo Buffers                    4694016 bytes
    
35. SQL> @/home/oracle/control8c-2
    
36. 
    
37. Control file created.
    
38. 
    
39. 
    
40. PL/SQL procedure successfully completed.
    
41. 
    
42. 
    
43. PL/SQL procedure successfully completed.
    
44. 
    
45. 
    
46. PL/SQL procedure successfully completed.
    
47. 
    
48. 
    
49. PL/SQL procedure successfully completed.
    
50. 
    
51. 
    
52. PL/SQL procedure successfully completed.
    
53. 
    
54. 
    
55. PL/SQL procedure successfully completed.
    
56. 
    
57. 
    
58. PL/SQL procedure successfully completed.
    
59. 
    
60. 
    
61. PL/SQL procedure successfully completed.
    
62. 
    
63. 
    
64. PL/SQL procedure successfully completed.
    
65. 
    
66. SQL> alter database open ;
    
67. 
    
68. Database altered.
    
69. 
    
70. SQL> alter tablespace temp add tempfile '+DATA' size 30M autoextend on ;
    
71. 
    
72. Tablespace altered.
    
73. 
    
74. SQL> show parameter spfile;
    
75. 
    
76. NAME                                     TYPE         VALUE
    
77. ------------------------------------ ----------- ------------------------------
    
78. spfile                                     string         /u01/app/oracle/product/11.2.0
    
79.                                                  /dbhome_1/dbs/spfileorcl.ora
    
80. SQL> create pfile='/home/oracle/pfile.ora' from spfile;
    
81. 
    
82. File created.
    
83. 
    
84. SQL> create spfile='+data/orcl/spfileorcl.ora' from pfile='/home/oracle/pfile.ora';
    
85. 
    
86. File created.
    
87. 
    
88. SQL> shutdown immediate
    
89. Database closed.
    
90. Database dismounted.
    
91. ORACLE instance shut down.
    
92. SQL>
    

复制代码

写/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora为spfile='+data/orcl/spfileorcl.ora'
再启动，做完。

1. [oracle@station86 ~]$ srvctl remove  database -d orcl
   
2. Remove the database orcl? (y/[n]) y
   
3. [oracle@station86 ~]$ srvctl add database -d orcl -o /u01/app/oracle/product/11.2.0/dbhome_1
   
4. [oracle@station86 ~]$ crs_stat -t
   
5. Name           Type           Target    State     Host        
   
6. ------------------------------------------------------------
   
7. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station86   
   
8. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station86   
   
9. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station86   
   
10. ora.asm        ora.asm.type   ONLINE    ONLINE    station86   
    
11. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station86   
    
12. ora.diskmon    ora....on.type ONLINE    ONLINE    station86   
    
13. ora.orcl.db    ora....se.type OFFLINE   OFFLINE               
    
14. [oracle@station86 ~]$ crsctl start res ora.orcl.db
    
15. CRS-2672: Attempting to start 'ora.orcl.db' on 'station86'
    

复制代码

关于ASM迁移的最后的讨论：
当时的操作时串行：

1. RMAN>  run {
   
2. 2> allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/system01.dbf';
   
3. 3> backup as copy datafile 1;
   
4. 4> release channel c1;
   
5. 5> allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/sysaux01.dbf';
   
6. 6> backup as copy datafile 2;
   
7. 7> release channel c1;
   
8. 8> allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/undotbs1.dbf';
   
9. 9> backup as copy datafile 3;
   
10. 10> release channel c1;
    
11. 11> allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/users01.dbf';
    
12. 12> backup as copy datafile 4;
    
13. 13> release channel c1;
    
14. 14> allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/example01.dbf';
    
15. 15> backup as copy datafile 5;
    
16. 16> release channel c1;
    
17. 17>  allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/tbs1.dbf';
    
18. 18> backup as copy datafile 6;
    
19. 19> release channel c1;
    
20. 20> allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/tbs2.dbf';
    
21. 21> backup as copy datafile 7;
    
22. 22> release channel c1;
    
23. 23> }

复制代码

做数据文件迁移的时候能改进一下吗：

1. RMAN>  run {
   
2. 2> allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/system01.dbf';
   
3. 3> allocate channel c2 device type disk format '/u01/app/oracle/oradata/orcl/sysaux01.dbf';
   
4. 4> allocate channel c3 device type disk format '/u01/app/oracle/oradata/orcl/undotbs1.dbf';
   
5. 5> allocate channel c4 device type disk format '/u01/app/oracle/oradata/orcl/users01.dbf';
   
6. 6> allocate channel c5 device type disk format '/u01/app/oracle/oradata/orcl/example01.dbf';
   
7. 7>  allocate channel c6 device type disk format '/u01/app/oracle/oradata/orcl/tbs1.dbf';
   
8. 8> allocate channel c7device type disk format '/u01/app/oracle/oradata/orcl/tbs2.dbf';
   
9. 9> backup as copy  database;
   
10. 10>}

复制代码

以上的做法有可能存在通道和输入不是你想要的对应关系：

1.         Tag: ORA_OEM_LEVEL_0
   
2. 
   
3. 
   
4. RMAN> list copy of datafile 5;
   
5. 
   
6. List of Datafile Copies
   
7. =======================
   
8. 
   
9. Key     File S Completion Time     Ckp SCN    Ckp Time           
   
10. ------- ---- - ------------------- ---------- -------------------
    
11. 9       5    A 2018-06-26:20:18:09 1334275    2018-06-26:20:17:12
    
12.         Name: /u01/app/oracle/oradata/orcl/users01.dbf
    
13.         Tag: TAG20180626T201706
    
14. 
    
15. 4       5    A 2018-06-26:20:16:50 1333986    2018-06-26:20:16:40
    
16.         Name: +FRA/orcl/datafile/example.340.979849001
    
17.         Tag: ORA_OEM_LEVEL_0
    
18. 
    
19. 
    
20. RMAN>
    

复制代码

可以提前看一下1Z0-053第8章的解决方案：

1. RMAN> report schema;
   
2. 
   
3. Report of database schema for database with db_unique_name ORCL
   
4. 
   
5. List of Permanent Datafiles
   
6. ===========================
   
7. File Size(MB) Tablespace           RB segs Datafile Name
   
8. ---- -------- -------------------- ------- ------------------------
   
9. 1    690      SYSTEM               ***     +DATA/orcl/datafile/system.268.979847755
   
10. 2    570      SYSAUX               ***     +DATA/orcl/datafile/sysaux.267.979847755
    
11. 3    290      UNDOTBS1             ***     +DATA/orcl/datafile/undotbs1.258.979847755
    
12. 4    5        USERS                ***     +DATA/orcl/datafile/users.265.979847755
    
13. 5    198      EXAMPLE              ***     +DATA/orcl/datafile/example.259.979847765
    
14. 6    5        TBS1                 ***     +DATA/orcl/datafile/tbs1.256.979847755
    
15. 7    5        TBS2                 ***     +DATA/orcl/datafile/tbs2.257.979847755
    
16. 
    
17. List of Temporary Files
    
18. =======================
    
19. File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
    
20. ---- -------- -------------------- ----------- --------------------
    
21. 1    30       TEMP                 32767       +DATA/orcl/tempfile/temp.261.979848279
    
22. 
    

复制代码

1. RMAN> run {
   
2. 2> allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/system01.dbf';
   
3. 3> allocate channel c2 device type disk format '/u01/app/oracle/oradata/orcl/sysaux01.dbf';
   
4. 4> allocate channel c3 device type disk format '/u01/app/oracle/oradata/orcl/undotbs1.dbf';
   
5. 5> allocate channel c4 device type disk format '/u01/app/oracle/oradata/orcl/users01.dbf';
   
6. 6> allocate channel c5 device type disk format '/u01/app/oracle/oradata/orcl/example01.dbf';
   
7. 7> allocate channel c6 device type disk format '/u01/app/oracle/oradata/orcl/tbs1.dbf';
   
8. 8> allocate channel c7 device type disk format '/u01/app/oracle/oradata/orcl/tbs2.dbf';
   
9. 9> backup as copy  (datafile 1 channel c1  )
   
10.                                (datafile 2 channel c2)
    
11.                                (datafile 3 channel c3)
    
12.                                (datafile 4 channel c4)
    
13.                                (datafile 5 channel c5)
    
14.                                (datafile 6  channel c6)
    
15.                                (datafile 7 channel c7) ;
    
16. 10>}

复制代码

1. [oracle@station86 ~]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 26 20:31:26 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1359978017)
   
8. 
   
9. RMAN> list copy of datafile 1;
   
10. 
    
11. using target database control file instead of recovery catalog
    
12. List of Datafile Copies
    
13. =======================
    
14. 
    
15. Key     File S Completion Time     Ckp SCN    Ckp Time           
    
16. ------- ---- - ------------------- ---------- -------------------
    
17. 18      1    A 2018-06-26:20:31:08 1335940    2018-06-26:20:29:58
    
18.         Name: /u01/app/oracle/oradata/orcl/system01.dbf
    
19.         Tag: TAG20180626T202957
    
20. 
    
21. 
    
22. RMAN> list copy of datafile 2;
    
23. 
    
24. List of Datafile Copies
    
25. =======================
    
26. 
    
27. Key     File S Completion Time     Ckp SCN    Ckp Time           
    
28. ------- ---- - ------------------- ---------- -------------------
    
29. 16      2    A 2018-06-26:20:31:06 1335941    2018-06-26:20:29:58
    
30.         Name: /u01/app/oracle/oradata/orcl/sysaux01.dbf
    
31.         Tag: TAG20180626T202957
    
32. 
    
33. 
    
34. RMAN> list copy of datafile 3;
    
35. 
    
36. List of Datafile Copies
    
37. =======================
    
38. 
    
39. Key     File S Completion Time     Ckp SCN    Ckp Time           
    
40. ------- ---- - ------------------- ---------- -------------------
    
41. 19      3    A 2018-06-26:20:31:08 1335944    2018-06-26:20:29:59
    
42.         Name: /u01/app/oracle/oradata/orcl/undotbs1.dbf
    
43.         Tag: TAG20180626T202957
    
44. 
    
45. 
    
46. RMAN> list copy of datafile 4;
    
47. 
    
48. List of Datafile Copies
    
49. =======================
    
50. 
    
51. Key     File S Completion Time     Ckp SCN    Ckp Time           
    
52. ------- ---- - ------------------- ---------- -------------------
    
53. 15      4    A 2018-06-26:20:30:40 1335948    2018-06-26:20:30:02
    
54.         Name: /u01/app/oracle/oradata/orcl/users01.dbf
    
55.         Tag: TAG20180626T202957
    
56. 
    
57. 
    
58. RMAN> list copy of datafile 5;
    
59. 
    
60. List of Datafile Copies
    
61. =======================
    
62. 
    
63. Key     File S Completion Time     Ckp SCN    Ckp Time           
    
64. ------- ---- - ------------------- ---------- -------------------
    
65. 17      5    A 2018-06-26:20:31:08 1335950    2018-06-26:20:30:06
    
66.         Name: /u01/app/oracle/oradata/orcl/example01.dbf
    
67.         Tag: TAG20180626T202957
    
68. 
    
69. 
    
70. RMAN> list copy of datafile 6;
    
71. 
    
72. List of Datafile Copies
    
73. =======================
    
74. 
    
75. Key     File S Completion Time     Ckp SCN    Ckp Time           
    
76. ------- ---- - ------------------- ---------- -------------------
    
77. 20      6    A 2018-06-26:20:31:08 1335963    2018-06-26:20:30:16
    
78.         Name: /u01/app/oracle/oradata/orcl/tbs1.dbf
    
79.         Tag: TAG20180626T202957
    
80. 
    
81. 
    
82. RMAN> list copy of datafile 7;
    
83. 
    
84. List of Datafile Copies
    
85. =======================
    
86. 
    
87. Key     File S Completion Time     Ckp SCN    Ckp Time           
    
88. ------- ---- - ------------------- ---------- -------------------
    
89. 21      7    A 2018-06-26:20:31:08 1335966    2018-06-26:20:30:21
    
90.         Name: /u01/app/oracle/oradata/orcl/tbs2.dbf
    
91.         Tag: TAG20180626T202957
    
92. 
    
93. 
    
94. RMAN> report schema;
    
95. 
    
96. Report of database schema for database with db_unique_name ORCL
    
97. 
    
98. List of Permanent Datafiles
    
99. ===========================
    
100. File Size(MB) Tablespace           RB segs Datafile Name
     
101. ---- -------- -------------------- ------- ------------------------
     
102. 1    690      SYSTEM               ***     +DATA/orcl/datafile/system.268.979847755
     
103. 2    570      SYSAUX               ***     +DATA/orcl/datafile/sysaux.267.979847755
     
104. 3    290      UNDOTBS1             ***     +DATA/orcl/datafile/undotbs1.258.979847755
     
105. 4    5        USERS                ***     +DATA/orcl/datafile/users.265.979847755
     
106. 5    198      EXAMPLE              ***     +DATA/orcl/datafile/example.259.979847765
     
107. 6    5        TBS1                 ***     +DATA/orcl/datafile/tbs1.256.979847755
     
108. 7    5        TBS2                 ***     +DATA/orcl/datafile/tbs2.257.979847755
     
109. 
     
110. List of Temporary Files
     
111. =======================
     
112. File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
     
113. ---- -------- -------------------- ----------- --------------------
     
114. 1    30       TEMP                 32767       +DATA/orcl/tempfile/temp.261.979848279
     
115. 
     
116. RMAN>
     

复制代码

1. RMAN> list failure;
   
2. 
   
3. using target database control file instead of recovery catalog
   
4. List of Database Failures
   
5. =========================
   
6. 
   
7. Failure ID Priority Status    Time Detected       Summary
   
8. ---------- -------- --------- ------------------- -------
   
9. 4268       HIGH     OPEN      2018-06-26:21:11:51 Tablespace 4: 'USERS' is offline
   
10. 
    
11. RMAN> advise failure;
    
12. 
    
13. List of Database Failures
    
14. =========================
    
15. 
    
16. Failure ID Priority Status    Time Detected       Summary
    
17. ---------- -------- --------- ------------------- -------
    
18. 4268       HIGH     OPEN      2018-06-26:21:11:51 Tablespace 4: 'USERS' is offline
    
19. 
    
20. analyzing automatic repair options; this may take some time
    
21. allocated channel: ORA_DISK_1
    
22. channel ORA_DISK_1: SID=105 device type=DISK
    
23. allocated channel: ORA_DISK_2
    
24. channel ORA_DISK_2: SID=147 device type=DISK
    
25. allocated channel: ORA_DISK_3
    
26. channel ORA_DISK_3: SID=16 device type=DISK
    
27. allocated channel: ORA_DISK_4
    
28. channel ORA_DISK_4: SID=48 device type=DISK
    
29. allocated channel: ORA_DISK_5
    
30. channel ORA_DISK_5: SID=104 device type=DISK
    
31. allocated channel: ORA_DISK_6
    
32. channel ORA_DISK_6: SID=148 device type=DISK
    
33. allocated channel: ORA_DISK_7
    
34. channel ORA_DISK_7: SID=13 device type=DISK
    
35. allocated channel: ORA_DISK_8
    
36. channel ORA_DISK_8: SID=53 device type=DISK
    
37. allocated channel: ORA_SBT_TAPE_1
    
38. channel ORA_SBT_TAPE_1: SID=100 device type=SBT_TAPE
    
39. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
40. allocated channel: ORA_SBT_TAPE_2
    
41. channel ORA_SBT_TAPE_2: SID=144 device type=SBT_TAPE
    
42. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
43. analyzing automatic repair options complete
    
44. 
    
45. Mandatory Manual Actions
    
46. ========================
    
47. no manual actions available
    
48. 
    
49. Optional Manual Actions
    
50. =======================
    
51. no manual actions available
    
52. 
    
53. Automated Repair Options
    
54. ========================
    
55. Option Repair Description
    
56. ------ ------------------
    
57. 1      Online tablespace USERS  
    
58.   Strategy: The repair includes complete media recovery with no data loss
    
59.   Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_87746635.hm
    
60. 
    
61. RMAN> repair failure preview;
    
62. 
    
63. Strategy: The repair includes complete media recovery with no data loss
    
64. Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_87746635.hm
    
65. 
    
66. contents of repair script:
    
67.    # online a offline tablespace
    
68.    sql "begin sys.dbms_ir.execsqlscript(filename => ''/u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_2569490396.hm'' ); end;";
    
69. 
    
70. RMAN> repair failure;
    
71. 
    
72. Strategy: The repair includes complete media recovery with no data loss
    
73. Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_87746635.hm
    
74. 
    
75. contents of repair script:
    
76.    # online a offline tablespace
    
77.    sql "begin sys.dbms_ir.execsqlscript(filename => ''/u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_2569490396.hm'' ); end;";
    
78. 
    
79. Do you really want to execute the above repair (enter YES or NO)? YES
    
80. executing repair script
    
81. 
    
82. sql statement: begin sys.dbms_ir.execsqlscript(filename => ''/u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_2569490396.hm'' ); end;
    
83. repair failure complete
    
84. 
    
85. RMAN> exit
    
86. 
    
87. 
    
88. Recovery Manager complete.
    
89. [oracle@station86 ~]$
    

复制代码