2009. 10. 9. 18:05

에러:: Error: 3456

2009-10-09 13:30:01.120 spid62 The database 'XXX' is marked RESTORING and is in a state that does not allow recovery to be run.
2009-10-09 13:30:25.530 spid20s Database mirroring is active with database 'XXX' as the mirror copy. This is an informational message only. No user action is required.
2009-10-09 17:19:14.180 spid20s Error: 3456, Severity: 21, State: 1.
2009-10-09 17:19:14.180 spid20s Could not redo log record (276495:119218:6),
for transaction ID (0:408286833), on page (20:508656), database 'XXX' (database ID 12).
Page: LSN = (276492:1649102:28), type = 1. Log: OpCode = 4, context 2,

 PrevPageLSN: (276495:66503:4). Restore from a backup of the database, or repair the database.
2009-10-09 17:19:14.190 spid20s Error: 1454, Severity: 16, State: 1.
2009-10-09 17:19:14.190 spid20s While acting as a mirroring partner for database 'XXX', server instance '장비명' encountered error 3456, status 1, severity 21. Database mirroring will be suspended.  Try to resolve the error and resume mirroring.
2009-10-09 17:19:14.700 spid20s Database mirroring is inactive for database 'XXX'. This is an informational message only. No user action is required.

 

http://www.errorhelp.com/ 에서 찾아봤음.

 

미러링되는 미러서버의 DB가 정합성이 맞지 않아서 발생. 미러도 일시 중지 상태가 됨.

미러를 재 구축 해야함.

 

미러DB가 아니라면 응급 모드로 변경해서 읽기라도 가능하게 하여 조치할것 조치함.

2009. 9. 28. 14:47

미러링::Error: 1479, Severity: 16, State: 1.

SQL SERVER 2005 이상


미러서버의 네티워크 사용량 증라고 미러링이 재개되지 못하는 경우. 

 

Database mirroring sessions may stop intermittently in SQL Server 2005

http://support.microsoft.com/default.aspx?scid=kb;en-us;959006&sd=rss&spid=2855

 

select is_send_flow_controlled column , * from sys.dm_db_mirroring_connections dynamic management

is_send_flow_controlled column  컬럼이 1 이면 네트워크 사용량이 많은거다.

 

(미러서버)

 

<Date><Time> spid16s Error: 1479, Severity: 16, State: 1.
<Date><Time> spid16s The mirroring connection to "<EndPoint>" has timed out for database "MSS" after 120 seconds without a response. Check the service and network connections.
<Date><Time> spid16s Database mirroring is inactive for database 'MSS'. This is an informational message only. No user action is required.
<Date><Time> spid16s Restart packet created for dbid 5.
<Date><Time> spid22s Restart packet processing for dbid 5.
<Date><Time> spid22s SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
<Date><Time> spid22s SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
<Date><Time> spid22s SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
<Date><Time> spid22s Starting up database '<Database name>'.
<Date><Time> spid22s Bypassing recovery for database '<Database name>' because it is marked as a mirror database, which cannot be recovered. This is an informational message only. No user action is required.