设为首页 加入收藏

TOP

使用dataguard将单实例数据库转换为rac数据库(三)
2015-11-21 01:51:26 来源: 作者: 【 】 浏览:1
Tags:使用 dataguard 实例 数据库 转换 rac
and Real Application Testing options SQL> exit [oracle@suq1 ~]$ sqlplus sys/manager@primary as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 26 21:50:25 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> exit
5.使用duplicate 创建standby database:

?

?

[oracle@11g1 arch]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 26 22:28:11 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SUQ (DBID=1469685490)

RMAN> connect auxiliary sys/manager@standby

connected to auxiliary database: SUQ (not mounted)

RMAN> duplicate target database for standby from active database; 

Starting Duplicate Db at 26-JUL-15
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=141 instance=suq1 device type=DISK

contents of Memory Script:
{
   backup as copy reuse
   targetfile  '/opt/oracle/product/OraHome11204/dbs/orapwsuq' auxiliary format 
 '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwsuq1'   ;
}
executing Memory Script

Starting backup at 26-JUL-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=147 device type=DISK
Finished backup at 26-JUL-15

contents of Memory Script:
{
   backup as copy current controlfile for standby auxiliary format  '+DATADG/suq/control.ctl';
}
executing Memory Script

Starting backup at 26-JUL-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/opt/oracle/product/OraHome11204/dbs/snapcf_suq.f tag=TAG20150726T222820 RECID=3 STAMP=886112900
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 26-JUL-15

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 
 "+DATADG/suq/datafile/temp01.dbf";
   switch clone tempfile all;
   set newname for datafile  1 to 
 "+DATADG/suq/datafile/system01.dbf";
   set newname for datafile  2 to 
 "+DATADG/suq/datafile/sysaux01.dbf";
   set newname for datafile  3 to 
 "+DATADG/suq/datafile/undotbs01.dbf";
   set newname for datafile  4 to 
 "+DATADG/suq/datafile/users01.dbf";
   backup as copy reuse
   datafile  1 auxiliary format 
 "+DATADG/suq/datafile/system01.dbf"   datafile 
 2 auxiliary format 
 "+DATADG/suq/datafile/sysaux01.dbf"   datafile 
 3 auxiliary format 
 "+DATADG/suq/datafile/undotbs01.dbf"   datafile 
 4 auxiliary format 
 "+DATADG/suq/datafile/users01.dbf"   ;
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to +DATADG/suq/datafile/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 26-JUL-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/opt/oracle/oradata/suq/system01.
首页 上一页 1 2 3 4 5 6 下一页 尾页 3/6/6
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇oracle获取某时间段内的年份、月.. 下一篇oracle10g不支持continue解决方法

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: