ITPub博客

首页 > Linux操作系统 > Linux操作系统 > standby 忘记创建逻辑磁盘造成的错误

standby 忘记创建逻辑磁盘造成的错误

原创 Linux操作系统 作者:wghxwl12 时间:2013-02-25 17:22:54 0 删除 编辑
数据库版本: oracle10g 10.2.0.1
操作系统:   IBM AIX
存储设备:   裸设备

--21号检查主库表空间不够,在裸设备加数据文件,主库创建后,忘记在standby库创建,发生如下错误,几天之后才发现,赶紧抓紧处理

--日志报错信息如下
Thu Feb 21 11:55:53 2013
RFS[13034]: No standby redo logfiles created
Thu Feb 21 11:57:23 2013
RFS[13034]: Archived Log: '/arch/arch8/2_43005_650002171.dbf'
RFS[13034]: No standby redo logfiles created
Thu Feb 21 11:57:25 2013
Media Recovery Log /arch/arch8/2_43005_650002171.dbf
Media Recovery Waiting for thread 1 sequence 23369 (in transit)
Thu Feb 21 11:58:37 2013
RFS[13034]: Archived Log: '/arch/arch8/1_23369_650002171.dbf'
Thu Feb 21 11:58:40 2013
Media Recovery Log /arch/arch8/1_23369_650002171.dbf
Thu Feb 21 11:59:09 2013
WARNING: File being created with same name as in Primary
Existing file may be overwritten
WARNING: You are creating datafile /dev/virindex21.
WARNING: Oracle recommends creating new datafiles on devices with zero offset. The command "/usr/sbin/mklv -y LVname -T O -w n -s n -r n VGname NumPPs" can be used. Please contact Oracle customer support for more details.
Thu Feb 21 11:59:32 2013
WARNING: You are creating/reusing datafile /dev/virindex21.
WARNING: Oracle recommends creating new datafiles on devices with zero offset. The command "/usr/sbin/mklv -y LVname -T O -w n -s n -r n VGname NumPPs" can be used. Please contact Oracle customer support for more details.
Recovery created file /dev/virindex21
Successfully added datafile 35 to media recovery
Datafile #35: '/dev/virindex21'
WARNING: File being created with same name as in Primary
Existing file may be overwritten
WARNING: You are creating datafile /dev/virosdb01.
WARNING: Oracle recommends creating new datafiles on devices with zero offset. The command "/usr/sbin/mklv -y LVname -T O -w n -s n -r n VGname NumPPs" can be used. Please contact Oracle customer support for more details.
Thu Feb 21 11:59:57 2013
WARNING: You are creating/reusing datafile /dev/virosdb01.
WARNING: Oracle recommends creating new datafiles on devices with zero offset. The command "/usr/sbin/mklv -y LVname -T O -w n -s n -r n VGname NumPPs" can be used. Please contact Oracle customer support for more details.
Recovery created file /dev/virosdb01
Successfully added datafile 36 to media recovery
Datafile #36: '/dev/virosdb01'
WARNING: File being created with same name as in Primary
Existing file may be overwritten
File #37 added to control file as 'UNNAMED00037'.
Originally created as:
'/dev/virbase06'
Recovery was unable to create the file as:
'/dev/virbase06'
Errors with log /arch/arch8/1_23369_650002171.dbf
MRP0: Background Media Recovery terminated with error 1274
Thu Feb 21 12:00:06 2013
Errors in file /db/oracle/admin/rz/bdump/virz1_mrp0_1404956.trc:
ORA-01274: Message 1274 not found; No message file for product=RDBMS, facility=ORA; arguments: [/dev/virbase06]
ORA-01119: Message 1119 not found; No message file for product=RDBMS, facility=ORA; arguments: [/dev/virbase06]
ORA-27040: Message 27040 not found; No message file for product=RDBMS, facility=ORA
IBM AIX RISC System/6000 Error: 13: Permission denied
Some recovered datafiles maybe left media fuzzy
Media recovery may continue but open resetlogs may fail
Thu Feb 21 12:00:09 2013
Errors in file /db/oracle/admin/rz/bdump/virz1_mrp0_1404956.trc:
ORA-01274: Message 1274 not found; No message file for product=RDBMS, facility=ORA; arguments: [/dev/virbase06]
ORA-01119: Message 1119 not found; No message file for product=RDBMS, facility=ORA; arguments: [/dev/virbase06]
ORA-27040: Message 27040 not found; No message file for product=RDBMS, facility=ORA
IBM AIX RISC System/6000 Error: 13: Permission denied
Thu Feb 21 12:00:09 2013
MRP0: Background Media Recovery process shutdown (rz1)
Thu Feb 21 12:49:04 2013
RFS[13035]: No standby redo logfiles created
Thu Feb 21 12:50:08 2013
RFS[13034]: No standby redo logfiles created
Thu Feb 21 12:50:24 2013
RFS[13034]: Archived Log: '/arch/arch8/1_23370_650002171.dbf'
Thu Feb 21 12:58:08 2013
RFS[13034]: No standby redo logfiles created
RFS[13034]: Archived Log: '/arch/arch8/1_23371_650002171.dbf'
Thu Feb 21 12:59:01 2013
RFS[13035]: Archived Log: '/arch/arch8/2_43006_650002171.dbf'
RFS[13035]: No standby redo logfiles created
Thu Feb 21 13:08:57 2013
RFS[13035]: Archived Log: '/arch/arch8/2_43007_650002171.dbf'
RFS[13035]: No standby redo logfiles created
Thu Feb 21 13:18:53 2013
RFS[13035]: Archived Log: '/arch/arch8/2_43008_650002171.dbf'
RFS[13035]: No standby redo logfiles created
Thu Feb 21 13:28:49 2013
RFS[13035]: Archived Log: '/arch/arch8/2_43009_650002171.dbf'
RFS[13035]: No standby redo logfiles created
Thu Feb 21 13:38:47 2013
RFS[13035]: Archived Log: '/arch/arch8/2_43010_650002171.dbf'
Thu Feb 21 15:39:26 2013
RFS[13035]: No standby redo logfiles created

