Duplicate with RMAN Fails with ORA-01547 [message #262599] |
Mon, 27 August 2007 16:46 |
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.
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 #262909 is a reply to message #262903] |
Tue, 28 August 2007 08:39 |
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
|
|
|
|
|
|