Home » RDBMS Server » Backup & Recovery » Duplicate with RMAN Fails with ORA-01547
Duplicate with RMAN Fails with ORA-01547 [message #262599] Mon, 27 August 2007 16:46 Go to next message
Chewie71
Messages: 19
Registered: October 2005
Location: WIU
Junior Member
Hi experts... I always seem to get the right answer here so hopefully ya'll will pull through for me again. Smile

I'm running an RMAN duplicate process to clone my production DB over to a test system. It works all the way until the end where I get the following errors...

channel ch1: restore complete

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: '/webct/u01/oradata/webcttst/system01.dbf'

released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/27/2007 15:51:16
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 16242 scn 194183721 found to restore
RMAN-06025: no backup of log thread 1 seq 16241 scn 194182489 found to restore
RMAN-06025: no backup of log thread 1 seq 16240 scn 194181854 found to restore
RMAN-06025: no backup of log thread 1 seq 16239 scn 194141202 found to restore


I've Googled the error numbers and nothing really pops out at me as being the answer. Anyone have any thoughts why the system01.dbf file is not getting restored to the clone correctly?

Thanks,
Matt
Re: Duplicate with RMAN Fails with ORA-01547 [message #262630 is a reply to message #262599] Mon, 27 August 2007 23:28 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

ORA-01152: file 1 was not restored from a sufficiently old backup

Did you take valid backup before start recovery process.


regards
Taj
Re: Duplicate with RMAN Fails with ORA-01547 [message #262631 is a reply to message #262599] Mon, 27 August 2007 23:32 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 16242 scn 194183721 found to restore


I can suggest you to use,

recover database until cancel 


and then apply redo log
Re: Duplicate with RMAN Fails with ORA-01547 [message #262903 is a reply to message #262630] Tue, 28 August 2007 08:26 Go to previous messageGo to next message
Chewie71
Messages: 19
Registered: October 2005
Location: WIU
Junior Member
Taj...

I had a successful full backup on Friday and then immediately before I began the duplicate operation I took an incremental.

Arju...

I run these operations on the test box that I am cloning to?

Thanks,
Matt
Re: Duplicate with RMAN Fails with ORA-01547 [message #262907 is a reply to message #262903] Tue, 28 August 2007 08:36 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Your source and target database is some machine ???

or
I took an incremental.
Take level 0 backup (complete)

Regards
Taj
Re: Duplicate with RMAN Fails with ORA-01547 [message #262909 is a reply to message #262903] Tue, 28 August 2007 08:39 Go to previous messageGo to next message
Chewie71
Messages: 19
Registered: October 2005
Location: WIU
Junior Member
Tried these commands...

SQL> recover database until cancel
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database using backup controlfile;
ORA-00279: change 194106686 generated at 08/27/2007 12:40:21 needed for thread
1
ORA-00289: suggestion : /webct/oracle/oradata/webcttst/archive/1_16234.log
ORA-00280: change 194106686 for thread 1 is in sequence #16234


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'/webct/oracle/oradata/webcttst/archive/1_16234.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

[Updated on: Tue, 28 August 2007 08:39]

Report message to a moderator

Re: Duplicate with RMAN Fails with ORA-01547 [message #262929 is a reply to message #262907] Tue, 28 August 2007 09:41 Go to previous messageGo to next message
Chewie71
Messages: 19
Registered: October 2005
Location: WIU
Junior Member
Target DB(production) is one physical host, and the auxiliary(clone) DB is on another physical host.

I will take a full backup and try again this afternoon.

Thanks,
Matt
Re: Duplicate with RMAN Fails with ORA-01547 [message #263029 is a reply to message #262599] Tue, 28 August 2007 15:26 Go to previous messageGo to next message
Chewie71
Messages: 19
Registered: October 2005
Location: WIU
Junior Member
Bah...that was the problem. Had to run a full backup then immediately clone it...and all is well.

Thanks,
Matt
Re: Duplicate with RMAN Fails with ORA-01547 [message #263045 is a reply to message #262599] Tue, 28 August 2007 22:40 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Apply redo one not archive one.
Previous Topic: RMAN Tag parameter
Next Topic: can i delete rman backups
Goto Forum:
  


Current Time: Fri May 17 06:45:39 CDT 2024