|
|
逻辑备库无法更新，不知道什么原因。求好心人指点一下
主库：
file:///C:\Users\Administrator\AppData\Roaming\Tencent\Users\779616723\QQ\WinTemp\RichOle\M1WMZK(BRH}AZ{V]~O]KUZ4.jpg
file:///C:\Users\Administrator\AppData\Roaming\Tencent\Users\779616723\QQ\WinTemp\RichOle\$PPBNES4}B62}{(RM%(TV`5.jpg
SQL> select name,database_role ,protection_mode,switchover_status from v$database ;
NAME DATABASE_ROLE
------------------ --------------------------------
PROTECTION_MODE
----------------------------------------
SWITCHOVER_STATUS
----------------------------------------
R5 PRIMARY
MAXIMUM PERFORMANCE
TO STANDBY
initr5.ora :
*.CONTROL_FILES='/home/oracle/arch/dg1/control01.ctl','/u01/app/oracle/fast_recovery_area/r5/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.DB_FILE_NAME_CONVERT='dg1','dg2'
*.DB_NAME='r5'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4322230272
*.DB_UNIQUE_NAME='dg1'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=r5XDB)'
*.fal_client='dg2'
*.FAL_SERVER='dg1'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(dg1,dg2)'
*.log_archive_dest_1='LOCATION=/home/oracle/arch
VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=dg1'
*.LOG_ARCHIVE_DEST_2='SERVICE=dg2 ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=dg2
MAX_FAILURE=3
REOPEN=5
NET_TIMEOUT=180'
*.log_archive_dest_3='LOCATION=/home/oracle/arch1
VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE)
DB_UNIQUE_NAME=dg1'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.log_archive_dest_state_3='ENABLE'
*.LOG_ARCHIVE_FORMAT='%t_%s_%r.arc'
*.LOG_FILE_NAME_CONVERT='/data/r5/dg1/redo01.log','/data/r5/dg2/redo01.log','/data/r5/dg1/redo02.log','/data/r5/dg2/redo02.log','/data/r5/dg1/redo03.log','/data/r5/dg2/redo03.log'
*.memory_target=415236096
*.open_cursors=300
*.processes=150
altert.log :
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Sun Nov 23 02:57:41 2014
QMNC started with pid=25, OS id=4839
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Sun Nov 23 02:57:44 2014
Thread 1 advanced to log sequence 253 (LGWR switch)
Current log# 2 seq# 253 mem# 0: /data/r5/dg1/redo02.log
Sun Nov 23 02:57:44 2014
Starting background process SMCO
Archived Log entry 541 added for thread 1 sequence 252 ID 0x8cf6978d dest 1:
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Sun Nov 23 02:57:44 2014
SMCO started with pid=26, OS id=4843
Completed: ALTER DATABASE OPEN
ARC3: Standby redo logfile selected for thread 1 sequence 252 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 253 for destination LOG_ARCHIVE_DEST_2
ARC0: Standby redo logfile selected for thread 1 sequence 251 for destination LOG_ARCHIVE_DEST_2
Sun Nov 23 02:57:46 2014
db_recovery_file_dest_size of 4122 MB is 26.74% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Sun Nov 23 02:57:46 2014
Starting background process CJQ0
Sun Nov 23 02:57:46 2014
CJQ0 started with pid=28, OS id=4871
备库：
SQL> SELECT db_unique_name,name,open_mode, database_role,switchover_status,guard_status,protection_mode FROM V$DATABASE ;
DB_UNIQUE_NAME NAME
------------------------------------------------------------ ------------------
OPEN_MODE DATABASE_ROLE
---------------------------------------- --------------------------------
SWITCHOVER_STATUS GUARD_STATUS
---------------------------------------- --------------
PROTECTION_MODE
----------------------------------------
dg2 LGR5
READ WRITE LOGICAL STANDBY
NOT ALLOWED ALL
MAXIMUM PERFORMANCE
initr5.ora:
*.CONTROL_FILES='/home/oracle/arch/dg2/control01.ctl','/u01/app/oracle/fast_recovery_area/r5/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.DB_NAME='r5'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4322230272
*.DB_UNIQUE_NAME='dg2'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=r5XDB)'
*.fal_client='dg2'
*.fal_server='dg1'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(dg1,dg2)'
*.LOG_ARCHIVE_DEST_1='LOCATION=/home/oracle/arch
VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=dg2'
*.LOG_ARCHIVE_DEST_2='SERVICE=dg1 ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=dg1
MAX_FAILURE=3
REOPEN=5
NET_TIMEOUT=180'
*.LOG_ARCHIVE_DEST_3='LOCATION=/home/oracle/arch2
VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE)
DB_UNIQUE_NAME=dg2'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_3='ENABLE'
*.LOG_ARCHIVE_FORMAT='%t_%s_%r.arc'
*.LOG_FILE_NAME_CONVERT='/data/r5/dg1/redo01.log','/data/r5/dg2/redo01.log','/data/r5/dg1/redo02.log','/data/r5/dg2/redo02.log','/data/r5/dg1/redo03.log','/data/r5/dg2/redo03.log'
*.memory_target=415236096
*.open_cursors=300
*.processes=150
allter.lg :
Sun Nov 23 02:57:49 2014
RFS[5]: Assigned to RFS process 7679
RFS[5]: Selected log 4 for thread 1 sequence 252 dbid -1930259324 branch 863920071
RFS[6]: Assigned to RFS process 7681
RFS[6]: Selected log 6 for thread 1 sequence 253 dbid -1930259324 branch 863920071
Sun Nov 23 02:57:50 2014
RFS[7]: Assigned to RFS process 7683
RFS[7]: Selected log 5 for thread 1 sequence 251 dbid -1930259324 branch 863920071
Sun Nov 23 02:57:50 2014
RFS LogMiner: Registered logfile [/home/oracle/arch2/1_252_863920071.arc] to LogMiner session id [1]
Sun Nov 23 02:57:50 2014
LOGMINER: Alternate logfile found. Transition to mining archived logfile for session 1 thread 1 sequence 251, /home/oracle/arch2/1_251_863920071.arc
Sun Nov 23 02:57:50 2014
RFS LogMiner: Registered logfile [/home/oracle/arch2/1_251_863920071.arc] to LogMiner session id [1]
LOGMINER: End mining logfile for session 1 thread 1 sequence 251, /home/oracle/arch2/1_251_863920071.arc
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 252, /home/oracle/arch2/1_252_863920071.arc
LOGMINER: End mining logfile for session 1 thread 1 sequence 252, /home/oracle/arch2/1_252_863920071.arc
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 253, /data/r5/dg1/redo6.log
Sun Nov 23 02:58:45 2014
RFS LogMiner: RFS id [7692] assigned as thread [1] PING handler
RFS LogMiner: RFS id [7692] assigned as thread [1] PING handler
Sun Nov 23 03:19:22 2014
ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE
ALTER DATABASE START LOGICAL STANDBY APPLY (r5)
with optional part
IMMEDIATE
Attempt to start background Logical Standby process
ORA-16103 signalled during: ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE...
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 249, /data/r5/dg1/redo5.log
RFS[1]: Selected log 4 for thread 1 sequence 250 dbid -1930259324 branch 863920071
LOGMINER: End mining logfile for session 1 thread 1 sequence 249, /data/r5/dg1/redo5.log
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 250, /data/r5/dg1/redo4.log
Sun Nov 23 02:44:48 2014
RFS LogMiner: Registered logfile [/home/oracle/arch2/1_249_863920071.arc] to LogMiner session id [1]
RFS[1]: Selected log 5 for thread 1 sequence 251 dbid -1930259324 branch 863920071
RFS LogMiner: Registered logfile [/home/oracle/arch2/1_250_863920071.arc] to LogMiner session id [1]
LOGMINER: Alternate logfile found. Transition to mining archived logfile for session 1 thread 1 sequence 250, /home/oracle/arch2/1_250_863920071.arc
LOGMINER: End mining logfile for session 1 thread 1 sequence 250, /home/oracle/arch2/1_250_863920071.arc
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 251, /data/r5/dg1/redo5.log
主备的llsnrctl 状态都是正常
file:///C:\Users\Administrator\AppData\Roaming\Tencent\Users\779616723\QQ\WinTemp\RichOle\5RAN5R$FE97FULJOE`4H22S.jpg
file:///C:\Users\Administrator\AppData\Roaming\Tencent\Users\779616723\QQ\WinTemp\RichOle\}$9HU90N(I)KF2_HUHSVHVI.jpg
|
|
发表于 2014-11-23 16:30:22
