活动第21/22次（2018-05-26星期六上下午）

botang

Handle和Media Family以及Volumn的关系：



定制备份，通常这么做：

1. RMAN> backup tag '1T_WHOLE_INCR0' incremental level 0 database plus archivelog not backed up delete all input;

复制代码

Oracle-Suggested Backup strategy：
Use disk to store the most recent database backup and archived logs for fast complete recovery. Use tape to store older backups for an extended recovery window.
天备份：

1. Daily Script:
   
2. run {
   
3. allocate channel oem_disk_backup device type disk;
   
4. recover copy of database with tag 'ORA_OEM_LEVEL_0';
   
5. backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
   
6. release channel oem_disk_backup;
   
7. allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station87)';
   
8. allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station87)';
   
9. backup archivelog all not backed up;
   
10. }
    
11. allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station87)';
    
12. delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
    
13. Weekly Script:
    
14. run {
    
15. allocate channel oem_disk_backup device type disk;
    
16. recover copy of database with tag 'ORA_OEM_LEVEL_0';
    
17. backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
    
18. release channel oem_disk_backup;
    
19. allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station87)';
    
20. allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station87)';
    
21. backup recovery area;
    
22. }
    
23. allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station87)';
    
24. delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
    

复制代码

第一天：

A full database copy will be performed during the first backup.
（可选择每天备份archived logs、incremental backup或the full database copy 到磁带。 在磁盘上的备份会保留在1天之类，使你可以最远回到昨天。 ）

1. RMAN> list backup;
   
2. 
   
3. using target database control file instead of recovery catalog
   
4. 
   
5. List of Backup Sets
   
6. ===================
   
7. 
   
8. 
   
9. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
   
10. ------- ---- -- ---------- ----------- ------------ -------------------
    
11. 37      Full    9.52M      DISK        00:00:01     2018-05-26:23:06:50
    
12.         BP Key: 37   Status: AVAILABLE  Compressed: NO  Tag: TAG20180526T230649
    
13.         Piece Name: +FRA/orcl/autobackup/2018_05_26/s_977180809.282.977180811
    
14.   SPFILE Included: Modification time: 2018-05-26:19:12:46
    
15.   SPFILE db_unique_name: ORCL
    
16.   Control File Included: Ckp SCN: 1205857      Ckp time: 2018-05-26:23:06:49
    
17. 
    
18. BS Key  Size       Device Type Elapsed Time Completion Time   
    
19. ------- ---------- ----------- ------------ -------------------
    
20. 38      10.31M     SBT_TAPE    00:01:14     2018-05-26:23:08:10
    
21.         BP Key: 38   Status: AVAILABLE  Compressed: NO  Tag: TAG20180526T230655
    
22.         Handle: 1ct3t64g_1_1   Media: station87-000005
    
23. 
    
24.   List of Archived Logs in backup set 38
    
25.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
    
26.   ---- ------- ---------- ------------------- ---------- ---------
    
27.   1    51      1200728    2018-05-26:22:00:20 1205937    2018-05-26:23:06:54
    
28. 
    
29. BS Key  Size       Device Type Elapsed Time Completion Time   
    
30. ------- ---------- ----------- ------------ -------------------
    
31. 39      40.13M     SBT_TAPE    00:01:17     2018-05-26:23:08:13
    
32.         BP Key: 39   Status: AVAILABLE  Compressed: NO  Tag: TAG20180526T230655
    
33.         Handle: 1bt3t64g_1_1   Media: station87-000006
    
34. 
    
35.   List of Archived Logs in backup set 39
    
36.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
    
37.   ---- ------- ---------- ------------------- ---------- ---------
    
38.   1    49      1185696    2018-05-26:19:44:29 1186124    2018-05-26:19:48:29
    
39.   1    50      1186124    2018-05-26:19:48:29 1200728    2018-05-26:22:00:20
    
40. 
    
41. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
42. ------- ---- -- ---------- ----------- ------------ -------------------
    
43. 40      Full    9.56M      SBT_TAPE    00:00:37     2018-05-26:23:08:58
    
44.         BP Key: 40   Status: AVAILABLE  Compressed: NO  Tag: TAG20180526T230821
    
45.         Handle: c-1359978017-20180526-03   Media: station87-000006
    
46.   SPFILE Included: Modification time: 2018-05-26:23:06:53
    
47.   SPFILE db_unique_name: ORCL
    
48.   Control File Included: Ckp SCN: 1206041      Ckp time: 2018-05-26:23:08:21
    
49. 
    
50. RMAN>
    

复制代码

1. RMAN> list copy;
   
2. 
   
3. specification does not match any control file copy in the repository
   
4. List of Datafile Copies
   
5. =======================
   
6. 
   
7. Key     File S Completion Time     Ckp SCN    Ckp Time           
   
8. ------- ---- - ------------------- ---------- -------------------
   
9. 2       1    A 2018-05-26:23:05:58 1205713    2018-05-26:23:05:24
   
10.         Name: +FRA/orcl/datafile/system.262.977180725
    
11.         Tag: ORA_OEM_LEVEL_0
    
12. 
    
13. 3       2    A 2018-05-26:23:06:21 1205768    2018-05-26:23:05:59
    
