oracle11g active dataguard dupliacte制作从库
来源:互联网 发布:rng淘宝官方旗舰店 编辑:程序博客网 时间:2024/06/06 23:17
今天尝试了用adg 的duplicate方式制作从库,主库上不需要制作备份拷贝到从库上恢复,只需在主库上直接使用命令执行duplicate,在线传输制作
Oracle instance shut down
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/22/2017 11:46:17
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 04/22/2017 11:46:09
ORA-17628: Oracle error 19505 returned by remote Oracle server
上面的原因是我在备库上少创建了对应的目录。
输出日志如下;
Starting Duplicate Db at 22-APR-17
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=129 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile ‘/data/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/orapwdbadb’ auxiliary format
‘/data/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/orapwdbadb’ ;
}
executing Memory Script
Starting backup at 22-APR-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=71 device type=DISK
Finished backup at 22-APR-17
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format ‘/data/oracle/app/oradata/dbadb/control01.ctl’;
restore clone controlfile to ‘/data/oracle/app/fast_recovery_area/dbadb/control02.ctl’ from
‘/data/oracle/app/oradata/dbadb/control01.ctl’;
}
executing Memory Script
Starting backup at 22-APR-17
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/data/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_dbadb.f tag=TAG20170422T123154 RECID=4 STAMP=941977914
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 22-APR-17
Starting restore at 22-APR-17
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 22-APR-17
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
“/data/oracle/app/oradata/dbadb/temp01.dbf”;
switch clone tempfile all;
set newname for datafile 1 to
“/data/oracle/app/oradata/dbadb/system01.dbf”;
set newname for datafile 2 to
“/data/oracle/app/oradata/dbadb/sysaux01.dbf”;
set newname for datafile 3 to
“/data/oracle/app/oradata/dbadb/undotbs01.dbf”;
set newname for datafile 4 to
“/data/oracle/app/oradata/dbadb/users01.dbf”;
set newname for datafile 5 to
“/data/oracle/app/oradata/dbadb/test.dbf”;
backup as copy reuse
datafile 1 auxiliary format
“/data/oracle/app/oradata/dbadb/system01.dbf” datafile
2 auxiliary format
“/data/oracle/app/oradata/dbadb/sysaux01.dbf” datafile
3 auxiliary format
“/data/oracle/app/oradata/dbadb/undotbs01.dbf” datafile
4 auxiliary format
“/data/oracle/app/oradata/dbadb/users01.dbf” datafile
5 auxiliary format
“/data/oracle/app/oradata/dbadb/test.dbf” ;
sql ‘alter system archive log current’;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /data/oracle/app/oradata/dbadb/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
Starting backup at 22-APR-17
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/data/oracle/app/oradata/dbadb/system01.dbf
output file name=/data/oracle/app/oradata/dbadb/system01.dbf tag=TAG20170422T123201
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/data/oracle/app/oradata/dbadb/sysaux01.dbf
output file name=/data/oracle/app/oradata/dbadb/sysaux01.dbf tag=TAG20170422T123201
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/data/oracle/app/oradata/dbadb/test.dbf
output file name=/data/oracle/app/oradata/dbadb/test.dbf tag=TAG20170422T123201
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/data/oracle/app/oradata/dbadb/undotbs01.dbf
output file name=/data/oracle/app/oradata/dbadb/undotbs01.dbf tag=TAG20170422T123201
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/data/oracle/app/oradata/dbadb/users01.dbf
output file name=/data/oracle/app/oradata/dbadb/users01.dbf tag=TAG20170422T123201
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 22-APR-17
sql statement: alter system archive log current
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=4 STAMP=941977931 file name=/data/oracle/app/oradata/dbadb/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=5 STAMP=941977931 file name=/data/oracle/app/oradata/dbadb/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=6 STAMP=941977931 file name=/data/oracle/app/oradata/dbadb/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=7 STAMP=941977931 file name=/data/oracle/app/oradata/dbadb/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=8 STAMP=941977931 file name=/data/oracle/app/oradata/dbadb/test.dbf
Finished Duplicate Db at 22-APR-17
- oracle11g active dataguard dupliacte制作从库
- oracle11g dataguard完全手册3-failover &active dataguard(完)
- Oracle11G DataGuard
- Oracle11gR2 Active DataGuard
- oracle11g dataguard undo恢复
- linux oracle11g dataguard配置
- oracle11g dataguard 完全手册
- oracle11g dataguard 完全手册
- oracle11g dataguard安装实施
- oracle11g dataguard 完全手册
- oracle11g dataguard 完全手册
- oracle11g dataguard 完全手册
- Oracle11g Dataguard配置
- oracle11g dataguard 完全手册
- oracle11g dataguard 完全手册
- 主库不停的情况下联机创建active dataguard
- oracle11g dataguard 备库数据同步的检查方法
- Oracle 11g DataGuard 物理备库配置及Active DataGuard测试
- 【java】二叉树重建
- 高精度开方
- 列表渲染多层嵌套循环及wx:key的使用
- excle+pytest+jenkins+allure接口自动化测试框架
- 题目1202:排序
- oracle11g active dataguard dupliacte制作从库
- 【IMWeb训练营作业2】-select
- part-1 输入偏置电流和输入失调电流
- C++11中std::addressof的使用
- java线程中yield(),sleep(),wait()区别详解
- 题目1203:IP地址
- BigDecimal使用方式
- (4.5.5.4)Espresso的进阶: OnView & onData & Matchers
- android去掉振动相关选项