Dealing with Dataguard and rman RMAN-05501
Dataguard Reserve Library Restoration Times rman-05501
RMAN > duplicate target database for standby
Starting Duplicate Db at 09-JUN-15
Allocated channel: ORA_AUX_DISK_1
Channel ORA_AUX_DISK_1: SID=345 device type=DISK
Contents of Memory Script:
{
Restore clone standby controlfile
}
Executing Memory Script
Starting restore at 09-JUN-15
Using channel ORA_AUX_DISK_1
Channel ORA_AUX_DISK_1: restoring control file
Channel ORA_AUX_DISK_1: copied control file copy
Input file name=/u01/oradata_backup/full_backup/db.ctl
Output file name=/opt/oracle/database/oradata/db/control01.ctl
Output file name=/opt/oracle/database/fast_recovery_area/db/control02.ctl
Finished restore at 09-JUN-15
Contents of Memory Script:
{
Sql clone 'alter database mount standby database'
}
Executing Memory Script
Sql statement: alter database mount standby database
RMAN-00571: =
RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =
RMAN-00571: =
RMAN-03002: failure of Duplicate Db command at 06/09/2015 16:54:16
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f18.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f17.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f16.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f15.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f14.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f13.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f12.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f11.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f10.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f09.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f08.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f07.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f06.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f05.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f04.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/warehouse_f05.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/warehouse_f04.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/warehouse_f03.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/warehouse_f02.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/warehouse_f01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f03.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f02.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/adv_ts_main_f01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/users01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name / opt/oracle/database/oradata/db/system01.dbf conflicts with a file used by the target database
Reason:
The datafile directory of the master database is the same as that of the slave database, and the parameters * .db_file_name_convert and * .log _ file_name_convert are not added to the initialization parameters. So you need to add nofilenamecheck when you duplicate here.
SQL > shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL > startup pfile='/u01/oradata_backup/standby.pfile' nomount
ORACLE instance started.
Total System Global Area 3.1935E+10 bytes
Fixed Size 2268992 bytes
Variable Size 2.8119E+10 bytes
Database Buffers 3758096384 bytes
Redo Buffers 55840768 bytes
SQL > create spfile='/opt/oracle/database/product/11.2.0/db_1/dbs/initdkhlstd.ora' from pfile='/u01/oradata_backup/standby.pfile'
File created.
[oracle@wx ~] $rman target sys/dk2014_oracle@db auxiliary /
Recovery Manager: Release 11.2.0.4.0-Production on Tue Jun 9 17:03:10 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to target database: db (DBID=4232991297)
Connected to auxiliary database: db (not mounted)
RMAN > duplicate target database for standby nofilenamecheck
Starting Duplicate Db at 09-JUN-15
Using target database control file instead of recovery catalog
Allocated channel: ORA_AUX_DISK_1
Channel ORA_AUX_DISK_1: SID=296 device type=DISK
Contents of Memory Script:
{
Restore clone standby controlfile
}
Executing Memory Script
Starting restore at 09-JUN-15
Using channel ORA_AUX_DISK_1
Channel ORA_AUX_DISK_1: restoring control file
Channel ORA_AUX_DISK_1: copied control file copy
Input file name=/u01/oradata_backup/full_backup/db.ctl
Output file name=/opt/oracle/database/oradata/db/control01.ctl
Output file name=/opt/oracle/database/fast_recovery_area/db/control02.ctl
Finished restore at 09-JUN-15
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
"/ opt/oracle/database/oradata/db/temp01.dbf"
Switch clone tempfile all
Set newname for datafile 1 to
"/ opt/oracle/database/oradata/db/system01.dbf"
Set newname for datafile 2 to
"/ opt/oracle/database/oradata/db/sysaux01.dbf"
Set newname for datafile 3 to
"/ opt/oracle/database/oradata/db/undotbs01.dbf"
Set newname for datafile 4 to
"/ opt/oracle/database/oradata/db/users01.dbf"
Set newname for datafile 5 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f01.dbf"
Set newname for datafile 6 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f02.dbf"
Set newname for datafile 7 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f03.dbf"
Set newname for datafile 8 to
"/ opt/oracle/database/oradata/db/warehouse_f01.dbf"
Set newname for datafile 9 to
"/ opt/oracle/database/oradata/db/warehouse_f02.dbf"
Set newname for datafile 10 to
"/ opt/oracle/database/oradata/db/warehouse_f03.dbf"
Set newname for datafile 11 to
"/ opt/oracle/database/oradata/db/warehouse_f04.dbf"
Set newname for datafile 12 to
"/ opt/oracle/database/oradata/db/warehouse_f05.dbf"
Set newname for datafile 13 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f04.dbf"
Set newname for datafile 14 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f05.dbf"
Set newname for datafile 15 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f06.dbf"
Set newname for datafile 16 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f07.dbf"
Set newname for datafile 17 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f08.dbf"
Set newname for datafile 18 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f09.dbf"
Set newname for datafile 19 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f10.dbf"
Set newname for datafile 20 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f11.dbf"
Set newname for datafile 21 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f12.dbf"
Set newname for datafile 22 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f13.dbf"
Set newname for datafile 23 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f14.dbf"
Set newname for datafile 24 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f15.dbf"
Set newname for datafile 25 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f16.dbf"
Set newname for datafile 26 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f17.dbf"
Set newname for datafile 27 to
"/ opt/oracle/database/oradata/db/adv_ts_main_f18.dbf"
Restore
Clone database
}
Executing Memory Script
.
RMAN >
RMAN > exit
Recovery Manager complete.
