课程第28次
2019-07-20并行度是由输入文件的个数决定的，
是由通道来执行完成，而通道是由设备来提供的。
磁带机：
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;磁盘：
RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM8BACKUP TYPE TO BACKUPSET;对于磁带机，为了确定卷标通常会去“实例化”并行度的通道：
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS'ENV=(OB_MEDIA_FAMILY=station76)';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS'ENV=(OB_MEDIA_FAMILY=station76)';
https://192.168.0.76:1158/em/console/database/rec/config?event=start&target=orcl.example.com&type=oracle_database
下面研究一下"maxpiecesize":
改配置之前的show all:
<p>RMAN> show all;</p><p>RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS'ENV=(OB_MEDIA_FAMILY=station76)';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS'ENV=(OB_MEDIA_FAMILY=station76)';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
改配置之后：
请注意：CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 250 M;
RMAN> show all;
starting full resync of recovery catalog
full resync complete
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS'ENV=(OB_MEDIA_FAMILY=station76)';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS'ENV=(OB_MEDIA_FAMILY=station76)';
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 250 M;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS'ENV=(OB_MEDIA_FAMILY=station76)' MAXPIECESIZE 250 M;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN>backup tag '2T-WHOLE-INCR0'incremental level 0 database plus archivelog delete all input ;
Starting backup at 20-JUL-19
current log archived
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=73 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=78 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
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=6 RECID=1 STAMP=1013962566
input archived log thread=1 sequence=7 RECID=2 STAMP=1013962567
input archived log thread=1 sequence=8 RECID=3 STAMP=1013962569
input archived log thread=1 sequence=9 RECID=4 STAMP=1013962572
input archived log thread=1 sequence=10 RECID=5 STAMP=1013962572
input archived log thread=1 sequence=11 RECID=6 STAMP=1013962574
input archived log thread=1 sequence=12 RECID=7 STAMP=1013962576
input archived log thread=1 sequence=13 RECID=8 STAMP=1013962580
input archived log thread=1 sequence=14 RECID=9 STAMP=1013962581
input archived log thread=1 sequence=15 RECID=10 STAMP=1013963203
input archived log thread=1 sequence=16 RECID=11 STAMP=1013963204
input archived log thread=1 sequence=17 RECID=12 STAMP=1013963208
input archived log thread=1 sequence=18 RECID=13 STAMP=1013963210
input archived log thread=1 sequence=19 RECID=14 STAMP=1013963211
input archived log thread=1 sequence=20 RECID=15 STAMP=1013963213
input archived log thread=1 sequence=21 RECID=16 STAMP=1013963213
input archived log thread=1 sequence=22 RECID=17 STAMP=1013963214
input archived log thread=1 sequence=23 RECID=18 STAMP=1013963215
input archived log thread=1 sequence=24 RECID=19 STAMP=1013963216
input archived log thread=1 sequence=25 RECID=20 STAMP=1013963217
channel ORA_SBT_TAPE_1: starting piece 1 at 20-JUL-19
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=26 RECID=21 STAMP=1013963217
input archived log thread=1 sequence=27 RECID=22 STAMP=1013963218
input archived log thread=1 sequence=28 RECID=23 STAMP=1013963219
input archived log thread=1 sequence=29 RECID=24 STAMP=1013963219
input archived log thread=1 sequence=30 RECID=25 STAMP=1013963220
input archived log thread=1 sequence=31 RECID=26 STAMP=1013963220
input archived log thread=1 sequence=32 RECID=27 STAMP=1013963221
input archived log thread=1 sequence=33 RECID=28 STAMP=1013963222
input archived log thread=1 sequence=34 RECID=29 STAMP=1013963222
input archived log thread=1 sequence=35 RECID=30 STAMP=1013966650
input archived log thread=1 sequence=36 RECID=32 STAMP=1013970799
input archived log thread=1 sequence=37 RECID=31 STAMP=1013970799
input archived log thread=1 sequence=38 RECID=33 STAMP=1013970808
input archived log thread=1 sequence=39 RECID=34 STAMP=1013970808
input archived log thread=1 sequence=40 RECID=35 STAMP=1013970811
input archived log thread=1 sequence=41 RECID=36 STAMP=1013970811
input archived log thread=1 sequence=42 RECID=37 STAMP=1014072930
input archived log thread=1 sequence=43 RECID=38 STAMP=1014073619
input archived log thread=1 sequence=44 RECID=39 STAMP=1014073954
channel ORA_SBT_TAPE_2: starting piece 1 at 20-JUL-19
channel ORA_SBT_TAPE_1: finished piece 1 at 20-JUL-19
piece handle=0fu735s6_1_1 tag=2T-WHOLE-INCR0 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_1: deleting archived log(s)
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_6.262.1013962565 RECID=1 STAMP=1013962566
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_7.263.1013962567 RECID=2 STAMP=1013962567
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_8.264.1013962569 RECID=3 STAMP=1013962569
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_9.265.1013962571 RECID=4 STAMP=1013962572
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_10.266.1013962573 RECID=5 STAMP=1013962572
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_11.267.1013962573 RECID=6 STAMP=1013962574
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_12.268.1013962577 RECID=7 STAMP=1013962576
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_13.269.1013962579 RECID=8 STAMP=1013962580
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_14.270.1013962581 RECID=9 STAMP=1013962581
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_15.271.1013963203 RECID=10 STAMP=1013963203
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_16.272.1013963205 RECID=11 STAMP=1013963204
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_17.273.1013963209 RECID=12 STAMP=1013963208
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_18.274.1013963211 RECID=13 STAMP=1013963210
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_19.275.1013963211 RECID=14 STAMP=1013963211
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_20.276.1013963213 RECID=15 STAMP=1013963213
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_21.277.1013963213 RECID=16 STAMP=1013963213
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_22.278.1013963215 RECID=17 STAMP=1013963214
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_23.279.1013963215 RECID=18 STAMP=1013963215
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_24.280.1013963217 RECID=19 STAMP=1013963216
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_25.281.1013963217 RECID=20 STAMP=1013963217
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=45 RECID=40 STAMP=1014077306
channel ORA_SBT_TAPE_1: starting piece 1 at 20-JUL-19
channel ORA_SBT_TAPE_2: finished piece 1 at 20-JUL-19
piece handle=0gu735s7_1_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:32
channel ORA_SBT_TAPE_2: deleting archived log(s)
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_26.282.1013963217 RECID=21 STAMP=1013963217
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_27.283.1013963219 RECID=22 STAMP=1013963218
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_28.284.1013963219 RECID=23 STAMP=1013963219
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_29.285.1013963219 RECID=24 STAMP=1013963219
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_30.286.1013963219 RECID=25 STAMP=1013963220
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_31.287.1013963221 RECID=26 STAMP=1013963220
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_32.288.1013963221 RECID=27 STAMP=1013963221
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_33.289.1013963223 RECID=28 STAMP=1013963222
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_34.290.1013963223 RECID=29 STAMP=1013963222
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_35.291.1013966651 RECID=30 STAMP=1013966650
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_36.292.1013970799 RECID=32 STAMP=1013970799
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_37.293.1013970799 RECID=31 STAMP=1013970799
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_38.294.1013970809 RECID=33 STAMP=1013970808
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_39.295.1013970809 RECID=34 STAMP=1013970808
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_40.296.1013970811 RECID=35 STAMP=1013970811
archived log file name=+FRA/orcl/archivelog/2019_07_18/thread_1_seq_41.297.1013970811 RECID=36 STAMP=1013970811
archived log file name=+FRA/orcl/archivelog/2019_07_19/thread_1_seq_42.298.1014072929 RECID=37 STAMP=1014072930
archived log file name=+FRA/orcl/archivelog/2019_07_19/thread_1_seq_43.300.1014073619 RECID=38 STAMP=1014073619
archived log file name=+FRA/orcl/archivelog/2019_07_19/thread_1_seq_44.301.1014073951 RECID=39 STAMP=1014073954
channel ORA_SBT_TAPE_1: finished piece 1 at 20-JUL-19
piece handle=0hu735t7_1_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:18
channel ORA_SBT_TAPE_1: deleting archived log(s)
archived log file name=+FRA/orcl/archivelog/2019_07_20/thread_1_seq_45.303.1014077305 RECID=40 STAMP=1014077306
Finished backup at 20-JUL-19
Starting backup at 20-JUL-19
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1013960881
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.1013960987
channel ORA_SBT_TAPE_1: starting piece 1 at 20-JUL-19
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.1013960883
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.1013960883
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1013960885
channel ORA_SBT_TAPE_2: starting piece 1 at 20-JUL-19
channel ORA_SBT_TAPE_2: finished piece 1 at 20-JUL-19
piece handle=0ju735ts_1_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_2: starting piece 2 at 20-JUL-19
channel ORA_SBT_TAPE_1: finished piece 1 at 20-JUL-19
piece handle=0iu735ts_1_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: starting piece 2 at 20-JUL-19
channel ORA_SBT_TAPE_2: finished piece 2 at 20-JUL-19
piece handle=0ju735ts_2_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:47
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_SBT_TAPE_2: starting piece 1 at 20-JUL-19
channel ORA_SBT_TAPE_1: finished piece 2 at 20-JUL-19
piece handle=0iu735ts_2_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: starting piece 3 at 20-JUL-19
channel ORA_SBT_TAPE_2: finished piece 1 at 20-JUL-19
piece handle=0ku735vd_1_1 tag=2T-WHOLE-INCR0 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_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_SBT_TAPE_2: starting piece 1 at 20-JUL-19
channel ORA_SBT_TAPE_2: finished piece 1 at 20-JUL-19
piece handle=0lu73607_1_1 tag=2T-WHOLE-INCR0 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: finished piece 3 at 20-JUL-19
piece handle=0iu735ts_3_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:50
Finished backup at 20-JUL-19
Starting backup at 20-JUL-19
current log archived
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
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=46 RECID=41 STAMP=1014077483
channel ORA_SBT_TAPE_1: starting piece 1 at 20-JUL-19
channel ORA_SBT_TAPE_1: finished piece 1 at 20-JUL-19
piece handle=0mu7361d_1_1 tag=2T-WHOLE-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:15
channel ORA_SBT_TAPE_1: deleting archived log(s)
archived log file name=+FRA/orcl/archivelog/2019_07_20/thread_1_seq_46.303.1014077483 RECID=41 STAMP=1014077483
Finished backup at 20-JUL-19
RMAN> list backup of tablespace system;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
157 Full 647.25M SBT_TAPE 00:03:16 18-JUL-19
BP Key: 169 Status: AVAILABLECompressed: NOTag: TAG20190718T173340
Handle: 04u6vqbl_1_1 Media: station76-000001
List of Datafiles in backup set 157
File LV Type Ckp SCN Ckp TimeName
---- -- ---- ---------- --------- ----
1 Full 1034213 18-JUL-19 +DATA/orcl/datafile/system.256.1013960881
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
161 Full 648.75M SBT_TAPE 00:04:00 18-JUL-19
BP Key: 173 Status: AVAILABLECompressed: NOTag: TAG20190718T182614
Handle: 08u6vte7_1_1 Media: station76-000001,station76-000003
List of Datafiles in backup set 161
File LV Type Ckp SCN Ckp TimeName
---- -- ---- ---------- --------- ----
1 Full 1037207 18-JUL-19 +DATA/orcl/datafile/system.256.1013960881
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
165 Full 649.00M SBT_TAPE 00:00:28 18-JUL-19
BP Key: 177 Status: AVAILABLECompressed: NOTag: TAG20190718T183055
Handle: 0cu6vtmv_1_1 Media: station76-000003
List of Datafiles in backup set 165
File LV Type Ckp SCN Ckp TimeName
---- -- ---- ---------- --------- ----
1 Full 1037443 18-JUL-19 +DATA/orcl/datafile/system.256.1013960881
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
286 Incr 0712.75M SBT_TAPE 00:01:46 20-JUL-19
List of Datafiles in backup set 286
File LV Type Ckp SCN Ckp TimeName
---- -- ---- ---------- --------- ----
1 0Incr 1082359 20-JUL-19 +DATA/orcl/datafile/system.256.1013960881
Backup Set Copy #1 of backup set 286
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
SBT_TAPE 00:01:46 20-JUL-19 NO 2T-WHOLE-INCR0
List of Backup Pieces for backup set 286 Copy #1
BP KeyPc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
292 1 AVAILABLE station76-000002 0iu735ts_1_1
293 2 AVAILABLE station76-000002,station76-000004 0iu735ts_2_1
294 3 AVAILABLE station76-000004 0iu735ts_3_1
RMAN>
如果RMAN默认去磁带机，但是临时要去磁盘，请参考：
Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jul 20 00:42:04 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
RMAN>
connected to target database: ORCL (DBID=1541741703)
using target database control file instead of recovery catalog
RMAN>
echo set on
RMAN> set command id to 'BACKUP_ORCL.EXAMPL_072019124141';
executing command: SET COMMAND ID
RMAN> backup incremental level 1 cumulative device type disk tag 'BACKUP_ORCL.EXAMPL_072019124141' database;
Starting backup at 20-JUL-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=53 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=72 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=59 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=49 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=42 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=1 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=48 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=80 device type=DISK
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.1013960881
channel ORA_DISK_1: starting piece 1 at 20-JUL-19
channel ORA_DISK_2: starting incremental level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.1013960883
channel ORA_DISK_2: starting piece 1 at 20-JUL-19
channel ORA_DISK_3: starting incremental level 1 datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.1013960987
channel ORA_DISK_3: starting piece 1 at 20-JUL-19
channel ORA_DISK_4: starting incremental level 1 datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.1013960883
channel ORA_DISK_4: starting piece 1 at 20-JUL-19
channel ORA_DISK_5: starting incremental level 1 datafile backup set
channel ORA_DISK_5: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1013960885
channel ORA_DISK_5: starting piece 1 at 20-JUL-19
channel ORA_DISK_5: finished piece 1 at 20-JUL-19
piece handle=+FRA/orcl/backupset/2019_07_20/nnndn1_backup_orcl.exampl_0720191241_0.297.1014079337 tag=BACKUP_ORCL.EXAMPL_072019124141 comment=NONE
channel ORA_DISK_5: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: finished piece 1 at 20-JUL-19
piece handle=+FRA/orcl/backupset/2019_07_20/nnndn1_backup_orcl.exampl_0720191241_0.303.1014079335 tag=BACKUP_ORCL.EXAMPL_072019124141 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
channel ORA_DISK_2: finished piece 1 at 20-JUL-19
piece handle=+FRA/orcl/backupset/2019_07_20/nnndn1_backup_orcl.exampl_0720191241_0.301.1014079335 tag=BACKUP_ORCL.EXAMPL_072019124141 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:08
channel ORA_DISK_3: finished piece 1 at 20-JUL-19
piece handle=+FRA/orcl/backupset/2019_07_20/nnndn1_backup_orcl.exampl_0720191241_0.300.1014079335 tag=BACKUP_ORCL.EXAMPL_072019124141 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:08
channel ORA_DISK_4: finished piece 1 at 20-JUL-19
piece handle=+FRA/orcl/backupset/2019_07_20/nnndn1_backup_orcl.exampl_0720191241_0.298.1014079335 tag=BACKUP_ORCL.EXAMPL_072019124141 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed time: 00:00:08
Finished backup at 20-JUL-19
Starting Control File and SPFILE Autobackup at 20-JUL-19
piece handle=+FRA/orcl/autobackup/2019_07_20/s_1014079343.296.1014079343 comment=NONE
Finished Control File and SPFILE Autobackup at 20-JUL-19
RMAN> backup device type disk tag 'BACKUP_ORCL.EXAMPL_072019124141' archivelog all not backed up delete all input;
Starting backup at 20-JUL-19
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=47 RECID=42 STAMP=1014079348
channel ORA_DISK_1: starting piece 1 at 20-JUL-19
channel ORA_DISK_1: finished piece 1 at 20-JUL-19
piece handle=+FRA/orcl/backupset/2019_07_20/annnf0_backup_orcl.exampl_0720191241_0.294.1014079349 tag=BACKUP_ORCL.EXAMPL_072019124141 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+FRA/orcl/archivelog/2019_07_20/thread_1_seq_47.295.1014079347 RECID=42 STAMP=1014079348
Finished backup at 20-JUL-19
Starting Control File and SPFILE Autobackup at 20-JUL-19
piece handle=+FRA/orcl/autobackup/2019_07_20/s_1014079351.295.1014079353 comment=NONE
Finished Control File and SPFILE Autobackup at 20-JUL-19
RMAN> exit;
Recovery Manager complete.
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_SID=orcl
ORACLE_BASE=/u01/app/oracle
*/3* * * * /u01/app/oracle/product/11.2.0/dbhome_1/bin/rmantarget / catalog u76/oracle_4U@rcat cmdfile=/home/oracle/backupusers.rcv
页:
[1]