请教system表空间恢复

显示全部楼层 · 2011-11-1 16:21:15

如下操作过程，请教恢复：
SQL> shutdown immediate;
ORA-01149: cannot shutdown - file 1 has online backup set
ORA-01110: data file 1: '/dev/rsystem_5g'
SQL> shutdown abort
SQL>startup
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/dev/rsystem_5g'
SQL>
注：启用归档，但是没有磁带备份，每天晚上自动删除归档日志。

千问 · 2011-11-1 16:21:15

recover datafile 1;
alter database open;

千问 · 2011-11-1 16:21:15

alter tablespace system end backup;

千问 · 2011-11-1 16:21:15

then
recover tablespace system;

千问 · 2011-11-1 16:21:15

多谢版主，我试下，等有结果我贴上来！

千问 · 2011-11-1 16:21:15

就按yanggq 说的，可以了吧

千问 · 2011-11-1 16:21:15

应该按 howard_zhang 的说发做吧，楼主已经shutdown abort了，这个时候在mount状态下恢复受损空间就可以了

千问 · 2011-11-1 16:21:15

具体处理过程
$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 9 14:38:39 2009
Copyright (c) 1982, 2005, Oracle.All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 5368709120 bytes
Fixed Size
2028416 bytes
Variable Size
1006636160 bytes
Database Buffers 4345298944 bytes
Redo Buffers
14745600 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/dev/rsystem_5g'

SQL> recover datafile 1
ORA-00279: change 71139451 generated at 12/17/2008 00:47:16 needed for thread 1
ORA-00289: suggestion : /ora_arch/1_2344_620750480.arc
ORA-00280: change 71139451 for thread 1 is in sequence #2344

Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log '/ora_arch/1_2344_620750480.arc'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log '/ora_arch/1_2344_620750480.arc'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup restrict
ORACLE instance started.
Total System Global Area 5368709120 bytes
Fixed Size
2028416 bytes
Variable Size
1006636160 bytes
Database Buffers 4345298944 bytes
Redo Buffers
14745600 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/dev/rsystem_5g'

SQL> alter tablespace system end backup;
Tablespace altered.
SQL> recover tablespace system;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: '/dev/rundotbs1_5g'

SQL> alter tablespace undotbs1 end backup;
Tablespace altered.
SQL> recover tablespace undotbs1;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: '/dev/rsysaux_2g'

SQL> alter tablespace sysaux end backup;
Tablespace altered.
SQL> recover tablespace sysaux;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: '/dev/rusers_512m'

SQL> alter tablespace users end backup;
Tablespace altered.
SQL> recover tablespace users;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/dev/rindx_512m'

SQL> alter tablespace indx end backup;
Tablespace altered.
SQL> recover tablespace indx;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 6 needs media recovery
ORA-01110: data file 6: '/dev/rtools_256m'

SQL> alter tablespace tools end backup;
Tablespace altered.
SQL> recover tablespace tools;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 7 needs media recovery
ORA-01110: data file 7: '/dev/rdata_share_01_2'
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 7 needs media recovery
ORA-01110: data file 7: '/dev/rdata_share_01_2'

SQL> alter tablespace fmis_share end backup;
Tablespace altered.
SQL> recover tablespace fmis_share;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: '/dev/rdata_0001_01_2g'

SQL> alter tablespace fmis_0001 end backup;
Tablespace altered.
SQL> recover tablespace fmis_0001;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 9 needs media recovery
ORA-01110: data file 9: '/dev/rdata_0005_01_2g'

SQL> alter tablespace fmis_0005 end backup;
Tablespace altered.
SQL> recover tablespace fmis_0005;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: '/dev/rdata_0006_01_2g'

SQL> alter tablespace fmis_0006 end backup;
Tablespace altered.
SQL> recover tablespace fmis_0006
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 11 needs media recovery
ORA-01110: data file 11: '/dev/rdata_0007_01_2g'

SQL> alter tablespace fmis_0007 end backup;
Tablespace altered.
SQL> recover tablespace fmis_0007;
Media recovery complete.
SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 12 needs media recovery
ORA-01110: data file 12: '/dev/rdata_bank_01_2g'

SQL> alter tablespace yg_bank end backup;
Tablespace altered.
SQL> recover tablespace yg_bank;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 13 needs media recovery
ORA-01110: data file 13: '/dev/rdata_0002_01_2g'

SQL> alter tablespace fmis_0002 end backkup;
alter tablespace fmis_0002 end backkup

*
ERROR at line 1:
ORA-01906: BACKUP keyword expected

SQL> alter tablespace fmis_0002 end backup;
Tablespace altered.
SQL> recover tablespace fmis_0002;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 14 needs media recovery
ORA-01110: data file 14: '/dev/rdata_0003_01_2g'

SQL> alter tablespace fmis_0003 end backup;
Tablespace altered.
SQL> recover tablespace fmis_0003;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 15 needs media recovery
ORA-01110: data file 15: '/dev/rdata_0004_01_2g'

SQL> alter tablespace fmis_0004 end backukp;
alter tablespace fmis_0004 end backukp

*
ERROR at line 1:
ORA-01906: BACKUP keyword expected

SQL> alter tablespace fmis_0004 end backup;
Tablespace altered.
SQL> recover tablespace fmis_0004;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 16 needs media recovery
ORA-01110: data file 16: '/dev/rdata_0008_01_2g'

SQL> alter tablespace fmis_0008 end backup;
Tablespace altered.
SQL> recover tablespace fmis_0008;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 17 needs media recovery
ORA-01110: data file 17: '/dev/rdata_0009_01_2g'

SQL> alter tablespace fmis_0009 end backup;
Tablespace altered.
SQL> recover tablespace fmis_0009;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 18 needs media recovery
ORA-01110: data file 18: '/dev/rdata_0010_01_2g'

SQL> alter tablespace fmis_0010 end backup;
Tablespace altered.
SQL> recover tablespace fmis_0010;
Media recovery complete.
SQL> alter database open;
Database altered.
SQL>

千问 · 2011-11-1 16:21:15

感谢“yanggq
版主 ”的提醒

千问 · 2011-11-1 16:21:15

呵呵，费了点功夫。