标题: RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece [打印本页] 作者: jiawang 时间: 2020-8-20 15:37 标题: RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece 问题描述：
在通过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