Archive log not being applied to standby 'Data Gaurd' server
587671Jun 10 2008 — edited Jun 10 2008Db1 Oracle Oracle Database 10g 10.2.0.3.0
Db2 Oracle Oracle Database 10g 10.2.0.3.0
Grid Db Oracle Database 10g 10.1.0.4.0
We have the following problem where the Data Guard standby server is not applying achieve logs from the primary server.
An example of this is on the standby server the Last Received Log was 14745 and the last Applied log was 0, I ran the ‘Verify Configuration’ report and got this..
Initializing
Connected to instance server2:Db2
Starting alert log monitor...
Updating Data Guard link on database homepage...
Data Protection Settings:
Protection mode : Maximum Performance
Log Transport Mode settings:
Db1: ASYNC
Db2: ASYNC
Checking standby redo log files.....OK
Checking Data Guard status
Db1 : Normal
Db2 : Normal
Checking Inconsistent Properties
Checking agent status
Db1 ... WARNING: No credentials available for target server1
Attempting agent ping ... OK
Db2 ... WARNING: No credentials available for target server2
Attempting agent ping ... OK
Switching log file 14,745.Done
Checking applied log on Db2.......WARNING:
Timed out after 60 seconds waiting for log to be applied.
Processing completed.
I have limited knowledge of data guard but seeing ‘Db1 ... WARNING: No credentials available for target server1’ doesn’t look good. The only thing I can thing is that the stand by server has been down for a couple of weeks abd becuase of this its out of sync with the primary server ?
Any help would be good