Database Software

Hi,


RMAN ends up with below errors while duplication, please help

Recovery Manager: Release 11.2.0.3.0 - Production on Wed Jun 20 01:43:46 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: PAWSDB (DBID=3014417093)
connected to auxiliary database: ADPAWS (not mounted)

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48>
using target database control file instead of recovery catalog
allocated channel: d1
channel d1: SID=962 device type=DISK

allocated channel: d2
channel d2: SID=1055 device type=DISK

allocated channel: d3
channel d3: SID=1341 device type=DISK

allocated channel: d4
channel d4: SID=1534 device type=DISK

allocated channel: d5
channel d5: SID=1620 device type=DISK

allocated channel: d6
channel d6: SID=1717 device type=DISK

allocated channel: d7
channel d7: SID=1820 device type=DISK

allocated channel: d8
channel d8: SID=1915 device type=DISK

allocated channel: d9
channel d9: SID=2007 device type=DISK

allocated channel: stby1
channel stby1: SID=266 device type=DISK

allocated channel: stby2
channel stby2: SID=332 device type=DISK

Starting Duplicate Db at 20-JUN-12

contents of Memory Script:
{
backup as copy reuse
targetfile '/db_asm_home/oracle/db_home/product/11.2.0/dbhome_1/dbs/orapwpawsdb' auxiliary format
'/home/oracle/oracle/product/11.2.0/dbhome_1/dbs/orapwadpaws' targetfile
'+DG_DATA1/pawsdb/spfilepawsdb.ora' auxiliary format
'/home/oracle/oracle/product/11.2.0/dbhome_1/dbs/spfileadpaws.ora' ;
sql clone "alter system set spfile= ''/home/oracle/oracle/product/11.2.0/dbhome_1/dbs/spfileadpaws.ora''";
}
executing Memory Script

Starting backup at 20-JUN-12
RMAN-03009: failure of backup command on d1 channel at 06/20/2012 01:45:04
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
ORA-17629: Cannot connect to the remote database server
continuing other job steps, job failed will not be re-run
released channel: d1
released channel: d2
released channel: d3
released channel: d4
released channel: d5
released channel: d6
released channel: d7
released channel: d8
released channel: d9
released channel: stby1
released channel: stby2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/20/2012 01:45:04
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on d2 channel at 06/20/2012 01:45:04
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
ORA-17629: Cannot connect to the remote database server

TNSPing from either servers is successfull, primary is up and running, aux is started with nomount


RMAN Script is as below

run
{
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
allocate channel d5 type disk;
allocate channel d6 type disk;
allocate channel d7 type disk;
allocate channel d8 type disk;
allocate channel d9 type disk;
allocate auxiliary channel stby1 type disk;
allocate auxiliary channel stby2 type disk;
duplicate target database
for standby
from active database
dorecover
spfile
set db_unique_name='adpaws'
set control_files='+DG_DATA2/ADPAWS/CONTROLFILE/stdby_adpaws.ctl01','+DG_DATA2/ADPAWS/CONTROLFILE/stdby_adpaws.ctl02'
set audit_file_dest='/home/oracle/oracle/admin/adpaws/adump'
set diagnostic_dest='/home/oracle/oracle'
set log_archive_max_processes='4'
set fal_client='ADPAWS'
set fal_server='PAWSDB'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(pawsdb,adpaws)'
set log_archive_dest_1='LOCATION=+DG_ARCHIVE1/ADPAWS/ARCHIVE VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=adpaws'
set log_archive_dest_2='service=pawsdb ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=adpaws'
set db_file_name_convert='+DG_DATA1/pawsdb/','+DG_DATA2/ADPAWS'
set log_file_name_convert='+DG_REDO1/pawsdb/','+DG_DATA2/ADPAWS'
set memory_target='0'
set sga_max_size='25G'
set sga_target='0'
nofilenamecheck
;
release channel d1;
release channel d2;
release channel d3;
release channel d4;
release channel d5;
release channel d6;
release channel d7;
release channel d8;
release channel d9;
release channel stby1;
release channel stby2;
}

Thanks

Edited by: user1687821 on Jun 19, 2012 11:50 PM