Hi friends,
OS: windows server 2008
DB: 10.2.0.4.0
I restored full backup with archivelogs and controlfile to new oracle installed (software only) Windows server 2008.
I used the following instruction to do restoration
https://www.linkedin.com/pulse/restoring-oracle-database-new-server-sajjad-razmi?forceNoSplash=true
I restore database succesfully.
But when recover database then following error occurs
RMAN> recover database;
Starting recover at 24-NOV-16
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=146797
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=146798
channel ORA_DISK_1: reading from backup piece D:\BACKUP\FULL\BTB_20161124_1605_1
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\BTB\SYSTEM01.DBF'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/24/2016 14:11:14
ORA-19870: error reading backup piece D:\BACKUP\FULL\BTB_20161124_1605_1
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 47933440 bytes disk space from 16106127360 limit
when I set until clause also error ooccurs
RMAN> run {
2> set until sequence 146797 thread 1;
3> recover database;
4> }
executing command: SET until clause
Starting recover at 24-NOV-16
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/24/2016 14:18:12
RMAN-06556: datafile 1 must be restored from backup older than scn 4289321723
What is the problem? Please propose me way to solve the problem? It is urgent!!!
Thanks!!!