RMAN duplicate for standby failure resolution process
It is always unsuccessful to generate a standby with Rman duplicate to standby, which is the following error:
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_07nvi815_1_1
Channel Ora_aux_disk_1:piece Handle=/backup/dg_back_07nvi815_1_1 tag=tag20130116t110405
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 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";
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 the 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_05nvi7sn_1_1
Channel Ora_aux_disk_1:ora-19870:error while restoring backup piece/backup/dg_back_05nvi7sn_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 was 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
Channel ora_aux_disk_1:starting datafile backup set restore
Channel ora_aux_disk_1:specifying DataFile (s) to the 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 was 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 has backups that can is 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 to check also can not detect errors, redo is the same problem.
Question 1:
Set newname for Tempfile 1 to
"+data";
The problem is that the conversion parameters of the temporary table space are less written in the parameters:
*.db_file_name_convert= ' +data/e7rac/tempfile/', '/oradata/e7dg2/datafile/'
When this parameter is added, it will become:
Set newname for Tempfile 1 to
"/oradata/e7dg2/datafile/temp.263.804695143";
Question 2:
DataFile part
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";
Parameters are configured:
*.db_file_name_convert= ' +data/e7rac/datafile/', '/oradata/e7dg2/datafile/'
The last discovery is a case error: The above path is from the PWD in asmcmd>, and the parameter is modified to the following condition after normal.
*.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 final correct execution process:
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_07nvi815_1_1
Channel Ora_aux_disk_1:piece Handle=/backup/dg_back_07nvi815_1_1 tag=tag20130116t110405
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 to
"/oradata/e7dg2/datafile/temp.263.804695143";
Switch clone tempfile all;
Set newname for DataFile 1 to
"/oradata/e7dg2/datafile/system.256.804692297";
Set newname for DataFile 2 to
"/oradata/e7dg2/datafile/sysaux.257.804692309";
Set newname for DataFile 3 to
"/oradata/e7dg2/datafile/undotbs1.258.804692313";
Set newname for DataFile 4 to
"/oradata/e7dg2/datafile/users.259.804692315";
Set newname for DataFile 5 to
"/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 the 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_05nvi7sn_1_1
Channel Ora_aux_disk_1:piece Handle=/backup/dg_back_05nvi7sn_1_1 tag=tag20130116t110143
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
This article is from "Xu Sanjin those years of mixed it" blog, please be sure to keep this source http://xu3jin.blog.51cto.com/2261216/1828557
Do the DG Standby library execution Duplicate target database for standby Nofilenamecheck report RMAN-06023