ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 一次rman duplicate数据库报错

一次rman duplicate数据库报错

原创 Linux操作系统 作者:marvinoracle 时间:2012-12-11 12:46:33 0 删除 编辑
一次rman duplicate数据库报错
......
contents of Memory Script.:
{
   switch clone datafile all;
}
executing Memory Script

released channel: ORA_AUX_DISK_1
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=801734731 filename=/opt/u01/app/oracle/oradata/finance/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=801734731 filename=/opt/u01/app/oracle/oradata/finance/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=801734731 filename=/opt/u01/app/oracle/oradata/finance/finance01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=801734731 filename=/opt/u01/app/oracle/oradata/finance/finance02.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=801734731 filename=/opt/u01/app/oracle/oradata/finance/users01.dbf
datafile 7 switched to datafile copy
input datafile copy recid=6 stamp=801734731 filename=/opt/u01/app/oracle/oradata/finance/EAS_D_YQ_STANDARD.ora
datafile 8 switched to datafile copy
input datafile copy recid=7 stamp=801734731 filename=/opt/u01/app/oracle/oradata/finance/finance03.dbf
datafile 9 switched to datafile copy
input datafile copy recid=8 stamp=801734731 filename=/opt/u01/app/oracle/oradata/finance/finance04.dbf
datafile 10 switched to datafile copy
input datafile copy recid=9 stamp=801734731 filename=/opt/u01/app/oracle/oradata/finance/finance05.dbf
datafile 11 switched to datafile copy
input datafile copy recid=10 stamp=801734731 filename=/opt/u01/app/oracle/oradata/finance/finance06.dbf
datafile 12 switched to datafile copy
input datafile copy recid=11 stamp=801734731 filename=/opt/u01/app/oracle/oradata/finance/finance07.dbf

contents of Memory Script.:
{
   set until scn  49009992470;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 11-DEC-12
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=869 devtype=DISK

starting media recovery

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: '/opt/u01/app/oracle/oradata/finance/system01.dbf'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/11/2012 08:06:25
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 log thread 1 seq 1519 lowscn 49009887727 found to restore
RMAN-06025: no backup of log thread 1 seq 1518 lowscn 49009788449 found to restore
RMAN-06025: no backup of log thread 1 seq 1517 lowscn 49009722481 found to restore
RMAN-06025: no backup of log thread 1 seq 1516 lowscn 49009626149 found to restore
RMAN-06025: no backup of log thread 1 seq 1515 lowscn 49009609126 found to restore
RMAN-06025: no backup of log thread 1 seq 1514 lowscn 49009601602 found to restore
RMAN-06025: no backup of log thread 1 seq 1513 lowscn 49009592652 found to restore
RMAN-06025: no backup of log thread 1 seq 1512 lowscn 49009589300 found to restore
RMAN-06025: no backup of log thread 1 seq 1511 lowscn 49009580644 found to restore
RMAN-06025: no backup of log thread 1 seq 1510 lowscn 49009576975 found to restore
RMAN-06025: no backup of log thread 1 seq 1509 lowscn 49009570393 found to restore
RMAN-06025: no backup of log thread 1 seq 1508 lowscn 49009543986 found to restore
RMAN-06025: no backup of log thread 1 seq 1507 lowscn 49009534946 found to restore
RMAN-06025: no backup of log thread 1 seq 1506 lowscn 49009528706 found to restore
RMAN-06025: no backup of log thread 1 seq 1505 lowscn 49009524255 found to restore
RMAN-06025: no backup of log thread 1 seq 1504 lowscn 49009519121 found to restore
RMAN-06025: no backup of log thread 1 seq 1503 lowscn 49009513289 found to restore
RMAN-06025: no backup of log thread 1 seq 1502 lowscn 49009508440 found to restore
RMAN-06025: no backup of log thread 1 seq 1501 lowscn 49009493844 found to restore
RMAN-06025: no backup of log thread 1 seq 1500 lowscn 49009471392 found to restore
RMAN-06025: no backup of log thread 1 seq 1499 lowscn 49009466286 found to restore
RMAN-06025: no backup of log thread 1 seq 1498 lowscn 49009461927 found to restore
RMAN-06025: no backup of log thread 1 seq 1497 lowscn 49009415873 found to restore
RMAN-06025: no backup of log thread 1 seq 1496 lowscn 49009358449 found to restore
RMAN-06025: no backup of log thread 1 seq 1495 lowscn 49009341182 found to restore

RMAN>

解决方法:
1、从源库拷贝归档到目标端
2、注册归档文件
3、不完全恢复

一、拷贝归档
scp -r  source/xxx  target/xxx

二、注册归档
run {
set archivelog destination to '/opt/u01/app/oracle/archivelog';
recover database until cancel;
}
三、恢复
SQL>  recover database using backup controlfile until cancel;
ORA-00279: change 49009992470 generated at 12/11/2012 06:02:00 needed for
thread 1
ORA-00289: suggestion : /opt/u01/app/oracle/archivelog/1_1520_787030419.dbf
ORA-00280: change 49009992470 for thread 1 is in sequence #1520


Specify log: {=suggested | filename | AUTO | CANCEL}
cancel\
ORA-00308: cannot open archived log 'cancel\'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24531354/viewspace-750896/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-09-02

  • 博文量
    67
  • 访问量
    181767