--从错误信息可以看出,原来是在主库裸设备建立逻辑磁盘后,忘记在相应的备库建立同名的逻辑磁盘
--接下来在standby库建立了逻辑磁盘virbase06

--在standby库查询
sql>select name from v$datafile where name like '%UNNAMED00037%'
name
------
/db/oracle/product/10.2.0/db_1/dbs/UNNAMED00037

sql>

--先将standby的managed_standby参数修改成manual,不然不能手工创建修改数据库对象
sql>alter system set managed_standby='manual';


sql>alter database create datafile '/db/oracle/product/10.2.0/db_1/dbs/UNNAMED00037' as '/dev/virbase06';


sql>alter database recover managed standby database disconnect from session;

--执行完以上两条语句后看日志

alter database create datafile '/db/oracle/product/10.2.0/db_1/dbs/UNNAMED00037' as '/dev/virbase06'
Mon Feb 25 13:52:03 2013
WARNING: You are creating/reusing datafile /dev/virbase06.
WARNING: Oracle recommends creating new datafiles on devices with zero offset. The command "/usr/sbin/mklv -y LVname -T O -w n -s n -r n VGname NumPPs" can be used. Please contact Oracle customer support for more details.
Mon Feb 25 13:52:25 2013
WARNING: You are creating/reusing datafile /dev/virbase06.
WARNING: Oracle recommends creating new datafiles on devices with zero offset. The command "/usr/sbin/mklv -y LVname -T O -w n -s n -r n VGname NumPPs" can be used. Please contact Oracle customer support for more details.
Completed: alter database create datafile '/db/oracle/product/10.2.0/db_1/dbs/UNNAMED00037' as '/dev/virbase06'
Mon Feb 25 13:52:55 2013
ALTER DATABASE RECOVER  standby database  
Mon Feb 25 13:52:55 2013
Media Recovery Start
Mon Feb 25 13:52:55 2013
Managed Standby Recovery not using Real Time Apply
Mon Feb 25 13:52:55 2013
 parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER  standby database  ...
Mon Feb 25 13:53:17 2013
ALTER DATABASE RECOVER    LOGFILE 'auto;'  
Mon Feb 25 13:53:17 2013
Media Recovery Log auto;
Errors with log auto;
ORA-308 signalled during: ALTER DATABASE RECOVER    LOGFILE 'auto;'  ...
Mon Feb 25 13:53:40 2013
ALTER DATABASE RECOVER    CONTINUE DEFAULT  
Mon Feb 25 13:53:40 2013
Media Recovery Log /arch/arch9/1_23369_650002171.dbf
Errors with log /arch/arch9/1_23369_650002171.dbf
ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
Mon Feb 25 13:53:40 2013
ALTER DATABASE RECOVER    CONTINUE DEFAULT  
Mon Feb 25 13:53:40 2013
Media Recovery Log /arch/arch9/1_23369_650002171.dbf
Errors with log /arch/arch9/1_23369_650002171.dbf
ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
Mon Feb 25 13:53:40 2013
ALTER DATABASE RECOVER CANCEL 
ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL ...
Mon Feb 25 13:54:32 2013
alter database recover managed standby database disconnect from session
Mon Feb 25 13:54:32 2013
Attempt to start background Managed Standby Recovery process (rz1)
MRP0 started with pid=27, OS id=532650
Mon Feb 25 13:54:33 2013
MRP0: Background Managed Standby Recovery process started (rz1)
Mon Feb 25 13:54:38 2013
Managed Standby Recovery not using Real Time Apply
Mon Feb 25 13:54:38 2013
Media Recovery Log /arch/arch8/1_23369_650002171.dbf
Media Recovery Log /arch/arch8/2_43005_650002171.dbf
Mon Feb 25 13:54:38 2013
Completed: alter database recover managed standby database disconnect from session
Mon Feb 25 13:54:41 2013
Media Recovery Log /arch/arch8/1_23370_650002171.dbf
Media Recovery Log /arch/arch8/2_43006_650002171.dbf
Mon Feb 25 13:55:06 2013
Media Recovery Log /arch/arch8/2_43007_650002171.dbf

--通过日志可以看出,目前执行是正确的,将standby参数standby_file_management修改成'auto'

sql>ALTER SYSTEM SET standby_file_management='auto' SCOPE=BOTH;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/187805/viewspace-754692/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-14

  • 博文量
    155
  • 访问量
    565140