14.         Name: +FRA/orcl/datafile/sysaux.263.977180761
    
15.         Tag: ORA_OEM_LEVEL_0
    
16. 
    
17. 4       3    A 2018-05-26:23:06:36 1205792    2018-05-26:23:06:25
    
18.         Name: +FRA/orcl/datafile/undotbs1.315.977180785
    
19.         Tag: ORA_OEM_LEVEL_0
    
20. 
    
21. 6       4    A 2018-05-26:23:06:48 1205844    2018-05-26:23:06:47
    
22.         Name: +FRA/orcl/datafile/users.310.977180809
    
23.         Tag: ORA_OEM_LEVEL_0
    
24. 
    
25. 5       5    A 2018-05-26:23:06:45 1205813    2018-05-26:23:06:40
    
26.         Name: +FRA/orcl/datafile/example.314.977180801
    
27.         Tag: ORA_OEM_LEVEL_0
    
28. 
    
29. List of Archived Log Copies for database with db_unique_name ORCL
    
30. =====================================================================
    
31. 
    
32. Key     Thrd Seq     S Low Time           
    
33. ------- ---- ------- - -------------------
    
34. 50      1    49      A 2018-05-26:19:44:29
    
35.         Name: +FRA/orcl/archivelog/2018_05_26/thread_1_seq_49.264.977168911
    
36. 
    
37. 51      1    49      A 2018-05-26:19:44:29
    
38.         Name: /home/oracle/1_49_832197286.dbf
    
39. 
    
40. 52      1    50      A 2018-05-26:19:48:29
    
41.         Name: +FRA/orcl/archivelog/2018_05_26/thread_1_seq_50.261.977176821
    
42. 
    
43. 53      1    50      A 2018-05-26:19:48:29
    
44.         Name: /home/oracle/1_50_832197286.dbf
    
45. 
    
46. 54      1    51      A 2018-05-26:22:00:20
    
47.         Name: +FRA/orcl/archivelog/2018_05_26/thread_1_seq_51.281.977180815
    
48. 
    
49. 55      1    51      A 2018-05-26:22:00:20
    
50.         Name: /home/oracle/1_51_832197286.dbf
    
51. 
    
52. 
    
53. RMAN>
    

复制代码

第二天：
Subsequently, an incremental backup to disk will be performed every day.

list backup 增加了：

1. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
   
2. ------- ---- -- ---------- ----------- ------------ -------------------
   
3. 41      Incr 1  12.73M     DISK        00:00:09     2018-05-27:23:05:34
   
4.         BP Key: 41   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
   
5.         Piece Name: +FRA/orcl/backupset/2018_05_27/nnndn1_ora_oem_level_0_0.280.977267127
   
6.   List of Datafiles in backup set 41
   
7.   File LV Type Ckp SCN    Ckp Time            Name
   
8.   ---- -- ---- ---------- ------------------- ----
   
9.   1    1  Incr 1208369    2018-05-27:23:05:25 +DATA/orcl/datafile/system.256.832197063
   
10.   2    1  Incr 1208369    2018-05-27:23:05:25 +DATA/orcl/datafile/sysaux.257.832197065
    
11.   3    1  Incr 1208369    2018-05-27:23:05:25 +DATA/orcl/datafile/undotbs1.258.832197065
    
12.   4    1  Incr 1208369    2018-05-27:23:05:25 +DATA/orcl/datafile/users.259.832197065
    
13.   5    1  Incr 1208369    2018-05-27:23:05:25 +DATA/orcl/datafile/example.265.832197353
    
14. 
    
15. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
16. ------- ---- -- ---------- ----------- ------------ -------------------
    
17. 42      Full    9.52M      DISK        00:00:02     2018-05-27:23:05:42
    
18.         BP Key: 42   Status: AVAILABLE  Compressed: NO  Tag: TAG20180527T230540
    
19.         Piece Name: +FRA/orcl/autobackup/2018_05_27/s_977267140.279.977267141
    
20.   SPFILE Included: Modification time: 2018-05-26:23:06:53
    
21.   SPFILE db_unique_name: ORCL
    
22.   Control File Included: Ckp SCN: 1208412      Ckp time: 2018-05-27:23:05:40
    
23. 
    
24. BS Key  Size       Device Type Elapsed Time Completion Time   
    
25. ------- ---------- ----------- ------------ -------------------
    
26. 43      7.56M      SBT_TAPE    00:01:01     2018-05-27:23:06:48
    
27.         BP Key: 43   Status: AVAILABLE  Compressed: NO  Tag: TAG20180527T230547
    
28.         Handle: 1gt3vqeb_1_1   Media: station87-000005
    
29. 
    
30.   List of Archived Logs in backup set 43
    
31.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
    
32.   ---- ------- ---------- ------------------- ---------- ---------
    
33.   1    52      1205937    2018-05-26:23:06:54 1208507    2018-05-27:23:05:46
    
34. 
    
35. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
36. ------- ---- -- ---------- ----------- ------------ -------------------
    
37. 44      Full    9.56M      SBT_TAPE    00:00:41     2018-05-27:23:07:34
    
38.         BP Key: 44   Status: AVAILABLE  Compressed: NO  Tag: TAG20180527T230652
    
