'미러링'에 해당되는 글 2건
- 2009.10.09 에러:: Error: 3456
- 2009.09.28 미러링::Error: 1479, Severity: 16, State: 1.
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.
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가 아니라면 응급 모드로 변경해서 읽기라도 가능하게 하여 조치할것 조치함.
'Error Case' 카테고리의 다른 글
| Error::NOLOCK 함께 스캔할 수 없음 - 601 (0) | 2009.12.08 |
|---|---|
| Error::Non-yielding IOCP Listener - Stack Dump analysis (0) | 2009.12.07 |
| Error:: '80004005', SQL 서버가 죽음 (2) | 2009.11.09 |
| 에러::64bit 버퍼 풀 페이징 (0) | 2009.07.08 |
2009. 9. 28. 14:47
미러링::Error: 1479, Severity: 16, State: 1.
2009. 9. 28. 14:47 in Database Mirroring
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.
<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.
Prev
