Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error restoring backup from other database.

Me_101Aug 6 2012 — edited Aug 10 2012
Hi,

I just duplicate my PRODUCTION database to TEST database (11.2.0.1 both) on windows 7.

I just create a backup from PRODUCTION:
RMAN> backup full database format ='C:\Users\my_user\miBBDD\flash_recovery_are
a\TEST\database_%U';
and controlfile backup:
RMAN> backup current controlfile format='C:\Users\my_user\miBBDD\flash_recover
y_area\TEST\CONTROL_FILE_%U';
now i'm trying to restore this backup into TEST with this script:
RMAN
CONNECT TARGET /
STARTUP NOMOUNT;
SET DBID 486238190;  #DBID of TEST database
RUN
{
  ALLOCATE CHANNEL c1 DEVICE TYPE disk format 'C:\Users\my_user\miBBDD\flash_recovery_area\TEST\DATABASE_07NHV7KD_1_1';
  RESTORE CONTROLFILE FROM 'C:\Users\my_user\miBBDD\flash_recovery_area\TEST\CONTROL_FILE_09NHV8MI_1_1'; 
  ALTER DATABASE MOUNT;
  SET NEWNAME FOR DATAFILE 'C:\USERS\my_user\MIBBDD\ORADATA\PRODUCTION\SYSTEM01.DBF' TO 'C:\USERS\my_user\MIBBDD\ORADATA\TEST\SYSTEM01.DBF'; 
  SET NEWNAME FOR DATAFILE 'C:\USERS\my_user\MIBBDD\ORADATA\PRODUCTION\SYSAUX01.DBF' TO 'C:\USERS\my_user\MIBBDD\ORADATA\TEST\SYSAUX01.DBF'; 
  SET NEWNAME FOR DATAFILE 'C:\USERS\my_user\MIBBDD\ORADATA\PRODUCTION\UNDOTBS01.DBF' TO 'C:\USERS\my_user\MIBBDD\ORADATA\TEST\UNDOTBS01.DBF'; 
  SET NEWNAME FOR DATAFILE 'C:\USERS\my_user\MIBBDD\ORADATA\PRODUCTION\USERS01.DBF' TO 'C:\USERS\my_user\MIBBDD\ORADATA\TEST\USERS01.DBF'; 
  SET NEWNAME FOR DATAFILE 'C:\USERS\my_user\MIBBDD\ORADATA\PRODUCTION\EXAMPLE01.DBF' TO 'C:\USERS\my_user\MIBBDD\ORADATA\TEST\EXAMPLE01.DBF'; 
  SET NEWNAME FOR TEMPFILE 'C:\USERS\my_user\MIBBDD\ORADATA\PRODUCTION\TEMP01.DBF' TO 'C:\USERS\my_user\MIBBDD\ORADATA\TEST\TEMP01.DBF';
  SET NEWNAME FOR TEMPFILE 'C:\USERS\my_user\MIBBDD\ORADATA\PRODUCTION\TEMP02.DBF' TO 'C:\USERS\my_user\MIBBDD\ORADATA\TEST\TEMP02.DBF';
  RESTORE DATABASE;
  RECOVER DATABASE;
  release channel c1;
}
ALTER DATABASE OPEN RESETLOGS; 
but i'm having a similar error when i tried to duplicate both databases ( post -->2425698
fallo de la recuperaci¾n del medio fÝsico
canal liberado: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: fallo del comando recover en 08/06/2012 11:53:06
ORA-00283: recovery session canceled due to errors
RMAN-11003: fallo al analizar/ejecutar la sentencia SQL: alter database recover
if needed
 start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: 'C:\USERS\my_user\MIBBDD\ORADATA\PRODUCTION\SYSTEM01.D
BF'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:\USERS\my_user\MIBBDD\ORADATA\PRODUCTION\SYSTEM01.D
BF'
Controlfile was restored correctly. what am I doing wrong?
This post has been answered by mseberg on Aug 8 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2012
Added on Aug 6 2012
23 comments
2,585 views