39.         Handle: c-1359978017-20180527-01   Media: station87-000005
    
40.   SPFILE Included: Modification time: 2018-05-26:23:06:53
    
41.   SPFILE db_unique_name: ORCL
    
42.   Control File Included: Ckp SCN: 1208592      Ckp time: 2018-05-27:23:06:53
    
43. 
    
44. RMAN>
    

复制代码

list copy的输出中数据文件镜像拷贝没变化，只是多了一些归档日志。

第三天：
Subsequently, an incremental backup to disk will be performed every day.
把第2天合成到第1天里头去，然后自己做增量备份。

list backup 增加了：

1. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
   
2. ------- ---- -- ---------- ----------- ------------ -------------------
   
3. 45      Incr 1  33.17M     DISK        00:00:11     2018-05-28:23:05:53
   
4.         BP Key: 45   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
   
5.         Piece Name: +FRA/orcl/backupset/2018_05_28/nnndn1_ora_oem_level_0_0.277.977353547
   
6.   List of Datafiles in backup set 45
   
7.   File LV Type Ckp SCN    Ckp Time            Name
   
8.   ---- -- ---- ---------- ------------------- ----
   
9.   1    1  Incr 1217231    2018-05-28:23:05:43 +DATA/orcl/datafile/system.256.832197063
   
10.   2    1  Incr 1217231    2018-05-28:23:05:43 +DATA/orcl/datafile/sysaux.257.832197065
    
11.   3    1  Incr 1217231    2018-05-28:23:05:43 +DATA/orcl/datafile/undotbs1.258.832197065
    
12.   4    1  Incr 1217231    2018-05-28:23:05:43 +DATA/orcl/datafile/users.259.832197065
    
13.   5    1  Incr 1217231    2018-05-28:23:05:43 +DATA/orcl/datafile/example.265.832197353
    
14. 
    
15. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
16. ------- ---- -- ---------- ----------- ------------ -------------------
    
17. 46      Full    9.52M      DISK        00:00:01     2018-05-28:23:05:59
    
18.         BP Key: 46   Status: AVAILABLE  Compressed: NO  Tag: TAG20180528T230558
    
19.         Piece Name: +FRA/orcl/autobackup/2018_05_28/s_977353558.276.977353559
    
20.   SPFILE Included: Modification time: 2018-05-26:23:06:53
    
21.   SPFILE db_unique_name: ORCL
    
22.   Control File Included: Ckp SCN: 1217270      Ckp time: 2018-05-28:23:05:58
    
23. 
    
24. BS Key  Size       Device Type Elapsed Time Completion Time   
    
25. ------- ---------- ----------- ------------ -------------------
    
26. 47      25.00M     SBT_TAPE    00:00:52     2018-05-28:23:06:57
    
27.         BP Key: 47   Status: AVAILABLE  Compressed: NO  Tag: TAG20180528T230605
    
28.         Handle: 1kt42eqt_1_1   Media: station87-000005
    
29. 
    
30.   List of Archived Logs in backup set 47
    
31.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
    
32.   ---- ------- ---------- ------------------- ---------- ---------
    
33.   1    53      1208507    2018-05-27:23:05:46 1217366    2018-05-28:23:06:03
    
34. 
    
35. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
36. ------- ---- -- ---------- ----------- ------------ -------------------
    
37. 48      Full    9.56M      SBT_TAPE    00:00:31     2018-05-28:23:07:32
    
38.         BP Key: 48   Status: AVAILABLE  Compressed: NO  Tag: TAG20180528T230701
    
39.         Handle: c-1359978017-20180528-01   Media: station87-000005
    
40.   SPFILE Included: Modification time: 2018-05-26:23:06:53
    
41.   SPFILE db_unique_name: ORCL
    
42.   Control File Included: Ckp SCN: 1217452      Ckp time: 2018-05-28:23:07:01
    
43. 
    
44. RMAN>
    

复制代码

list copy：
RMAN> list copy;

specification does not match any control file copy in the repository
List of Datafile Copies
=======================

Key     File S Completion Time     Ckp SCN    Ckp Time           
------- ---- - ------------------- ---------- -------------------
11      1    A 2018-05-28:23:05:37 1208369    2018-05-27:23:05:25
        Name: +FRA/orcl/datafile/system.262.977180725
        Tag: ORA_OEM_LEVEL_0

10      2    A 2018-05-28:23:05:37 1208369    2018-05-27:23:05:25
        Name: +FRA/orcl/datafile/sysaux.263.977180761
        Tag: ORA_OEM_LEVEL_0

9       3    A 2018-05-28:23:05:36 1208369    2018-05-27:23:05:25
        Name: +FRA/orcl/datafile/undotbs1.315.977180785
        Tag: ORA_OEM_LEVEL_0

7       4    A 2018-05-28:23:05:34 1208369    2018-05-27:23:05:25
        Name: +FRA/orcl/datafile/users.310.977180809
        Tag: ORA_OEM_LEVEL_0

8       5    A 2018-05-28:23:05:35 1208369    2018-05-27:23:05:25
        Name: +FRA/orcl/datafile/example.314.977180801
        Tag: ORA_OEM_LEVEL_0

