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?