Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

40

积分

0

好友

14

主题
1#
发表于 2012-4-13 23:49:02 | 查看: 4412| 回复: 1
Using STANDBY_ARCHIVE_DEST parameter default value as /archive
Fri Apr 13 13:15:48 2012
alter database register logfile  '/archive/1_81911_704866110.dbf'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Register archivelog /archive/1_81911_704866110.dbf already exists
ORA-16089 signalled during: alter database register logfile  '/archive/1_81911_704866110.dbf'...
Fri Apr 13 13:52:45 2012
alter database recover managed standby database cancel
ORA-16136 signalled during: alter database recover managed standby database cancel...
Fri Apr 13 13:53:14 2012
alter database recover managed standby database disconnect from session
Attempt to start background Managed Standby Recovery process (standby)
Fri Apr 13 13:53:14 2012
MRP0 started with pid=16, OS id=454944
MRP0: Background Managed Standby Recovery process started (standby)
Fast Parallel Media Recovery enabled
Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery terminated with error 1110
Errors in file /oracle/db/diag/rdbms/standby/standby/trace/standby_mrp0_454944.trc:
ORA-01110: data file 33: '/oradata/fgxt/rdb_fgjywtx53'
ORA-01122: database file 33 failed verification check
ORA-01110: data file 33: '/oradata/fgxt/rdb_fgjywtx53'
ORA-01205: not a data file - type number in header is 0
Errors in file /oracle/db/diag/rdbms/standby/standby/trace/standby_mrp0_454944.trc:
ORA-01110: data file 33: '/oradata/fgxt/rdb_fgjywtx53'
ORA-01122: database file 33 failed verification check
ORA-01110: data file 33: '/oradata/fgxt/rdb_fgjywtx53'
ORA-01205: not a data file - type number in header is 0
MRP0: Background Media Recovery process shutdown (standby)
Completed: alter database recover managed standby database disconnect from session
Fri Apr 13 14:01:00 2012
ALTER DATABASE CREATE DATAFILE '/oradata/fgxt/rdb_fgjywtx53'
ORA-1275 signalled during: ALTER DATABASE CREATE DATAFILE '/oradata/fgxt/rdb_fgjywtx53'...
Fri Apr 13 14:03:06 2012
alter database recover managed standby database cancel
ORA-16136 signalled during: alter database recover managed standby database cancel...
Fri Apr 13 14:03:21 2012
ALTER DATABASE CREATE DATAFILE '/oradata/fgxt/rdb_fgjywtx53'
ORA-1275 signalled during: ALTER DATABASE CREATE DATAFILE '/oradata/fgxt/rdb_fgjywtx53'...
Fri Apr 13 14:03:45 2012
ALTER SYSTEM SET standby_file_management='MANUAL' SCOPE=BOTH;
ALTER DATABASE CREATE DATAFILE '/oradata/fgxt/rdb_fgjywtx53'
2#
发表于 2012-4-14 20:47:18
请上传完整的alert.log 日志和 MRP进程的TRACE文件

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-15 13:04 , Processed in 0.052646 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569