Hi,
I m doing Duplicate Database from ASM to Non- ASM(remote Server) Database Using RMAN cold backups. Below the steps
below the error i m getting when when running RMAN from target db
[oracle@asmprod dbs]$ rman target / nocatalog auxiliary sys/sys@test1
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Mar 10 10:50:07 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: TEST1ASM (DBID=819568112, not open)
using target database control file instead of recovery catalog
connected to auxiliary database: TEST1 (not mounted)
RMAN> duplicate target database to test1 nofilenamecheck;
Starting Duplicate Db at 10-MAR-12
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=155 devtype=DISK
contents of Memory Script:
{
set until scn 247747;
set newname for datafile 1 to
"+DGROUPB/test1asm/datafile/system.260.777490617";
set newname for datafile 2 to
"+DGROUPB/test1asm/datafile/undotbs.256.777490695";
set newname for datafile 3 to
"+DGROUPB/test1asm/datafile/sysaux.257.777490745";
set newname for datafile 4 to
"+DGROUPB/test1asm/datafile/p1.258.777490805";
set newname for datafile 5 to
"+DGROUPB/test1asm/datafile/p2.259.777490857";
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
Starting restore at 10-MAR-12
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: restoring datafile 00001
input datafile copy recid=18 stamp=777490972 filename=/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-SYSTEM_FNO-1_04n5d41a
destination for restore of datafile 00001: +DGROUPB/test1asm/datafile/system.260.777490617
ORA-19505: failed to identify file "/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-SYSTEM_FNO-1_04n5d41a"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-19600: input file is datafile-copy 0 (/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-SYSTEM_FNO-1_04n5d41a)
ORA-19601: output file is datafile 1 (+DGROUPB
channel ORA_AUX_DISK_1: restoring datafile 00002
input datafile copy recid=19 stamp=777490972 filename=/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-UNDOTBS_FNO-2_05n5d436
destination for restore of datafile 00002: +DGROUPB/test1asm/datafile/undotbs.256.777490695
ORA-19505: failed to identify file "/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-UNDOTBS_FNO-2_05n5d436"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-19600: input file is datafile-copy 0 (/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-UNDOTBS_FNO-2_05n5d436)
ORA-19601: output file is datafile 2 (+DGROUPB
channel ORA_AUX_DISK_1: restoring datafile 00003
input datafile copy recid=20 stamp=777490973 filename=/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-SYSAUX_FNO-3_06n5d44f
destination for restore of datafile 00003: +DGROUPB/test1asm/datafile/sysaux.257.777490745
ORA-19505: failed to identify file "/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-SYSAUX_FNO-3_06n5d44f"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-19600: input file is datafile-copy 0 (/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-SYSAUX_FNO-3_06n5d44f)
ORA-19601: output file is datafile 3 (+DGROUPB
channel ORA_AUX_DISK_1: restoring datafile 00004
input datafile copy recid=21 stamp=777490973 filename=/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-P1_FNO-4_07n5d45j
destination for restore of datafile 00004: +DGROUPB/test1asm/datafile/p1.258.777490805
ORA-19505: failed to identify file "/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-P1_FNO-4_07n5d45j"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-19600: input file is datafile-copy 0 (/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-P1_FNO-4_07n5d45j)
ORA-19601: output file is datafile 4 (+DGROUPB
channel ORA_AUX_DISK_1: restoring datafile 00005
input datafile copy recid=22 stamp=777490973 filename=/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-P2_FNO-5_08n5d46o
destination for restore of datafile 00005: +DGROUPB/test1asm/datafile/p2.259.777490857
ORA-19505: failed to identify file "/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-P2_FNO-5_08n5d46o"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-19600: input file is datafile-copy 0 (/u01/app/oracle/product/10.2.0/oradata/test1_asm/data_D-TEST1ASM_I-819568112_TS-P2_FNO-5_08n5d46o)
ORA-19601: output file is datafile 5 (+DGROUPB
failover to previous backup
channel ORA_AUX_DISK_1: restoring datafile 00001
input datafile copy recid=7 stamp=777425166 filename=+DGROUPB/test1asm/datafile/system.259.777413031
destination for restore of datafile 00001: +DGROUPB/test1asm/datafile/system.260.777490617
ORA-19505: failed to identify file "+DGROUPB/test1asm/datafile/system.259.777413031"
ORA-17503: ksfdopn:2 Failed to open file +DGROUPB/test1asm/datafile/system.259.777413031
ORA-15001: diskgroup "DGROUPB" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
ORA-19600: input file is datafile-copy 0 (+DGROUPB/test1asm/datafile/system.259.777413031
channel ORA_AUX_DISK_1: restoring datafile 00002
input datafile copy recid=8 stamp=777425166 filename=+DGROUPB/test1asm/datafile/undotbs.258.777413061
destination for restore of datafile 00002: +DGROUPB/test1asm/datafile/undotbs.256.777490695
ORA-19505: failed to identify file "+DGROUPB/test1asm/datafile/undotbs.258.777413061"
ORA-17503: ksfdopn:2 Failed to open file +DGROUPB/test1asm/datafile/undotbs.258.777413061
ORA-15001: diskgroup "DGROUPB" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
ORA-19600: input file is datafile-copy 0 (+DGROUPB/test1asm/datafile/undotbs.258.777413061
channel ORA_AUX_DISK_1: restoring datafile 00003
input datafile copy recid=9 stamp=777425166 filename=+DGROUPB/test1asm/datafile/sysaux.257.777413091
destination for restore of datafile 00003: +DGROUPB/test1asm/datafile/sysaux.257.777490745
ORA-19505: failed to identify file "+DGROUPB/test1asm/datafile/sysaux.257.777413091"
ORA-17503: ksfdopn:2 Failed to open file +DGROUPB/test1asm/datafile/sysaux.257.777413091
ORA-15001: diskgroup "DGROUPB" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
ORA-19600: input file is datafile-copy 0 (+DGROUPB/test1asm/datafile/sysaux.257.777413091
channel ORA_AUX_DISK_1: restoring datafile 00004
input datafile copy recid=10 stamp=777425166 filename=+DGROUPB/test1asm/datafile/p1.256.777421945
destination for restore of datafile 00004: +DGROUPB/test1asm/datafile/p1.258.777490805
ORA-19505: failed to identify file "+DGROUPB/test1asm/datafile/p1.256.777421945"
ORA-17503: ksfdopn:2 Failed to open file +DGROUPB/test1asm/datafile/p1.256.777421945
ORA-15001: diskgroup "DGROUPB" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
ORA-19600: input file is datafile-copy 0 (+DGROUPB/test1asm/datafile/p1.256.777421945
channel ORA_AUX_DISK_1: restoring datafile 00005
input datafile copy recid=11 stamp=777425166 filename=+DGROUPB/test1asm/datafile/p2.260.777421981
destination for restore of datafile 00005: +DGROUPB/test1asm/datafile/p2.259.777490857
ORA-19505: failed to identify file "+DGROUPB/test1asm/datafile/p2.260.777421981"
ORA-17503: ksfdopn:2 Failed to open file +DGROUPB/test1asm/datafile/p2.260.777421981
ORA-15001: diskgroup "DGROUPB" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
ORA-19600: input file is datafile-copy 0 (+DGROUPB/test1asm/datafile/p2.260.777421981
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/10/2012 10:50:58
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 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
Below the filenames in ASM db i.e. test1asm
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+DGROUPB/test1asm/datafile/system.260.777490617
+DGROUPB/test1asm/datafile/undotbs.256.777490695
+DGROUPB/test1asm/datafile/sysaux.257.777490745
+DGROUPB/test1asm/datafile/p1.258.777490805
+DGROUPB/test1asm/datafile/p2.259.777490857
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
+DGROUPA/test1asm/onlinelog/group_1.258.777491663
+DGROUPA/test1asm/onlinelog/group_2.257.777491705
+DGROUPA/test1asm/onlinelog/group_3.259.777491855
below the pfile of test1 in another server
*.audit_file_dest='/u01/app/oracle/product/10.2.0/admin/test1/adump'
*.background_dump_dest='/u01/app/oracle/product/10.2.0/admin/test1/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/product/10.2.0/oradata/test1/control01.ctl',
'/u01/app/oracle/product/10.2.0/oradata/test1/control02.ctl','/u01/app/oracle/product/10.2.0/oradata/test1/control03.ctl'
*.core_dump_dest='/u01/app/oracle/product/10.2.0/admin/test1/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.dispatchers='(PROTOCOL=TCP) (SERVICE=indiaXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=200278016
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=601882624
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS'
*.user_dump_dest='/u01/app/oracle/product/10.2.0/admin/test1/udump'
*.db_recovery_file_dest='/u01/app/oracle/product/10.2.0/backup/test1'
*.db_recovery_file_dest_size=2147483648
#############################################################################################################################
*.DB_FILE_NAME_CONVERT=(/+DGROUPB/test1asm/datafile/,/u01/app/oracle/product/10.2.0/oradata/test1/)
*.DB_NAME='test1'
*.INSTANCE_NAME='test1'
*.LOG_ARCHIVE_DEST_1='LOCATION=/u01/app/oracle/product/10.2.0/archive/test1'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_FORMAT='%t_%s_%r.arc'
*.LOG_FILE_NAME_CONVERT=(/+DGROUPA/test1asm/onlinelog/,/u01/app/oracle/product/10.2.0/oradata/test1/)
*.REMOTE_LOGIN_PASSWORDFILE='EXCLUSIVE'
basically i want to restore the datafile from
DGROUPB to /u01/app/oracle/product/10.2.0/oradata/test1 location in test1 db and all logfile from DGROUPA to /u01/app/oracle/product/10.2.0/oradata/test1 and that is where the root of the problem lies. Can any1 help me to overcome this problem
Thanks in advance