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

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.

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.