List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================

Key     Thrd Seq     S Low Time           
------- ---- ------- - -------------------
50      1    49      A 2018-05-26:19:44:29
        Name: +FRA/orcl/archivelog/2018_05_26/thread_1_seq_49.264.977168911

51      1    49      A 2018-05-26:19:44:29
        Name: /home/oracle/1_49_832197286.dbf

52      1    50      A 2018-05-26:19:48:29
        Name: +FRA/orcl/archivelog/2018_05_26/thread_1_seq_50.261.977176821

53      1    50      A 2018-05-26:19:48:29
        Name: /home/oracle/1_50_832197286.dbf

54      1    51      A 2018-05-26:22:00:20
        Name: +FRA/orcl/archivelog/2018_05_26/thread_1_seq_51.281.977180815

55      1    51      A 2018-05-26:22:00:20
        Name: /home/oracle/1_51_832197286.dbf

56      1    52      A 2018-05-26:23:06:54
        Name: +FRA/orcl/archivelog/2018_05_27/thread_1_seq_52.278.977267147

57      1    52      A 2018-05-26:23:06:54
        Name: /home/oracle/1_52_832197286.dbf

58      1    53      A 2018-05-27:23:05:46
        Name: +FRA/orcl/archivelog/2018_05_28/thread_1_seq_53.275.977353563

59      1    53      A 2018-05-27:23:05:46
        Name: /home/oracle/1_53_832197286.dbf




周备份：
All recovery related files on disk will be backed up to tape once a week.

周备份的输出：

View Data

Status Succeeded Exit Code 0 Step ID 236 Targets orcl.example.com

