auxiliary恢复备库详细记录

最新推荐文章于 2022-01-26 15:33:00 发布
最新推荐文章于 2022-01-26 15:33:00 发布
阅读量589 收藏 1
点赞数
文章标签： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_34162629/article/details/85086567
版权

 

 -bash-3.2$ rman target / auxiliary sys/password@standby

 


 

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Feb 8 22:01:47 2012
 


 

Copyright (c) 1982, 2007, Oracle.  All rights reserved.
 


 

connected to target database: port (DBID=2726356005)
 

connected to auxiliary database: port (not mounted)
 


 

RMAN> run{
 

allocate channel c1 device type disk format '/u01/rmanbak/forstandby/%U' connect sys/password@port;
 

allocate auxiliary channel ac1 device type disk format '/u01/rmanbak/forstandby/%U'; 
 

duplicate target database for standby;
 

}2> 3> 4> 5> 
 


 

using target database control file instead of recovery catalog
 

allocated channel: c1
 

channel c1: sid=114 devtype=DISK
 


 

allocated channel: ac1
 

channel ac1: sid=318 devtype=DISK
 


 

Starting Duplicate Db at 2012-02-08 22:02:16
 


 

contents of Memory Script:
 

{
 

   restore clone standby controlfile;
 

   sql clone 'alter database mount standby database';
 

}
 

executing Memory Script
 


 

Starting restore at 2012-02-08 22:02:16
 


 

channel ac1: starting datafile backupset restore
 

channel ac1: restoring control file
 

channel ac1: reading from backup piece /u01/rmanbak/forstandby/ctl/CON_17n2r6q5_1_1
 

ORA-19870: error reading backup piece /u01/rmanbak/forstandby/ctl/CON_17n2r6q5_1_1
 

ORA-19505: failed to identify file "/u01/rmanbak/forstandby/ctl/CON_17n2r6q5_1_1"
 

ORA-27037: unable to obtain file status
 

Linux-x86_64 Error: 2: No such file or directory
 

Additional information: 3
 

failover to previous backup
 


 

released channel: c1
 

RMAN-00571: ===========================================================
 

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 

RMAN-00571: ===========================================================
 

RMAN-03002: failure of Duplicate Db command at 02/08/2012 22:02:19
 

RMAN-03015: error occurred in stored script Memory Script
 

RMAN-06026: some targets not found - aborting restore
 

RMAN-06024: no backup or copy of the control file found to restore
 

#########################################################################################
 

=======================错误原因，从库备份文件放置路径和主库不一致========================
 

#########################################################################################
 

RMAN> 
 


 

RMAN> 
 


 


 


 


 

RMAN> run{
 

allocate channel c1 device type disk format '/u01/rmanbak/forstandby/%U' connect sys/password@port;
 

allocate auxiliary channel ac1 device type disk format '/u01/rmanbak/forstandby/%U'; 
 

duplicate target database for standby;
 

}2> 3> 4> 5> 
 


 

allocated channel: c1
 

channel c1: sid=114 devtype=DISK
 


 

allocated channel: ac1
 

channel ac1: sid=318 devtype=DISK
 


 

Starting Duplicate Db at 2012-02-08 22:04:35
 


 

contents of Memory Script:
 

{
 

   restore clone standby controlfile;
 

   sql clone 'alter database mount standby database';
 

}
 

executing Memory Script
 


 

Starting restore at 2012-02-08 22:04:35
 


 

channel ac1: starting datafile backupset restore
 

channel ac1: restoring control file
 

channel ac1: reading from backup piece /u01/rmanbak/forstandby/ctl/CON_17n2r6q5_1_1
 

channel ac1: restored backup piece 1
 

piece handle=/u01/rmanbak/forstandby/ctl/CON_17n2r6q5_1_1 tag=TAG20120208T214644
 

channel ac1: restore complete, elapsed time: 00:00:01
 

output filename=/u01/oracle/oradata/port/control01.ctl
 

output filename=/u01/oracle/oradata/port/control02.ctl
 

