oracle11g ora 29927,oracle 11g 从+DATA迁移到+newdata ASM 磁盘组迁移

最新推荐文章于 2022-07-09 19:01:12 发布
最新推荐文章于 2022-07-09 19:01:12 发布
阅读量127 收藏
点赞数
文章标签： oracle11g ora 29927

从+DATA迁移到+newdata磁盘组

---归档模式：

1.利用copy备份数据库

rman>

backup as copy database format '+DG1'

2.待备份完，启动到mount状态(启动第一节点数据库到mount,其它节点数据库实例关闭)

sql> shutdown immediate

sql> startup mount;

P750a:/home/oracle$export ORACLE_SID=lixora1

P750a:/home/oracle$rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Dec 2 23:58:55 2016

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

connected to target database: lixora (DBID=2736577994,not open)

RMAN>

switch database to copy;

using target database control file instead of recovery catalog

datafile 1 switched to datafile copy "+NEWDATA/lixora/datafile/system.305.929576161"

datafile 2 switched to datafile copy "+NEWDATA/lixora/datafile/sysaux.306.929576161"

datafile 3 switched to datafile copy "+NEWDATA/lixora/datafile/undotbs1.257.929568027"

datafile 4 switched to datafile copy "+NEWDATA/lixora/datafile/undotbs2.256.929568027"

datafile 5 switched to datafile copy "+NEWDATA/lixora/datafile/users.258.929568027"

datafile 6 switched to datafile copy "+NEWDATA/lixora/datafile/users.259.929568027"

datafile 7 switched to datafile copy "+NEWDATA/lixora/datafile/users.260.929568783"

datafile 8 switched to datafile copy "+NEWDATA/lixora/datafile/users.261.929568783"

datafile 9 switched to datafile copy "+NEWDATA/lixora/datafile/users.262.929568783"

datafile 10 switched to datafile copy "+NEWDATA/lixora/datafile/users.263.929568783"

datafile 11 switched to datafile copy "+NEWDATA/lixora/datafile/users.264.929569509"

datafile 12 switched to datafile copy "+NEWDATA/lixora/datafile/users.265.929569509"

datafile 13 switched to datafile copy "+NEWDATA/lixora/datafile/users.266.929569513"

datafile 14 switched to datafile copy "+NEWDATA/lixora/datafile/users.267.929569515"

datafile 15 switched to datafile copy "+NEWDATA/lixora/datafile/users.268.929570251"

datafile 16 switched to datafile copy "+NEWDATA/lixora/datafile/users.269.929570251"

datafile 17 switched to datafile copy "+NEWDATA/lixora/datafile/users.270.929570251"

datafile 18 switched to datafile copy "+NEWDATA/lixora/datafile/users.271.929570251"

datafile 19 switched to datafile copy "+NEWDATA/lixora/datafile/users.272.929571027"

datafile 20 switched to datafile copy "+NEWDATA/lixora/datafile/users01.273.929571027"

datafile 21 switched to datafile copy "+NEWDATA/lixora/datafile/users01.274.929571027"

datafile 22 switched to datafile copy "+NEWDATA/lixora/datafile/users01.275.929571031"

datafile 23 switched to datafile copy "+NEWDATA/lixora/datafile/users01.276.929571837"

datafile 24 switched to datafile copy "+NEWDATA/lixora/datafile/users02.277.929571837"

datafile 25 switched to datafile copy "+NEWDATA/lixora/datafile/users02.278.929571837"

datafile 26 switched to datafile copy "+NEWDATA/lixora/datafile/users02.279.929571837"

datafile 27 switched to datafile copy "+NEWDATA/lixora/datafile/users02.280.929572663"

datafile 28 switched to datafile copy "+NEWDATA/lixora/datafile/users03.297.929575401"

datafile 29 switched to datafile copy "+NEWDATA/lixora/datafile/users03.298.929575401"

datafile 30 switched to datafile copy "+NEWDATA/lixora/datafile/users03.299.929575401"

datafile 31 switched to datafile copy "+NEWDATA/lixora/datafile/users03.300.929575787"

datafile 32 switched to datafile copy "+NEWDATA/lixora/datafile/users04.288.929574281"

datafile 33 switched to datafile copy "+NEWDATA/lixora/datafile/users04.289.929574293"

datafile 34 switched to datafile copy "+NEWDATA/lixora/datafile/users04.290.929574293"

