AI 助理
备案控制台
开发者社区 数据库 文章 正文

【RAC,DATAGUARD】Creating a physical standby from ASM (RAC ) primary之四

2016-04-14 1716
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：
oracle@rac1:/home/oracle>rman target sys/yang402@rac auxiliary sys/yang402@yangdb
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 15 15:46:58 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database: RAC (DBID=2349912968)
connected to auxiliary database: RAC (not mounted)
RMAN> run {
2>    allocate channel c1 type disk connect 'sys/yang402@rac';
3>    allocate channel c2 type disk connect 'sys/yang402@rac';
4>    allocate auxiliary channel s1 type disk ;
5>    allocate auxiliary channel s2 type disk ;
6>    sql channel c1 "alter system archive log current";
7>    duplicate target database for standby from active database 
8>          spfile
9>          set db_name='rac' 
10>          set db_unique_name='yangdb'
11>          set cluster_database='FALSE'
12>          set audit_file_dest='/opt/oracle/admin/yangdb/adump'
13>          set DIAGNOSTIC_DEST='/opt/oracle'
14>          set db_create_file_dest='/opt/oracle/oradata/yangdb'
15>          set db_recovery_file_dest='/opt/oracle/flash_recovery_area'
16>          set control_files='/opt/oracle/oradata/yangdb/control01.ctl','/opt/oracle/oradata/yangdb/control02.ctl','/opt/oracle/oradata/yangdb/control03.ctl'
17>          set undo_tablespace='UNDOTBS1'
18>          set service_names='yangdb'
19>          set standby_file_management='AUTO'
20>          set log_archive_config='DG_CONFIG=(rac,yangdb,alifpre)'
21>          set log_archive_dest_1='LOCATION=/opt/oracle/yangdb_arch'
22>          set log_archive_dest_2='service=rac ARCH ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=rac'
23>          set log_archive_dest_state_1='enable'
24>          set log_archive_dest_state_2='enable'
25>          set log_archive_format='yangdb_%t_%s_%r.log'
26>          set remote_login_passwordfile='exclusive'
27>          set LOG_FILE_NAME_CONVERT='+DATA1/rac/onlinelog','/opt/oracle/oradata/yangdb','+DATA2/rac/onlinelog','/opt/oracle/oradata/yangdb'
28>          set DB_FILE_NAME_CONVERT='+DATA2/rac/datafile','/opt/oracle/oradata/yangdb','+DATA2','/opt/oracle/oradata/yangdb'
29>          set remote_listener=''
30>          set fal_client='yangdb'
31>          set fal_server='rac' 
32>          NOFILENAMECHECK;
33>     sql channel c1 "alter system archive log current";
34>  }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=48 instance=rac1 device type=DISK
allocated channel: c2
channel c2: SID=52 instance=rac1 device type=DISK
allocated channel: s1
channel s1: SID=19 device type=DISK
allocated channel: s2
channel s2: SID=20 device type=DISK
sql statement: alter system archive log current
Starting Duplicate Db at 15-SEP-11
contents of Memory Script.:
{
   backup as copy reuse
   targetfile  '/opt/rac/oracle/11.2.0/db/dbs/orapwrac2' auxiliary format 
 '/opt/oracle/11.2.0/alifpre/dbs/orapwyangdb'   targetfile 
 '+DATA2/rac/spfilerac.ora' auxiliary format 
 '/opt/oracle/11.2.0/alifpre/dbs/spfileyangdb.ora'   ;
   sql clone "alter system set spfile= ''/opt/oracle/11.2.0/alifpre/dbs/spfileyangdb.ora''";
}
executing Memory Script
Starting backup at 15-SEP-11
Finished backup at 15-SEP-11
sql statement: alter system set spfile= ''/opt/oracle/11.2.0/alifpre/dbs/spfileyangdb.ora''
contents of Memory Script.:
{
   sql clone "alter system set  db_name =  ''rac'' comment='''' scope=spfile";
   sql clone "alter system set  db_unique_name = ''yangdb'' comment='''' scope=spfile";
   sql clone "alter system set  cluster_database = FALSE comment='''' scope=spfile";
   sql clone "alter system set  audit_file_dest = ''/opt/oracle/admin/yangdb/adump'' comment='''' scope=spfile";
   sql clone "alter system set  DIAGNOSTIC_DEST = ''/opt/oracle'' comment= '''' scope=spfile";
   sql clone "alter system set  db_create_file_dest = ''/opt/oracle/oradata/yangdb'' comment='''' scope=spfile";
   sql clone "alter system set  db_recovery_file_dest = ''/opt/oracle/flash_recovery_area'' comment= '''' scope=spfile";
   sql clone "alter system set  control_files =''/opt/oracle/oradata/yangdb/control01.ctl'', ''/opt/oracle/oradata/yangdb/control02.ctl'', ''/opt/oracle/oradata/yangdb/control03.ctl'' comment= '''' scope=spfile";
   sql clone "alter system set  undo_tablespace=''UNDOTBS1'' comment='''' scope=spfile";
   sql clone "alter system set  service_names =''yangdb'' comment='''' scope=spfile";
   sql clone "alter system set  standby_file_management =''AUTO'' comment='''' scope=spfile";
   sql clone "alter system set  log_archive_config =''DG_CONFIG=(rac,yangdb,alifpre)'' comment='''' scope=spfile";
   sql clone "alter system set  log_archive_dest_1 =''LOCATION=/opt/oracle/yangdb_arch'' comment='''' scope=spfile";
   sql clone "alter system set  log_archive_dest_2 =''service=rac ARCH ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=rac'' comment='''' scope=spfile";
   sql clone "alter system set  log_archive_dest_state_1 =''enable'' comment='''' scope=spfile";
   sql clone "alter system set  log_archive_dest_state_2 =''enable'' comment='''' scope=spfile";
   sql clone "alter system set  log_archive_format =''yangdb_%t_%s_%r.log'' comment='''' scope=spfile";
   sql clone "alter system set  remote_login_passwordfile = ''exclusive'' comment='''' scope=spfile";
   sql clone "alter system set  LOG_FILE_NAME_CONVERT =''+DATA1/rac/onlinelog'', ''/opt/oracle/oradata/yangdb'', ''+DATA2/rac/onlinelog'', ''/opt/oracle/oradata/yangdb'' comment='''' scope=spfile";
   sql clone "alter system set  db_file_name_convert =''+DATA2/rac/datafile'', ''/opt/oracle/oradata/yangdb'', ''+DATA2'', ''/opt/oracle/oradata/yangdb'' comment='''' scope=spfile";
   sql clone "alter system set  remote_listener = '''' comment='''' scope=spfile";
   sql clone "alter system set  fal_client = ''yangdb'' comment='''' scope=spfile";
   sql clone "alter system set  fal_server = ''rac'' comment='''' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script
sql statement: alter system set  db_name =  ''rac'' comment= '''' scope=spfile
sql statement: alter system set  db_unique_name =  ''yangdb'' comment= '''' scope=spfile
sql statement: alter system set  cluster_database =  FALSE comment= '''' scope=spfile
sql statement: alter system set  audit_file_dest =  ''/opt/oracle/admin/yangdb/adump'' comment= '''' scope=spfile
sql statement: alter system set  DIAGNOSTIC_DEST =  ''/opt/oracle'' comment= '''' scope=spfile
sql statement: alter system set  db_create_file_dest =  ''/opt/oracle/oradata/yangdb'' comment= '''' scope=spfile
sql statement: alter system set  db_recovery_file_dest =  ''/opt/oracle/flash_recovery_area'' comment= '''' scope=spfile
sql statement: alter system set  control_files =  ''/opt/oracle/oradata/yangdb/control01.ctl'', ''/opt/oracle/oradata/yangdb/control02.ctl'', ''/opt/oracle/oradata/yangdb/control03.ctl'' comment= '''' scope=spfile
sql statement: alter system set  undo_tablespace =  ''UNDOTBS1'' comment= '''' scope=spfile
sql statement: alter system set  service_names =  ''yangdb'' comment= '''' scope=spfile
sql statement: alter system set  standby_file_management =  ''AUTO'' comment= '''' scope=spfile
sql statement: alter system set  log_archive_config =  ''DG_CONFIG=(rac,yangdb,alifpre)'' comment= '''' scope=spfile
sql statement: alter system set  log_archive_dest_1 =  ''LOCATION=/opt/oracle/yangdb_arch'' comment= '''' scope=spfile
sql statement: alter system set  log_archive_dest_2 =  ''service=rac ARCH ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=rac'' comment= '''' scope=spfile
sql statement: alter system set  log_archive_dest_state_1 =  ''enable'' comment= '''' scope=spfile
sql statement: alter system set  log_archive_dest_state_2 =  ''enable'' comment= '''' scope=spfile
sql statement: alter system set  log_archive_format =  ''yangdb_%t_%s_%r.log'' comment= '''' scope=spfile
sql statement: alter system set  remote_login_passwordfile =  ''exclusive'' comment= '''' scope=spfile
sql statement: alter system set  LOG_FILE_NAME_CONVERT =  ''+DATA1/rac/onlinelog'', ''/opt/oracle/oradata/yangdb'', ''+DATA2/rac/onlinelog'', ''/opt/oracle/oradata/yangdb'' comment= '''' scope=spfile
sql statement: alter system set  db_file_name_convert =  ''+DATA2/rac/datafile'', ''/opt/oracle/oradata/yangdb'', ''+DATA2'', ''/opt/oracle/oradata/yangdb'' comment= '''' scope=spfile
sql statement: alter system set  remote_listener =  '''' comment= '''' scope=spfile
sql statement: alter system set  fal_client =  ''yangdb'' comment= '''' scope=spfile
sql statement: alter system set  fal_server =  ''rac'' comment= '''' scope=spfile
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    1469792256 bytes

Fixed Size                     2213456 bytes
Variable Size                872417712 bytes
Database Buffers             587202560 bytes
Redo Buffers                   7958528 bytes
allocated channel: s1
channel s1: SID=19 device type=DISK
allocated channel: s2
channel s2: SID=20 device type=DISK

contents of Memory Script.:
{
   backup as copy current controlfile for standby auxiliary format  '/opt/oracle/oradata/yangdb/control01.ctl';
   restore clone controlfile to  '/opt/oracle/oradata/yangdb/control02.ctl' from 
 '/opt/oracle/oradata/yangdb/control01.ctl';
   restore clone controlfile to  '/opt/oracle/oradata/yangdb/control03.ctl' from 
 '/opt/oracle/oradata/yangdb/control01.ctl';
}
executing Memory Script
Starting backup at 15-SEP-11
channel c1: starting datafile copy
copying standby control file
output file name=/opt/rac/oracle/11.2.0/db/dbs/snapcf_rac1.f tag=TAG20110915T154731 RECID=1 STAMP=761932052
channel c1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 15-SEP-11
Starting restore at 15-SEP-11
channel s2: skipped, AUTOBACKUP already found
channel s1: copied control file copy
Finished restore at 15-SEP-11
Starting restore at 15-SEP-11
channel s2: skipped, AUTOBACKUP already found
channel s1: copied control file copy
Finished restore at 15-SEP-11

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 "/opt/oracle/oradata/yangdb/rac/tempfile/temp.268.761930967";
   switch clone tempfile all;
   set newname for datafile  1 to "/opt/oracle/oradata/yangdb/system.261.761930837";
   set newname for datafile  2 to "/opt/oracle/oradata/yangdb/sysaux.265.761930837";
   set newname for datafile  3 to "/opt/oracle/oradata/yangdb/undotbs1.264.761930837";
   set newname for datafile  4 to "/opt/oracle/oradata/yangdb/users.263.761930837";
   set newname for datafile  5 to "/opt/oracle/oradata/yangdb/undotbs2.269.761931099";
   backup as copy reuse
   datafile  1 auxiliary format "/opt/oracle/oradata/yangdb/system.261.761930837"   
   datafile  2 auxiliary format "/opt/oracle/oradata/yangdb/sysaux.265.761930837"   
   datafile  3 auxiliary format "/opt/oracle/oradata/yangdb/undotbs1.264.761930837"   
   datafile  4 auxiliary format "/opt/oracle/oradata/yangdb/users.263.761930837"   
   datafile  5 auxiliary format "/opt/oracle/oradata/yangdb/undotbs2.269.761931099";
   sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /opt/oracle/oradata/yangdb/rac/tempfile/temp.268.761930967 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 15-SEP-11
channel c1: starting datafile copy
input datafile file number=00001 name=+DATA2/rac/datafile/system.261.761930837
channel c2: starting datafile copy
input datafile file number=00002 name=+DATA2/rac/datafile/sysaux.265.761930837
output file name=/opt/oracle/oradata/yangdb/sysaux.265.761930837 tag=TAG20110915T154757
channel c2: datafile copy complete, elapsed time: 00:00:25
channel c2: starting datafile copy
input datafile file number=00003 name=+DATA2/rac/datafile/undotbs1.264.761930837
output file name=/opt/oracle/oradata/yangdb/system.261.761930837 tag=TAG20110915T154757
channel c1: datafile copy complete, elapsed time: 00:00:33
channel c1: starting datafile copy
input datafile file number=00005 name=+DATA2/rac/datafile/undotbs2.269.761931099
output file name=/opt/oracle/oradata/yangdb/undotbs1.264.761930837 tag=TAG20110915T154757
channel c2: datafile copy complete, elapsed time: 00:00:07
channel c2: starting datafile copy
input datafile file number=00004 name=+DATA2/rac/datafile/users.263.761930837
output file name=/opt/oracle/oradata/yangdb/undotbs2.269.761931099 tag=TAG20110915T154757
channel c1: datafile copy complete, elapsed time: 00:00:01
output file name=/opt/oracle/oradata/yangdb/users.263.761930837 tag=TAG20110915T154757
channel c2: datafile copy complete, elapsed time: 00:00:01
Finished backup at 15-SEP-11
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=1 STAMP=761932121 file name=/opt/oracle/oradata/yangdb/system.261.761930837
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=761932121 file name=/opt/oracle/oradata/yangdb/sysaux.265.761930837
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=761932121 file name=/opt/oracle/oradata/yangdb/undotbs1.264.761930837
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=761932121 file name=/opt/oracle/oradata/yangdb/users.263.761930837
datafile 5 switched to datafile copy
input datafile copy RECID=5 STAMP=761932121 file name=/opt/oracle/oradata/yangdb/undotbs2.269.761931099
Finished Duplicate Db at 15-SEP-11
sql statement: alter system archive log current
released channel: c1
released channel: c2
released channel: s1
released channel: s2
RMAN> exit


Recovery Manager complete.
oracle@rac1:/home/oracle>
文章标签：
服务网格
数据库备份
关系型数据库
Oracle
SQL
关键词：
RAC ASM
rac服务网格
RAC dataguard
dataguard服务网格
RAC creating standby asm primary
北在南方
目录
相关文章
snowofsummer
|
6月前
|
存储 Oracle 关系型数据库
RAC创建ASM磁盘组时配置多路径和UDEV
RAC创建ASM磁盘组时配置多路径和UDEV
snowofsummer
1398 7
姚远OracleACE
RAC 增加4块 asm 磁盘
增加磁盘之前的asm状态
姚远OracleACE
98 0
持续高温
|
Oracle 关系型数据库 数据库
RAC到单机搭建DataGuard
一、环境信息 1、服务器：Cetnos 7.22、数据库版本：11.2.0.43、RAC -> 单机 二、环境准备      目标是搭建RAC到单机的Activity DataGuard，首先RAC环境是准备完善的，接下来需要搭建一个单机环境。
持续高温
1976 0
技术小美
|
SQL Oracle 关系型数据库
rac ASM下最简单归档开启/关闭方法
技术小美
947 0
技术小美
|
存储 Linux 虚拟化
LINUX 11G RAC ASM磁盘组在线增加磁盘扩容
技术小美
1564 0
技术小美
11g RAC日志体系（cluster,database,asm,scan日志，ADRCI工具的使用）
技术小美
1218 0
snowofsummer
|
6月前
|
Oracle 关系型数据库
oracle asm 磁盘显示offline
oracle asm 磁盘显示offline
snowofsummer
328 2
1436047922066202
|
29天前
|
存储 Oracle 关系型数据库
数据库数据恢复—Oracle ASM磁盘组故障数据恢复案例
Oracle数据库数据恢复环境&故障： Oracle ASM磁盘组由4块磁盘组成。Oracle ASM磁盘组掉线 ，ASM实例不能mount。 Oracle数据库故障分析&恢复方案： 数据库数据恢复工程师对组成ASM磁盘组的磁盘进行分析。对ASM元数据进行分析发现ASM存储元数据损坏，导致磁盘组无法挂载。
1436047922066202
53 1
1436047922066202
|
6月前
|
存储 Oracle 关系型数据库
【数据库数据恢复】Oracle数据库ASM磁盘组掉线的数据恢复案例
oracle数据库ASM磁盘组掉线，ASM实例不能挂载。数据库管理员尝试修复数据库，但是没有成功。
1436047922066202
161 1
【数据库数据恢复】Oracle数据库ASM磁盘组掉线的数据恢复案例
小麦苗
|
SQL Oracle 关系型数据库
Oracle ASM磁盘和磁盘组的常用SQL语句
Oracle ASM磁盘和磁盘组的常用SQL语句
小麦苗
284 0

热门文章

最新文章

  • 1
    oracle 11g RAC 安装前准备脚本
  • 2
    【OGG】RAC环境下配置OGG单向同步 (四)
  • 3
    RAC5——11gR2以后GI进程的变化
  • 4
    使用RMAN迁移单库到RAC
  • 5
    12c rac 实例无法启动之磁盘组空间耗尽
  • 6
    RAC5——11gR2以后GI进程的变化
  • 7
    RAC环境中threads变更后如何确保goldengate继续正常复制
  • 8
    牛刀小试Oracle之ORACLE 11GR2 RAC安装配置--先决配置阶段(一）
  • 9
    RAC一节点重启时CSSD日志（加黑处是表明踢出）
  • 10
    Oracle 10g RAC过段时间会出现如下ALTER.LOG，什么原因
  • 1
    阿里云服务网格ASM多集群实践（二）：高效按需的应用多环境部署与全链路灰度发布
    85
  • 2
    云原生架构的演进：从容器化到服务网格
    48
  • 3
    服务网格 ASM 负载均衡算法全面解析
    69
  • 4
    使用ASM为一个类增加属性工具类
    53
  • 5
    使用ASM动态生成类的拦截代理类
    59
  • 6
    使用ASM动态创建接口实现类
    36
  • 7
    ASM 框架：字节码操作的常见用法（生成类，修改类,方法插桩，方法注入）
    96
  • 8
    ASM字节码操纵框架实现AOP
    51
  • 9
    Android 进阶——代码插桩必知必会&ASM7字节码操作
    245
  • 10
    ASM字节码插桩实现点击防抖
    47

    • 相关课程

    更多
  • 深度解读服务网格的未来
  • Nacos 服务网格生态
  • 服务网格技术最佳实践

    • 相关电子书

    更多
  • 基于英特尔®架构的阿里云服务网格ASM技术加速应用服务加密通
  • 阿里云总监课第五期第四节：从容器到云原生–服务网格
  • INTEGRATING OFFLINE AND ONLINE
    • 下一篇
    无影云桌面