一次rman duplicate数据库报错

一次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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24531354/viewspace-750896/