日期:2014-05-16 浏览次数:20400 次
1. copy datafile.
2. delete ora_control1 property from /oracle/ora11g/product/11.2.0/db_1/dbs/init.ora and spfile.ora.
create pfile='/home/oracle/pfile.ora' from spfile
create spfile from pfile='/home/oracle/pfile.ora'
3. STARTUP RESTRICT,?
if encounter ORA-01113: file 1 needs media recovery, goto 4.
if encounter "ORA-01589: must use RESETLOGS or NORESETLOGS option for database open", goto 5.
4. recover database until cancel
5. alter database open resetlogs;
6. copy the control02.ctl to control01.ctl.
7. add ora_control1 property in init.ora and spfile.ora.
8. startup database.