点击( 此处 )折叠或打开
-
RMAN > run{
-
2 > set newname for datafile 1 to '/data1/datafile10g/zheng/system01.dbf' ;
-
3 > set newname for datafile 2 to '/data1/datafile10g/zheng/undotbs01.dbf' ;
-
4 > set newname for datafile 3 to '/data1/datafile10g/zheng/sysaux01.dbf' ;
-
5 > set newname for datafile 4 to '/data1/datafile10g/zheng/users01.dbf' ;
-
6 > set newname for datafile 5 to '/data1/datafile10g/zheng/trswcm01.dbf' ;
-
7 > set newname for datafile 6 to '/data1/datafile10g/zheng/wmly01.dbf' ;
-
8 > set newname for datafile 7 to '/data1/datafile10g/zheng/exam01.dbf' ;
-
9 > set newname for datafile 8 to '/data1/datafile10g/zheng/bjzj01.dbf' ;
-
10 > set newname for datafile 9 to '/data1/datafile10g/zheng/pjuserdb01.dbf' ;
-
11 > set newname for datafile 10 to '/data1/datafile10g/zheng/dcl01.dbf' ;
-
12 > set newname for datafile 11 to '/data1/datafile10g/zheng/outer01.dbf' ;
-
13 > set newname for datafile 12 to '/data1/datafile10g/zheng/data01.dbf' ;
-
14 > set newname for datafile 13 to '/data1/datafile10g/zheng/trsmas01.dbf' ;
-
15 > set newname for datafile 14 to '/data1/datafile10g/zheng/trswcmplugins01.dbf' ;
-
16 > set newname for datafile 15 to '/data1/datafile10g/zheng/trswcm50.dbf' ;
-
17 > set newname for datafile 16 to '/data1/datafile10g/zheng/trswcm65.dbf' ;
-
18 > set newname for datafile 17 to '/data1/datafile10g/zheng/trswcmz1.dbf' ;
-
19 > set newname for datafile 18 to '/data1/datafile10g/zheng/data02.dbf' ;
-
20 > set newname for datafile 19 to '/data1/datafile10g/zheng/system02.dbf' ;
-
21 > set newname for datafile 20 to '/data1/datafile10g/zheng/users02.dbf' ;
-
22 > set newname for datafile 21 to '/data1/datafile10g/zheng/apmon01.dbf' ;
-
23 > restore database ;
-
24 > switch datafile all ;
-
25 > }
-
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
executing command : SET NEWNAME
-
Starting restore at 07 - MAY - 15
-
allocated channel : ORA_DISK_1
-
channel ORA_DISK_1 : sid = 1972 devtype = DISK
-
-
-
channel ORA_DISK_1 : starting datafile backupset restore
-
channel ORA_DISK_1 : specifying datafile ( s ) to restore from backup set
-
restoring datafile 00003 to /data1/datafile10g/zheng/sysaux01 . dbf
-
restoring datafile 00007 to /data1/datafile10g/zheng/exam01 . dbf
-
restoring datafile 00008 to /data1/datafile10g/zheng/bjzj01 . dbf
-
restoring datafile 00009 to /data1/datafile10g/zheng/pjuserdb01 . dbf
-
restoring datafile 00011 to /data1/datafile10g/zheng/outer01 . dbf
-
restoring datafile 00012 to /data1/datafile10g/zheng/data01 . dbf
-
restoring datafile 00014 to /data1/datafile10g/zheng/trswcmplugins01 . dbf
-
restoring datafile 00015 to /data1/datafile10g/zheng/trswcm50 . dbf
-
restoring datafile 00016 to /data1/datafile10g/zheng/trswcm65 . dbf
-
restoring datafile 00019 to /data1/datafile10g/zheng/system02 . dbf
-
restoring datafile 00021 to /data1/datafile10g/zheng/apmon01 . dbf
-
channel ORA_DISK_1 : reading from backup piece /data/rmanbak/full_db_9kpgn22e_1_1_20140823
-
channel ORA_DISK_1 : restored backup piece 1
-
failover to piece handle = / data1/rmanbak/zheng/full_db_9kpgn22e_1_1_20140823 tag = TAG20140823T231005
-
channel ORA_DISK_1 : restore complete , elapsed time : 01 : 30 : 37
-
channel ORA_DISK_1 : starting datafile backupset restore
-
channel ORA_DISK_1 : specifying datafile ( s ) to restore from backup set
-
restoring datafile 00001 to /data1/datafile10g/zheng/system01 . dbf
-
restoring datafile 00002 to /data1/datafile10g/zheng/undotbs01 . dbf
-
restoring datafile 00004 to /data1/datafile10g/zheng/users01 . dbf
-
restoring datafile 00005 to /data1/datafile10g/zheng/trswcm01 . dbf
-
restoring datafile 00006 to /data1/datafile10g/zheng/wmly01 . dbf
-
restoring datafile 00010 to /data1/datafile10g/zheng/dcl01 . dbf
-
restoring datafile 00013 to /data1/datafile10g/zheng/trsmas01 . dbf
-
restoring datafile 00017 to /data1/datafile10g/zheng/trswcmz1 . dbf
-
restoring datafile 00018 to /data1/datafile10g/zheng/data02 . dbf
-
restoring datafile 00020 to /data1/datafile10g/zheng/users02 . dbf
-
channel ORA_DISK_1 : reading from backup piece /data/rmanbak/full_db_9lpgn22e_1_1_20140823
-
ORA - 19870 : error reading backup piece /data1/rmanbak/zheng/full_db_9lpgn22e_1_1_20140823
-
ORA - 19502 : write error on file "/data1/datafile10g/zheng/trsmas01.dbf" , blockno 994753 ( blocksize = 8192 )
-
ORA - 27072 : File I/O error
-
Linux - x86_64 Error : 9 : Bad file descriptor
-
Additional information : 4
-
Additional information : 994753
-
Additional information : 94208
-
failover to previous backup
-
-
-
channel ORA_DISK_1 : starting datafile backupset restore
-
channel ORA_DISK_1 : specifying datafile ( s ) to restore from backup set
-
restoring datafile 00001 to /data1/datafile10g/zheng/system01 . dbf
-
restoring datafile 00002 to /data1/datafile10g/zheng/undotbs01 . dbf
-
restoring datafile 00004 to /data1/datafile10g/zheng/users01 . dbf
-
restoring datafile 00005 to /data1/datafile10g/zheng/trswcm01 . dbf
-
restoring datafile 00013 to /data1/datafile10g/zheng/trsmas01 . dbf
-
restoring datafile 00017 to /data1/datafile10g/zheng/trswcmz1 . dbf
-
restoring datafile 00018 to /data1/datafile10g/zheng/data02 . dbf
-
channel ORA_DISK_1 : reading from backup piece /data/rmanbak/full_db_9gpgkdmf_1_1_20140822
-
ORA - 19870 : error reading backup piece /data/rmanbak/full_db_9gpgkdmf_1_1_20140822
-
ORA - 19505 : failed to identify file "/data/rmanbak/full_db_9gpgkdmf_1_1_20140822"
-
ORA - 27037 : unable to obtain file status
-
Linux - x86_64 Error : 2 : No such file or directory
-
Additional information : 3
-
failover to previous backup
-
-
-
RMAN - 00571 : = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
-
RMAN - 00569 : = = = = = = = = = = = = = = = ERROR MESSAGE STACK FOLLOWS = = = = = = = = = = = = = = =
-
RMAN - 00571 : = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
-
RMAN - 03002 : failure of restore command at 05/07/2015 04 : 57 : 34
-
RMAN - 06026 : some targets not found - aborting restore
-
RMAN - 06023 : no backup or copy of datafile 4 found to restore
-
RMAN - 06023 : no backup or copy of datafile 2 found to restore
-
RMAN - 06023 : no backup or copy of datafile 1 found to restore
-
-
RMAN > restore database from '/data1/rmanbak/zheng/full_db_9lpgn22e_1_1_20140823' ;
-
-
Starting restore at 08 - MAY - 15
-
using channel ORA_DISK_1
-
-
RMAN - 00571 : = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
-
RMAN - 00569 : = = = = = = = = = = = = = = = ERROR MESSAGE STACK FOLLOWS = = = = = = = = = = = = = = =
-
RMAN - 00571 : = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
-
RMAN - 03002 : failure of restore command at 05/08/2015 02 : 06 : 37
-
RMAN - 06509 : only SPFILE or control file can be restored from autobackup
查看文件系统空间不足
点击( 此处 )折叠或打开
-
yun - recv : / data1 # df - h
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 7G 11G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 183G 4 . 4G 98% /data1
这些空间肯定不够剩下数据文件转储的
重新转储,监控下文件系统
点击( 此处 )折叠或打开
-
# ! / bin/sh
-
while true
-
do
-
df - h > > /home/oracle/ df . log
-
sleep 5
-
done
点击( 此处 )折叠或打开
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 8G 10G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 187G 29M 100% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 8G 10G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 187G 27M 100% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 8G 10G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 187G 24M 100% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 8G 10G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 187G 19M 100% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 8G 10G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 187G 13M 100% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 8G 10G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 187G 6 . 4M 100% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 8G 10G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 187G 0 100% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 8G 10G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 187G 0 100% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 8G 10G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 187G 0 100% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 8G 10G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 187G 0 100% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 9G 9 . 9G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 187G 0 100% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 9G 9 . 9G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 185G 2 . 6G 99% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 9G 9 . 9G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 184G 2 . 9G 99% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 9G 9 . 9G 41% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 184G 3 . 0G 99% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 9G 9 . 9G 42% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 184G 3 . 1G 99% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 9G 9 . 9G 42% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 184G 3 . 2G 99% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 9G 9 . 9G 42% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 184G 3 . 4G 99% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
-
-
Filesystem Size Used Avail Use% Mounted on
-
/dev/hda3 18G 6 . 9G 9 . 9G 42% /
-
udev 4 . 0G 156K 4 . 0G 1% /dev
-
/dev/hda1 99M 27M 67M 29% /boot
-
tmpfs 3 . 0G 32K 3 . 0G 1% /dev/shm
-
/dev/hda6 22G 16G 4 . 8G 77% /data
-
/dev/mapper/datavg1 - datalv1
-
197G 184G 3 . 5G 99% /data1
-
/dev/hdb5 99G 66G 28G 71% /rman_file
当报错之后,文件会倒退,空间释放, 致此确定原因
重新搞喽~嘿嘿
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29990276/viewspace-1623540/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29990276/viewspace-1623540/