问题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

阅读(3475) | 评论(0) | 转发(0) |