当前位置:操作系统 > Unix/Linux >>

dg备库恢复

dg备库恢复
 
执行全备: 
RMAN> run{ 
allocate channel a1 type disk; 
backup full database include current controlfile for standby plus archivelog ; 
release channel a1; 
} 
rman target sys/oracle@orcl auxiliary / 
duplicate target database for standby nofilenamecheck dorecover; 

 

在备库上恢复时提示: 
Oracle Error: 
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: '/s01/oracle/app/oracle/oradata/orcl/system01.dbf' 

RMAN-00571: =========================================================== 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== 
RMAN-00571: =========================================================== 
RMAN-03002: failure of Duplicate Db command at 08/16/2013 04:35:46 
RMAN-03015: error occurred in stored script Memory Script 
RMAN-06053: unable to perform media recovery because of missing log 
RMAN-06025: no backup of archived log for thread 1 with sequence 23 and starting SCN of 1135707 found to restore 
RMAN-06025: no backup of archived log for thread 1 with sequence 22 and starting SCN of 1135400 found to restore 

 

 
错误大致意思:dbf文件与控制文件的版本号对不上 
 
修改主库备份脚本: 
1.backup database plus archivelog; 
2.backup current controlfile for standdy; 

 

再恢复,ok!
 
备库取消redo:
alter database recover managed standby database cancel; 

 

 
启用:
alter database recover managed standby database using current logfile disconnect from session; 

 

 
rman恢复: 
duplicate target database for standby nofilenamecheck dorecover;

 

 
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,