rman duplicate
646575Mar 14 2010 — edited Mar 14 2010Hello gurus
I am trying to duplicate database using rman on my vista pc i am getting following error.
connected to target database: ORCL (DBID=1197103292)
connected to auxiliary database: RMANDUP (not mounted)
RMAN> run {
2> allocate auxiliary channel ch1 type disk;
3> duplicate target database to RMANDUP;
4> }
using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: sid=157 devtype=DISK
Starting Duplicate Db at 13-MAR-10
contents of Memory Script:
{
set until scn 38417495;
set newname for datafile 1 to
"C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\SYSTEM01.DBF";
set newname for datafile 2 to
"C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\UNDOTBS01.DBF";
set newname for datafile 3 to
"C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\SYSAUX01.DBF";
set newname for datafile 4 to
"C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\USERS01.DBF";
set newname for datafile 5 to
"C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\EXAMPLE01.DBF";
set newname for datafile 6 to
"C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\TEST1.DBF";
set newname for datafile 7 to
"C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\TEST2.DBF";
restore
check readonly
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 13-MAR-10
channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\SYSTEM01.DBF
restoring datafile 00002 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\UNDOTBS01.DBF
restoring datafile 00003 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\SYSAUX01.DBF
restoring datafile 00004 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\USERS01.DBF
restoring datafile 00005 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\EXAMPLE01.DBF
restoring datafile 00006 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\TEST1.DBF
restoring datafile 00007 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\TEST2.DBF
channel ch1: reading from backup piece C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\19L8GDSR_1_1
ORA-19870: error reading backup piece C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\19L8GDSR_1_1
ORA-19504: failed to create file "C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\SYSTEM01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
failover to previous backup
channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\SYSTEM01.DBF
restoring datafile 00002 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\UNDOTBS01.DBF
restoring datafile 00003 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\SYSAUX01.DBF
restoring datafile 00004 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\USERS01.DBF
restoring datafile 00005 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\EXAMPLE01.DBF
restoring datafile 00006 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\TEST1.DBF
restoring datafile 00007 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\TEST2.DBF
channel ch1: reading from backup piece C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\14L1SNL9_1_1
ORA-19870: error reading backup piece C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\14L1SNL9_1_1
ORA-19505: failed to identify file "C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\14L1SNL9_1_1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
failover to previous backup
channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\SYSTEM01.DBF
restoring datafile 00002 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\UNDOTBS01.DBF
restoring datafile 00003 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\SYSAUX01.DBF
restoring datafile 00004 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\USERS01.DBF
restoring datafile 00005 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\EXAMPLE01.DBF
restoring datafile 00006 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\TEST1.DBF
restoring datafile 00007 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\TEST2.DBF
channel ch1: reading from backup piece C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2009_12_
NDF_TAG20091226T145207_5MDTC7LK_.BKP
ORA-19870: error reading backup piece C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2009_12_2
DF_TAG20091226T145207_5MDTC7LK_.BKP
ORA-19504: failed to create file "C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\SYSTEM01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
failover to previous backup
channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\SYSTEM01.DBF
restoring datafile 00002 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\UNDOTBS01.DBF
restoring datafile 00003 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\SYSAUX01.DBF
restoring datafile 00004 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\USERS01.DBF
restoring datafile 00005 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\EXAMPLE01.DBF
restoring datafile 00006 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\TEST1.DBF
restoring datafile 00007 to C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\TEST2.DBF
channel ch1: reading from backup piece C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2009_12_
NDF_TAG20091224T221659_5M8COD33_.BKP
ORA-19870: error reading backup piece C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2009_12_2
DF_TAG20091224T221659_5M8COD33_.BKP
ORA-19504: failed to create file "C:\ORACLE\PRODUCT\10.2.0\RMANDUP\ORCL\SYSTEM01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
failover to previous backup
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/13/2010 22:49:07
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
and this is my initfile
rmandup.__db_cache_size=58720256
rmandup.__java_pool_size=4194304
rmandup.__large_pool_size=4194304
rmandup.__shared_pool_size=532676608
rmandup.__streams_pool_size=4194304
*.audit_file_dest='C:\oracle\product\10.2.0\admin\rmandup\adump'
*.background_dump_dest='C:\oracle\product\10.2.0\admin\rmandup\bdump'
*.compatible='10.2.0.3.0'
*.control_files='C:\oracle\product\10.2.0\oradata\rmandup\control01.ctl','C:\oracle\product\10.2.0\oradata\rmandup\control02.ctl','C:\oracle\product\10.2.0\oradata\rmandup\control03.ctl'
*.core_dump_dest='C:\oracle\product\10.2.0\admin\rmandup\cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='rmandup'
*.db_recovery_file_dest_size=2147483648
*.db_recovery_file_dest=''
*.dispatchers='(PROTOCOL=TCP) (SERVICE=rmandupXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=612368384
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:\oracle\product\10.2.0\admin\rmandup\udump'
*.db_file_name_convert = ('C:\oracle\product\10.2.0\oradata', 'C:\oracle\product\10.2.0\rmandup')
*.log_file_name_convert = ('C:\oracle\product\10.2.0\oradata', 'C:\oracle\product\10.2.0\rmandup')
all directories have been created also....please advice