You are here

unload sybase database

 
Info: Kann Online durchgeführt werden.

 

$ isql -U xxxx -S SASP -w 999 -Dmaster

1> sp_helpdb
2> go

 name             db_size       owner        dbid   created        status                                     
-------------- ------------- ------------ ------ -------------- -------------------------------------- ACSON 75.0 MB acsonowner 5 Feb 22, 2007 select into/bulkcopy/pllsort, trunc log on chkpt SAS 80.0 MB sa 4 Feb 22, 2007 select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full audit_hist 2304.0 MB sa 6 Feb 22, 2007 select into/bulkcopy/pllsort, trunc log on chkpt master 93.5 MB sa 1 Jan 01, 1900 no options set
model
2.0 MB sa 3 Jan 01, 1900 no options set sybsecurity 80.0 MB batchsa 31515 Feb 23, 2007 select into/bulkcopy/pllsort
sybsystemdb
7.0 MB sa 31513 Nov 03, 1999 trunc log on chkpt sybsystemprocs 100.0 MB sa 31514 Feb 22, 2007 trunc log on chkpt tempdb 110.0 MB sa 2 Nov 27, 2008 select into/bulkcopy/pllsort,trunc log on chkpt,abort tran on log full
(1 row affected)
(return status = 0)

 


1>
dump database SAS
2> to "/var/opt/data/DUMP/sybase/SAS_1_2009042_1010_Mo.dmp"
3> stripe on "/var/opt/data/DUMP/sybase/SAS_2_2009042_1010_Mo.dmp"
4>
stripe on "/var/opt/data/DUMP/sybase/SAS_3_2009042_1010_Mo.dmp"
5> stripe on "/var/opt/data/DUMP/sybase/SAS_4_2009042_1010_Mo.dmp"
6> go 

Backup Server session id is:  130.  Use this value when executing the 'sp_volchanged' system stored procedure
after fulfilling any volume change requ
est from the Backup Server. Backup Server: 4.41.1.1: Creating new disk file /var/opt/data/DUMP/sybase/SAS_1_2009042_1010_Mo.dmp. Backup Server: 4.41.1.1: Creating new disk file /var/opt/data/DUMP/sybase/SAS_2_2009042_1010_Mo.dmp. Backup Server: 4.41.1.1: Creating new disk file /var/opt/data/DUMP/sybase/SAS_3_2009042_1010_Mo.dmp. Backup Server: 4.41.1.1: Creating new disk file /var/opt/data/DUMP/sybase/SAS_4_2009042_1010_Mo.dmp. Backup Server: 6.28.1.1: Dumpfile name 'SAS0911708FA9 ' section number 1 mounted on disk file '/var/opt/data/DUMP/sybase/SAS_2_2009042_1010_Mo.dmp' Backup Server: 6.28.1.1: Dumpfile name 'SAS0911708FA9 ' section number 1 mounted on disk file '/var/opt/data/DUMP/sybase/SAS_1_2009042_1010_Mo.dmp' Backup Server: 6.28.1.1: Dumpfile name 'SAS0911708FA9 ' section number 1 mounted on disk file '/var/opt/data/DUMP/sybase/SAS_3_2009042_1010_Mo.dmp' Backup Server: 6.28.1.1: Dumpfile name 'SAS0911708FA9 ' section number 1 mounted on disk file '/var/opt/data/DUMP/sybase/SAS_4_2009042_1010_Mo.dmp' Backup Server: 4.58.1.1: Database SAS: 630428 kilobytes DUMPed. Backup Server: 4.58.1.1: Database SAS: 1255406 kilobytes DUMPed. Backup Server: 4.58.1.1: Database SAS: 1873240 kilobytes DUMPed. [...] Backup Server: 4.58.1.1: Database SAS: 62974550 kilobytes DUMPed. Backup Server: 4.58.1.1: Database SAS: 63591176 kilobytes DUMPed. Backup Server: 4.58.1.1: Database SAS: 64218620 kilobytes DUMPed. Backup Server: 3.43.1.1: Dump phase number 1 completed. Backup Server: 3.43.1.1: Dump phase number 2 completed. Backup Server: 3.43.1.1: Dump phase number 3 completed. Backup Server: 4.58.1.1: Database SAS: 64253540 kilobytes DUMPed. Backup Server: 3.42.1.1: DUMP is complete (database SAS). 1> exit

 

$ ls -la SAS*

-rw-r-----   1 sybase   sybase   16449122304 Apr 27 10:27 SAS_1_2009042_1010_Mo.dmp
-rw-r-----   1 sybase   sybase   16448667648 Apr 27 10:27 SAS_2_2009042_1010_Mo.dmp
-rw-r-----   1 sybase   sybase   16449382400 Apr 27 10:27 SAS_3_2009042_1010_Mo.dmp
-rw-r-----   1 sybase   sybase   16448501760 Apr 27 10:27 SAS_4_2009042_1010_Mo.dmp

 

-- bei bedarf mit "scp" auf einen anderen Server kopieren. 

$ scp -B -p -q -Q SAS_[1234]_2009042_1010_Mo.dmp rmx114:/var/opt/data/DUMP/backup/sybase/