|
上完1Z0-052第15章
1Z0-052共19章(上完11章),1Z0-053共21章(上完5章)和1Z0-063多租户部分共9章(上完0章)
总共上完全部49章中的16章
对磁盘备份集再备份(转移)到磁带机上:
用磁带机执行backup recovery files:
- RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
- old RMAN configuration parameters:
- CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
- new RMAN configuration parameters:
- CONFIGURE DEFAULT DEVICE TYPE TO DISK;
- new RMAN configuration parameters are successfully stored
- released channel: ORA_SBT_TAPE_1
- released channel: ORA_SBT_TAPE_2
- RMAN> backup recovery files;
- Starting backup at 14-SEP-17
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=77 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=79 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=139 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=198 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=11 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=78 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=135 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=203 device type=DISK
- specification does not match any datafile copy in the repository
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of backup command at 09/14/2017 20:07:32
- RMAN-06603: TO DESTINATION option must be specified with RECOVERY AREA, RECOVERY FILES or DB_RECOVERY_FILE_DEST on disk device
- RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
- old RMAN configuration parameters:
- CONFIGURE DEFAULT DEVICE TYPE TO DISK;
- new RMAN configuration parameters:
- CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
- new RMAN configuration parameters are successfully stored
- released channel: ORA_DISK_1
- released channel: ORA_DISK_2
- released channel: ORA_DISK_3
- released channel: ORA_DISK_4
- released channel: ORA_DISK_5
- released channel: ORA_DISK_6
- released channel: ORA_DISK_7
- released channel: ORA_DISK_8
- RMAN> backup recovery files;
- Starting backup at 14-SEP-17
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=77 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=79 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- specification does not match any datafile copy in the repository
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=20 RECID=12 STAMP=954585053
- input archived log thread=1 sequence=21 RECID=13 STAMP=954586600
- input archived log thread=1 sequence=22 RECID=14 STAMP=954593821
- input archived log thread=1 sequence=23 RECID=15 STAMP=954601529
- input archived log thread=1 sequence=24 RECID=16 STAMP=954608466
- input archived log thread=1 sequence=25 RECID=17 STAMP=954618389
- input archived log thread=1 sequence=26 RECID=18 STAMP=954625206
- input archived log thread=1 sequence=27 RECID=19 STAMP=954626436
- channel ORA_SBT_TAPE_1: starting piece 1 at 14-SEP-17
- channel ORA_SBT_TAPE_2: starting archived log backup set
- channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
- input archived log thread=1 sequence=28 RECID=20 STAMP=954626466
- input archived log thread=1 sequence=29 RECID=21 STAMP=954665031
- input archived log thread=1 sequence=30 RECID=22 STAMP=954670878
- input archived log thread=1 sequence=31 RECID=23 STAMP=954688375
- input archived log thread=1 sequence=32 RECID=24 STAMP=954691244
- input archived log thread=1 sequence=33 RECID=25 STAMP=954702452
- input archived log thread=1 sequence=34 RECID=26 STAMP=954705658
- channel ORA_SBT_TAPE_2: starting piece 1 at 14-SEP-17
- channel ORA_SBT_TAPE_1: finished piece 1 at 14-SEP-17
- piece handle=19sefa58_1_1 tag=TAG20170914T200808 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_2: finished piece 1 at 14-SEP-17
- piece handle=1asefa58_1_1 tag=TAG20170914T200808 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: input backup set: count=39, stamp=954705450, piece=1
- channel ORA_SBT_TAPE_1: starting piece 1 at 14-SEP-17
- channel ORA_SBT_TAPE_1: backup piece +FRA/orcl/autobackup/2017_09_14/s_954705450.275.954705451
- piece handle=c-1343950367-20170914-00 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: finished piece 1 at 14-SEP-17
- channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:00:25
- Finished backup at 14-SEP-17
- Starting Control File and SPFILE Autobackup at 14-SEP-17
- piece handle=c-1343950367-20170914-02 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 14-SEP-17
- RMAN>
复制代码 【可选】清理磁带:
- [root@station90 10]# du -sh *
- 8.0K CLN101L4
- 8.0K CLN102L5
- 934M E01001L4
- 622M E01002L4
- 8.0K E01003L4
- 8.0K E01004L4
- 8.0K E01005L4
- 8.0K E01006L4
- 8.0K E01007L4
- 8.0K E01008L4
- 8.0K E01009L4
- 8.0K E01010L4
- 8.0K E01011L4
- 8.0K E01012L4
- 8.0K E01013L4
- 8.0K E01014L4
- 8.0K E01015L4
- 8.0K E01016L4
- 8.0K E01017L4
- 8.0K E01018L4
- 8.0K E01019L4
- 8.0K E01020L4
- 8.0K F01030L5
- 8.0K F01031L5
- 8.0K F01032L5
- 8.0K F01033L5
- 8.0K F01034L5
- 8.0K F01035L5
- 8.0K F01036L5
- 8.0K F01037L5
- 8.0K F01038L5
- 8.0K F01039L5
- [root@station90 10]# obtool
- ob> loadvol -D tape04 -m write 1
- ob> unlabelvol -D tape04
- ob> reusevol -D tape04
- ob> unloadvol -D tape04
- ob> loadvol -D tape04 -m write 2
- ob> unloadvol -D tape04
- ob> reusevol -D tape04
- Error: the device is offline.
- ob> loadvol -D tape04 -m write 2
- ob> unlabelvol -D tape04
- ob> reusevol -D tape04
- ob> unloadvol -D tape04
- ob> lsvol -L lib01 -l
- Inventory of library lib01:
- in 1: barcode E01001L4, oid 137, 8190976 kb remaining
- in 2: barcode E01002L4, oid 139, 8190976 kb remaining
- in 3: barcode E01003L4, oid 102
- in 4: barcode E01004L4, oid 103
- in 5: barcode E01005L4, oid 104
- in 6: barcode E01006L4, oid 105
- in 7: barcode E01007L4, oid 106
- in 8: barcode E01008L4, oid 107
- in 9: barcode E01009L4, oid 108
- in 10: barcode E01010L4, oid 109
- in 11: barcode E01011L4, oid 110
- in 12: barcode E01012L4, oid 111
- in 13: barcode E01013L4, oid 112
- in 14: barcode E01014L4, oid 113
- in 15: barcode E01015L4, oid 114
- in 16: barcode E01016L4, oid 115
- in 17: barcode E01017L4, oid 116
- in 18: barcode E01018L4, oid 117
- in 19: barcode E01019L4, oid 118
- in 20: barcode E01020L4, oid 119
- in 21: vacant
- in 22: barcode CLN101L4, oid 120
- in 23: barcode CLN102L5, oid 121
- in 24: vacant
- in 25: vacant
- in 26: vacant
- in 27: vacant
- in 28: vacant
- in 29: vacant
- in 30: barcode F01030L5, oid 122
- in 31: barcode F01031L5, oid 123
- in 32: barcode F01032L5, oid 124
- in 33: barcode F01033L5, oid 125
- in 34: barcode F01034L5, oid 126
- in 35: barcode F01035L5, oid 127
- in 36: barcode F01036L5, oid 128
- in 37: barcode F01037L5, oid 129
- in 38: barcode F01038L5, oid 130
- in 39: barcode F01039L5, oid 131
- in iee1: vacant
- in iee2: vacant
- in iee3: vacant
- in iee4: vacant
- in dte1: vacant
- in dte2: vacant
- in dte3: vacant
- in dte4: vacant
- ob> exit
- [root@station90 10]# du -sh *
- 8.0K CLN101L4
- 8.0K CLN102L5
- 140K E01001L4
- 140K E01002L4
- 8.0K E01003L4
- 8.0K E01004L4
- 8.0K E01005L4
- 8.0K E01006L4
- 8.0K E01007L4
- 8.0K E01008L4
- 8.0K E01009L4
- 8.0K E01010L4
- 8.0K E01011L4
- 8.0K E01012L4
- 8.0K E01013L4
- 8.0K E01014L4
- 8.0K E01015L4
- 8.0K E01016L4
- 8.0K E01017L4
- 8.0K E01018L4
- 8.0K E01019L4
- 8.0K E01020L4
- 8.0K F01030L5
- 8.0K F01031L5
- 8.0K F01032L5
- 8.0K F01033L5
- 8.0K F01034L5
- 8.0K F01035L5
- 8.0K F01036L5
- 8.0K F01037L5
- 8.0K F01038L5
- 8.0K F01039L5
- [root@station90 10]#
复制代码 Oracle Suggested Backup策略:
- Daily Script:
- run {
- allocate channel oem_disk_backup device type disk;
- recover copy of database with tag 'ORA_OEM_LEVEL_0';
- backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
- release channel oem_disk_backup;
- allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
- allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
- backup archivelog all not backed up;
- }
- allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
- delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
- Weekly Script:
- run {
- allocate channel oem_disk_backup device type disk;
- recover copy of database with tag 'ORA_OEM_LEVEL_0';
- backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
- release channel oem_disk_backup;
- allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
- allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
- backup recovery area;
- }
- allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
- delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
复制代码 第一天的EM输出:
- Step: Backup
-
- Page Refreshed Sep 14, 2017 8:44:22 PM CST
- View Data
-
- Status Succeeded
- Exit Code 0
- Step ID 215
- Targets orcl.example.com
-
- Started Sep 14, 2017 8:35:22 PM CST
- Ended Sep 14, 2017 8:36:55 PM CST
- Step Elapsed Time 1 minutes, 33 seconds
- Management Service station90.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 Thu Sep 14 20:35:22 2017
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- RMAN>
- connected to target database: ORCL (DBID=1343950367)
- using target database control file instead of recovery catalog
- RMAN>
- echo set on
- RMAN> 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=station90)';
- 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
- 8> backup archivelog all not backed up;
- 9> }
- allocated channel: oem_disk_backup
- channel oem_disk_backup: SID=204 device type=DISK
- Starting recover at 14-SEP-17
- no copy of datafile 1 found to recover
- no copy of datafile 2 found to recover
- no copy of datafile 3 found to recover
- no copy of datafile 4 found to recover
- no copy of datafile 5 found to recover
- Finished recover at 14-SEP-17
- Starting backup at 14-SEP-17
- no parent backup or copy of datafile 1 found
- no parent backup or copy of datafile 2 found
- no parent backup or copy of datafile 3 found
- no parent backup or copy of datafile 5 found
- no parent backup or copy of datafile 4 found
- channel oem_disk_backup: starting datafile copy
- input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
- output file name=+FRA/orcl/datafile/system.276.954707725 tag=ORA_OEM_LEVEL_0 RECID=4 STAMP=954707728
- channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:08
- channel oem_disk_backup: starting datafile copy
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
- output file name=+FRA/orcl/datafile/sysaux.274.954707731 tag=ORA_OEM_LEVEL_0 RECID=5 STAMP=954707734
- channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:07
- channel oem_disk_backup: starting datafile copy
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
- output file name=+FRA/orcl/datafile/undotbs1.273.954707739 tag=ORA_OEM_LEVEL_0 RECID=6 STAMP=954707739
- channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:01
- channel oem_disk_backup: starting datafile copy
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
- output file name=+FRA/orcl/datafile/example.272.954707739 tag=ORA_OEM_LEVEL_0 RECID=7 STAMP=954707740
- channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:01
- channel oem_disk_backup: starting datafile copy
- input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
- output file name=+FRA/orcl/datafile/users.271.954707741 tag=ORA_OEM_LEVEL_0 RECID=8 STAMP=954707741
- channel oem_disk_backup: datafile copy complete, elapsed time: 00:00:01
- Finished backup at 14-SEP-17
- Starting Control File and SPFILE Autobackup at 14-SEP-17
- piece handle=+FRA/orcl/autobackup/2017_09_14/s_954707741.270.954707743 comment=NONE
- Finished Control File and SPFILE Autobackup at 14-SEP-17
- released channel: oem_disk_backup
- allocated channel: oem_sbt_backup1
- channel oem_sbt_backup1: SID=204 device type=SBT_TAPE
- channel oem_sbt_backup1: Oracle Secure Backup
- allocated channel: oem_sbt_backup2
- channel oem_sbt_backup2: SID=82 device type=SBT_TAPE
- channel oem_sbt_backup2: Oracle Secure Backup
- Starting backup at 14-SEP-17
- current log archived
- channel oem_sbt_backup1: starting archived log backup set
- channel oem_sbt_backup1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=35 RECID=27 STAMP=954707754
- channel oem_sbt_backup1: starting piece 1 at 14-SEP-17
- channel oem_sbt_backup1: finished piece 1 at 14-SEP-17
- piece handle=1isefbpb_1_1 tag=TAG20170914T203555 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25
- Finished backup at 14-SEP-17
- Starting Control File and SPFILE Autobackup at 14-SEP-17
- piece handle=c-1343950367-20170914-04 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 14-SEP-17
- released channel: oem_sbt_backup1
- released channel: oem_sbt_backup2
- RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
- allocated channel: ORA_MAINT_SBT_TAPE_1
- channel ORA_MAINT_SBT_TAPE_1: SID=204 device type=SBT_TAPE
- channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup
- RMAN> delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
- no obsolete backups found
- RMAN> exit;
- Recovery Manager complete.
复制代码 第一天的产出物:
- RMAN> list backup;
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 44 Full 9.36M DISK 00:00:01 14-SEP-17
- BP Key: 46 Status: AVAILABLE Compressed: NO Tag: TAG20170914T203541
- Piece Name: +FRA/orcl/autobackup/2017_09_14/s_954707741.270.954707743
- SPFILE Included: Modification time: 13-SEP-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1152721 Ckp time: 14-SEP-17
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 45 4.00M SBT_TAPE 00:00:24 14-SEP-17
- BP Key: 47 Status: AVAILABLE Compressed: NO Tag: TAG20170914T203555
- Handle: 1isefbpb_1_1 Media: station90-000003
- List of Archived Logs in backup set 45
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 35 1150069 14-SEP-17 1152813 14-SEP-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 46 Full 9.50M SBT_TAPE 00:00:15 14-SEP-17
- BP Key: 48 Status: AVAILABLE Compressed: NO Tag: TAG20170914T203620
- Handle: c-1343950367-20170914-04 Media: station90-000003
- SPFILE Included: Modification time: 13-SEP-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1152852 Ckp time: 14-SEP-17
- RMAN>
复制代码- 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
- ------- ---- - --------------- ---------- ---------------
- 4 1 A 14-SEP-17 1152634 14-SEP-17
- Name: +FRA/orcl/datafile/system.276.954707725
- Tag: ORA_OEM_LEVEL_0
- 5 2 A 14-SEP-17 1152644 14-SEP-17
- Name: +FRA/orcl/datafile/sysaux.274.954707731
- Tag: ORA_OEM_LEVEL_0
- 6 3 A 14-SEP-17 1152685 14-SEP-17
- Name: +FRA/orcl/datafile/undotbs1.273.954707739
- Tag: ORA_OEM_LEVEL_0
- 8 4 A 14-SEP-17 1152711 14-SEP-17
- Name: +FRA/orcl/datafile/users.271.954707741
- Tag: ORA_OEM_LEVEL_0
- 7 5 A 14-SEP-17 1152698 14-SEP-17
- Name: +FRA/orcl/datafile/example.272.954707739
- Tag: ORA_OEM_LEVEL_0
- List of Archived Log Copies for database with db_unique_name ORCL
- =====================================================================
- Key Thrd Seq S Low Time
- ------- ---- ------- - ---------
- 27 1 35 A 14-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_14/thread_1_seq_35.269.954707755
- RMAN>
复制代码 第二天EM的输出:
- Step: Backup
-
- Page Refreshed Sep 15, 2017 8:37:18 PM CST
- View Data
-
- Status Succeeded
- Exit Code 0
- Step ID 241
- Targets orcl.example.com
-
- Started Sep 15, 2017 8:35:26 PM CST
- Ended Sep 15, 2017 8:36:45 PM CST
- Step Elapsed Time 1 minutes, 19 seconds
- Management Service station90.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 Fri Sep 15 20:35:26 2017
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- RMAN>
- connected to target database: ORCL (DBID=1343950367)
- using target database control file instead of recovery catalog
- RMAN>
- echo set on
- RMAN> 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=station90)';
- 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
- 8> backup archivelog all not backed up;
- 9> }
- allocated channel: oem_disk_backup
- channel oem_disk_backup: SID=13 device type=DISK
- Starting recover at 15-SEP-17
- no copy of datafile 1 found to recover
- no copy of datafile 2 found to recover
- no copy of datafile 3 found to recover
- no copy of datafile 4 found to recover
- no copy of datafile 5 found to recover
- Finished recover at 15-SEP-17
- Starting backup at 15-SEP-17
- channel oem_disk_backup: starting incremental level 1 datafile backup set
- channel oem_disk_backup: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
- input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
- channel oem_disk_backup: starting piece 1 at 15-SEP-17
- channel oem_disk_backup: finished piece 1 at 15-SEP-17
- piece handle=+FRA/orcl/backupset/2017_09_15/nnndn1_ora_oem_level_0_0.268.954794129 tag=ORA_OEM_LEVEL_0 comment=NONE
- channel oem_disk_backup: backup set complete, elapsed time: 00:00:03
- Finished backup at 15-SEP-17
- Starting Control File and SPFILE Autobackup at 15-SEP-17
- piece handle=+FRA/orcl/autobackup/2017_09_15/s_954794131.267.954794133 comment=NONE
- Finished Control File and SPFILE Autobackup at 15-SEP-17
- released channel: oem_disk_backup
- allocated channel: oem_sbt_backup1
- channel oem_sbt_backup1: SID=13 device type=SBT_TAPE
- channel oem_sbt_backup1: Oracle Secure Backup
- allocated channel: oem_sbt_backup2
- channel oem_sbt_backup2: SID=130 device type=SBT_TAPE
- channel oem_sbt_backup2: Oracle Secure Backup
- Starting backup at 15-SEP-17
- current log archived
- skipping archived log file +FRA/orcl/archivelog/2017_09_14/thread_1_seq_35.269.954707755; already backed on 14-SEP-17
- channel oem_sbt_backup1: starting archived log backup set
- channel oem_sbt_backup1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=36 RECID=28 STAMP=954794144
- channel oem_sbt_backup1: starting piece 1 at 15-SEP-17
- channel oem_sbt_backup1: finished piece 1 at 15-SEP-17
- piece handle=1msei051_1_1 tag=TAG20170915T203545 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25
- Finished backup at 15-SEP-17
- Starting Control File and SPFILE Autobackup at 15-SEP-17
- piece handle=c-1343950367-20170915-01 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 15-SEP-17
- released channel: oem_sbt_backup1
- released channel: oem_sbt_backup2
- RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
- allocated channel: ORA_MAINT_SBT_TAPE_1
- channel ORA_MAINT_SBT_TAPE_1: SID=13 device type=SBT_TAPE
- channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup
- RMAN> delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
- no obsolete backups found
- RMAN> exit;
- Recovery Manager complete.
复制代码 第二天的产出物:
- RMAN> list backup;
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 44 Full 9.36M DISK 00:00:01 14-SEP-17
- BP Key: 46 Status: AVAILABLE Compressed: NO Tag: TAG20170914T203541
- Piece Name: +FRA/orcl/autobackup/2017_09_14/s_954707741.270.954707743
- SPFILE Included: Modification time: 13-SEP-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1152721 Ckp time: 14-SEP-17
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 45 4.00M SBT_TAPE 00:00:24 14-SEP-17
- BP Key: 47 Status: AVAILABLE Compressed: NO Tag: TAG20170914T203555
- Handle: 1isefbpb_1_1 Media: station90-000003
- List of Archived Logs in backup set 45
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 35 1150069 14-SEP-17 1152813 14-SEP-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 46 Full 9.50M SBT_TAPE 00:00:15 14-SEP-17
- BP Key: 48 Status: AVAILABLE Compressed: NO Tag: TAG20170914T203620
- Handle: c-1343950367-20170914-04 Media: station90-000003
- SPFILE Included: Modification time: 13-SEP-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1152852 Ckp time: 14-SEP-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 47 Incr 1 17.88M DISK 00:00:02 15-SEP-17
- BP Key: 49 Status: AVAILABLE Compressed: NO Tag: ORA_OEM_LEVEL_0
- Piece Name: +FRA/orcl/backupset/2017_09_15/nnndn1_ora_oem_level_0_0.268.954794129
- List of Datafiles in backup set 47
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 1 Incr 1155512 15-SEP-17 +DATA/orcl/datafile/system.256.816169553
- 2 1 Incr 1155512 15-SEP-17 +DATA/orcl/datafile/sysaux.257.816169553
- 3 1 Incr 1155512 15-SEP-17 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 1 Incr 1155512 15-SEP-17 +DATA/orcl/datafile/users.259.816169553
- 5 1 Incr 1155512 15-SEP-17 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 48 Full 9.36M DISK 00:00:01 15-SEP-17
- BP Key: 50 Status: AVAILABLE Compressed: NO Tag: TAG20170915T203531
- Piece Name: +FRA/orcl/autobackup/2017_09_15/s_954794131.267.954794133
- SPFILE Included: Modification time: 13-SEP-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1155522 Ckp time: 15-SEP-17
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 49 11.50M SBT_TAPE 00:00:25 15-SEP-17
- BP Key: 51 Status: AVAILABLE Compressed: NO Tag: TAG20170915T203545
- Handle: 1msei051_1_1 Media: station90-000003
- List of Archived Logs in backup set 49
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 36 1152813 14-SEP-17 1155635 15-SEP-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 50 Full 9.50M SBT_TAPE 00:00:15 15-SEP-17
- BP Key: 52 Status: AVAILABLE Compressed: NO Tag: TAG20170915T203610
- Handle: c-1343950367-20170915-01 Media: station90-000003
- SPFILE Included: Modification time: 13-SEP-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1155702 Ckp time: 15-SEP-17
- RMAN>
复制代码- 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
- ------- ---- - --------------- ---------- ---------------
- 4 1 A 14-SEP-17 1152634 14-SEP-17
- Name: +FRA/orcl/datafile/system.276.954707725
- Tag: ORA_OEM_LEVEL_0
- 5 2 A 14-SEP-17 1152644 14-SEP-17
- Name: +FRA/orcl/datafile/sysaux.274.954707731
- Tag: ORA_OEM_LEVEL_0
- 6 3 A 14-SEP-17 1152685 14-SEP-17
- Name: +FRA/orcl/datafile/undotbs1.273.954707739
- Tag: ORA_OEM_LEVEL_0
- 8 4 A 14-SEP-17 1152711 14-SEP-17
- Name: +FRA/orcl/datafile/users.271.954707741
- Tag: ORA_OEM_LEVEL_0
- 7 5 A 14-SEP-17 1152698 14-SEP-17
- Name: +FRA/orcl/datafile/example.272.954707739
- Tag: ORA_OEM_LEVEL_0
- List of Archived Log Copies for database with db_unique_name ORCL
- =====================================================================
- Key Thrd Seq S Low Time
- ------- ---- ------- - ---------
- 27 1 35 A 14-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_14/thread_1_seq_35.269.954707755
- 28 1 36 A 14-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_15/thread_1_seq_36.266.954794145
- RMAN>
复制代码 第三天EM的输出:
- Step: Backup
-
- Page Refreshed Sep 16, 2017 8:37:32 PM CST
- View Data
-
- Status Succeeded
- Exit Code 0
- Step ID 267
- Targets orcl.example.com
-
- Started Sep 16, 2017 8:35:28 PM CST
- Ended Sep 16, 2017 8:37:06 PM CST
- Step Elapsed Time 1 minutes, 38 seconds
- Management Service station90.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 Sat Sep 16 20:35:29 2017
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- RMAN>
- connected to target database: ORCL (DBID=1343950367)
- using target database control file instead of recovery catalog
- RMAN>
- echo set on
- RMAN> 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=station90)';
- 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
- 8> backup archivelog all not backed up;
- 9> }
- allocated channel: oem_disk_backup
- channel oem_disk_backup: SID=135 device type=DISK
- Starting recover at 16-SEP-17
- channel oem_disk_backup: starting incremental datafile backup set restore
- channel oem_disk_backup: specifying datafile copies to recover
- recovering datafile copy file number=00001 name=+FRA/orcl/datafile/system.276.954707725
- recovering datafile copy file number=00002 name=+FRA/orcl/datafile/sysaux.274.954707731
- recovering datafile copy file number=00003 name=+FRA/orcl/datafile/undotbs1.273.954707739
- recovering datafile copy file number=00004 name=+FRA/orcl/datafile/users.271.954707741
- recovering datafile copy file number=00005 name=+FRA/orcl/datafile/example.272.954707739
- channel oem_disk_backup: reading from backup piece +FRA/orcl/backupset/2017_09_15/nnndn1_ora_oem_level_0_0.268.954794129
- channel oem_disk_backup: piece handle=+FRA/orcl/backupset/2017_09_15/nnndn1_ora_oem_level_0_0.268.954794129 tag=ORA_OEM_LEVEL_0
- channel oem_disk_backup: restored backup piece 1
- channel oem_disk_backup: restore complete, elapsed time: 00:00:03
- Finished recover at 16-SEP-17
- Starting backup at 16-SEP-17
- channel oem_disk_backup: starting incremental level 1 datafile backup set
- channel oem_disk_backup: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
- input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
- channel oem_disk_backup: starting piece 1 at 16-SEP-17
- channel oem_disk_backup: finished piece 1 at 16-SEP-17
- piece handle=+FRA/orcl/backupset/2017_09_16/nnndn1_ora_oem_level_0_0.263.954880539 tag=ORA_OEM_LEVEL_0 comment=NONE
- channel oem_disk_backup: backup set complete, elapsed time: 00:00:07
- Finished backup at 16-SEP-17
- Starting Control File and SPFILE Autobackup at 16-SEP-17
- piece handle=+FRA/orcl/autobackup/2017_09_16/s_954880542.261.954880543 comment=NONE
- Finished Control File and SPFILE Autobackup at 16-SEP-17
- released channel: oem_disk_backup
- allocated channel: oem_sbt_backup1
- channel oem_sbt_backup1: SID=135 device type=SBT_TAPE
- channel oem_sbt_backup1: Oracle Secure Backup
- allocated channel: oem_sbt_backup2
- channel oem_sbt_backup2: SID=197 device type=SBT_TAPE
- channel oem_sbt_backup2: Oracle Secure Backup
- Starting backup at 16-SEP-17
- current log archived
- skipping archived log file +FRA/orcl/archivelog/2017_09_14/thread_1_seq_35.269.954707755; already backed on 14-SEP-17
- skipping archived log file +FRA/orcl/archivelog/2017_09_15/thread_1_seq_36.266.954794145; already backed on 15-SEP-17
- channel oem_sbt_backup1: starting archived log backup set
- channel oem_sbt_backup1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=37 RECID=29 STAMP=954880359
- input archived log thread=1 sequence=38 RECID=30 STAMP=954880389
- channel oem_sbt_backup1: starting piece 1 at 16-SEP-17
- channel oem_sbt_backup2: starting archived log backup set
- channel oem_sbt_backup2: specifying archived log(s) in backup set
- input archived log thread=1 sequence=39 RECID=31 STAMP=954880555
- channel oem_sbt_backup2: starting piece 1 at 16-SEP-17
- channel oem_sbt_backup1: finished piece 1 at 16-SEP-17
- piece handle=1qsekkhc_1_1 tag=TAG20170916T203555 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25
- channel oem_sbt_backup2: finished piece 1 at 16-SEP-17
- piece handle=1rsekkhc_1_1 tag=TAG20170916T203555 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup2: backup set complete, elapsed time: 00:00:35
- Finished backup at 16-SEP-17
- Starting Control File and SPFILE Autobackup at 16-SEP-17
- piece handle=c-1343950367-20170916-01 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 16-SEP-17
- released channel: oem_sbt_backup1
- released channel: oem_sbt_backup2
- RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
- allocated channel: ORA_MAINT_SBT_TAPE_1
- channel ORA_MAINT_SBT_TAPE_1: SID=135 device type=SBT_TAPE
- channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup
- RMAN> delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
- no obsolete backups found
- RMAN> exit;
- Recovery Manager complete.
复制代码 第三天产出物:
看滚雪球:
- 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 16-SEP-17 1155512 15-SEP-17
- Name: +FRA/orcl/datafile/system.276.954707725
- Tag: ORA_OEM_LEVEL_0
- 13 2 A 16-SEP-17 1155512 15-SEP-17
- Name: +FRA/orcl/datafile/sysaux.274.954707731
- Tag: ORA_OEM_LEVEL_0
- 12 3 A 16-SEP-17 1155512 15-SEP-17
- Name: +FRA/orcl/datafile/undotbs1.273.954707739
- Tag: ORA_OEM_LEVEL_0
- 10 4 A 16-SEP-17 1155512 15-SEP-17
- Name: +FRA/orcl/datafile/users.271.954707741
- Tag: ORA_OEM_LEVEL_0
- 9 5 A 16-SEP-17 1155512 15-SEP-17
- Name: +FRA/orcl/datafile/example.272.954707739
- Tag: ORA_OEM_LEVEL_0
- List of Archived Log Copies for database with db_unique_name ORCL
- =====================================================================
- Key Thrd Seq S Low Time
- ------- ---- ------- - ---------
- 27 1 35 A 14-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_14/thread_1_seq_35.269.954707755
- 28 1 36 A 14-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_15/thread_1_seq_36.266.954794145
- 29 1 37 A 15-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_37.265.954880359
- 30 1 38 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_38.264.954880389
- 31 1 39 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_39.262.954880555
- RMAN>
复制代码 周备份EM输出:
- Step: Backup
-
- Page Refreshed Sep 17, 2017 8:39:54 PM CST
- View Data
-
- Status Succeeded
- Exit Code 0
- Step ID 293
- Targets orcl.example.com
-
- Started Sep 17, 2017 8:35:21 PM CST
- Ended Sep 17, 2017 8:39:06 PM CST
- Step Elapsed Time 3 minutes, 45 seconds
- Management Service station90.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 Sun Sep 17 20:35:22 2017
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- RMAN>
- connected to target database: ORCL (DBID=1343950367)
- using target database control file instead of recovery catalog
- RMAN>
- echo set on
- RMAN> 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=station90)';
- 7> allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
- 8> backup recovery area;
- 9> }
- allocated channel: oem_disk_backup
- channel oem_disk_backup: SID=79 device type=DISK
- Starting recover at 17-SEP-17
- channel oem_disk_backup: starting incremental datafile backup set restore
- channel oem_disk_backup: specifying datafile copies to recover
- recovering datafile copy file number=00001 name=+FRA/orcl/datafile/system.276.954707725
- recovering datafile copy file number=00002 name=+FRA/orcl/datafile/sysaux.274.954707731
- recovering datafile copy file number=00003 name=+FRA/orcl/datafile/undotbs1.273.954707739
- recovering datafile copy file number=00004 name=+FRA/orcl/datafile/users.271.954707741
- recovering datafile copy file number=00005 name=+FRA/orcl/datafile/example.272.954707739
- channel oem_disk_backup: reading from backup piece +FRA/orcl/backupset/2017_09_16/nnndn1_ora_oem_level_0_0.263.954880539
- channel oem_disk_backup: piece handle=+FRA/orcl/backupset/2017_09_16/nnndn1_ora_oem_level_0_0.263.954880539 tag=ORA_OEM_LEVEL_0
- channel oem_disk_backup: restored backup piece 1
- channel oem_disk_backup: restore complete, elapsed time: 00:00:03
- Finished recover at 17-SEP-17
- Starting backup at 17-SEP-17
- channel oem_disk_backup: starting incremental level 1 datafile backup set
- channel oem_disk_backup: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
- input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
- channel oem_disk_backup: starting piece 1 at 17-SEP-17
- channel oem_disk_backup: finished piece 1 at 17-SEP-17
- piece handle=+FRA/orcl/backupset/2017_09_17/nnndn1_ora_oem_level_0_0.278.954966931 tag=ORA_OEM_LEVEL_0 comment=NONE
- channel oem_disk_backup: backup set complete, elapsed time: 00:00:07
- Finished backup at 17-SEP-17
- Starting Control File and SPFILE Autobackup at 17-SEP-17
- piece handle=+FRA/orcl/autobackup/2017_09_17/s_954966934.279.954966935 comment=NONE
- Finished Control File and SPFILE Autobackup at 17-SEP-17
- released channel: oem_disk_backup
- allocated channel: oem_sbt_backup1
- channel oem_sbt_backup1: SID=79 device type=SBT_TAPE
- channel oem_sbt_backup1: Oracle Secure Backup
- allocated channel: oem_sbt_backup2
- channel oem_sbt_backup2: SID=142 device type=SBT_TAPE
- channel oem_sbt_backup2: Oracle Secure Backup
- Starting backup at 17-SEP-17
- skipping archived log file +FRA/orcl/archivelog/2017_09_14/thread_1_seq_35.269.954707755; already backed up 1 time(s)
- skipping archived log file +FRA/orcl/archivelog/2017_09_15/thread_1_seq_36.266.954794145; already backed up 1 time(s)
- skipping archived log file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_37.265.954880359; already backed up 1 time(s)
- skipping archived log file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_38.264.954880389; already backed up 1 time(s)
- skipping archived log file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_39.262.954880555; already backed up 1 time(s)
- channel oem_sbt_backup1: starting full datafile backup set
- channel oem_sbt_backup1: including datafile copy of datafile 00002 in backup set
- input file name=+FRA/orcl/datafile/sysaux.274.954707731
- channel oem_sbt_backup1: including datafile copy of datafile 00003 in backup set
- input file name=+FRA/orcl/datafile/undotbs1.273.954707739
- channel oem_sbt_backup1: including datafile copy of datafile 00005 in backup set
- input file name=+FRA/orcl/datafile/example.272.954707739
- channel oem_sbt_backup1: starting piece 1 at 17-SEP-17
- channel oem_sbt_backup2: starting full datafile backup set
- channel oem_sbt_backup2: including datafile copy of datafile 00001 in backup set
- input file name=+FRA/orcl/datafile/system.276.954707725
- channel oem_sbt_backup2: including datafile copy of datafile 00004 in backup set
- input file name=+FRA/orcl/datafile/users.271.954707741
- channel oem_sbt_backup2: starting piece 1 at 17-SEP-17
- channel oem_sbt_backup1: finished piece 1 at 17-SEP-17
- piece handle=1vsen8t4_1_1 tag=TAG20170917T203547 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:35
- channel oem_sbt_backup1: starting archived log backup set
- channel oem_sbt_backup1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=40 RECID=32 STAMP=954966748
- channel oem_sbt_backup1: starting piece 1 at 17-SEP-17
- channel oem_sbt_backup2: finished piece 1 at 17-SEP-17
- piece handle=20sen8t4_1_1 tag=TAG20170917T203547 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup2: backup set complete, elapsed time: 00:00:35
- channel oem_sbt_backup2: starting archived log backup set
- channel oem_sbt_backup2: specifying archived log(s) in backup set
- input archived log thread=1 sequence=41 RECID=33 STAMP=954966917
- channel oem_sbt_backup2: starting piece 1 at 17-SEP-17
- channel oem_sbt_backup1: finished piece 1 at 17-SEP-17
- piece handle=21sen8u7_1_1 tag=TAG20170917T203547 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup1: backup set complete, elapsed time: 00:00:25
- channel oem_sbt_backup2: finished piece 1 at 17-SEP-17
- piece handle=22sen8u7_1_1 tag=TAG20170917T203547 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup2: backup set complete, elapsed time: 00:00:25
- channel oem_sbt_backup1: input backup set: count=49, stamp=954707741, piece=1
- channel oem_sbt_backup1: starting piece 1 at 17-SEP-17
- channel oem_sbt_backup1: backup piece +FRA/orcl/autobackup/2017_09_14/s_954707741.270.954707743
- channel oem_sbt_backup2: input backup set: count=52, stamp=954794128, piece=1
- channel oem_sbt_backup2: starting piece 1 at 17-SEP-17
- channel oem_sbt_backup2: backup piece +FRA/orcl/backupset/2017_09_15/nnndn1_ora_oem_level_0_0.268.954794129
- piece handle=c-1343950367-20170914-03 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup1: finished piece 1 at 17-SEP-17
- channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:25
- channel oem_sbt_backup1: input backup set: count=53, stamp=954794131, piece=1
- channel oem_sbt_backup1: starting piece 1 at 17-SEP-17
- channel oem_sbt_backup1: backup piece +FRA/orcl/autobackup/2017_09_15/s_954794131.267.954794133
- piece handle=1ksei04g_1_2 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup2: finished piece 1 at 17-SEP-17
- channel oem_sbt_backup2: backup piece complete, elapsed time: 00:00:26
- channel oem_sbt_backup2: input backup set: count=56, stamp=954880535, piece=1
- channel oem_sbt_backup2: starting piece 1 at 17-SEP-17
- channel oem_sbt_backup2: backup piece +FRA/orcl/backupset/2017_09_16/nnndn1_ora_oem_level_0_0.263.954880539
- piece handle=c-1343950367-20170915-00 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup1: finished piece 1 at 17-SEP-17
- channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:26
- channel oem_sbt_backup1: input backup set: count=57, stamp=954880542, piece=1
- channel oem_sbt_backup1: starting piece 1 at 17-SEP-17
- channel oem_sbt_backup1: backup piece +FRA/orcl/autobackup/2017_09_16/s_954880542.261.954880543
- piece handle=1osekkgn_1_2 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup2: finished piece 1 at 17-SEP-17
- channel oem_sbt_backup2: backup piece complete, elapsed time: 00:00:25
- channel oem_sbt_backup2: input backup set: count=61, stamp=954966927, piece=1
- channel oem_sbt_backup2: starting piece 1 at 17-SEP-17
- channel oem_sbt_backup2: backup piece +FRA/orcl/backupset/2017_09_17/nnndn1_ora_oem_level_0_0.278.954966931
- piece handle=c-1343950367-20170916-00 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup1: finished piece 1 at 17-SEP-17
- channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:25
- channel oem_sbt_backup1: input backup set: count=62, stamp=954966934, piece=1
- channel oem_sbt_backup1: starting piece 1 at 17-SEP-17
- channel oem_sbt_backup1: backup piece +FRA/orcl/autobackup/2017_09_17/s_954966934.279.954966935
- piece handle=1tsen8sf_1_2 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup2: finished piece 1 at 17-SEP-17
- channel oem_sbt_backup2: backup piece complete, elapsed time: 00:00:26
- piece handle=c-1343950367-20170917-00 comment=API Version 2.0,MMS Version 10.4.0.4
- channel oem_sbt_backup1: finished piece 1 at 17-SEP-17
- channel oem_sbt_backup1: backup piece complete, elapsed time: 00:00:26
- Finished backup at 17-SEP-17
- Starting Control File and SPFILE Autobackup at 17-SEP-17
- piece handle=c-1343950367-20170917-01 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 17-SEP-17
- released channel: oem_sbt_backup1
- released channel: oem_sbt_backup2
- RMAN> allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
- allocated channel: ORA_MAINT_SBT_TAPE_1
- channel ORA_MAINT_SBT_TAPE_1: SID=79 device type=SBT_TAPE
- channel ORA_MAINT_SBT_TAPE_1: Oracle Secure Backup
- RMAN> delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
- no obsolete backups found
- RMAN> exit;
- Recovery Manager complete.
复制代码 周备份的产出物:
- RMAN> list copy;
- using target database control file instead of recovery catalog
- specification does not match any control file copy in the repository
- List of Datafile Copies
- =======================
- Key File S Completion Time Ckp SCN Ckp Time
- ------- ---- - --------------- ---------- ---------------
- 17 1 A 17-SEP-17 1165770 16-SEP-17
- Name: +FRA/orcl/datafile/system.276.954707725
- Tag: ORA_OEM_LEVEL_0
- 18 2 A 17-SEP-17 1165770 16-SEP-17
- Name: +FRA/orcl/datafile/sysaux.274.954707731
- Tag: ORA_OEM_LEVEL_0
- 16 3 A 17-SEP-17 1165770 16-SEP-17
- Name: +FRA/orcl/datafile/undotbs1.273.954707739
- Tag: ORA_OEM_LEVEL_0
- 15 4 A 17-SEP-17 1165770 16-SEP-17
- Name: +FRA/orcl/datafile/users.271.954707741
- Tag: ORA_OEM_LEVEL_0
- 14 5 A 17-SEP-17 1165770 16-SEP-17
- Name: +FRA/orcl/datafile/example.272.954707739
- Tag: ORA_OEM_LEVEL_0
- List of Archived Log Copies for database with db_unique_name ORCL
- =====================================================================
- Key Thrd Seq S Low Time
- ------- ---- ------- - ---------
- 27 1 35 A 14-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_14/thread_1_seq_35.269.954707755
- 28 1 36 A 14-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_15/thread_1_seq_36.266.954794145
- 29 1 37 A 15-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_37.265.954880359
- 30 1 38 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_38.264.954880389
- 31 1 39 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_39.262.954880555
- 32 1 40 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_17/thread_1_seq_40.275.954966747
- 33 1 41 A 17-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_17/thread_1_seq_41.277.954966917
- RMAN>
复制代码
|
|