Thanks for the question, Tyler.
Asked: June 30, 2021 - 1:49 pm UTC
Last updated: July 15, 2021 - 3:42 am UTC
Version: 19.7
Viewed 1000+ times
You Asked
Hey guys,
Running a 2 node RAC and I’m trying to utilize parallelism for backups but I’m not having any success. When I monitor gv$session_longops I see sessions on both instances but there are like 2 sessions from instance x and the rest go to instance y. Wondering if I’m missing something or doing something wrong or what is going on.
Working with 32cpu on each instance on Linux
uname -a
Linux <> 4.18.0-305.el8.x86_64 #1 SMP Thu Apr 29 08:54:30 EDT 2021 x86_64 x86_64 x86_64 GNU/Linux
I set up tns entries as
RMAN_PROD1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <host_one>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD)
(INSTANCE_NAME = PROD1)
)
)
RMAN_PROD2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <host_two>)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = PROD)
(INSTANCE_NAME = PROD2)
)
)
I set up a common user in CDB$ROOT (c##SW_BACKUP below) and then try to assign 2 channels (one per instance) and then backup (log shown)
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jul 6 07:58:37 2021
Version 19.7.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=485338250)
RMAN>
echo set on
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name PROD are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 64;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';
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 RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/snapcf_DW.f';
RMAN> run {
2> configure channel 1 device type disk connect *;
3> configure channel 2 device type disk connect *;
4> configure device type disk backup type to compressed backupset parallelism 64;
5> configure archivelog deletion policy to backed up 2 times to device type disk;
6> configure retention policy to redundancy 2;
7> configure controlfile autobackup on;
8> configure snapshot controlfile NAME TO '+DATA/snapcf_DW.f';
9> crosscheck backup;
10> crosscheck copy;
11> backup as compressed backupset incremental level=0 database plus archivelog FORMAT '+DATA' SECTION SIZE 16G;
12> delete noprompt obsolete;
13> }
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 48;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 64;
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/snapcf_DW.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/snapcf_DW.f';
new RMAN configuration parameters are successfully stored
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=713 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=2603 instance=PROD2 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=2841 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=4021 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=6140 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=6616 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=7324 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=243 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_9
channel ORA_DISK_9: SID=948 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_10
channel ORA_DISK_10: SID=1190 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_11
channel ORA_DISK_11: SID=1426 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_12
channel ORA_DISK_12: SID=2134 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_13
channel ORA_DISK_13: SID=2366 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_14
channel ORA_DISK_14: SID=3079 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_15
channel ORA_DISK_15: SID=3315 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_16
channel ORA_DISK_16: SID=3546 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_17
channel ORA_DISK_17: SID=3782 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_18
channel ORA_DISK_18: SID=4961 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_19
channel ORA_DISK_19: SID=4729 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_20
channel ORA_DISK_20: SID=5199 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_21
channel ORA_DISK_21: SID=5675 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_22
channel ORA_DISK_22: SID=6145 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_23
channel ORA_DISK_23: SID=6377 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_24
channel ORA_DISK_24: SID=6615 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_25
channel ORA_DISK_25: SID=6850 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_26
channel ORA_DISK_26: SID=7087 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_27
channel ORA_DISK_27: SID=7325 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_28
channel ORA_DISK_28: SID=6 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_29
channel ORA_DISK_29: SID=242 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_30
channel ORA_DISK_30: SID=479 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_31
channel ORA_DISK_31: SID=716 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_32
channel ORA_DISK_32: SID=952 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_33
channel ORA_DISK_33: SID=1186 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_34
channel ORA_DISK_34: SID=1422 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_35
channel ORA_DISK_35: SID=1662 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_36
channel ORA_DISK_36: SID=1894 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_37
channel ORA_DISK_37: SID=2135 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_38
channel ORA_DISK_38: SID=2367 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_39
channel ORA_DISK_39: SID=2605 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_40
channel ORA_DISK_40: SID=2837 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_41
channel ORA_DISK_41: SID=3080 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_42
channel ORA_DISK_42: SID=3311 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_43
channel ORA_DISK_43: SID=3542 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_44
channel ORA_DISK_44: SID=3784 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_45
channel ORA_DISK_45: SID=4020 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_46
channel ORA_DISK_46: SID=4257 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_47
channel ORA_DISK_47: SID=4494 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_48
channel ORA_DISK_48: SID=4726 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_49
channel ORA_DISK_49: SID=4965 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_50
channel ORA_DISK_50: SID=5202 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_51
channel ORA_DISK_51: SID=5438 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_52
channel ORA_DISK_52: SID=5672 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_53
channel ORA_DISK_53: SID=5909 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_54
channel ORA_DISK_54: SID=6144 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_55
channel ORA_DISK_55: SID=6379 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_56
channel ORA_DISK_56: SID=6613 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_57
channel ORA_DISK_57: SID=6851 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_58
channel ORA_DISK_58: SID=7089 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_59
channel ORA_DISK_59: SID=7327 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_60
channel ORA_DISK_60: SID=7 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_61
channel ORA_DISK_61: SID=244 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_62
channel ORA_DISK_62: SID=480 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_63
channel ORA_DISK_63: SID=717 instance=PROD1 device type=DISK
allocated channel: ORA_DISK_64
channel ORA_DISK_64: SID=953 instance=PROD1 device type=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.926.1076409053 RECID=1250 STAMP=1076409052
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.929.1076409075 RECID=1251 STAMP=1076409075
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.931.1076409091 RECID=1252 STAMP=1076409091
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.924.1076409049 RECID=1253 STAMP=1076409048
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.935.1076409101 RECID=1254 STAMP=1076409100
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.938.1076409119 RECID=1255 STAMP=1076409118
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.941.1076409119 RECID=1256 STAMP=1076409119
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.943.1076409131 RECID=1257 STAMP=1076409130
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.946.1076409137 RECID=1258 STAMP=1076409137
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.948.1076409157 RECID=1259 STAMP=1076409157
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.951.1076409157 RECID=1260 STAMP=1076409157
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.953.1076409183 RECID=1261 STAMP=1076409182
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.956.1076409187 RECID=1262 STAMP=1076409187
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.958.1076409199 RECID=1263 STAMP=1076409198
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.962.1076409209 RECID=1264 STAMP=1076409208
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.965.1076409211 RECID=1265 STAMP=1076409210
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.967.1076409227 RECID=1266 STAMP=1076409227
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.970.1076409231 RECID=1267 STAMP=1076409231
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.972.1076409239 RECID=1268 STAMP=1076409238
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.978.1076409259 RECID=1269 STAMP=1076409258
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.975.1076409243 RECID=1270 STAMP=1076409242
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.980.1076409275 RECID=1271 STAMP=1076409275
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C331BF75DC96FC0DE0530E6716AC4323/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.984.1076409299 RECID=1272 STAMP=1076409298
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F2A9D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.987.1076409299 RECID=1273 STAMP=1076409299
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.989.1076409325 RECID=1274 STAMP=1076409325
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F2A9D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.992.1076409327 RECID=1275 STAMP=1076409327
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C331BF75DC96FC0DE0530E6716AC4323/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.997.1076409361 RECID=1276 STAMP=1076409360
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C331BF75DC96FC0DE0530E6716AC4323/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.995.1076409355 RECID=1277 STAMP=1076409354
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1000.1076409385 RECID=1278 STAMP=1076409384
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1003.1076409395 RECID=1279 STAMP=1076409395
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F2A9D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1005.1076409401 RECID=1280 STAMP=1076409400
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F2A9D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1008.1076409415 RECID=1281 STAMP=1076409414
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1012.1076409421 RECID=1282 STAMP=1076409420
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1015.1076409435 RECID=1283 STAMP=1076409434
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.737.1076409021 RECID=1284 STAMP=1076409020
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.905.1076409025 RECID=1285 STAMP=1076409025
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.908.1076409027 RECID=1286 STAMP=1076409026
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.903.1076409025 RECID=1287 STAMP=1076409024
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1930.1076409023 RECID=1288 STAMP=1076409022
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.581.1076409023 RECID=1315 STAMP=1076409022
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1900.1076409023 RECID=1289 STAMP=1076409022
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1898.1076409021 RECID=1290 STAMP=1076409021
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1896.1076409021 RECID=1291 STAMP=1076409021
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.912.1076409027 RECID=1292 STAMP=1076409026
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.907.1076409027 RECID=1293 STAMP=1076409025
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.916.1076409045 RECID=1294 STAMP=1076409045
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.921.1076409047 RECID=1295 STAMP=1076409046
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.573.1076409023 RECID=1296 STAMP=1076409022
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.913.1076409031 RECID=1297 STAMP=1076409030
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.918.1076409045 RECID=1298 STAMP=1076409045
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.910.1076409027 RECID=1299 STAMP=1076409026
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1906.1076409023 RECID=1301 STAMP=1076409022
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1892.1076409021 RECID=1302 STAMP=1076409021
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t121340_0.674.1076415267 RECID=1358 STAMP=1076415267
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1884.1076409021 RECID=1300 STAMP=1076409021
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1904.1076409023 RECID=1303 STAMP=1076409022
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.568.1076409023 RECID=1304 STAMP=1076409022
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1888.1076409021 RECID=1305 STAMP=1076409021
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.897.1076409025 RECID=1311 STAMP=1076409024
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.895.1076409025 RECID=1312 STAMP=1076409023
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.901.1076409025 RECID=1317 STAMP=1076409024
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.887.1076409023 RECID=1320 STAMP=1076409023
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.890.1076409023 RECID=1321 STAMP=1076409023
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.896.1076409025 RECID=1322 STAMP=1076409024
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.891.1076409023 RECID=1324 STAMP=1076409023
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.892.1076409023 RECID=1325 STAMP=1076409023
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+DATA/PROD/BACKUPSET/2021_06_28/annnf0_tag20210628t113000_0.569.1076412601 RECID=1330 STAMP=1076412600
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+DATA/PROD/BACKUPSET/2021_06_28/annnf0_tag20210628t113000_0.573.1076412601 RECID=1331 STAMP=1076412600
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+DATA/PROD/BACKUPSET/2021_06_28/annnf0_tag20210628t113000_0.577.1076412601 RECID=1332 STAMP=1076412600
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+DATA/PROD/BACKUPSET/2021_06_28/annnf0_tag20210628t113000_0.574.1076412601 RECID=1333 STAMP=1076412600
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+DATA/PROD/BACKUPSET/2021_06_28/annnf0_tag20210628t113000_0.580.1076412601 RECID=1334 STAMP=1076412600
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+DATA/PROD/BACKUPSET/2021_06_28/annnf0_tag20210628t113000_0.575.1076412601 RECID=1335 STAMP=1076412600
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+DATA/PROD/BACKUPSET/2021_06_28/annnf0_tag20210628t121336_0.734.1076415217 RECID=1337 STAMP=1076415216
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+DATA/PROD/BACKUPSET/2021_06_28/annnf0_tag20210628t121336_0.729.1076415217 RECID=1338 STAMP=1076415216
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+DATA/PROD/BACKUPSET/2021_06_28/annnf0_tag20210628t121336_0.737.1076415217 RECID=1339 STAMP=1076415216
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+DATA/PROD/BACKUPSET/2021_06_28/annnf0_tag20210628t121336_0.738.1076415217 RECID=1342 STAMP=1076415216
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+DATA/PROD/BACKUPSET/2021_06_28/annnf0_tag20210628t121336_0.743.1076415217 RECID=1343 STAMP=1076415216
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+DATA/PROD/BACKUPSET/2021_06_28/annnf0_tag20210628t121336_0.745.1076415217 RECID=1345 STAMP=1076415216
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+DATA/PROD/BACKUPSET/2021_06_28/annnf0_tag20210628t121336_0.666.1076415217 RECID=1346 STAMP=1076415217
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+DATA/PROD/BACKUPSET/2021_06_28/annnf0_tag20210628t121336_0.667.1076415217 RECID=1347 STAMP=1076415217
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1878.1076409021 RECID=1306 STAMP=1076409021
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1890.1076409021 RECID=1307 STAMP=1076409021
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.586.1076409023 RECID=1308 STAMP=1076409023
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.571.1076409023 RECID=1309 STAMP=1076409022
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1866.1076409021 RECID=1310 STAMP=1076409021
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.584.1076409023 RECID=1313 STAMP=1076409022
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1880.1076409021 RECID=1314 STAMP=1076409021
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/BACKUPSET/2021_06_28/nnndn0_tag20210628t121340_0.343.1076415297 RECID=1372 STAMP=1076415297
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1864.1076409021 RECID=1316 STAMP=1076409021
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C331BF75DC96FC0DE0530E6716AC4323/BACKUPSET/2021_06_28/nnndn0_tag20210628t121340_0.324.1076415341 RECID=1379 STAMP=1076415340
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1870.1076409021 RECID=1318 STAMP=1076409021
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1874.1076409021 RECID=1319 STAMP=1076409021
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C331BF75DC96FC0DE0530E6716AC4323/BACKUPSET/2021_06_28/nnndn0_tag20210628t121340_0.552.1076415341 RECID=1380 STAMP=1076415339
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t121340_0.327.1076415349 RECID=1381 STAMP=1076415349
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F289D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t121340_0.682.1076415351 RECID=1382 STAMP=1076415351
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.1872.1076409021 RECID=1323 STAMP=1076409020
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F2A9D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t121340_0.492.1076415353 RECID=1383 STAMP=1076415353
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F2A9D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t121340_0.687.1076415353 RECID=1384 STAMP=1076415353
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.589.1076409023 RECID=1326 STAMP=1076409023
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=+RECO/PROD/C446DAC48F259D9FE0530E6716AC29E0/BACKUPSET/2021_06_28/nnndn0_tag20210628t103016_0.594.1076409023 RECID=1327 STAMP=1076409023
crosschecked backup piece: found to be 'AVAILABLE'
bChee
and Connor said...
Thanks for your patience. A few key points here
1) crosscheck
RMAN will happily take care of deleting obsolete backups etc when you run the DELETE command.
'crosscheck' is for when *something* has happened outside of RMAN's vision, and you need to get RMAN back in sync with the real world, ie, an abnormal event.
Lets say an archivelog has mistakenly been deleted at OS level.
Without crosscheck: Any RMAN trial recovery, real recovery, or validate command is going to say: "I am expecting to find this archivelog, ie, at some stage I backed it up and now it aint there....You need to fix this"
With crosscheck: Any RMAN trial recovery, real recovery, or validate command is going to say: "Everything is fine, the list of archives I expect matches those on the OS so we're good"......but of course, you're not good, you're screwed :-)
If RMAN is out of sync with the real world, you want it to complain, so you can take reparative action. That action might be a crosscheck, but its an out-of-the-normal operation, not part of the regular backup.
2) channels
Channel configuration is not a template as such, its a genuine channel specification, So if you do
configure channel 1 as ...
configure channel 2 as ...
configure parallelism 12
you have really only "locked down" the connection details for the first 2 channels. If you want to lock down 12 channels worth of parallelim, then run 12 configure command BUT see the next point
3) instance specific connections
... are a bad idea, because if an instance is down, then your RMAN script doesn't *skip* that instance, it just doesn't run at all. Better to have a single service name that is defined as (say) round robin load balanced. In that way, you don't need instance specific connections - every channel just connects to the same service name and if an instance is down etc, your script still runs just fine
4) overload
32 cpus x 2 instances does not equate to using parallelism 64 for RMAN because you might swamp the nodes and the traffic to/from them...which spells trouble for clusterware. Start small and scale up to a point of diminishing returns, eg
- parallel 2 might take 6 hours,
- parallel 6 might take 3 hours
- parallel 8 might take 2 hours
- parallel 12 might take 1hour 50.
which tells you that much about 8 is just a waste of resources.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment