今天duplicate database for standby的时候,出现了RMAN-05001错误:
RMAN> duplicate target database for standby;
Starting Duplicate Db at 18-OCT-12
using channel ORA_AUX_DISK_1
contents of Memory Script.:
{
restore clone standby controlfile;
}
executing Memory Script
Starting restore at 18-OCT-12
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 /u01/rmanbackup/05no2p6c_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/rmanbackup/05no2p6c_1_1 tag=TAG20121018T152224
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/oradata/node/control01.ctl
output file name=/u01/oradata/node/control02.ctl
Finished restore at 18-OCT-12
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 10/18/2012 15:43:12
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary file name /u01/oradata/node/users01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/node/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/node/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/node/system01.dbf conflicts with a file used by the target database
关闭实例,重新启动
SQL> shutdown abort
ORACLE instance shut down.
SQL> create spfile from pfile;
File created.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 613797888 bytes
Fixed Size 2215824 bytes
Variable Size 373293168 bytes
Database Buffers 234881024 bytes
Redo Buffers 3407872 bytes
此处消除了RMAN-05001错误,但是增加了ORA-19527: physical standby redo log must be renamed错误!!!
oracle@node_standby dbs]$ rman target sys/oracle@node auxiliary /
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Oct 18 20:35:46 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: NODE (DBID=842482436)
connected to auxiliary database: NODE (not mounted)
RMAN> duplicate target database for standby nofilenamecheck;
Starting Duplicate Db at 18-OCT-12
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK
contents of Memory Script.:
{
restore clone standby controlfile;
}
executing Memory Script
Starting restore at 18-OCT-12
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 /u01/rmanbackup/05no2p6c_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/rmanbackup/05no2p6c_1_1 tag=TAG20121018T152224
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:08
output file name=/u01/oradata/node/control01.ctl
output file name=/u01/oradata/node/control02.ctl
Finished restore at 18-OCT-12
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
"/u01/oradata/node/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/oradata/node/system01.dbf";
set newname for datafile 2 to
"/u01/oradata/node/sysaux01.dbf";
set newname for datafile 3 to
"/u01/oradata/node/undotbs01.dbf";
set newname for datafile 4 to
"/u01/oradata/node/users01.dbf";
restore
clone database
;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/oradata/node/temp01.dbf in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 18-OCT-12
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 /u01/oradata/node/system01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00002 to /u01/oradata/node/sysaux01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/oradata/node/undotbs01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/oradata/node/users01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u01/rmanbackup/04no2p1h_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/rmanbackup/04no2p1h_1_1 tag=TAG20121018T152224
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:02:06
Finished restore at 18-OCT-12
contents of Memory Script.:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=797027920 file name=/u01/oradata/node/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=797027920 file name=/u01/oradata/node/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=797027920 file name=/u01/oradata/node/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=797027920 file name=/u01/oradata/node/users01.dbf
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: '/u01/oradata/node/redo01.log'
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 2 thread 1: '/u01/oradata/node/redo02.log'
RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 3 thread 1: '/u01/oradata/node/redo03.log'
RMAN-05535: WARNING: All redo log files were not defined properly.
Finished Duplicate Db at 18-OCT-12