数据库不能启动 system文件报错

sky13and23

数据库启动
SQL*Plus: Release 10.2.0.5.0
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 8589934592 bytes
Fixed Size                  2110032 bytes
Variable Size            1258294704 bytes
Database Buffers         7314866176 bytes
Redo Buffers               14663680 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

alter.log报错
Errors in file /oracle/admin/bodb/udump/bodb_ora_27711.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 498)
ORA-01110: data file 1: '+DATA/bodb/datafile/system.260.781736213'
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 27711
ORA-1092 signalled during: ALTER DATABASE OPEN...


数据库没有归档，没有备份，请问如何恢复，谢谢！

Maclean Liu(刘相兵

请 压缩打包后上传 /oracle/admin/bodb/udump/bodb_ora_27711.trc

sky13and23

附件上传trace文件

Maclean Liu(刘相兵

action plan:

$ rman target / nocatalog

startup mount;

RMAN> run {
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
backup validate check logical database;
}


select * from V$DATABASE_BLOCK_CORRUPTION ;


贴出以上的命令的输出

sky13and23

这是一个培训库，没有归档

RMAN> run {
2> allocate channel d1 type disk;
3> allocate channel d2 type disk;
4> allocate channel d3 type disk;
5> allocate channel d4 type disk;
6> backup validate check logical database;
7> }


using target database control file instead of recovery catalog
allocated channel: d1
channel d1: sid=321 devtype=DISK

allocated channel: d2
channel d2: sid=316 devtype=DISK

allocated channel: d3
channel d3: sid=315 devtype=DISK

allocated channel: d4
channel d4: sid=314 devtype=DISK

Starting backup at 28-4ÔÂ -12
channel d1: starting full datafile backupset
channel d1: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on d1 channel at 04/28/2012 16:43:51
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel d1: starting full datafile backupset
channel d1: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on d1 channel at 04/28/2012 16:43:51
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel d1: starting full datafile backupset
channel d1: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on d1 channel at 04/28/2012 16:43:51
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel d1: starting full datafile backupset
channel d1: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on d1 channel at 04/28/2012 16:43:51
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel d1: starting full datafile backupset
channel d1: specifying datafile(s) in backupset
including current control file in backupset
channel d2: starting full datafile backupset
channel d2: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on d2 channel at 04/28/2012 16:43:52
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel d2: starting full datafile backupset
channel d2: specifying datafile(s) in backupset
channel d3: starting full datafile backupset
channel d3: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on d3 channel at 04/28/2012 16:43:53
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel d4: starting full datafile backupset
channel d4: specifying datafile(s) in backupset
RMAN-03009: failure of backup command on d4 channel at 04/28/2012 16:43:53
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel d1: backup set complete, elapsed time: 00:00:02
including current SPFILE in backupset
channel d2: backup set complete, elapsed time: 00:00:01
released channel: d1
released channel: d2
released channel: d3
released channel: d4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on d2 channel at 04/28/2012 16:43:52
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on d3 channel at 04/28/2012 16:43:53
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on d1 channel at 04/28/2012 16:43:51
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on d4 channel at 04/28/2012 16:43:53
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on d1 channel at 04/28/2012 16:43:51
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on d1 channel at 04/28/2012 16:43:51
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on d1 channel at 04/28/2012 16:43:51
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode




SQL> select * from V$DATABASE_BLOCK_CORRUPTION ;

     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
         1        498          1            9015639 UNKNOWN

Maclean Liu(刘相兵

尝试利用 BBED 修改 datafile 1  block 498

如果无法实施 可以 QQ找我