datafile 35 switched to datafile copy "+NEWDATA/lixora/datafile/users04.291.929574293"

datafile 36 switched to datafile copy "+NEWDATA/lixora/datafile/users05.301.929575787"

datafile 37 switched to datafile copy "+NEWDATA/lixora/datafile/users05.302.929575789"

datafile 38 switched to datafile copy "+NEWDATA/lixora/datafile/users05.303.929575867"

datafile 39 switched to datafile copy "+NEWDATA/lixora/datafile/users05.304.929576161"

datafile 40 switched to datafile copy "+NEWDATA/lixora/datafile/users06.311.929576269"

datafile 41 switched to datafile copy "+NEWDATA/lixora/datafile/users06.312.929576271"

datafile 42 switched to datafile copy "+NEWDATA/lixora/datafile/users06.313.929576275"

datafile 43 switched to datafile copy "+NEWDATA/lixora/datafile/users06.314.929576275"

datafile 44 switched to datafile copy "+NEWDATA/lixora/datafile/users07.307.929576219"

datafile 45 switched to datafile copy "+NEWDATA/lixora/datafile/users07.308.929576237"

datafile 46 switched to datafile copy "+NEWDATA/lixora/datafile/users07.309.929576257"

datafile 47 switched to datafile copy "+NEWDATA/lixora/datafile/users07.310.929576269"

datafile 48 switched to datafile copy "+NEWDATA/lixora/datafile/popdata.281.929572663"

datafile 49 switched to datafile copy "+NEWDATA/lixora/datafile/popdata.282.929572663"

datafile 50 switched to datafile copy "+NEWDATA/lixora/datafile/users.292.929574853"

datafile 51 switched to datafile copy "+NEWDATA/lixora/datafile/users.293.929574855"

datafile 52 switched to datafile copy "+NEWDATA/lixora/datafile/users.294.929574855"

datafile 53 switched to datafile copy "+NEWDATA/lixora/datafile/users.295.929574855"

datafile 54 switched to datafile copy "+NEWDATA/lixora/datafile/users.283.929572663"

datafile 55 switched to datafile copy "+NEWDATA/lixora/datafile/users.284.929573479"

datafile 56 switched to datafile copy "+NEWDATA/lixora/datafile/users.285.929573479"

datafile 57 switched to datafile copy "+NEWDATA/lixora/datafile/users.286.929573481"

datafile 58 switched to datafile copy "+NEWDATA/lixora/datafile/users.287.929573481"

datafile 64 switched to datafile copy "+NEWDATA/lixora/datafile/zcf6.296.929575401"

---恢复数据库，打开数据库

RMAN>

run

{

recover database;

alter database open;

}

Starting recover at 2016-12-03 00:00:05

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=3902 instance=lixora1 device type=DISK

starting media recovery

archived log for thread 1 with sequence 20885 is already on disk as file +ARCHDG/lixora/archivelog/2016_12_02/thread_1_seq_20885.799.929572247

archived log for thread 1 with sequence 20886 is already on disk as file +ARCHDG/lixora/archivelog/2016_12_02/thread_1_seq_20886.735.929574767

archived log for thread 1 with sequence 20887 is already on disk as file +ARCHDG/lixora/archivelog/2016_12_02/thread_1_seq_20887.822.929576417

archived log for thread 1 with sequence 20888 is already on disk as file +ARCHDG/lixora/archivelog/2016_12_02/thread_1_seq_20888.812.929576723

archived log for thread 2 with sequence 12639 is already on disk as file +ARCHDG/lixora/archivelog/2016_12_02/thread_2_seq_12639.1427.929576341

archived log for thread 2 with sequence 12640 is already on disk as file +ARCHDG/lixora/archivelog/2016_12_02/thread_2_seq_12640.888.929577207

archived log file name=+ARCHDG/lixora/archivelog/2016_12_02/thread_1_seq_20885.799.929572247 thread=1 sequence=20885

archived log file name=+ARCHDG/lixora/archivelog/2016_12_02/thread_1_seq_20886.735.929574767 thread=1 sequence=20886

media recovery complete,elapsed time: 00:02:24

Finished recover at 2016-12-03 00:02:41

database opened

RMAN>

----结果确认：

select file_name from dba_data_files;

后续要做的事情：