output filename=/u01/oracle/oradata/port/control03.ctl
 

Finished restore at 2012-02-08 22:04:36
 


 

sql statement: alter database mount standby database
 

released channel: c1
 

released channel: ac1
 

RMAN-00571: ===========================================================
 

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 

RMAN-00571: ===========================================================
 

RMAN-03002: failure of Duplicate Db command at 02/08/2012 22:04:41
 

RMAN-05501: aborting duplication of target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/cuteinfo.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/cuteinfo_index.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/cuteinfo_data.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/zghgzz_index.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/zghgzz_data.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/chicago_index.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/chicago_data.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/chicago.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/wms_index.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/wms_data.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/system02.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/rman_catalog.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/users01.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/sysaux01.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/undotbs01.dbf conflicts with a file used by the target database
 

RMAN-05001: auxiliary filename /u01/oracle/oradata/port/system01.dbf conflicts with a file used by the target database
 


 

#########################################################################################
 

===============错误原因，主库和从库目录结构一致，为防止异常覆盖，出以上报错==============
 

===============可以用duplicate target database for standby nofilenamecheck;方法解决======
 

#########################################################################################
 


 


 


 

RMAN>duplicate target database for standby nofilenamecheck;
 


 

Starting Duplicate Db at 2012-02-08 22:08:59
 

using channel ORA_AUX_DISK_1
 

RMAN-00571: ===========================================================
 

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 

RMAN-00571: ===========================================================
 

RMAN-03002: failure of Duplicate Db command at 02/08/2012 22:08:59
 

RMAN-05500: the auxiliary database must be not mounted when issuing a DUPLICATE command
 


 

RMAN> exit
 


 


 

Recovery Manager complete.
 


 


 

-bash-3.2$ rman target / auxiliary sys/password@standby
 


 

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Feb 8 22:09:52 2012
 


 

Copyright (c) 1982, 2007, Oracle.  All rights reserved.
 


 

connected to target database: port (DBID=2726356005)
 

connected to auxiliary database: port (DBID=2726356005, not open)
 


 

RMAN> duplicate target database for standby nofilenamecheck;
 


 

Starting Duplicate Db at 2012-02-08 22:10:05
 

using target database control file instead of recovery catalog
 

allocated channel: ORA_AUX_DISK_1
 

channel ORA_AUX_DISK_1: sid=320 devtype=DISK
 

RMAN-00571: ===========================================================
 

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 

RMAN-00571: ===========================================================
 

RMAN-03002: failure of Duplicate Db command at 02/08/2012 22:10:05
 

RMAN-05500: the auxiliary database must be not mounted when issuing a DUPLICATE command
 

#########################################################################################
 

======================错误原因，从库状态不对，应该在NOMOUNT状态下========================
 

#########################################################################################
 


 

RMAN> 
 


 

RMAN> exit
 


 

Recovery Manager complete.
 

-bash-3.2$ rman target / auxiliary sys/password@standby
 


 

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Feb 8 22:21:28 2012
 


 

Copyright (c) 1982, 2007, Oracle.  All rights reserved.
 


 

connected to target database: port (not mounted)
 

connected to auxiliary database: port (DBID=2726356005, not open)
 


 

RMAN> duplicate target database for standby nofilenamecheck;
 


 

Starting Duplicate Db at 2012-02-08 22:21:54
 

using target database control file instead of recovery catalog
 

allocated channel: ORA_AUX_DISK_1
 

channel ORA_AUX_DISK_1: sid=156 devtype=DISK
 

RMAN-00571: ===========================================================
 

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 

RMAN-00571: ===========================================================
 

RMAN-03002: failure of Duplicate Db command at 02/08/2012 22:21:55
 

RMAN-05502: the target database must be mounted when issuing a DUPLICATE command
 


 

#########################################################################################
 

======================错误原因，主库状态不对，应该在MOUNT状态下==========================
 

#########################################################################################
 


 


 


 

RMAN> exit
 


 

Recovery Manager complete.
 

