rman 恢复 错误
环境描述:
备份到本地 磁盘存储上的全备份不能恢复:
备份到本地 磁盘存储上的全备份不能恢复:
[ora@DB01_manage] /tmp 973> df -g
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 2.00 1.02 49% 9190 4% /
/dev/hd2 4.00 1.88 54% 48127 10% /usr
/dev/hd9var 4.00 3.54 12% 4906 1% /var
/dev/hd3 15.00 7.79 49% 4109 1% /tmp
/dev/fwdump 1.00 1.00 1% 5 1% /var/adm/ras/platform
/dev/hd1 2.00 1.30 36% 2441 1% /home
/proc - - - - - /proc
/dev/hd10opt 2.00 1.39 31% 4373 2% /opt
/dev/lvora 16.00 7.75 52% 36170 2% /oracle
/dev/fslv00 399.00 294.07 27% 1749 1% /arch
/dev/fslv01 2996.00 2354.07 22% 34968 1% /bustest
/dev/fslv02 1997.00 729.53 64% 11 1% /bus_bak
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 2.00 1.02 49% 9190 4% /
/dev/hd2 4.00 1.88 54% 48127 10% /usr
/dev/hd9var 4.00 3.54 12% 4906 1% /var
/dev/hd3 15.00 7.79 49% 4109 1% /tmp
/dev/fwdump 1.00 1.00 1% 5 1% /var/adm/ras/platform
/dev/hd1 2.00 1.30 36% 2441 1% /home
/proc - - - - - /proc
/dev/hd10opt 2.00 1.39 31% 4373 2% /opt
/dev/lvora 16.00 7.75 52% 36170 2% /oracle
/dev/fslv00 399.00 294.07 27% 1749 1% /arch
/dev/fslv01 2996.00 2354.07 22% 34968 1% /bustest
/dev/fslv02 1997.00 729.53 64% 11 1% /bus_bak
[ora@DB01_manage] /tmp 974> cd /bus_bak
[ora@DB01_manage] /bus_bak 976> ls -la
total 2657438984
drwxrwxrwx 4 oracle dba 8192 Nov 15 12:50 .
drwxr-xr-x 46 root system 4096 Aug 25 14:06 ..
drwxr-xr-x 2 oracle dba 256 Dec 03 2010 595
-rw-r----- 1 ora oinstall 41828352 Nov 15 12:50 control01.ctl
-rw-r----- 1 ora oinstall 41828352 Nov 15 12:50 control02.ctl
-rw-r----- 1 ora oinstall 41828352 Nov 15 12:50 control03.ctl
-rw-r----- 1 ora oinstall 469047705600 Nov 09 15:58 full_BUSDB_n1mr7ko0
-rw-r----- 1 ora oinstall 452601675776 Nov 09 15:55 full_BUSDB_n2mr7ko0
-rw-r----- 1 ora oinstall 438722969600 Nov 09 15:50 full_BUSDB_n3mr7ko0
drwxrwxrwx 2 root system 256 Nov 08 2010 lost+found
total 2657438984
drwxrwxrwx 4 oracle dba 8192 Nov 15 12:50 .
drwxr-xr-x 46 root system 4096 Aug 25 14:06 ..
drwxr-xr-x 2 oracle dba 256 Dec 03 2010 595
-rw-r----- 1 ora oinstall 41828352 Nov 15 12:50 control01.ctl
-rw-r----- 1 ora oinstall 41828352 Nov 15 12:50 control02.ctl
-rw-r----- 1 ora oinstall 41828352 Nov 15 12:50 control03.ctl
-rw-r----- 1 ora oinstall 469047705600 Nov 09 15:58 full_BUSDB_n1mr7ko0
-rw-r----- 1 ora oinstall 452601675776 Nov 09 15:55 full_BUSDB_n2mr7ko0
-rw-r----- 1 ora oinstall 438722969600 Nov 09 15:50 full_BUSDB_n3mr7ko0
drwxrwxrwx 2 root system 256 Nov 08 2010 lost+found
---这个备份是nocatalog 进行的备份,可以看到备份集概况:
RMAN> list backup summary;
14637 B F A DISK 2011-11-14 1 1 NO TAG20111114T081731
14638 B F A DISK 2011-11-14 1 1 NO TAG20111114T084616
14639 B F A DISK 2011-11-14 1 1 NO TAG20111114T084747
14640 B F A DISK 2011-11-14 1 1 NO TAG20111114T085547
14641 B F A DISK 2011-11-14 1 1 NO TAG20111114T085639
14642 B F A DISK 2011-11-14 1 1 NO TAG20111114T090544
14643 B F A DISK 2011-11-14 1 1 NO TAG20111114T090647
14644 B F A DISK 2011-11-14 1 1 NO TAG20111114T091221
14645 B F A DISK 2011-11-14 1 1 NO TAG20111114T091319
14646 B F A DISK 2011-11-14 1 1 NO TAG20111114T091420
14647 B F A DISK 2011-11-14 1 1 NO TAG20111114T091502
14648 B F A DISK 2011-11-14 1 1 NO TAG20111114T091529
14649 B F A DISK 2011-11-14 1 1 NO TAG20111114T091559
14650 B F A DISK 2011-11-14 1 1 NO TAG20111114T091614
14651 B F A DISK 2011-11-14 1 1 NO TAG20111114T091633
14652 B F A DISK 2011-11-14 1 1 NO TAG20111114T091816
14653 B F A DISK 2011-11-14 1 1 NO TAG20111114T091830
14654 B F A DISK 2011-11-14 1 1 NO TAG20111114T091844
14655 B F A DISK 2011-11-14 1 1 NO TAG20111114T091918
14656 B F A DISK 2011-11-14 1 1 NO TAG20111114T091925
14657 B F A DISK 2011-11-14 1 1 NO TAG20111114T091930
14658 B F A DISK 2011-11-14 1 1 NO TAG20111114T091936
14659 B F A DISK 2011-11-14 1 1 NO TAG20111114T091942
14660 B F A DISK 2011-11-14 1 1 NO TAG20111114T092517
14661 B F A DISK 2011-11-14 1 1 NO TAG20111114T092818
14662 B F A DISK 2011-11-14 1 1 NO TAG20111114T092927
14663 B F A DISK 2011-11-14 1 1 NO TAG20111114T092953
14664 B F A DISK 2011-11-14 1 1 NO TAG20111114T094044
14637 B F A DISK 2011-11-14 1 1 NO TAG20111114T081731
14638 B F A DISK 2011-11-14 1 1 NO TAG20111114T084616
14639 B F A DISK 2011-11-14 1 1 NO TAG20111114T084747
14640 B F A DISK 2011-11-14 1 1 NO TAG20111114T085547
14641 B F A DISK 2011-11-14 1 1 NO TAG20111114T085639
14642 B F A DISK 2011-11-14 1 1 NO TAG20111114T090544
14643 B F A DISK 2011-11-14 1 1 NO TAG20111114T090647
14644 B F A DISK 2011-11-14 1 1 NO TAG20111114T091221
14645 B F A DISK 2011-11-14 1 1 NO TAG20111114T091319
14646 B F A DISK 2011-11-14 1 1 NO TAG20111114T091420
14647 B F A DISK 2011-11-14 1 1 NO TAG20111114T091502
14648 B F A DISK 2011-11-14 1 1 NO TAG20111114T091529
14649 B F A DISK 2011-11-14 1 1 NO TAG20111114T091559
14650 B F A DISK 2011-11-14 1 1 NO TAG20111114T091614
14651 B F A DISK 2011-11-14 1 1 NO TAG20111114T091633
14652 B F A DISK 2011-11-14 1 1 NO TAG20111114T091816
14653 B F A DISK 2011-11-14 1 1 NO TAG20111114T091830
14654 B F A DISK 2011-11-14 1 1 NO TAG20111114T091844
14655 B F A DISK 2011-11-14 1 1 NO TAG20111114T091918
14656 B F A DISK 2011-11-14 1 1 NO TAG20111114T091925
14657 B F A DISK 2011-11-14 1 1 NO TAG20111114T091930
14658 B F A DISK 2011-11-14 1 1 NO TAG20111114T091936
14659 B F A DISK 2011-11-14 1 1 NO TAG20111114T091942
14660 B F A DISK 2011-11-14 1 1 NO TAG20111114T092517
14661 B F A DISK 2011-11-14 1 1 NO TAG20111114T092818
14662 B F A DISK 2011-11-14 1 1 NO TAG20111114T092927
14663 B F A DISK 2011-11-14 1 1 NO TAG20111114T092953
14664 B F A DISK 2011-11-14 1 1 NO TAG20111114T094044
---验证datafile 1 有效性:
RMAN> restore datafile 1 preview summary;
Starting restore at 2011-11-16
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_1
using channel ORA_DISK_2
data file 1 will be created automatically during restore operation
....
428500 1 3 A 2011-11-14 /arch/busdb/archlog/1_3_767175445.dbf
428502 1 4 A 2011-11-14 /arch/busdb/archlog/1_4_767175445.dbf
428503 1 5 A 2011-11-14 /arch/busdb/archlog/1_5_767175445.dbf
428504 1 6 A 2011-11-14 /arch/busdb/archlog/1_6_767175445.dbf
428506 1 7 A 2011-11-14 /arch/busdb/archlog/1_7_767175445.dbf
428507 1 8 A 2011-11-14 /arch/busdb/archlog/1_8_767175445.dbf
428508 1 9 A 2011-11-14 /arch/busdb/archlog/1_9_767175445.dbf
428510 1 10 A 2011-11-14 /arch/busdb/archlog/1_10_767175445.dbf
428511 1 11 A 2011-11-14 /arch/busdb/archlog/1_11_767175445.dbf
428512 1 12 A 2011-11-14 /arch/busdb/archlog/1_12_767175445.dbf
428514 1 13 A 2011-11-14 /arch/busdb/archlog/1_13_767175445.dbf
428515 1 14 A 2011-11-14 /arch/busdb/archlog/1_14_767175445.dbf
428499 2 1 A 2011-11-14 /arch/busdb/archlog/2_1_767175445.dbf
428501 2 2 A 2011-11-14 /arch/busdb/archlog/2_2_767175445.dbf
428505 2 3 A 2011-11-14 /arch/busdb/archlog/2_3_767175445.dbf
428509 2 4 A 2011-11-14 /arch/busdb/archlog/2_4_767175445.dbf
428513 2 5 A 2011-11-14 /arch/busdb/archlog/2_5_767175445.dbf
Media recovery start SCN is 5
Recovery must be done beyond SCN 5 to clear data files fuzziness
Finished restore at 2011-11-16
....
428500 1 3 A 2011-11-14 /arch/busdb/archlog/1_3_767175445.dbf
428502 1 4 A 2011-11-14 /arch/busdb/archlog/1_4_767175445.dbf
428503 1 5 A 2011-11-14 /arch/busdb/archlog/1_5_767175445.dbf
428504 1 6 A 2011-11-14 /arch/busdb/archlog/1_6_767175445.dbf
428506 1 7 A 2011-11-14 /arch/busdb/archlog/1_7_767175445.dbf
428507 1 8 A 2011-11-14 /arch/busdb/archlog/1_8_767175445.dbf
428508 1 9 A 2011-11-14 /arch/busdb/archlog/1_9_767175445.dbf
428510 1 10 A 2011-11-14 /arch/busdb/archlog/1_10_767175445.dbf
428511 1 11 A 2011-11-14 /arch/busdb/archlog/1_11_767175445.dbf
428512 1 12 A 2011-11-14 /arch/busdb/archlog/1_12_767175445.dbf
428514 1 13 A 2011-11-14 /arch/busdb/archlog/1_13_767175445.dbf
428515 1 14 A 2011-11-14 /arch/busdb/archlog/1_14_767175445.dbf
428499 2 1 A 2011-11-14 /arch/busdb/archlog/2_1_767175445.dbf
428501 2 2 A 2011-11-14 /arch/busdb/archlog/2_2_767175445.dbf
428505 2 3 A 2011-11-14 /arch/busdb/archlog/2_3_767175445.dbf
428509 2 4 A 2011-11-14 /arch/busdb/archlog/2_4_767175445.dbf
428513 2 5 A 2011-11-14 /arch/busdb/archlog/2_5_767175445.dbf
Media recovery start SCN is 5
Recovery must be done beyond SCN 5 to clear data files fuzziness
Finished restore at 2011-11-16
---未发现错误
RMAN> restore datafile 1;
Starting restore at 2011-11-16
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_1
using channel ORA_DISK_2
creating datafile fno=1 name=/ora/oradata/busdb/rlvbussystem01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/16/2011 10:15:45
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/ora/oradata/busdb/rlvbussystem01.dbf'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/16/2011 10:15:45
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/ora/oradata/busdb/rlvbussystem01.dbf'
--声明一下。数据文件是文件系统。看样子像裸设备。是因为早先这库是从 裸设备 clone 转成文件系统的。
--查看文件夹权限
--查看文件夹权限
[ora@DB01_manage] /bus_bak 978> cd /ora/oradata/busdb/
[ora@DB01_manage] /ora/oradata/busdb 979> ls -la
total 246256
drwxr-xr-x 3 ora oinstall 4096 Nov 16 09:13 .
drwxr-xr-x 3 ora oinstall 256 Nov 10 2010 ..
drwxr-xr-x 2 ora oinstall 581632 Nov 09 00:15 archlog
-rw-r----- 1 ora oinstall 41828352 Nov 16 10:17 control01.ctl
-rw-r----- 1 ora oinstall 41828352 Nov 16 10:17 control02.ctl
-rw-r----- 1 ora oinstall 41828352 Nov 16 10:17 control03.ctl
[ora@DB01_manage] /ora/oradata/busdb 980> cd ..
[ora@DB01_manage] /ora/oradata 981> ls -la
total 16
drwxr-xr-x 3 ora oinstall 256 Nov 10 2010 .
drwxr-xr-x 9 ora oinstall 4096 Nov 11 08:15 ..
drwxr-xr-x 3 ora oinstall 4096 Nov 16 09:13 busdb
--不在权限问题上。因为我之前restore cf 就成功了
---在此。请教各位大师。这个问题到底出在哪里。在线等。比较急。。。。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/713360/viewspace-711021/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/713360/viewspace-711021/