newccm 유저db를 백업받을려고 하면 아래와 같은 백업 스크립트를 구동되면서 Error가 떨어집니다.
다른 db는 백업이 잘되는데. newccm db만 백업이 진행이 안됩니다.
dump database newccm to "compress::/data2/Sybase/BACKUP/DATA/newccmdb1.dmp"
stripe on "compress::/data2/Sybase/BACKUP/DATA/newccmdb2.dmp"
stripe on "compress::/data2/Sybase/BACKUP/DATA/newccmdb3.dmp"
go
Backup Server session id is: 5. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 4.132.1.1: Attempting to open byte stream device:
'compress::/data2/Sybase/BACKUP/DATA/newccmdb1.dmp::00'
Backup Server: 4.132.1.1: Attempting to open byte stream device:
'compress::/data2/Sybase/BACKUP/DATA/newccmdb2.dmp::01'
Backup Server: 4.132.1.1: Attempting to open byte stream device:
'compress::/data2/Sybase/BACKUP/DATA/newccmdb3.dmp::02'
Backup Server: 6.28.1.1: Dumpfile name 'newccm081051067B ' section number 1
mounted on byte stream 'compress::/data2/Sybase/BACKUP/DATA/newccmdb3.dmp::02'
Backup Server: 6.28.1.1: Dumpfile name 'newccm081051067B ' section number 1
mounted on byte stream 'compress::/data2/Sybase/BACKUP/DATA/newccmdb1.dmp::00'
Backup Server: 6.28.1.1: Dumpfile name 'newccm081051067B ' section number 1
mounted on byte stream 'compress::/data2/Sybase/BACKUP/DATA/newccmdb2.dmp::01'
Backup Server: 4.23.2.1: dd_read: read /data2/DEVICE/newccm.log: Number bytes
transferred <= 0.
Msg 8009, Level 16, State 1:
Server 'bankonbb', Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for
details.
의심히 가는건 아래와 같이 환경이 로그로되어 있어 백업이 안되는건지?
다른 DB는 usage 타입이 data only, log only로 되어 있는데. data and log 로 되어 있어서요
device_fragments size usage created free kbytes
---------------- ---- ----- ------- -----------
newccm_dat 500.0 MB data and log May 29 2007 8:28PM 504520
newccm_log 500.0 MB log only Apr 8 2008 10:05AM not applicable
log only free kbytes = 1014520
sp_help 정보
name db_size owner dbid created status
---- ------- ----- ----------- ------- ------
ccm 10620.0 MB ccmlogin 4 May 29, 2007 select into/bulkcopy/pllsort
master 50.0 MB sa 1 May 29, 2007 mixed log and data
model 4.0 MB sa 3 May 29, 2007 mixed log and data
newccm 1000.0 MB sa 5 May 29, 2007 select into/bulkcopy/pllsort, mixed log and data
passonccm 1000.0 MB sa 6 May 29, 2007 select into/bulkcopy/pllsort
passonccm2 100.0 MB sa 7 Aug 05, 2007 no options set
sybsystemdb 5.0 MB sa 31513 May 29, 2007 mixed log and data
sybsystemprocs 120.0 MB sa 31514 May 29, 2007 trunc log on chkpt, mixed log and data
tempdb 104.0 MB sa 2 Jun 20, 2007 select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data
name db_size owner dbid created status
---- ------- ----- ----------- ------- ------
newccm 1000.0 MB sa 5 May 29, 2007 select into/bulkcopy/pllsort, mixed log and data
device_fragments size usage created free kbytes
---------------- ---- ----- ------- -----------
newccm_dat 500.0 MB data and log May 29 2007 8:28PM 504520
newccm_log 500.0 MB log only Apr 8 2008 10:05AM not applicable
log only free kbytes = 1014520
device segment
newccm_dat default
newccm_dat logsegment
newccm_dat system
newccm_log logsegment
=================================
DB를 재생성하여 다시 만들어야되는건가요? 많은 도움주시기 바랍니다.
|