-bash-3.2$ rman target / auxiliary sys/password@standby
 


 

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Feb 8 22:24:49 2012
 


 

Copyright (c) 1982, 2007, Oracle.  All rights reserved.
 


 

connected to target database: port (DBID=2726356005, not open)
 

connected to auxiliary database: port (not mounted)
 

#########################################################################################
 

==================主库在MOUNT状态下，从库在NOMOUNT状态下才能执行如下语句=================
 

==================duplicate target database for standby nofilenamecheck==================
 

#########################################################################################
 

RMAN> duplicate target database for standby nofilenamecheck;
 


 

Starting Duplicate Db at 2012-02-08 22:25:11
 

using target database control file instead of recovery catalog
 

allocated channel: ORA_AUX_DISK_1
 

channel ORA_AUX_DISK_1: sid=155 devtype=DISK
 


 

contents of Memory Script:
 

{
 

   restore clone standby controlfile;
 

   sql clone 'alter database mount standby database';
 

}
 

executing Memory Script
 


 

Starting restore at 2012-02-08 22:25:12
 

using channel ORA_AUX_DISK_1
 


 

channel ORA_AUX_DISK_1: starting datafile backupset restore
 

channel ORA_AUX_DISK_1: restoring control file
 

channel ORA_AUX_DISK_1: reading from backup piece /u01/rmanbak/forstandby/ctl/CON_17n2r6q5_1_1
 

channel ORA_AUX_DISK_1: restored backup piece 1
 

piece handle=/u01/rmanbak/forstandby/ctl/CON_17n2r6q5_1_1 tag=TAG20120208T214644
 

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:04
 

output filename=/u01/oracle/oradata/port/control01.ctl
 

output filename=/u01/oracle/oradata/port/control02.ctl
 

output filename=/u01/oracle/oradata/port/control03.ctl
 

Finished restore at 2012-02-08 22:25:16
 


 

sql statement: alter database mount standby database
 

released channel: ORA_AUX_DISK_1
 


 

contents of Memory Script:
 

{
 

   set newname for tempfile  1 to 
 

 "/u01/oracle/oradata/port/temp01.dbf";
 

   switch clone tempfile all;
 

   set newname for datafile  1 to 
 

 "/u01/oracle/oradata/port/system01.dbf";
 

   set newname for datafile  2 to 
 

 "/u01/oracle/oradata/port/undotbs01.dbf";
 

   set newname for datafile  3 to 
 

 "/u01/oracle/oradata/port/sysaux01.dbf";
 

   set newname for datafile  4 to 
 

 "/u01/oracle/oradata/port/users01.dbf";
 

   set newname for datafile  5 to 
 

 "/u01/oracle/oradata/port/rman_catalog.dbf";
 

   set newname for datafile  6 to 
 

 "/u01/oracle/oradata/port/system02.dbf";
 

   set newname for datafile  7 to 
 

 "/u01/oracle/oradata/port/ms_data.dbf";
 

   set newname for datafile  8 to 
 

 "/u01/oracle/oradata/port/ms_index.dbf";
 

   set newname for datafile  9 to 
 

 "/u01/oracle/oradata/port/cago.dbf";
 

   set newname for datafile  10 to 
 

 "/u01/oracle/oradata/port/cago_data.dbf";
 

   set newname for datafile  11 to 
 

 "/u01/oracle/oradata/port/cago_index.dbf";
 

   set newname for datafile  12 to 
 

 "/u01/oracle/oradata/port/chinazz_data.dbf";
 

   set newname for datafile  13 to 
 

 "/u01/oracle/oradata/port/chinazz_index.dbf";
 

   set newname for datafile  14 to 
 

 "/u01/oracle/oradata/port/info_data.dbf";
 

   set newname for datafile  15 to 
 

 "/u01/oracle/oradata/port/info_index.dbf";
 

   set newname for datafile  16 to 
 

 "/u01/oracle/oradata/port/info.dbf";
 

   restore
 

   check readonly
 

   clone database
 

   ;
 

}
 

