Restoring RMAN backup on different host
Hi all,
DB Version: 9.2.0.8.0
Platform: Windows
I'm trying to restore rman backup on different host. I have put backups at appropriate location, restored spfile and controlfile using backup. and restored the database using following command:
RMAN> restore database until sequence 16777 thread 1;
It restored the database successfully, but when I tried to recover the database using:
RMAN> recover database until sequence 16777 thread 1;
Starting recover at 14-FEB-08
using channel ORA_DISK_1
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: 'E:\PROJECT\DATA\SYSTEM01.DBF'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/14/2008 13:11:39
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 16776 scn 657225775 found to restore
RMAN-06025: no backup of log thread 1 seq 16775 scn 657225139 found to restore
RMAN-06025: no backup of log thread 1 seq 16774 scn 657224562 found to restore
RMAN-06025: no backup of log thread 1 seq 16773 scn 657223972 found to restore
RMAN-06025: no backup of log thread 1 seq 16772 scn 657193941 found to restore
RMAN-06025: no backup of log thread 1 seq 16771 scn 657181122 found to restore
RMAN-06025: no backup of log thread 1 seq 16770 scn 657177846 found to restore
RMAN-06025: no backup of log thread 1 seq 16769 scn 657175078 found to restore
RMAN-06025: no backup of log thread 1 seq 16768 scn 657166257 found to restore
RMAN-06025: no backup of log thread 1 seq 16767 scn 657151662 found to restore
RMAN-06025: no backup of log thread 1 seq 16766 scn 657140828 found to restore
RMAN-06025: no backup of log thread 1 seq 16765 scn 657125993 found to restore
RMAN-06025: no backup of log thread 1 seq 16764 scn 657111484 found to restore
RMAN-06025: no backup of log thread 1 seq 16763 scn 657100075 found to restore
RMAN-06025: no backup of log thread 1 seq 16762 scn 657093034 found to restore
RMAN-06025: no backup of log thread 1 seq 16761 scn 657056155 found to restore
RMAN-06025: no backup of log thread 1 seq 16760 scn 657044226 found to restore
RMAN-06025: no backup of log thread 1 seq 16759 scn 657030127 found to restore
RMAN-06025: no backup of log thread 1 seq 16758 scn 657019782 found to restore
RMAN-06025: no backup of log thread 1 seq 16757 scn 657012557 found to restore
RMAN-06025: no backup of log thread 1 seq 16756 scn 657005135 found to restore
RMAN-06025: no backup of log thread 1 seq 16755 scn 656995744 found to restore
RMAN-06025: no backup of log thread 1 seq 16754 scn 656990300 found to restore
RMAN-06025: no backup of log thread 1 seq 16753 scn 656976521 found to restore
RMAN-06025: no backup of log thread 1 seq 16752 scn 656970794 found to restore
RMAN-06025: no backup of log thread 1 seq 16751 scn 656957905 found to restore
RMAN-06025: no backup of log thread 1 seq 16750 scn 656938992 found to restore
RMAN-06025: no backup of log thread 1 seq 16749 scn 656934940 found to restore
RMAN-06025: no backup of log thread 1 seq 16748 scn 656927427 found to restore
RMAN-06025: no backup of log thread 1 seq 16747 scn 656921425 found to restore
RMAN-06025: no backup of log thread 1 seq 16746 scn 656915883 found to restore
RMAN-06025: no backup of log thread 1 seq 16745 scn 656912991 found to restore
RMAN-06025: no backup of log thread 1 seq 16744 scn 656907841 found to restore
RMAN-06025: no backup of log thread 1 seq 16743 scn 656902786 found to restore
RMAN-06025: no backup of log thread 1 seq 16742 scn 656895311 found to restore
RMAN-06025: no backup of log thread 1 seq 16741 scn 656887836 found to restore
RMAN-06025: no backup of log thread 1 seq 16740 scn 656879817 found to restore
RMAN-06025: no backup of log thread 1 seq 16739 scn 656876441 found to restore
RMAN-06025: no backup of log thread 1 seq 16738 scn 656873086 found to restore
RMAN-06025: no backup of log thread 1 seq 16737 scn 656871597 found to restore
RMAN-06025: no backup of log thread 1 seq 16736 scn 656870474 found to restore
RMAN-06025: no backup of log thread 1 seq 16735 scn 656869278 found to restore
RMAN-06025: no backup of log thread 1 seq 16734 scn 656868045 found to restore
RMAN-06025: no backup of log thread 1 seq 16733 scn 656866150 found to restore
RMAN-06025: no backup of log thread 1 seq 16732 scn 656860367 found to restore
RMAN-06025: no backup of log thread 1 seq 16731 scn 656847787 found to restore
RMAN-06025: no backup of log thread 1 seq 16730 scn 656820676 found to restore
RMAN-06025: no backup of log thread 1 seq 16729 scn 656803760 found to restore
RMAN-06025: no backup of log thread 1 seq 16728 scn 656793411 found to restore
RMAN-06025: no backup of log thread 1 seq 16727 scn 656788585 found to restore
RMAN-06025: no backup of log thread 1 seq 16726 scn 656765888 found to restore
RMAN-06025: no backup of log thread 1 seq 16725 scn 656752007 found to restore
RMAN-06025: no backup of log thread 1 seq 16724 scn 656728335 found to restore
RMAN-06025: no backup of log thread 1 seq 16723 scn 656710444 found to restore
RMAN-06025: no backup of log thread 1 seq 16722 scn 656696033 found to restore
RMAN-06025: no backup of log thread 1 seq 16721 scn 656676088 found to restore
RMAN-06025: no backup of log thread 1 seq 16720 scn 656652507 found to restore
RMAN-06025: no backup of log thread 1 seq 16719 scn 656613338 found to restore
MAN-06025: no backup of log thread 1 seq 16718 scn 656586616 found to
RMAN>
Although I have checked that the backups of archivelog is available, using "list archivelog all".