RMAN duplicate for standby failure Solution Process
When using rman duplicate to standby to generate the standby database, it is always unsuccessful. The following error occurs when multiple attempts are made:
RMAN> duplicate target database for standby nofilenamecheck;
Starting Duplicate Db at 16-JAN-2013 12:22:45
Using target database control file instead of recovery catalog
Allocated channel: ORA_AUX_DISK_1
Channel ORA_AUX_DISK_1: SID = 25 device type = DISK
Contents of Memory Script:
{
Restore clone standby controlfile;
}
Executing Memory Script
Starting restore at 16-JAN-2013 12:22:49
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/backup/dg_back_071_815_1_1
Channel ORA_AUX_DISK_1: piece handle =/backup/dg_back_071_815_1_1 tag = tag201301_t110405
Channel ORA_AUX_DISK_1: restored backup piece 1
Channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Output file name =/oradata/e7dg1/controlfile/current1.ctl
Output file name =/oradata/e7dg1/controlfile/current2.ctl
Finished restore at 16-JAN-2013 12:22:52
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 newname for tempfile 1
"+ Data ";
Switch clone tempfile all;
Set newname for datafile 1
"+ Data ";
Set newname for datafile 2
"+ Data ";
Set newname for datafile 3
"+ Data ";
Set newname for datafile 4
"+ Data ";
Set newname for datafile 5
"+ Data ";
Restore
Clone database
;
}
Executing Memory Script
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
Starting restore at 16-JAN-2013 12:23:02
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: reading from backup piece/backup/dg_back_051_7sn_1_1
Channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece/backup/dg_back_051_7sn_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: cocould not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
Failover to previous backup
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: reading from backup piece + FRA/e7rac/backupset/2013_01_15/nnndf0_tag20130115t162421_0.278.804791379
Channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece + FRA/e7rac/backupset/2013_01_15/nnndf0_tag20130115t162421_0.278.804791379
ORA-19505: failed to identify file "+ FRA/e7rac/backupset/2013_01_15/nnndf0_tag20130115t162421_0.278.804791379"
ORA-17503: ksfdopn: 2 Failed to open file + FRA/e7rac/backupset/2013_01_15/nnndf0_tag20130115t162421_0.278.804791379
ORA-15001: diskgroup "FRA" does not exist or is not mounte
Failover to previous backup
RMAN-00571: ========================================================== ==============================
RMAN-00569: ==================== error message stack follows ==========================
RMAN-00571: ========================================================== ==============================
RMAN-03002: failure of Duplicate Db command at 01/16/2013 12:23:06
RMAN-05501: aborting duplication of target database
RMAN-05556: not all datafiles have backups that can be recovered to SCN consistent
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 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>
This problem has plagued me for two days. How can I check and check for errors? redo is the same.
Question 1:
Set newname for tempfile 1
"+ Data ";
This problem is caused by the following:
*. Db_file_name_convert = '+ DATA/e7rac/tempfile/', '/oradata/e7dg2/datafile /'
After this parameter is added, it will become as follows:
Set newname for tempfile 1
"/Oradata/e7dg2/datafile/temp.263.804695143 ";
Question 2:
Datafile
Set newname for datafile 1
"+ Data ";
Set newname for datafile 2
"+ Data ";
Set newname for datafile 3
"+ Data ";
Set newname for datafile 4
"+ Data ";
Set newname for datafile 5
"+ Data ";
The parameter has been configured:
*. Db_file_name_convert = '+ DATA/E7RAC/DATAFILE/', '/oradata/e7dg2/datafile /'
Case sensitivity error: The above path is from pwd in asmcmd> and the parameter is changed to the following.
*. Db_file_name_convert = '+ DATA/e7rac/datafile/', '/oradata/e7dg2/datafile /'
The correct path parameter is from the command:
Select file_name from dba_data_files;
The correct execution process is as follows:
RMAN> duplicate target database for standby nofilenamecheck;
Starting Duplicate Db at 17-JAN-2013 16:42:46
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:
{
Restore clone standby controlfile;
}
Executing Memory Script
Starting restore at 17-JAN-2013 16:42:49
Using channel ORA_AUX_DISK_1
Channel ORA_AUX_DISK_1: restoring control file
ORA-19625: error identifying file/apps/Oracle/product/11.2.0/dbhome_1/dbs/snapcf_e7rac1.f
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-19600: input file is control file (/apps/oracle/product/11.2.0/dbhome_1/dbs/snapcf_e7rac1.f)
ORA-19601: output file is control file (/oradata/e7dg2/controlfile/current1.ctl)
Failover to previous backup
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/backup/dg_back_071_815_1_1
Channel ORA_AUX_DISK_1: piece handle =/backup/dg_back_071_815_1_1 tag = tag201301_t110405
Channel ORA_AUX_DISK_1: restored backup piece 1
Channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Output file name =/oradata/e7dg2/controlfile/current1.ctl
Output file name =/oradata/e7dg2/controlfile/current2.ctl
Finished restore at 17-JAN-2013 16:42:51
Contents of Memory Script:
{
SQL clone 'alter database mount standby database ';
}
Executing Memory Script
SQL statement: alter database mount standby database
Contents of Memory Script:
{
Set newname for tempfile 1
"/Oradata/e7dg2/datafile/temp.263.804695143 ";
Switch clone tempfile all;
Set newname for datafile 1
"/Oradata/e7dg2/datafile/system.256.804692297 ";
Set newname for datafile 2
"/Oradata/e7dg2/datafile/sysaux.257.804692309 ";
Set newname for datafile 3
"/Oradata/e7dg2/datafile/undotbs1.258.804692313 ";
Set newname for datafile 4
"/Oradata/e7dg2/datafile/users.259.804692315 ";
Set newname for datafile 5
"/Oradata/e7dg2/datafile/undotbs2.264.804696469 ";
Restore
Clone database
;
}
Executing Memory Script
Executing command: SET NEWNAME
Renamed tempfile 1 to/oradata/e7dg2/datafile/temp.263.804695143 in control file
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Starting restore at 17-JAN-2013 16:42:58
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/oradata/e7dg2/datafile/system.256.804692297
Channel ORA_AUX_DISK_1: restoring datafile 00002 to/oradata/e7dg2/datafile/sysaux.257.804692309
Channel ORA_AUX_DISK_1: restoring datafile 00003 to/oradata/e7dg2/datafile/undotbs1.258.804692313
Channel ORA_AUX_DISK_1: restoring datafile 00004 to/oradata/e7dg2/datafile/users.259.804692315
Channel ORA_AUX_DISK_1: restoring datafile 00005 to/oradata/e7dg2/datafile/undotbs2.264.804696469
Channel ORA_AUX_DISK_1: reading from backup piece/backup/dg_back_051_7sn_1_1
Channel ORA_AUX_DISK_1: piece handle =/backup/dg_back_051_7sn_1_1 tag = tag201301_t110143
Channel ORA_AUX_DISK_1: restored backup piece 1
Channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:25
Finished restore at 17-JAN-2013 16:44:24
Contents of Memory Script:
{
Switch clone datafile all;
}
Executing Memory Script
Datafile 1 switched to datafile copy
Input datafile copy RECID = 1 STAMP = 804960154 file name =/oradata/e7dg2/datafile/system.256.804692297
Datafile 2 switched to datafile copy
Input datafile copy RECID = 2 STAMP = 804960154 file name =/oradata/e7dg2/datafile/sysaux.257.804692309
Datafile 3 switched to datafile copy
Input datafile copy RECID = 3 STAMP = 804960154 file name =/oradata/e7dg2/datafile/undotbs1.258.804692313
Datafile 4 switched to datafile copy
Input datafile copy RECID = 4 STAMP = 804960154 file name =/oradata/e7dg2/datafile/users.259.804692315
Datafile 5 switched to datafile copy
Input datafile copy RECID = 5 STAMP = 804960154 file name =/oradata/e7dg2/datafile/undotbs2.264.804696469
Finished Duplicate Db at 17-JAN-2013 16:44:55