rman导入时reading的路径与注册备份集的路径不一致

rman导入时reading的路径与注册备份集的路径不一致

一、问题背景

在rman导入时，读取的文件与之前注册的备份集路径不一致
reading from backup piece xxx.bak
1
2

二、问题原因

rman中已经存在了失效的备份集路径，就是之前导数时注册的路径，已经失效了，但是还是会去找

1.标记失效路径
RMAN>
run{
allocate channel ch1 DEVICE TYPE DISK;
allocate channel ch2 DEVICE TYPE DISK;
crosscheck backup;
release channel ch1;
release channel ch2;
}

2.删除失效的注册集路径
RMAN>
run{
allocate channel ch1 DEVICE TYPE DISK;
allocate channel ch2 DEVICE TYPE DISK;
delete noprompt expired backup;
release channel ch1;
release channel ch2;
}

3.删除无用归档（确定没用再删除，这条命令可以忽略，只执行上面两条就行）
delete force archivelog all;

4.从新注册备份集
catalog start with '/xxx/xxx/xxx';
list backup summary;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26