如何恢复?有RMAN的全备
[oracle@localhost bean]$ ls -l
total 1091988
-rw-r----- 1 oracle oinstall 7061504 Jul 13 15:31 control01.ctl
-rw-r----- 1 oracle oinstall 7061504 Jul 13 15:31 control02.ctl
-rw-r----- 1 oracle oinstall 7061504 Jul 13 15:31 control03.ctl
-rw-r----- 1 oracle oinstall 104858112 Jul 13 13:27 redo14_01.log
-rw-r----- 1 oracle oinstall 104858112 Jul 13 13:27 redo15_01.log
-rw-r----- 1 oracle oinstall 104858112 Jul 13 15:03 redo16_01.log
-rw-r----- 1 oracle oinstall 251666432 Jul 13 15:26 sysaux01.dbf
-rw-r----- 1 oracle oinstall 503324672 Jul 13 15:26 system01.dbf
-rw-r----- 1 oracle oinstall 20979712 Jul 13 11:14 temp01.dbf
-rw-r----- 1 oracle oinstall 26222592 Jul 13 15:26 undotbs01.dbf
-rw-r----- 1 oracle oinstall 0 Jul 13 13:42 users01.dbf
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01110: data file 4: '/usr/app/oracle/oradata/bean/users01.dbf'
ORA-01115: IO error reading block from file 4 (block # 1)
ORA-27069: attempt to do I/O beyond the range of the file
Additional information: 1
Additional information: 1
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/usr/app/oracle/oradata/bean/system01.dbf
/usr/app/oracle/oradata/bean/undotbs01.dbf
/usr/app/oracle/oradata/bean/sysaux01.dbf
/usr/app/oracle/oradata/bean/users01.dbf
SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
USERS
TEMP
RMAN> restore datafile 4;
Starting restore at 13-JUL-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=154 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00004 to /usr/app/oracle/oradata/bean/users01.dbf
channel ORA_DISK_1: reading from backup piece /backup/fullback/backup_03kk18l9_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/backup/fullback/backup_03kk18l9_1_1 tag=TAG20090713T103001
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 13-JUL-09
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 96471284 bytes
Database Buffers 67108864 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-01190: control file or data file 4 is from before the last RESETLOGS
ORA-01110: data file 4: '/usr/app/oracle/oradata/bean/users01.dbf'
************************************************************************************
SQL> startup
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01190: control file or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/usr/app/oracle/oradata/bean/system01.dbf'
没招了,上次恢复完RESETLOGS后没有重新备份
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12878495/viewspace-609029/,如需转载,请注明出处,否则将追究法律责任。