IT博客汇 | RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

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

Adamhuan发表于 2017-03-14 06:43:08

在使用RMAN恢复文件的时候，可能你会遇到如下所示的错误：

在我的环境里，我是在恢复控制文件的时候遇到的：

RMAN> restore controlfile from '/xxx/auto_controlc-2600836681-20170314-01';

Starting restore at 14-MAR-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1093 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/14/2017 14:37:40
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN>

造成该错误，有可能是因为RMAN没有权限操作你指定的目标文件造成的。

如下：

[root@xxx /]# ls -ltr /Trade
total 65334756
-rw-r----- 1 root   root         7933952 Mar 14 13:41 ARC_12467_1_938376904.bk
-rw-r----- 1 root   root       348174848 Mar 14 13:41 ARC_12465_1_938330827.bk
-rw-r----- 1 root   root        35584000 Mar 14 13:41 ARC_12469_1_938463304.bk
-rw-r----- 1 root   root       984540160 Mar 14 13:42 ARC_12471_1_938549707.bk
-rw-r----- 1 root   root       935067648 Mar 14 13:42 ARC_12472_1_938549804.bk
-rw-r----- 1 root   root       987440128 Mar 14 13:43 ARC_12473_1_938549901.bk
-rw-r----- 1 root   root       963453952 Mar 14 13:43 ARC_12474_1_938549998.bk
-rw-r----- 1 root   root       945367040 Mar 14 13:44 ARC_12475_1_938550095.bk
-rw-r----- 1 root   root       691497984 Mar 14 13:44 ARC_12476_1_938550191.bk
-rw-r----- 1 root   root       675165696 Mar 14 13:45 ARC_12487_1_938563502.bk
-rw-r----- 1 root   root       262144512 Mar 14 13:45 ARC_7376_1_899974576.bk
-rw-r----- 1 root   root        11600384 Mar 14 13:45 block_change_trace.trc
-rw-r----- 1 root   root     18993143808 Mar 14 13:54 ORA_12458_1_938323804.bk
-rw-r----- 1 root   root     19781369856 Mar 14 14:02 ORA_12459_1_938325979.bk
-rw-r----- 1 root   root     20598153216 Mar 14 14:10 ORA_12460_1_938328345.bk
-rw-r----- 1 root   root       397680640 Mar 14 14:10 ORA_12478_1_938563204.bk
-rw-r----- 1 root   root        70885376 Mar 14 14:10 ORA_12479_1_938563309.bk
-rw-r----- 1 root   root        45432832 Mar 14 14:10 ORA_12480_1_938563364.bk
-rw-r----- 1 root   root         1662976 Mar 14 14:10 ORA_12483_1_938563490.bk
-rw-r----- 1 root   root        21086208 Mar 14 14:10 ORA_12482_1_938563454.bk
-rw-r----- 1 root   root        71327744 Mar 14 14:10 ORA_12481_1_938563399.bk
drwxr-xr-x 2 oracle oinstall        4096 Mar 14 14:23 redolog
drwxr-xr-x 2 oracle oinstall        4096 Mar 14 14:23 oradata
drwxr-xr-x 2 oracle oinstall        4096 Mar 14 14:23 flash_recovery_area
drwxr-xr-x 2 oracle oinstall        4096 Mar 14 14:23 arch
-rw-r----- 1 root   root         8585216 Mar 14 14:30 auto_controlc-2600836681-20170314-01
[root@xxx /]#

将权限赋予上去，就好了：

[root@xxx /]# chown -R oracle.oinstall /xxx
[root@xxx /]# 
[root@xxx /]# ls -ltr /xxx
total 65334756
-rw-r----- 1 oracle oinstall     7933952 Mar 14 13:41 ARC_12467_1_938376904.bk
-rw-r----- 1 oracle oinstall   348174848 Mar 14 13:41 ARC_12465_1_938330827.bk
-rw-r----- 1 oracle oinstall    35584000 Mar 14 13:41 ARC_12469_1_938463304.bk
-rw-r----- 1 oracle oinstall   984540160 Mar 14 13:42 ARC_12471_1_938549707.bk
-rw-r----- 1 oracle oinstall   935067648 Mar 14 13:42 ARC_12472_1_938549804.bk
-rw-r----- 1 oracle oinstall   987440128 Mar 14 13:43 ARC_12473_1_938549901.bk
-rw-r----- 1 oracle oinstall   963453952 Mar 14 13:43 ARC_12474_1_938549998.bk
-rw-r----- 1 oracle oinstall   945367040 Mar 14 13:44 ARC_12475_1_938550095.bk
-rw-r----- 1 oracle oinstall   691497984 Mar 14 13:44 ARC_12476_1_938550191.bk
-rw-r----- 1 oracle oinstall   675165696 Mar 14 13:45 ARC_12487_1_938563502.bk
-rw-r----- 1 oracle oinstall   262144512 Mar 14 13:45 ARC_7376_1_899974576.bk
-rw-r----- 1 oracle oinstall    11600384 Mar 14 13:45 block_change_trace.trc
-rw-r----- 1 oracle oinstall 18993143808 Mar 14 13:54 ORA_12458_1_938323804.bk
-rw-r----- 1 oracle oinstall 19781369856 Mar 14 14:02 ORA_12459_1_938325979.bk
-rw-r----- 1 oracle oinstall 20598153216 Mar 14 14:10 ORA_12460_1_938328345.bk
-rw-r----- 1 oracle oinstall   397680640 Mar 14 14:10 ORA_12478_1_938563204.bk
-rw-r----- 1 oracle oinstall    70885376 Mar 14 14:10 ORA_12479_1_938563309.bk
-rw-r----- 1 oracle oinstall    45432832 Mar 14 14:10 ORA_12480_1_938563364.bk
-rw-r----- 1 oracle oinstall     1662976 Mar 14 14:10 ORA_12483_1_938563490.bk
-rw-r----- 1 oracle oinstall    21086208 Mar 14 14:10 ORA_12482_1_938563454.bk
-rw-r----- 1 oracle oinstall    71327744 Mar 14 14:10 ORA_12481_1_938563399.bk
drwxr-xr-x 2 oracle oinstall        4096 Mar 14 14:23 redolog
drwxr-xr-x 2 oracle oinstall        4096 Mar 14 14:23 oradata
drwxr-xr-x 2 oracle oinstall        4096 Mar 14 14:23 flash_recovery_area
drwxr-xr-x 2 oracle oinstall        4096 Mar 14 14:23 arch
-rw-r----- 1 oracle oinstall     8585216 Mar 14 14:30 auto_controlc-2600836681-20170314-01
[root@xxx /]#

权限授予了之后，再操作RMAN：

RMAN> restore controlfile from '/xxx/auto_controlc-2600836681-20170314-01';  

Starting restore at 14-MAR-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1091 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output filename=/xxx/oradata/control01.ctl
output filename=/xxx/oradata/control02.ctl
output filename=/xxx/oradata/control03.ctl
Finished restore at 14-MAR-17

RMAN>

————————————————————
Done。