Started May 29, 2018 11:05:27 PM CST Ended May 29, 2018 11:11:54 PM CST Step Elapsed Time 6 minutes, 27 seconds Management Service station87.example.com:1158_Management_Service TIP Management Service from which the job step was dispatched.

	Output Log
	Recovery Manager: Release 11.2.0.1.0 - Production on Tue May 29 23:05:28 2018Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.RMAN> connected to target database: ORCL (DBID=1359978017)using target database control file instead of recovery catalogRMAN> echo set onRMAN> run {2> allocate channel oem_disk_backup device type disk;3> recover copy of database with tag 'ORA_OEM_LEVEL_0';4> backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;5> release channel oem_disk_backup;6> allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station87)';7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station87)';8> backup recovery area;9> }allocated channel: oem_disk_backupchannel oem_disk_backup: SID=33 device type=DISKStarting recover at 2018-05-29:23:05:30channel oem_disk_backup: starting incremental datafile backup set restorechannel oem_disk_backup: specifying datafile copies to recoverrecovering datafile copy file number=00001 name=+FRA/orcl/datafile/system.262.977180725recovering datafile copy file number=00002 name=+FRA/orcl/datafile/sysaux.263.977180761recovering datafile copy file number=00003 name=+FRA/orcl/datafile/undotbs1.315.977180785recovering datafile copy file number=00004 name=+FRA/orcl/datafile/users.310.977180809recovering datafile copy file number=00005 name=+FRA/orcl/datafile/example.314.977180801channel oem_disk_backup: reading from backup piece +FRA/orcl/backupset/2018_05_28/nnndn1_ora_oem_level_0_0.277.977353547channel oem_disk_backup: piece handle=+FRA/orcl/backupset/2018_05_28/nnndn1_ora_oem_level_0_0.277.977353547 tag=ORA_OEM_LEVEL_0channel oem_disk_backup: restored backup piece 1channel oem_disk_backup: restore complete, elapsed time: 00:00:07Finished recover at 2018-05-29:23:05:39Starting backup at 2018-05-29:23:05:40channel oem_disk_backup: starting incremental level 1 datafile backup setchannel oem_disk_backup: specifying datafile(s) in backup setinput datafile file number=00001 name=+DATA/orcl/datafile/system.256.832197063input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.832197065input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.832197065input datafile file number=00005 name=+DATA/orcl/datafile/example.265.832197353input datafile file number=00004 name=+DATA/orcl/datafile/users.259.832197065channel oem_disk_backup: starting piece 1 at 2018-05-29:23:05:40channel oem_disk_backup: finished piece 1 at 2018-05-29:23:05:55piece handle=+FRA/orcl/backupset/2018_05_29/nnndn1_ora_oem_level_0_0.274.977439943 tag=ORA_OEM_LEVEL_0 comment=NONEchannel oem_disk_backup: backup set complete, elapsed time: 00:00:15Finished backup at 2018-05-29:23:05:55Starting Control File and SPFILE Autobackup at 2018-05-29:23:05:56piece handle=+FRA/orcl/autobackup/2018_05_29/s_977439956.273.977439957 comment=NONEFinished Control File and SPFILE Autobackup at 2018-05-29:23:05:59released channel: oem_disk_backupallocated channel: oem_sbt_backup1channel oem_sbt_backup1: SID=33 device type=SBT_TAPEchannel oem_sbt_backup1: Oracle Secure Backupallocated channel: oem_sbt_backup2channel oem_sbt_backup2: SID=158 device type=SBT_TAPEchannel oem_sbt_backup2: Oracle Secure BackupStarting backup at 2018-05-29:23:06:01skipping archived log file +FRA/orcl/archivelog/2018_05_26/thread_1_seq_49.264.977168911; already backed up 1 time(s)skipping archived log file /home/oracle/1_49_832197286.dbf; already backed up 1 time(s)skipping archived log file +FRA/orcl/archivelog/2018_05_26/thread_1_seq_50.261.977176821; already backed up 1 time(s)skipping archived log file /home/oracle/1_50_832197286.dbf; already backed up 1 time(s)skipping archived log file +FRA/orcl/archivelog/2018_05_26/thread_1_seq_51.281.977180815; already backed up 1 time(s)skipping archived log file /home/oracle/1_51_832197286.dbf; already backed up 1 time(s)skipping archived log file +FRA/orcl/archivelog/2018_05_27/thread_1_seq_52.278.977267147; already backed up 1 time(s)skipping archived log file /home/oracle/1_52_832197286.dbf; already backed up 1 time(s)skipping archived log file +FRA/orcl/archivelog/2018_05_28/thread_1_seq_53.275.977353563; already backed up 1 time(s)skipping archived log file /home/oracle/1_53_832197286.dbf; already backed up 1 time(s)channel oem_sbt_backup1: starting full datafile backup setchannel oem_sbt_backup1: including datafile copy of datafile 00001 in backup setinput file name=+FRA/orcl/datafile/system.262.977180725channel oem_sbt_backup1: including datafile copy of datafile 00003 in backup setinput file name=+FRA/orcl/datafile/undotbs1.315.977180785channel oem_sbt_backup1: starting piece 1 at 2018-05-29:23:06:02channel oem_sbt_backup2: starting full datafile backup setchannel oem_sbt_backup2: including datafile copy of datafile 00002 in backup setinput file name=+FRA/orcl/datafile/sysaux.263.977180761channel oem_sbt_backup2: including datafile copy of datafile 00005 in backup setinput file name=+FRA/orcl/datafile/example.314.977180801channel oem_sbt_backup2: including datafile copy of datafile 00004 in backup setinput file name=+FRA/orcl/datafile/users.310.977180809channel oem_sbt_backup2: starting piece 1 at 2018-05-29:23:06:02channel oem_sbt_backup1: finished piece 1 at 2018-05-29:23:07:57piece handle=1ot4536q_1_1 tag=TAG20180529T230602 comment=API Version 2.0,MMS Version 10.3.0.2channel oem_sbt_backup1: backup set complete, elapsed time: 00:01:55channel oem_sbt_backup1: input backup set: count=42, stamp=977180809, piece=1channel oem_sbt_backup1: starting piece 1 at 2018-05-29:23:07:59channel oem_sbt_backup1: backup piece +FRA/orcl/autobackup/2018_05_26/s_977180809.282.977180811channel oem_sbt_backup2: finished piece 1 at 2018-05-29:23:08:14piece handle=1pt4536q_1_1 tag=TAG20180529T230602 comment=API Version 2.0,MMS Version 10.3.0.2channel oem_sbt_backup2: backup set complete, elapsed time: 00:02:12channel oem_sbt_backup2: input backup set: count=46, stamp=977267125, piece=1channel oem_sbt_backup2: starting piece 1 at 2018-05-29:23:08:14channel oem_sbt_backup2: backup piece +FRA/orcl/backupset/2018_05_27/nnndn1_ora_oem_level_0_0.280.977267127piece handle=c-1359978017-20180526-02 comment=API Version 2.0,MMS Version 10.3.0.2channel oem_sbt_backup1: finished piece 1 at 2018-05-29:23:08:49channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:50channel oem_sbt_backup1: input backup set: count=47, stamp=977267140, piece=1channel oem_sbt_backup1: starting piece 1 at 2018-05-29:23:08:49channel oem_sbt_backup1: backup piece +FRA/orcl/autobackup/2018_05_27/s_977267140.279.977267141piece handle=1et3vqdl_1_2 comment=API Version 2.0,MMS Version 10.3.0.2channel oem_sbt_backup2: finished piece 1 at 2018-05-29:23:08:49channel oem_sbt_backup2: backup piece complete, elapsed time: 00:00:35channel oem_sbt_backup2: input backup set: count=50, stamp=977353542, piece=1channel oem_sbt_backup2: starting piece 1 at 2018-05-29:23:08:49channel oem_sbt_backup2: backup piece +FRA/orcl/backupset/2018_05_28/nnndn1_ora_oem_level_0_0.277.977353547piece handle=c-1359978017-20180527-00 comment=API Version 2.0,MMS Version 10.3.0.2channel oem_sbt_backup1: finished piece 1 at 2018-05-29:23:09:44channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:55channel oem_sbt_backup1: input backup set: count=51, stamp=977353558, piece=1channel oem_sbt_backup1: starting piece 1 at 2018-05-29:23:09:44channel oem_sbt_backup1: backup piece +FRA/orcl/autobackup/2018_05_28/s_977353558.276.977353559piece handle=1it42eq6_1_2 comment=API Version 2.0,MMS Version 10.3.0.2channel oem_sbt_backup2: finished piece 1 at 2018-05-29:23:09:44channel oem_sbt_backup2: backup piece complete, elapsed time: 00:00:55channel oem_sbt_backup2: input backup set: count=54, stamp=977439940, piece=1channel oem_sbt_backup2: starting piece 1 at 2018-05-29:23:09:44channel oem_sbt_backup2: backup piece +FRA/orcl/backupset/2018_05_29/nnndn1_ora_oem_level_0_0.274.977439943piece handle=c-1359978017-20180528-00 comment=API Version 2.0,MMS Version 10.3.0.2channel oem_sbt_backup1: finished piece 1 at 2018-05-29:23:10:30channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:46channel oem_sbt_backup1: input backup set: count=55, stamp=977439956, piece=1channel oem_sbt_backup1: starting piece 1 at 2018-05-29:23:10:30channel oem_sbt_backup1: backup piece +FRA/orcl/autobackup/2018_05_29/s_977439956.273.977439957piece handle=1mt45364_1_2 comment=API Version 2.0,MMS Version 10.3.0.2channel oem_sbt_backup2: finished piece 1 at 2018-05-29:23:10:30channel oem_sbt_backup2: backup piece complete, elapsed time: 00:00:46piece handle=c-1359978017-20180529-00 comment=API Version 2.0,MMS Version 10.3.0.2channel oem_sbt_backup1: finished piece 1 at 2018-05-29:23:11:15channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:45Finished backup at 2018-05-29:23:11:15Starting Control File and SPFILE Autobackup at 2018-05-29:23:11:15piece handle=c-1359978017-20180529-01 comment=API Version 2.0,MMS Version 10.3.0.2Finished Control File and SPFILE Autobackup at 2018-05-29:23:11:50released channel: oem_sbt_backup1released channel: oem_sbt_backup2RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station87)';allocated channel: ORA_MAINT_SBT_TAPE_1channel ORA_MAINT_SBT_TAPE_1: SID=33 device type=SBT_TAPEchannel ORA_MAINT_SBT_TAPE_1: Oracle Secure BackupRMAN> delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';no obsolete backups foundRMAN> exit;Recovery Manager complete.

