$ rman target / auxiliary sys/oracle@DUPLICATE RMAN> duplicate target database to orcl from active database nofilenamecheck; 注意:如果target 和 Auxiliary库的目录结构相同,记得加上nofilenamecheck参数,不然会报错误,如果目录不同,在pfile里加2个参数进行转换:db_file_name_convert、log_file_name_convert。 七...
当然,我们也可以在duplicate 命令中加上PASSWORD FILE 选项(也是默认值), 这样RMAN 在copy 的时候也会从target 库把密码文件copy过来,如果auxiliary库上已经存在了Password file,那么该操作会重写那个文件。 如: RMAN> DUPLICATE TARGET DATABASE TO Dave 2> FROM ACTIVE DATABASE 3> NOFILENAMECHECK 4> PASSWORD FI...
https://communities.oracle.com/portal/server.pt/community/database_backup_and_recovery/243 Database Name :- chicago Primary db_unique_name :- chicago standby db_unique_name :- Boston 有关复制 NONE-Standby,请参阅: Note 452868.1RMAN 'Duplicate From Active Database' Feature in 11G Fix 1.对主...
RMAN> duplicate database to sybo3 from active database spfile nofilenamecheck; --->发布duplicate命令 Starting Duplicate Db at 02-AUG-13 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=134 device type=DISK contents of...
在Oracle10g下,我们可以使用RMANduplicate命令创建一个具有不同DBID的复制库。到了Oracle11gR2,RMAN的duplicate有2种方法实现: 1.Activedatabaseduplication 2.Backup-basedduplication Activedatabaseduplication通过网络,直接copytarget库到auxiliary库,然后创建复制库。这种方法就不需要先用RMAN备份数据库,然后将备份文件发送...
(CONNECT_DATA = (SERVICE_NAME = orcl) ) ) 6.开始RMAN duplicate from active database: 注意:如果target和Auxiliary库的目录结构相同,记得加上nofilenamecheck参数,不然会报如下错误: RMAN-05001: auxiliary file name /u01/app/oracle/oradata/orcl/users01.dbf conflicts with a file used by the target da...
RMAN duplicate命令中有哪些重要参数? Oracle 11g RMAN能够实现基于活动数据库进行异机克隆,从而省去需要先备份再ftp到辅助服务器的过程。这一切可以全部交给Oracle来搞定。在克隆期间,Oracle会读取Target DB的所有数据结构,无须人为的干预(不同的磁盘系统,文件路径与文件名要指定转换方式)。尽管如此,对于生产环境数据库...
ORA-17628, ORA-19505 during RMAN DUPLICATE FROM ACTIVE (Doc ID 1331986.1) One data file is not using OMF name while the rest of the data files are using OMF name. 怀疑是对应数据文件名字的问题,但后来排除了此原因。 因为比对报错数据文件和正常的数据文件并无特殊之处,且每次报错文件并不一样。
oracle 10g可以通过基于备份的rman DUPLICATE实现dataguard,通过步骤需要对数据库进行备份,并在standby侧进行数据库的恢复。而到了11g,oracle推出了Duplicate From Active Database技术,不需要再对数据库进行rman备份恢复,一切动作都通过网络自动完成。 下面是具体的实现例子: ...
Hi - I have very strange situation. I've used this command a lot of times, did not have any problems. This time duplicate from active database ended with error ORA-01152. I searched MOS, found a bug 9044053, installed it. It did not help. After that