表空间恢复

如何恢复?有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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12878495/viewspace-609029/