list backup增加了以下：

1. BS Key  Type LV Size
   
2. ------- ---- -- ----------
   
3. 49      Incr 1  33.63M
   
4.   List of Datafiles in backup set 49
   
5.   File LV Type Ckp SCN    Ckp Time            Name
   
6.   ---- -- ---- ---------- ------------------- ----
   
7.   1    1  Incr 1227015    2018-05-29:23:05:40 +DATA/orcl/datafile/system.256.832197063
   
8.   2    1  Incr 1227015    2018-05-29:23:05:40 +DATA/orcl/datafile/sysaux.257.832197065
   
9.   3    1  Incr 1227015    2018-05-29:23:05:40 +DATA/orcl/datafile/undotbs1.258.832197065
   
10.   4    1  Incr 1227015    2018-05-29:23:05:40 +DATA/orcl/datafile/users.259.832197065
    
11.   5    1  Incr 1227015    2018-05-29:23:05:40 +DATA/orcl/datafile/example.265.832197353
    
12. 
    
13.   Backup Set Copy #1 of backup set 49
    
14.   Device Type Elapsed Time Completion Time     Compressed Tag
    
15.   ----------- ------------ ------------------- ---------- ---
    
16.   DISK        00:00:10     2018-05-29:23:05:50 NO         ORA_OEM_LEVEL_0
    
17. 
    
18.     List of Backup Pieces for backup set 49 Copy #1
    
19.     BP Key  Pc# Status      Piece Name
    
20.     ------- --- ----------- ----------
    
21.     49      1   AVAILABLE   +FRA/orcl/backupset/2018_05_29/nnndn1_ora_oem_level_0_0.274.977439943
    
22. 
    
23.   Backup Set Copy #2 of backup set 49
    
24.   Device Type Elapsed Time Completion Time     Compressed Tag
    
25.   ----------- ------------ ------------------- ---------- ---
    
26.   SBT_TAPE    00:00:10     2018-05-29:23:10:27 NO         ORA_OEM_LEVEL_0
    
27. 
    
28.     List of Backup Pieces for backup set 49 Copy #2
    
29.     BP Key  Pc# Status      Media                   Piece Name
    
30.     ------- --- ----------- ----------------------- ----------
    
31.     58      1   AVAILABLE   station87-000006        1mt45364_1_2
    
32. 
    
33. BS Key  Type LV Size
    
34. ------- ---- -- ----------
    
35. 50      Full    9.52M
    
36.   SPFILE Included: Modification time: 2018-05-26:23:06:53
    
37.   SPFILE db_unique_name: ORCL
    
38.   Control File Included: Ckp SCN: 1227044      Ckp time: 2018-05-29:23:05:56
    
39. 
    
40.   Backup Set Copy #1 of backup set 50
    
41.   Device Type Elapsed Time Completion Time     Compressed Tag
    
42.   ----------- ------------ ------------------- ---------- ---
    
43.   DISK        00:00:02     2018-05-29:23:05:58 NO         TAG20180529T230556
    
44. 
    
45.     List of Backup Pieces for backup set 50 Copy #1
    
