有备份下的控制文件完全丢失恢复实例

有备份下的控制文件完全丢失恢复实例
sapprd03[/]#su - oraprd
sapprd03:oraprd 1> sqlplus / as sysdba
SQL> startup  
ORA-00205: error in identifying control file, check alert log for more info
  根据日志提示，没有找到控制文件。  
SQL> shutdown immediate   关闭后从备份中恢复控制文件
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup open resetlogs;
ORA-01504: database name 'RESETLOGS' does not match parameter db_name 'PRD'
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount
SQL> alter database mount;
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/PRD/sapdata1/system_1/system.data1'
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount
SQL> recover database using backup controlfile until cancel;
开始应用归档日志，并且提供相应的日志文档。
SQL> alter database open resetlogs  ;
重启数据库，再次验证恢复成功。
SQL> shutdown immediate
SQL> startup
数据库成功启动，恢复成功完成