日期:2014-05-16  浏览次数:20381 次

Oracle从备份的数据文件恢复数据库

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.