46.     BP Key  Pc# Status      Piece Name
    
47.     ------- --- ----------- ----------
    
48.     50      1   AVAILABLE   +FRA/orcl/autobackup/2018_05_29/s_977439956.273.977439957
    
49. 
    
50.   Backup Set Copy #2 of backup set 50
    
51.   Device Type Elapsed Time Completion Time     Compressed Tag
    
52.   ----------- ------------ ------------------- ---------- ---
    
53.   SBT_TAPE    00:00:02     2018-05-29:23:11:05 NO         TAG20180529T230556
    
54. 
    
55.     List of Backup Pieces for backup set 50 Copy #2
    
56.     BP Key  Pc# Status      Media                   Piece Name
    
57.     ------- --- ----------- ----------------------- ----------
    
58.     59      1   AVAILABLE   station87-000005        c-1359978017-20180529-00
    
59. 
    
60. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
61. ------- ---- -- ---------- ----------- ------------ -------------------
    
62. 51      Full    613.25M    SBT_TAPE    00:01:55     2018-05-29:23:07:57
    
63.         BP Key: 51   Status: AVAILABLE  Compressed: NO  Tag: TAG20180529T230602
    
64.         Handle: 1ot4536q_1_1   Media: station87-000005
    
65.   List of Datafiles in backup set 51
    
66.   File LV Type Ckp SCN    Ckp Time            Name
    
67.   ---- -- ---- ---------- ------------------- ----
    
68.   1       Full 1217231    2018-05-28:23:05:43 +DATA/orcl/datafile/system.256.832197063
    
69.   3       Full 1217231    2018-05-28:23:05:43 +DATA/orcl/datafile/undotbs1.258.832197065
    
70. 
    
71. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
72. ------- ---- -- ---------- ----------- ------------ -------------------
    
73. 52      Full    522.00M    SBT_TAPE    00:02:05     2018-05-29:23:08:07
    
74.         BP Key: 52   Status: AVAILABLE  Compressed: NO  Tag: TAG20180529T230602
    
75.         Handle: 1pt4536q_1_1   Media: station87-000006
    
76.   List of Datafiles in backup set 52
    
77.   File LV Type Ckp SCN    Ckp Time            Name
    
78.   ---- -- ---- ---------- ------------------- ----
    
79.   2       Full 1217231    2018-05-28:23:05:43 +DATA/orcl/datafile/sysaux.257.832197065
    
80.   4       Full 1217231    2018-05-28:23:05:43 +DATA/orcl/datafile/users.259.832197065
    
81.   5       Full 1217231    2018-05-28:23:05:43 +DATA/orcl/datafile/example.265.832197353
    
82. 
    
83. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
84. ------- ---- -- ---------- ----------- ------------ -------------------
    
85. 53      Full    9.56M      SBT_TAPE    00:00:31     2018-05-29:23:11:46
    
86.         BP Key: 60   Status: AVAILABLE  Compressed: NO  Tag: TAG20180529T231115
    
87.         Handle: c-1359978017-20180529-01   Media: station87-000005
    
88.   SPFILE Included: Modification time: 2018-05-26:23:06:53
    
89.   SPFILE db_unique_name: ORCL
    
90.   Control File Included: Ckp SCN: 1227627      Ckp time: 2018-05-29:23:11:15
    
91. 
    
92. RMAN>
    

复制代码

list copy：
RMAN> list copy;

specification does not match any control file copy in the repository
List of Datafile Copies
=======================

Key     File S Completion Time     Ckp SCN    Ckp Time           
------- ---- - ------------------- ---------- -------------------
16      1    A 2018-05-29:23:05:36 1217231    2018-05-28:23:05:43
        Name: +FRA/orcl/datafile/system.262.977180725
        Tag: ORA_OEM_LEVEL_0

15      2    A 2018-05-29:23:05:36 1217231    2018-05-28:23:05:43
        Name: +FRA/orcl/datafile/sysaux.263.977180761
        Tag: ORA_OEM_LEVEL_0

14      3    A 2018-05-29:23:05:34 1217231    2018-05-28:23:05:43
        Name: +FRA/orcl/datafile/undotbs1.315.977180785
        Tag: ORA_OEM_LEVEL_0

12      4    A 2018-05-29:23:05:33 1217231    2018-05-28:23:05:43
        Name: +FRA/orcl/datafile/users.310.977180809
        Tag: ORA_OEM_LEVEL_0

13      5    A 2018-05-29:23:05:34 1217231    2018-05-28:23:05:43
        Name: +FRA/orcl/datafile/example.314.977180801
        Tag: ORA_OEM_LEVEL_0

List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================

Key     Thrd Seq     S Low Time           
------- ---- ------- - -------------------
50      1    49      A 2018-05-26:19:44:29
        Name: +FRA/orcl/archivelog/2018_05_26/thread_1_seq_49.264.977168911

51      1    49      A 2018-05-26:19:44:29
        Name: /home/oracle/1_49_832197286.dbf

52      1    50      A 2018-05-26:19:48:29
        Name: +FRA/orcl/archivelog/2018_05_26/thread_1_seq_50.261.977176821

