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 spfile from '/u01/app/backup/system_0su4hc4b_1_1'; Starting restore at 2019-06-27 22:49:26 using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 06/27/2019 22:49:26 RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece RMAN>
发现文件权限设置问题
[root@hear backup]# ll total 1184116 -rw-r-----. 1 root root 1202700288 Jun 27 20:45 system_0ru4hc1a_1_1 -rw-r-----. 1 root root 9830400 Jun 27 20:45 system_0su4hc4b_1_1 [root@hear backup]# pwd /u01/app/backup [root@hear backup]# chown oracle:oinstall //u01/app/backup/* [root@hear backup]# ll total 1184116 -rw-r-----. 1 oracle oinstall 1202700288 Jun 27 20:45 system_0ru4hc1a_1_1 -rw-r-----. 1 oracle oinstall 9830400 Jun 27 20:45 system_0su4hc4b_1_1 [root@hear backup]#