Shulou(Shulou.com)06/01 Report--

RMAN duplicate for standby failure resolution process

It is always unsuccessful to generate a repository with rman duplicate to standby. Many attempts are due to 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 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 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

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 been bothering me for two days. No matter how I check it, I can't find an error, and it's the same problem with redoing.

Question 1:

Set newname for tempfile 1 to

"+ data"

The problem is that the conversion parameters of temporary tablespaces are less written in the parameters:

* .db_file_name_convert='+DATA/e7rac/tempfile/','/oradata/e7dg2/datafile/'

When this parameter is added, it looks like this:

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"

The parameters have been configured:

* .db_file_name_convert='+DATA/E7RAC/DATAFILE/','/oradata/e7dg2/datafile/'

Finally, it is found that it is a case error: the above path comes from the pwd in asmcmd >, and the parameter is normal after being modified to the following case.

* .db_file_name_convert='+DATA/e7rac/datafile/','/oradata/e7dg2/datafile/'

The correct path parameters come from the command:

Select file_name from dba_data_files

Finally, the 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 controlfile (/ 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 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.