问题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
阅读(4498) | 评论(0) | 转发(0) |