示例：alter tablespace aaa add datafile '+DATA' size 10G;最后生成数据文件：+DATA/数据库的名称/表空间名称/和随机字符串
物理DG恢复又一例，未采用增量备份
故障现象： 为了查看硬盘的型号，系统工程师对AIX小机进行了关机，重启后系统工程师lsdev -Cc disk查看硬盘状态OK了，告知系统已经恢复。可ORACLE启动报错，提示控制文件损坏。
incremental backup恢复归档GAP的DG的方法本文不再详述，可参照链接：http://yunlongzheng.blog.51cto.com/788996/717249 本文着重讲一次恢复过程中出现的错误的解决方法，给自己备忘，也给需要的人参考。
纯粹个人笔记：便于回忆学习
一、RAC启动关闭顺序 启动RAC顺序: 1 启动HA (建议两节点分别启动，重起机器第一次启动HA软件oracle会自动启动) 2 启动CRS (两节点都要执行) 3 启动instance 默认会跟着CRS一并启动，如果没有启动可以单独启动。 关闭RAC顺序: 1 关闭instance (详见第2节) 2 关闭CRS (两节点都要执行) 3 关闭HA软件 (如果没有必要可以不关
物理DG因为主库新建数据文件同步到从库后从库磁盘空间不足，报如下错误 Mon Feb 4 08:56:48 2013 Errors in file /u01/app/oracle/admin/port/bdump/port_mrp0_12243.trc: ORA-01111: name for data file 28 is unknown - rename to correct file ORA-01110: data file 28: '/u01/app/oracle/db/dbs/UNNAMED00028' ORA-01157: cannot identify/lock data file 28 - see DBWR trace file ORA-01111: name for data file 28 is unknown - rename to correct file ORA-01110: data file 28: '/u01/app/oracle/db/dbs/UNNAMED00028'
crs_register ora.<node>.LISTENER_<node>.lsnr.cap
故障现象：监听能正常启动，但两个实例均未能监听到 [oracle@L-DB-100-17 ~]$ lsnrctl status LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 07-1月 -2002 14:29:33 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.100.17)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.4.0 - P
现象： RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 01/12/2013 21:16:08 ORA-19870: error reading backup piece /u01/rmanbak/for18dg/standby_PORT_20130112_1fnv8622_1_1.bak ORA-19573: cannot obtain exclusive enqueue for datafile 26 RMAN> 原因：数据库处于OPEN状态 处理方法： shutdown immediate; startup m
故障现象： [oracle@L-DB-100-17 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on 星期六 1月 5 14:59:15 2002 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. ERROR: ORA-01031: insufficient privileges Enter user-name: ERROR: ORA-01017: invalid username/password; logon denied
故障现象： mount: oracle1:/u01/rmanbak/for18dg/ failed, reason given by server: Permission denied[root@L-DB-163-18 rmanbak]# mount -t nfs oracle1:/u01/rmanbak/for18dg/ /u01/rmanbak/for18dg/
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号