executing Memory Script
 


 

executing command: SET NEWNAME
 


 

renamed temporary file 1 to /u01/oracle/oradata/port/temp01.dbf in control file
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

executing command: SET NEWNAME
 


 

Starting restore at 2012-02-08 22:25:22
 

allocated channel: ORA_AUX_DISK_1
 

channel ORA_AUX_DISK_1: sid=155 devtype=DISK
 


 

channel ORA_AUX_DISK_1: starting datafile backupset restore
 

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
 

restoring datafile 00001 to /u01/oracle/oradata/port/system01.dbf
 

restoring datafile 00002 to /u01/oracle/oradata/port/undotbs01.dbf
 

restoring datafile 00003 to /u01/oracle/oradata/port/sysaux01.dbf
 

restoring datafile 00004 to /u01/oracle/oradata/port/users01.dbf
 

restoring datafile 00005 to /u01/oracle/oradata/port/rman_catalog.dbf
 

restoring datafile 00006 to /u01/oracle/oradata/port/system02.dbf
 

restoring datafile 00007 to /u01/oracle/oradata/port/ms_data.dbf
 

restoring datafile 00008 to /u01/oracle/oradata/port/ms_index.dbf
 

restoring datafile 00009 to /u01/oracle/oradata/port/cago.dbf
 

restoring datafile 00010 to /u01/oracle/oradata/port/cago_data.dbf
 

restoring datafile 00011 to /u01/oracle/oradata/port/cago_index.dbf
 

restoring datafile 00012 to /u01/oracle/oradata/port/chinazz_data.dbf
 

restoring datafile 00013 to /u01/oracle/oradata/port/chinazz_index.dbf
 

restoring datafile 00014 to /u01/oracle/oradata/port/info_data.dbf
 

restoring datafile 00015 to /u01/oracle/oradata/port/info_index.dbf
 

restoring datafile 00016 to /u01/oracle/oradata/port/info.dbf
 

channel ORA_AUX_DISK_1: reading from backup piece /u01/rmanbak/forstandby/19n2r6r9_1_1
 

channel ORA_AUX_DISK_1: restored backup piece 1
 

piece handle=/u01/rmanbak/forstandby/19n2r6r9_1_1 tag=TAG20120208T214721
 

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:05:26
 

Finished restore at 2012-02-08 22:30:49
 


 

contents of Memory Script:
 

{
 

   switch clone datafile all;
 

}
 

executing Memory Script
 


 

datafile 1 switched to datafile copy
 

input datafile copy recid=18 stamp=774743414 filename=/u01/oracle/oradata/port/system01.dbf
 

datafile 2 switched to datafile copy
 

input datafile copy recid=19 stamp=774743414 filename=/u01/oracle/oradata/port/undotbs01.dbf
 

datafile 3 switched to datafile copy
 

input datafile copy recid=20 stamp=774743414 filename=/u01/oracle/oradata/port/sysaux01.dbf
 

datafile 4 switched to datafile copy
 

input datafile copy recid=21 stamp=774743414 filename=/u01/oracle/oradata/port/users01.dbf
 

datafile 5 switched to datafile copy
 

input datafile copy recid=22 stamp=774743414 filename=/u01/oracle/oradata/port/rman_catalog.dbf
 

datafile 6 switched to datafile copy
 

input datafile copy recid=23 stamp=774743414 filename=/u01/oracle/oradata/port/system02.dbf
 

datafile 7 switched to datafile copy
 

input datafile copy recid=24 stamp=774743415 filename=/u01/oracle/oradata/port/ms_data.dbf
 

datafile 8 switched to datafile copy
 

input datafile copy recid=25 stamp=774743415 filename=/u01/oracle/oradata/port/ms_index.dbf
 

datafile 9 switched to datafile copy
 

input datafile copy recid=26 stamp=774743415 filename=/u01/oracle/oradata/port/cago.dbf
 

datafile 10 switched to datafile copy
 

