服务器 频道

全面解读AMD未来三年产品路线图

shutdown immediate,丢失全部控制文件(不包括数据文件和redo),A[完全恢复]
SQL> conn internal 
SQL> shutdown immediate; 
 
用热备的控制文件恢复(把热备的控制文件拷贝回来) 
mount数据库 
SQL> startup mount 
ORACLE instance started. 
 
完全恢复和until cancel using backup controlfile都失败 
SQL> recover database; 
ORA-00283: recovery session canceled due to errors 
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done 
 
SQL> recover database until cancel using backup controlfile; 
ORA-00279: change 424123 generated at 10/20/2002 20:44:12 needed for thread 1 
 
Specify log: {<RET>=suggested | filename | AUTO | CANCEL} 
auto 
ORA-00266: name of archived log file needed 
 
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below 
ORA-01152: file 1 was not restored from a sufficiently old backup 
ORA-01110: data file 1: 'D:\BACKUPDB\SYSTEM01.DBF' 
 
重建控制文件  
SQL> alter database backup controlfile to trace; 
Database altered.
0
相关文章