数据库停电导致严重起不来，麻烦高手来看下
因其他人员误操作导致REDO丢失，ARCH丢失，控制文件丢失控制文件我已手工建立，启动时报错
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'/data/oracle/oradata/ALS/datafile/o1_mf_system_c70m7qxl_.dbf'
SQL> recover database using backup controlfile;
ORA-00279: change 85014328 generated at 05/27/2016 23:05:40 needed for thread 1
ORA-00289: suggestion :
/data/oracle/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_912985538.dbf
ORA-00280: change 85014328 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'/data/oracle/oradata/ALS/datafile/o1_mf_system_c70m7qxl_.dbf'
SQL> recover database using backup controlfile;
ORA-00279: change 85014328 generated at 05/27/2016 23:05:40 needed for thread 1
ORA-00289: suggestion :
/data/oracle/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_912985538.dbf
ORA-00280: change 85014328 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/data/oracle/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_912985538.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00308: cannot open archived log
'/data/oracle/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_912985538.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> recover database
;ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
pfile加了这3句还是不行
*._allow_resetlogs_corruption=TRUE
*._corrupted_rollback_segments= "_SYSSMU11_1017602384$"
*.undo_management=manual
==================================
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode
SQL> startup nomount pfile=/home/oracle/newpfile.ora
ORACLE instance started.
。。。。。。 创建控制文件 ，此处省略
SQL> recover database using backup controlfile;
ORA-00279: change 85014336 generated at 05/28/2016 01:42:03 needed for thread 1
ORA-00289: suggestion :
/data/oracle/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_912994922.dbf
ORA-00280: change 85014336 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 11 with name
"_SYSSMU11_1017602384$" too small
Process ID: 18082
Session ID: 705 Serial number: 1
页:
[1]