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

最新推荐文章于 2024-06-17 10:26:55 发布

cpqmpyvvo88762566

最新推荐文章于 2024-06-17 10:26:55 发布

阅读量150

点赞数

文章标签：数据库操作系统

数据库版本: 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.

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.

Thu Feb 21 11:59:57 2013

WARNING: You are creating/reusing datafile /dev/virosdb01.

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.

Mon Feb 25 13:52:25 2013

WARNING: You are creating/reusing datafile /dev/virbase06.

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/187805/viewspace-754692/

cpqmpyvvo88762566

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
standby 忘记创建逻辑磁盘造成的错误

数据库版本: oracle10g 10.2.0.1操作系统: IBM AIX存储设备: 裸设备--21号检查主库表空间不够，在裸设备加数据文件，主库创建后，忘记在standby库创建，发生如下错误，几天之后才发...
复制链接

扫一扫