53      1    50      A 2018-05-26:19:48:29
        Name: /home/oracle/1_50_832197286.dbf

54      1    51      A 2018-05-26:22:00:20
        Name: +FRA/orcl/archivelog/2018_05_26/thread_1_seq_51.281.977180815

55      1    51      A 2018-05-26:22:00:20
        Name: /home/oracle/1_51_832197286.dbf

56      1    52      A 2018-05-26:23:06:54
        Name: +FRA/orcl/archivelog/2018_05_27/thread_1_seq_52.278.977267147

57      1    52      A 2018-05-26:23:06:54
        Name: /home/oracle/1_52_832197286.dbf

58      1    53      A 2018-05-27:23:05:46
        Name: +FRA/orcl/archivelog/2018_05_28/thread_1_seq_53.275.977353563

59      1    53      A 2018-05-27:23:05:46
        Name: /home/oracle/1_53_832197286.dbf


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. 342        CRITICAL OPEN      27-MAY-18     System datafile 1: '+DATA/orcl/datafile/system.256.976686445' is missing
   
10. 205        CRITICAL OPEN      27-MAY-18     System datafile 1: '/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_fhzzfgb3_.dbf' is missing
    
11. 
    
12. RMAN> advise failure 342;
    
13. 
    
14. List of Database Failures
    
15. =========================
    
16. 
    
17. Failure ID Priority Status    Time Detected Summary
    
18. ---------- -------- --------- ------------- -------
    
19. 342        CRITICAL OPEN      27-MAY-18     System datafile 1: '+DATA/orcl/datafile/system.256.976686445' is missing
    
20. 
    
21. analyzing automatic repair options; this may take some time
    
22. allocated channel: ORA_DISK_1
    
23. channel ORA_DISK_1: SID=68 device type=DISK
    
24. allocated channel: ORA_DISK_2
    
25. channel ORA_DISK_2: SID=131 device type=DISK
    
26. allocated channel: ORA_DISK_3
    
27. channel ORA_DISK_3: SID=192 device type=DISK
    
28. allocated channel: ORA_DISK_4
    
29. channel ORA_DISK_4: SID=8 device type=DISK
    
30. allocated channel: ORA_DISK_5
    
31. channel ORA_DISK_5: SID=69 device type=DISK
    
32. allocated channel: ORA_DISK_6
    
33. channel ORA_DISK_6: SID=132 device type=DISK
    
34. allocated channel: ORA_DISK_7
    
35. channel ORA_DISK_7: SID=193 device type=DISK
    
36. allocated channel: ORA_DISK_8
    
37. channel ORA_DISK_8: SID=9 device type=DISK
    
38. allocated channel: ORA_SBT_TAPE_1
    
39. channel ORA_SBT_TAPE_1: SID=70 device type=SBT_TAPE
    
40. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
41. allocated channel: ORA_SBT_TAPE_2
    
42. channel ORA_SBT_TAPE_2: SID=133 device type=SBT_TAPE
    
43. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
44. analyzing automatic repair options complete
    
45. 
    
46. Mandatory Manual Actions
    
47. ========================
    
48. no manual actions available
    
49. 
    
50. Optional Manual Actions
    
51. =======================
    
52. 1. If file +DATA/orcl/datafile/system.256.976686445 was unintentionally renamed or moved, restore it
    
53. 
    
54. Automated Repair Options
    
55. ========================
    
56. Option Repair Description
    
57. ------ ------------------
    
58. 1      Restore and recover datafile 1  
    
59.   Strategy: The repair includes complete media recovery with no data loss
    
60.   Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_2705808684.hm
    
61. 
    
62. RMAN> repair failure preview;
    
63. 
    
64. Strategy: The repair includes complete media recovery with no data loss
    
65. Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_2705808684.hm
    
66. 
    
67. contents of repair script:
    
68.    # restore and recover datafile
    
69.    restore datafile 1;
    
70.    recover datafile 1;
    
71. 
    
72. RMAN> repair failure;
    
73. 
    
74. Strategy: The repair includes complete media recovery with no data loss
    
75. Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_2705808684.hm
    
76. 
    
77. contents of repair script:
    
78.    # restore and recover datafile
    
79.    restore datafile 1;
    
80.    recover datafile 1;
    
81. 
    
82. Do you really want to execute the above repair (enter YES or NO)? YES
    
83. executing repair script
    
84. 
    
85. Starting restore at 27-MAY-18
    
86. using channel ORA_DISK_1
    
87. using channel ORA_DISK_2
    
88. using channel ORA_DISK_3
    
89. using channel ORA_DISK_4
    
90. using channel ORA_DISK_5
    
91. using channel ORA_DISK_6
    
92. using channel ORA_DISK_7
    
93. using channel ORA_DISK_8
    
94. using channel ORA_SBT_TAPE_1
    
95. using channel ORA_SBT_TAPE_2
    
96. 
    
97. channel ORA_SBT_TAPE_1: starting datafile backup set restore
    
98. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
    
99. channel ORA_SBT_TAPE_1: restoring datafile 00001 to +DATA/orcl/datafile/system.256.976686445
    
100. channel ORA_SBT_TAPE_1: reading from backup piece 04t3tfr6_1_1
     
101. 
     

复制代码