NetBackup Restore( SAP ASE 복구), database load, bcp

Netbackup SAP ASE DB 복구 절차: database load

복구할 파일 조회

# Policy Type 지정 -t 7 = SybaseDB

# bplist -C ncci1 -t 7 -l -R "/*"|more
-rw-rw---- sybase15  sybase      17146862K 17 Nov 17:32 /sybase15.nccris_01.D.0.1019.17-11-2020.17:32:12

# 위에서 조회한 파일로 복구 합니다.
>load database nccres from 'sybackup::sybase15.nccris_01.D.0.1019.17-11-2020.17:32:12'
>go

# load완료후 online
>online database nccres

# Table 복구
>use nccris_01
>go
>select * into 'tablename' from nccres..'tablename'
>go

# BCP 백업
ex)

bcp nccris_01..TRP_ACPT_SUBJ_BASE out TRP_ACPT_SUBJ_BASE.dat -c -t "|" -J eucksc -Usa -P"패스워드"

-c char datatype as the default, does not prompt for each field
-t field_terminator
-J client charset



# BCP 복구
ex)

bcp nccris_01..SBJCT_SIGN_PRGS in SBJCT_SIGN_PRGS.dat -c -t "|" -J eucksc  -Usa-P"패스워드"


#rename table
sp_rename old_table, newtable

#column rename
sp_rename "table.column", newcolumnname

#truncate table
truncate table  dbo.SBJCT_SIGN_PRGS