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/