点击(此处)折叠或打开
-
RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;
Starting Duplicate Db at 02-JUL-18
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=396 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwnetdata' auxiliary format
'/u01/app/oracle/product/11.2.0/db_1/dbs/orapwnetdata' ;
}
executing Memory Script
Starting backup at 02-JUL-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=408 device type=DISK
Finished backup at 02-JUL-18
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/netdata/control01.ctl';
restore clone controlfile to '/u01/app/oracle/fast_recovery_area/netdata/control02.ctl' from
'/u01/app/oracle/oradata/netdata/control01.ctl';
}
executing Memory Script
Starting backup at 02-JUL-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_netdata.f tag=TAG20180702T183426 RECID=1 STAMP=980447667
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 02-JUL-18
Starting restore at 02-JUL-18
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 02-JUL-18
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/app/oracle/oradata/netdata/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/app/oracle/oradata/netdata/system01.dbf";
set newname for datafile 2 to
"/u01/app/oracle/oradata/netdata/sysaux01.dbf";
set newname for datafile 3 to
"/u01/app/oracle/oradata/netdata/undotbs01.dbf";
set newname for datafile 4 to
"/u01/app/oracle/oradata/netdata/users01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/u01/app/oracle/oradata/netdata/system01.dbf" datafile
2 auxiliary format
"/u01/app/oracle/oradata/netdata/sysaux01.dbf" datafile
3 auxiliary format
"/u01/app/oracle/oradata/netdata/undotbs01.dbf" datafile
4 auxiliary format
"/u01/app/oracle/oradata/netdata/users01.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oracle/oradata/netdata/temp01.dbf in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 02-JUL-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/netdata/system01.dbf
output file name=/u01/app/oracle/oradata/netdata/system01.dbf tag=TAG20180702T183437
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/netdata/sysaux01.dbf
output file name=/u01/app/oracle/oradata/netdata/sysaux01.dbf tag=TAG20180702T183437
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/netdata/undotbs01.dbf
output file name=/u01/app/oracle/oradata/netdata/undotbs01.dbf tag=TAG20180702T183437
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/netdata/users01.dbf
output file name=/u01/app/oracle/oradata/netdata/users01.dbf tag=TAG20180702T183437
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 02-JUL-18
sql statement: alter system archive log current
contents of Memory Script:
{
backup as copy reuse
archivelog like "/u01/archive/1_8_980442214.dbf" auxiliary format
"/u01/archive/1_8_980442214.dbf" ;
catalog clone archivelog "/u01/archive/1_8_980442214.dbf";
switch clone datafile all;
}
executing Memory Script
Starting backup at 02-JUL-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=8 RECID=4 STAMP=980447742
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/02/2018 18:35:43
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/02/2018 18:35:43
ORA-17628: Oracle error 19505 returned by remote Oracle server
点击(此处)折叠或打开
-
Additional information: 3
Mon Jul 02 18:35:43 2018
Errors in file /u01/app/oracle/diag/rdbms/netdata_st1/netdata/trace/netdata_ora_4020.trc:
ORA-19505: failed to identify file "/u01/archive/1_8_980442214.dbf"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 13: Permission denied
Additional information: 1
很明显的错误，由于之前是用root建的的目录未修改权限
点击(此处)折叠或打开
-
chown -R oracle:oinstall /u01/archive
修改后删除备库之前复制文件
点击(此处)折叠或打开
-
rm -rf /u01/app/oracle/oradata/netdata
重新duplicate
点击(此处)折叠或打开
-
RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;
Starting Duplicate Db at 02-JUL-18
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwnetdata' auxiliary format
'/u01/app/oracle/product/11.2.0/db_1/dbs/orapwnetdata' ;
}
executing Memory Script
Starting backup at 02-JUL-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=404 device type=DISK
Finished backup at 02-JUL-18
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/netdata/control01.ctl';
restore clone controlfile to '/u01/app/oracle/fast_recovery_area/netdata/control02.ctl' from
'/u01/app/oracle/oradata/netdata/control01.ctl';
}
executing Memory Script
Starting backup at 02-JUL-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_netdata.f tag=TAG20180702T185303 RECID=2 STAMP=980448784
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 02-JUL-18
Starting restore at 02-JUL-18
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 02-JUL-18
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/app/oracle/oradata/netdata/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/app/oracle/oradata/netdata/system01.dbf";
set newname for datafile 2 to
"/u01/app/oracle/oradata/netdata/sysaux01.dbf";
set newname for datafile 3 to
"/u01/app/oracle/oradata/netdata/undotbs01.dbf";
set newname for datafile 4 to
"/u01/app/oracle/oradata/netdata/users01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/u01/app/oracle/oradata/netdata/system01.dbf" datafile
2 auxiliary format
"/u01/app/oracle/oradata/netdata/sysaux01.dbf" datafile
3 auxiliary format
"/u01/app/oracle/oradata/netdata/undotbs01.dbf" datafile
4 auxiliary format
"/u01/app/oracle/oradata/netdata/users01.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oracle/oradata/netdata/temp01.dbf in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 02-JUL-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/netdata/system01.dbf
output file name=/u01/app/oracle/oradata/netdata/system01.dbf tag=TAG20180702T185311
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/netdata/sysaux01.dbf
output file name=/u01/app/oracle/oradata/netdata/sysaux01.dbf tag=TAG20180702T185311
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/netdata/undotbs01.dbf
output file name=/u01/app/oracle/oradata/netdata/undotbs01.dbf tag=TAG20180702T185311
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/netdata/users01.dbf
output file name=/u01/app/oracle/oradata/netdata/users01.dbf tag=TAG20180702T185311
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 02-JUL-18
sql statement: alter system archive log current
contents of Memory Script:
{
backup as copy reuse
archivelog like "/u01/archive/1_9_980442214.dbf" auxiliary format
"/u01/archive/1_9_980442214.dbf" ;
catalog clone archivelog "/u01/archive/1_9_980442214.dbf";
switch clone datafile all;
}
executing Memory Script
Starting backup at 02-JUL-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=9 RECID=5 STAMP=980448836
output file name=/u01/archive/1_9_980442214.dbf RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 02-JUL-18
cataloged archived log
archived log file name=/u01/archive/1_9_980442214.dbf RECID=1 STAMP=980448838
datafile 1 switched to datafile copy
input datafile copy RECID=2 STAMP=980448838 file name=/u01/app/oracle/oradata/netdata/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=3 STAMP=980448838 file name=/u01/app/oracle/oradata/netdata/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=4 STAMP=980448838 file name=/u01/app/oracle/oradata/netdata/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=5 STAMP=980448838 file name=/u01/app/oracle/oradata/netdata/users01.dbf
contents of Memory Script:
{
set until scn 973806;
recover
standby
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 02-JUL-18
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 9 is already on disk as file /u01/archive/1_9_980442214.dbf
archived log file name=/u01/archive/1_9_980442214.dbf thread=1 sequence=9
media recovery complete, elapsed time: 00:00:01
Finished recover at 02-JUL-18
Finished Duplicate Db at 02-JUL-18
RMAN> quit
Recovery Manager complete.
编辑推荐：
下一篇：
相关推荐
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
雷神推出 MIX PRO II 迷你主机：基于 Ultra 200H，玻璃上盖 + ARGB 灯效
2 月 9 日消息，雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C：支持手写笔、第三方安卓应用
2 月 10 日消息，制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- Oracle RAC 全局等待事件 gc current block busy 和 gc cr multi block request 说明
- Maya建模教程：打造超级英雄钢铁侠
Maya建模教程：打造超级英雄钢铁侠
26-03-03 - 2010word如何设置背景图片
2010word如何设置背景图片
26-03-03 - word2010解决停止响应的教程
word2010解决停止响应的教程
26-03-03 - RMAN备份和恢复
RMAN备份和恢复
26-03-03 - Oracle集群时间同步
Oracle集群时间同步
26-03-03 - Oracle的三种高可用集群方案
Oracle的三种高可用集群方案
26-03-03 - Maya打造华丽BJD娃娃
Maya打造华丽BJD娃娃
26-03-03 - Oracle数据库脱敏-在中国南方ORACLE用户组2018.06数据库技术专题研讨会上的分享