在新dg 上创建temp 文件；redo log 切换到新dg；spfile 位置dg上的位置调整；

总结

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。

网红教父
关注
oracle11g ora 29927,listagg函数 ORA-01489 result of string concatenation is too long的解决办法 【博森瑞】...
weixin_32018297的博客
04-05 1547
listagg函数 ORA-01489: result of string concatenation is too long的解决办法概述listagg 函数是Oracle 11g推出的一个分组函数,可以将字符串按分组连接起来.SQL> select deptno ,listagg(ename,'->') within group ( order by ename)2 from sc...
oracle asm空间利用率,ASM磁盘组空间不足-ORA-15041：DISGROUP DATA space exhausted （生产库案例）...
weixin_35923682的博客
04-07 574
ASM磁盘组空间不足--ORA-15041：DISGROUP DATA space exhausted (生产库案例)原创作品，出自 “深蓝的blog” 博客，深蓝的blog：http://blog.csdn.net/huangyanlong/article/details/47277715近日,处理了一个关于ASM磁盘组空间不足引起的问题。简单记录如下：一、问题的反馈驻地工程师的反馈：驻地工程师...
oracle11g ora 29927,oracle报错（ORA-00600）问题处理
weixin_29432775的博客
04-05 337
告警日志里这两天一直显示这个错误：ORA-00600:internalerrorcode,arguments:[kcblasm_1],[103],[],[],[],[],[],[]TueAug1209:20:17CST2014Errorsinfile/u01/app/oracle/admin/orcl/udump/orcl_ora_29974.trc:ORA-00600:internalerror...
oracle11g ora 29927,Oracle11gR2使用RMANDuplicate复制数据库
weixin_39793564的博客
04-05 126
四、安装软件并创建数据库./runInstaller -silent -debug -force -responseFile /home/oracle/database/response/db_install.rspdbca -silent -responsefile /home/oracle/database/response/dbca.rsp五、开启归档SQL> alter system...
oracle11g ora 29927,【案例】Oracle内存泄漏 进行10046跟踪分析07445导致数据库宕机
weixin_42361733的博客
04-05 471
天萃荷净在一次ORA-7445导致oracle数据库down掉故障分析中,发现sql因某种原因导致大量的sql area中很多内存泄露,最终导致数据库down掉.通过实验找出类此奇怪SQL.SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB)opt_param('parallel_exec...
oracle11g ora 29927,ORA-21779: duration not active问题解决方法
weixin_42512474的博客
04-05 249
用户告知一个RAC环境数据库在日志中产生大量ORA-21799错误信息，alert日志部分截取如下：Mon Jan 06 10:27:24 2014Errors in file d:\Oracle\product\10.2.0\admin\orcl\bdump\orcl1_smon_22688.trc:ORA-21779: duration not activeORA-06512: at line...
oracle asm 日志,oracle 11g RAC 下ASM实例的alert日志告诉我们什么
weixin_42369343的博客
04-03 1977
首先我们必须知道ASM实例的alert日志位置，ASM实例的alert日志默认路径为：/u01/app/grid/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log，在该日志里面告诉了我们非常重要的信息，以下几个实际应用场景。1、ASM的alert日志作为ASM实例的晴雨表，向我们展示了ASM实例的“健康状态”。2、ASM的alert日志告诉了我们创建磁盘组时候的操...
ASM实例+ASM数据库安装（Win8+Ora10）
05-22
- **注意事项**：在启动ASM实例时可能会遇到一些警告或错误，比如“ORA-15110: no diskgroups mounted”，这是因为还没有创建ASM磁盘组。 ##### 3.5 新建disk group - **操作步骤**：使用`create diskgroup`命令...
Oracle ASM + 11g R2 + Centos 6.5 安装
个人公众号：Alen的数据库学习笔记
12-09 2991
一 软件环境 VMware Workstation 12 ProCentOS-6.5-x86_64p13390677_112040_Linux-x86-64主机名称设置为strong.oracle.com，IP为192.168.1.115Xmanager Enterprise 5 二 主机设置 内存要求 安装独立服务器的Grid Infrastructure，内存至少是1.5G
RHEL6.3+Oracle11gR2+ASM+iSCSI+FreeNAS
Oracle Database
01-09 9286
从Oracle 11g开始，ASM(Automatic Storage Management)作为Grid Infrastructure的一部分，要想在Oracle数据库使用ASM，需要安装GridInfrastructure。而且从RHEL 6起，Oracle不再提供ASMlib的核心驱动，如果想使用ASM必须使用Oracle的Unbreakable Enterprise Kernel(UEK)
使用RMAN进行数据迁移
东城绝神
09-05 2344
使用RMAN进行数据迁移 一、分别在两个节点上修改spfile参数 SQL> alter system set db_create_file_dest='+DATA' scope=both ; System altered. SQL> alter system set db_recovery_file_dest='+RECOVERY' scope=both ; S
Oracle DB 使用RMAN将数据库移植到ASM存储区
aiduo1030的博客
04-03 109
1. 完全关闭数据库。 2. 关闭数据库并修改服务器参数文件，以使用OracleManaged Files (OMF)。 3. 编辑并执行以下RMAN 脚本： STARTUP NOMOUNT; RESTORE CONTROLFILE FROM '/u1/c1.ctl'; ALTER DATABASE MOUNT; BACKUP AS COPY DATABASE FORMAT...
oracle导出asm数据,Oracle使用RMAN将普通数据文件转成ASM
weixin_39781363的博客
04-13 115
1. 数据库启动至mountSQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startup mount2. RMAN备份数据文件RMAN> backup as copy database format '+data';Starting backup ...
Oracle数据库相关操作(20220709)
zhangbeizhen18的博客
07-09 2920
记录：283 场景：Oracle数据库相关操作。比如：创建用户，用户授权、查看对象、表、注释等；创建表空间和数据文件以及应用；创建序列以及应用；建表（普通表和分区表）以及应用，全局索引和局部索引应用、创建视图以及应用、创建同义词以及应用、创建Database Link以及应用、创建存储过程以及应用、创建包和包体管理存储过程以及应用、创建Job以及应用、表分析应用。......
catalog start with + switch database to copy的妙用
xiaoxiao520c的博客
09-01 2282
catalog start with + switch database to copy的妙用 环境：RHEL6.4 + Oracle 11.2.0.4 Primary RAC + Standby RAC 现象：从主库恢复控制文件之后，由于是OMF管理的方式，导致ASM上存储的数据文件名字和控制文件中的名字不一样。 我们来看看现象的具体情况： ASM上的数据文件信息： ASMCMD [+
使用switch database to copy快速复制数据库
w1346561235的博客
03-06 4190
1,  源库switch logfile，checkpoint，shutdown； 2,  源库startup restrict;shutdown immediate;startup mount; 3,  rman target / ;backup as copy database; 4,  新库restore spfile,  controlfile,   catalog 备份片,  st
rac进行image copy备份，以及异机单机switch to copy方式恢复
jiujiederoushan的博客
06-28 1114
集群rac1节点进行rman备份 集群rac1节点将spfile导出成可视化文件 将备份数据拷贝至单机环境，并chown -R将所有文件的拥有者改为oracle:oinstall，修改rac.ora修改前 修改后 以oracle用户身份创建对应目录，并复制控制文件到指定路径 oracle用户身份执行orapwd file=$ORACLE_HOME/dbs/orapw-zhangchen password=123456 force=yrman执行恢复....................
oracle 复制组删除,利用copy在ASM磁盘组之间迁移
weixin_42397141的博客
04-03 306
从+DISK迁移到+DG1磁盘组一.复制数据库文件到ASM磁盘组1.启动到mount状态(启动第一节点数据库到mount,其它节点数据库实例关闭)SQL> startup mount;2.利用copy备份数据库rman>backup as copy database format '+DG1'3.利用rman工具指定到新的路径RMAN> switch database to co...
oracle--rman备份纪要
jiujiederoushan的博客
11-12 3409
1、设置channel数量，增加备份/恢复传输速度。 2、设置最大坏块数，set maxcorrupt，避免少数坏块引起备份或恢复失败。 3、跳过只读数据块，backup指令加上skip readonly参数。 4、设置默认备份类型，默认为disk，可改为sbt，rman将顺序执行sbt库中函数。 ..................
Oracle 11g Data Guard 完整部署教程：从安装到配置详解
Oracle 11g Data Guard 是Oracle数据库的一项高可用性解决方案，它通过实时数据复制和恢复功能，确保数据库在发生故障时能够快速恢复，保障业务连续性。本指南详细介绍了如何在Oracle 11g环境下设置和配置Data Guard...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值