RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

jiawang

问题描述：
在通过RMAN将数据库恢复到同类机异机的时候，restore spfile一直报RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
报错现象：

RMAN> restore controlfile to '+DATADG/hisdb/controlfile/current.256.885665935' from '/home/backup20200819/ctl_HISDB_51v89350_1_1.bak';

Starting restore at 20-AUG-20
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/20/2020 15:31:26
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

最后发现是自己对文件权限设置的问题
[oracle@hisdb1 backup20200819]$ ll
total 377137124
-rw-r-----. 1 root root  5068097024 Aug 19 18:17 arch_HISDB_4rv892e1_1_1.bak
-rw-r-----. 1 root root  6104348672 Aug 19 18:20 arch_HISDB_4sv892e2_1_1.bak
-rw-r-----. 1 root root  6146285568 Aug 19 18:22 arch_HISDB_4tv892e2_1_1.bak
-rw-r-----. 1 root root  6116790784 Aug 19 18:24 arch_HISDB_4uv892e3_1_1.bak
-rw-r-----. 1 root root  5996995584 Aug 19 18:26 arch_HISDB_4vv892e4_1_1.bak
-rw-r-----. 1 root root  5167246336 Aug 19 18:28 arch_HISDB_50v892e5_1_1.bak
-rw-r-----. 1 root root    21430272 Aug 19 18:28 ctl_HISDB_51v89350_1_1.bak
-rw-r-----. 1 root root 57814433792 Aug 19 18:49 full_HISDB_4fv88o5c_1_1.bak
-rw-r-----. 1 root root 47590244352 Aug 19 19:01 full_HISDB_4gv88o5c_1_1.bak
-rw-r-----. 1 root root 32462479360 Aug 19 19:10 full_HISDB_4hv88o5d_1_1.bak
-rw-r-----. 1 root root 63493324800 Aug 19 19:27 full_HISDB_4iv88o5d_1_1.bak
-rw-r-----. 1 root root 79401295872 Aug 19 19:47 full_HISDB_4jv88o5d_1_1.bak
-rw-r-----. 1 root root 70805356544 Aug 19 20:05 full_HISDB_4kv88o5e_1_1.bak

[root@hisdb1 home]# chown -R oracle:dba backup20200819

再次执行恢复控制文件成功；
RMAN> restore controlfile to '+DATADG/hisdb/controlfile/current.256.885665935' from '/home/backup20200819/ctl_HISDB_51v89350_1_1.bak';

Starting restore at 20-AUG-20
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 20-AUG-20

RMAN>