input datafile copy recid=27 stamp=774743415 filename=/u01/oracle/oradata/port/cago_data.dbf
 

datafile 11 switched to datafile copy
 

input datafile copy recid=28 stamp=774743415 filename=/u01/oracle/oradata/port/cago_index.dbf
 

datafile 12 switched to datafile copy
 

input datafile copy recid=29 stamp=774743415 filename=/u01/oracle/oradata/port/chinazz_data.dbf
 

datafile 13 switched to datafile copy
 

input datafile copy recid=30 stamp=774743415 filename=/u01/oracle/oradata/port/chinazz_index.dbf
 

datafile 14 switched to datafile copy
 

input datafile copy recid=31 stamp=774743415 filename=/u01/oracle/oradata/port/info_data.dbf
 

datafile 15 switched to datafile copy
 

input datafile copy recid=32 stamp=774743415 filename=/u01/oracle/oradata/port/info_index.dbf
 

datafile 16 switched to datafile copy
 

input datafile copy recid=33 stamp=774743415 filename=/u01/oracle/oradata/port/info.dbf
 

Finished Duplicate Db at 2012-02-08 22:30:52
 


 

RMAN> 
 

Connection closed.
 
weixin_34162629
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
RMAN-05501 AND RMAN-05001
技术专栏
08-16 1293
在通过 rman active duplicate 创建 standby数据库时，报下面的错误： contents of Memory Script: {    sql clone 'alter database mount standby database'; } executing Memory Script sql statement: alter databas
rman duplicate target database RMAN-03002 RMAN-03015 RMAN-06136
03-24 758
通过RMAN的duplicate命令将目标数据库在另一主机上复制一个副本数据库时报以下错误信息： RMAN-00571: ===============================================...
oracle RAC数据库建立STANDBY（五）
weixin_33739541的博客
05-09 123
这篇文章描述为RAC环境创建STANDBY数据库。由于篇幅限制，加上碰到了很多的bug，只能将文章拆分成多篇。由于错误太多，导致一篇文章无法完全记录下来，创建STANDBY数据库问题汇总的第三部分。刚刚在进行RAC环境的DUPLICATE DATABASE的时候，就碰到了很多问题，由于二者命令比较相似，本来认为这次不会碰到太多的问题，没有想到的是，这次碰到的问题居然比DUPL...
【11.2拾遗】rman复制数据库 Duplicating a Database
viviliving的专栏
04-16 637
本章描述如何使用DUPLICATE命令创建独立运行的数据库副本。 This chapter contains the following topics: Overview of RMAN Database Duplication Preparing to Duplicate a Database Placing the Source Database in the Pr...
【RMAN】RMAN-05001: auxiliary filename conflicts with the target database
weixin_33737774的博客
06-28 459
oracle 11.2.0.4 运行以下脚本，使用活动数据库复制技术创建dataguard备库报错rman-005001： run{ duplicate target database for standby from active database spfile     set db_unique_name='dbkingstd'     set log_file_name_c...
Python库 | auxiliary-0.0.2.dev15.tar.gz
03-01
在Python后端开发中，auxiliary库可能包含各种实用工具，比如HTTP客户端、日志记录、异常处理、数据序列化和反序列化等功能，以提升开发效率和代码质量。对于一个库的贡献者或维护者来说，遵循良好的编码实践，提供...
Python库 | auxiliary-0.0.2.dev42.tar.gz
03-01
auxiliary库可能包含了各种辅助工具或者模块，这些工具可能涉及数据处理、网络通信、日志记录、错误处理等多个方面，旨在简化开发者的工作，提高开发效率。 Python库的开发通常遵循一定的标准，如PEP 8编码规范和...
nantou.zip_auxiliary particle
09-23
标题中的“nantou.zip_auxiliary particle”可能是指一个包含有关辅助粒子算法的压缩文件，而“nantou.m”可能是MATLAB代码文件，用于实现或演示该算法。在描述中提到的“噪声辅助数据分析方法”与“多目标跟踪的...
auxiliary-开源
04-25
错误处理部分通常包括日志记录和异常处理，确保在遇到问题时能提供有用的反馈，并有助于调试。 在文件`axl-0.3.1`中，我们可以期待找到框架的源代码，包括核心类库、示例应用、配置文件以及文档。安装和使用该框架...
Postfix Auxiliary Tools-开源
05-01
而“Postfix Auxiliary Tools”项目则是为了进一步增强Postfix的功能，尤其是针对网络安全和管理任务的优化。这个项目由Perl语言编写，旨在提供一套工具来帮助系统管理员更有效地防御垃圾邮件、病毒和其他可能对邮件...
RMAN-05001，RMAN-05500 问题解决
cuixie2370的博客
01-04 1640
On the primary node, perform. an RMAN backup of the primary database that places the backup pieces into the stagin...
RAC数据库建立STANDBY（五）
ckawt40802的专栏
05-29 117
这篇文章描述为RAC环境创建STANDBY数据库。 由于篇幅限制，加上碰到了很多的bug，只能将文章拆分成多篇。 由于错误太多，导致一篇文章无法完全记录下来，创建STANDBY数据库问题汇总的第三部分。 RAC数据库建立S...
使用RMAN传输数据_复制数据库
jetliu05的博客
01-26 3315
使用RMAN的DUPLICATE命令可以从源数据库复制全部或部分数据到复制数据库。
oracle数据库表备份到库里,Oracle数据库备份与恢复之四：RMAN(备份与恢复管理器)下...
weixin_31235395的博客
04-02 549
4.4.4.5联机日志的备份联机日志不能用RMAN来备份，可以先将其归档，再备份。为了实现这点，必须在 RMAN中执行归档命令语句：RMAN> run{2>allocate channel dev1 type disk；3> sql"alter system archive log current"；4> backup(archivelog from time "sy...
rman duplicate出现PLS-00201错误解决
cuanshao4773的博客
01-31 609
rman duplicate出现以下错误 点击(此处)折叠或打开 RMAN> duplicate target database for sta...
RMAN新特性duplicate概述和使用
热门推荐
真水无香，大象无形，做本分的自己，记录技术点滴
06-06 1万+
RMANDUPLICATION复制概述   DUPLICATE命令可以创建完整的运行良好的数据库副本（clone DB）或Physical standby数据库。 DUPLICATE命令自动为duplicate数据库分配不同的DBID，以便它可以注册在与源数据库相同的catalog中。 DUPLICATION可以是数据库级别，也可以指定表空间级别。 RMAN必须执行基于时间点的恢复，即使
RMAN-05501 RMAN-05001
Data & Analysis
03-28 748
错误信息： RMAN-05501: aborting duplication of target database RMAN-05001: auxiliary file name /oracle/oradata/skatedb/tbs_statspack01.dbf conflicts with a file used by the target database 在用rman duplicate创建dg的时候，抛出如上的错误，这里只列出用rman dumplicate的过程，具体操作步骤如下： .
RMAN duplicate 复制standby 数据库是的报错
cn00909332的博客
06-12 528
今天做RMAN搭建standby 数据库的时候报了一个错 2：RMAN> duplicate target database for standby from active database doreco...
oracle错误1327,Oracle DUPLICATE复制数据库
weixin_42121725的博客
04-03 894
一、DUPLICATE复制数据库1.使用duplicate命令可以在不影响目标数据库(Target/PrimaryDatabase)的情况下，依靠目标数据库的备份集创建一个Duplicate数据库(数据库副本)。在创建时既可以选择完整复制目标数据库，也可以仅包含目标数据库中的部分表空间，目标数据库和Duplicate数据库甚至可以在同一台机器上。2.Duplicate数据库是目标数据库在某个时间点...
write auxiliary register
最新发布
06-02
Auxiliary register是辅助寄存器的意思，它在计算机架构中扮演着辅助运算的角色。在某些指令集架构中，可以使用write auxiliary register的指令来写入辅助寄存器。这些指令通常用于执行一些特定的操作，如设置标志位...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值