Hi,
i am doing DR setup following below link
http://www.oracle.com/technetwork/database/features/availability/maa-wp-10g-racprimarysingleinstance-131970.pdf
Primary DB name - prod
Standby DB name - clonedb
i am getting below error on step 9,
9. From the standby host, duplicate the primary database as a standby into the ASM disk group. For example: $ rman target sys/oracle@CHICAGO1_SERV auxiliary / RMAN> DUPLICATE TARGET DATABASE FOR STANDBY;
Please help
my pfile:
*.audit_file_dest='/u01/app/oracle/admin/clonedb/adump'
*.audit_trail='db'
*.cluster_database=false
*.compatible='11.2.0.4.0'
*.control_files='/u01/app/oracle/oradata/clonedb/clonedbctl.ctl'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oracle/oradata/clonedb'
*.instance_name=clonedb
*.db_domain=''
*.db_name='prod'
*.db_unique_name=clonedb
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4621074432
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=prodXDB)'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=262144000
*.processes=150
*.remote_login_passwordfile='exclusive'
*.sga_target=786432000
*.thread=1
*.undo_tablespace=UNDOTBS1
*.log_archive_config='dg_config=(clonedb,prod)'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'
*.log_archive_dest_2='service=CHICAGO1_SERV valid_for=(online_logfiles,primary_role) db_unique_name=CHICAGO'
*.db_file_name_convert=('+DATA/orcl/datafile/sysaux.257.911398605','/u01/app/oracle/oradata/clonedb/sysaux.dbf'
'+DATA/orcl/datafile/system.256.911398605','/u01/app/oracle/oradata/clonedb/system.dbf'
'+DATA/orcl/datafile/example.267.911398731','/u01/app/oracle/oradata/clonedb/example.dbf'
'+DATA/orcl/datafile/undotbs1.258.911398605','/u01/app/oracle/oradata/clonedb/undotbs1.dbf'
'+DATA/orcl/datafile/undotbs2.268.911398873','/u01/app/oracle/oradata/clonedb/undotbs2.dbf'
'+DATA/orcl/datafile/users.259.911398607','/u01/app/oracle/oradata/clonedb/users.dbf')
*.log_file_name_convert='+DATA/orcl/','/u01/app/oracle/oradata/clonedb/'
*.standby_file_management=auto
*.fal_server='prod1','prod2'
*.fal_client='clonedb'
*.service_names='clonedb'
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 784998400 bytes
Fixed Size 2257352 bytes
Variable Size 272633400 bytes
Database Buffers 507510784 bytes
Redo Buffers 2596864 bytes
SQL> !
[oracle@dataguard clonedb]$ rman target sys/oracle@prod auxiliary /
Recovery Manager: Release 11.2.0.4.0 - Production on Tue May 3 04:38:15 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=324517783)
connected to auxiliary database: PROD (not mounted)
RMAN> DUPLICATE TARGET DATABASE FOR STANDBY nofilenamecheck dorecover;
Starting Duplicate Db at 03-MAY-16
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=20 device type=DISK
contents of Memory Script:
{
set until scn 1088816;
restore clone standby controlfile;
}
executing Memory Script
executing command: SET until clause
Starting restore at 03-MAY-16
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/backup/05r6cuof_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/backup/05r6cuof_1_1 tag=TAG20160524T114852
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/clonedb/clonedbctl.ctl
Finished restore at 03-MAY-16
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
contents of Memory Script:
{
set until scn 1088816;
set newname for tempfile 1 to
"+data";
switch clone tempfile all;
set newname for datafile 1 to
"+data";
set newname for datafile 2 to
"+data";
set newname for datafile 3 to
"+data";
set newname for datafile 4 to
"+data";
set newname for datafile 5 to
"+data";
set newname for datafile 6 to
"+data";
restore
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
renamed tempfile 1 to +data in control file
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 03-MAY-16
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to +data
channel ORA_AUX_DISK_1: restoring datafile 00002 to +data
channel ORA_AUX_DISK_1: restoring datafile 00003 to +data
channel ORA_AUX_DISK_1: restoring datafile 00004 to +data
channel ORA_AUX_DISK_1: restoring datafile 00005 to +data
channel ORA_AUX_DISK_1: restoring datafile 00006 to +data
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/backup/04r6cul5_1_1
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /u01/app/oracle/backup/04r6cul5_1_1
ORA-19504: failed to create file "+DATA"
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup "DATA" 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 Synchronization Service
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/03/2016 04:38:40
RMAN-05501: aborting duplication of target database
RMAN-05556: not all datafiles have backups that can be recovered to SCN 1088816
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
RMAN>