Skip to Main Content

Oracle Database Discussions

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!

rman duplicate

646575Mar 14 2010 — edited Mar 14 2010
Hello 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2010
Added on Mar 14 2010
7 comments
1,147 views