Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3279122
  • 博文数量: 815
  • 博客积分: 12898
  • 博客等级: 上将
  • 技术积分: 7883
  • 用 户 组: 普通用户
  • 注册时间: 2006-12-25 09:57
文章分类

全部博文(815)

文章存档

2014年(1)

2011年(46)

2010年(192)

2009年(121)

2008年(70)

2007年(385)

分类: Oracle

2010-03-28 13:30:54

问题1:ORA-19527: physical standby redo log must be renamed
PRIMARY:

Error 12514 received logging on to the standby
Sun Mar 28 23:37:44 2010
Errors in file /opt/oracle/admin/ATYU30/bdump/ATYU30_arc4_5364.trc:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
FAL[server, ARC4]: Error 12514 creating remote archivelog file 'ATYU30STD'
FAL[server, ARC4]: FAL archive failed, see trace file.
Sun Mar 28 23:37:44 2010
Errors in file /opt/oracle/admin/ATYU30/bdump/ATYU30_arc4_5364.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Sun Mar 28 23:37:44 2010
ORACLE Instance ATYU30 - Archival Error. Archiver continuing.
Sun Mar 28 23:37:45 2010
Thread 1 advanced to log sequence 24
  Current log# 2 seq# 24 mem# 0: /opt/oracle/oradata/ATYU30/redo02.log


Standby:
Sun Mar 28 23:37:28 2010
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
Sun Mar 28 23:37:28 2010
Attempt to start background Managed Standby Recovery process (ATYU30)
MRP0 started with pid=21, OS id=3088
Sun Mar 28 23:37:29 2010
MRP0: Background Managed Standby Recovery process started (ATYU30)
Managed Standby Recovery starting Real Time Apply
Clearing online redo logfile 1 /opt/oracle/oradata/ATYU30/redo01.log
Clearing online log 1 of thread 1 sequence number 5
Sun Mar 28 23:37:34 2010
Errors in file /opt/oracle/admin/ATYU30/bdump/ATYU30_mrp0_3088.trc:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: '/opt/oracle/oradata/ATYU30/redo01.log'
Clearing online redo logfile 1 complete
Media Recovery Waiting for thread 1 sequence 4
Fetching gap sequence in thread 1, gap sequence 4-4
Sun Mar 28 23:37:35 2010
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
Sun Mar 28 23:38:42 2010
FAL[client]: Failed to request gap sequence
 GAP - thread 1 sequence 4-4
 DBID 2906083413 branch 714298841
FAL[client]: All defined FAL servers have been attempted.
-------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that is sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
-------------------------------------------------------------

配置*.log_file_name_convert 参数
*.log_file_name_convert='/opt/oracle/oradata/ATYU30/','/opt/oracle/oradata/ATYU30/'

问题2:

ARCH: Possible network disconnect with primary database
Sun Mar 28 23:57:00 2010
Error 12514 received logging on to the standby
Sun Mar 28 23:57:00 2010
Errors in file /opt/oracle/admin/TVMDB/bdump/tvmdb_arc0_6078.trc:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
FAL[server, ARC0]: Error 12514 creating remote archivelog file 'TVMDBSTD'
FAL[server, ARC0]: FAL archive failed, see trace file.
Sun Mar 28 23:57:00 2010
Errors in file /opt/oracle/admin/TVMDB/bdump/tvmdb_arc0_6078.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Sun Mar 28 23:57:00 2010
ORACLE Instance TVMDB - Archival Error. Archiver continuing.
Sun Mar 28 23:57:28 2010
FAL[server]: Fail to queue the whole FAL gap
 GAP - thread 1 sequence 4-4
 DBID 2906083413 branch 714298841
阅读(4454) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~