sap sybase16备份及还原测试

开始备份数据库

BWDEV BWD/script% isql64 -Usapsa -Pxxxxx -SBWD -X 

1> dump database BWD using config = 'BWDDB'
2> go
Backup Server: 4.172.1.4: The value of 'allocated pages threshold' has been set
to 40%.
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.41.1.1: Creating new disk file
/sapbackup/BWD/backups/BWD.DB.20160406.154208.000.
Backup Server: 6.28.1.1: Dumpfile name 'BWD160970DCD0    ' section number 1
mounted on disk file '/sapbackup/BWD/backups/BWD.DB.20160406.154208.000'
Backup Server: 4.188.1.1: Database BWD: 231322 kilobytes (1%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 434382 kilobytes (2%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 657988 kilobytes (3%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 861288 kilobytes (4%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 1084654 kilobytes (5%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 1287954 kilobytes (5%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 1511560 kilobytes (6%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 1714092 kilobytes (7%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 1929222 kilobytes (8%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 2152700 kilobytes (9%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 2349520 kilobytes (10%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 2568086 kilobytes (10%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 2785244 kilobytes (11%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 2988544 kilobytes (12%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 3212150 kilobytes (13%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 3415210 kilobytes (14%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 3638816 kilobytes (14%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 3841876 kilobytes (15%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 4059690 kilobytes (16%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 4283056 kilobytes (17%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 4486356 kilobytes (18%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 4698426 kilobytes (19%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 4906128 kilobytes (19%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 5125528 kilobytes (20%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 5335056 kilobytes (21%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 5547782 kilobytes (22%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 5774558 kilobytes (23%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 5977858 kilobytes (24%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 6194776 kilobytes (24%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 6413454 kilobytes (25%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 6616514 kilobytes (26%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 6833992 kilobytes (27%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 7057214 kilobytes (28%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 7260514 kilobytes (28%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 7463848 kilobytes (29%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 7684792 kilobytes (30%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 7890304 kilobytes (31%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 8117682 kilobytes (32%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 8331134 kilobytes (33%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 8548228 kilobytes (34%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 8744408 kilobytes (35%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 8968014 kilobytes (36%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 9171314 kilobytes (37%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 9402410 kilobytes (38%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 9605710 kilobytes (38%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 9823220 kilobytes (39%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 10026520 kilobytes (40%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 10254206 kilobytes (41%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 10466580 kilobytes (41%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 10674888 kilobytes (41%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 10892030 kilobytes (42%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 11094738 kilobytes (42%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 11303750 kilobytes (43%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 11535132 kilobytes (43%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 11731334 kilobytes (44%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 11946394 kilobytes (44%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 12157842 kilobytes (45%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 12376456 kilobytes (45%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 12591516 kilobytes (45%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 12806576 kilobytes (46%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 13021636 kilobytes (46%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 13236696 kilobytes (47%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 13451756 kilobytes (47%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 13666816 kilobytes (47%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 13881876 kilobytes (48%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 14075430 kilobytes (48%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 14290490 kilobytes (49%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 14505550 kilobytes (49%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 14720610 kilobytes (49%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 14935670 kilobytes (50%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 15150730 kilobytes (50%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 15365790 kilobytes (51%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 15580850 kilobytes (51%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 15795910 kilobytes (52%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 16010970 kilobytes (52%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 16226030 kilobytes (52%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 16441090 kilobytes (53%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 16634644 kilobytes (53%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 16849704 kilobytes (54%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 17064764 kilobytes (54%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 17279824 kilobytes (54%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 17494884 kilobytes (55%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 17709944 kilobytes (55%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 17925004 kilobytes (56%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 18140064 kilobytes (56%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 18355124 kilobytes (56%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 18570184 kilobytes (57%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 18785244 kilobytes (57%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 18978798 kilobytes (58%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 19193858 kilobytes (58%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 19408918 kilobytes (58%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 19623978 kilobytes (59%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 19839038 kilobytes (59%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 20054098 kilobytes (60%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 20269158 kilobytes (60%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 20484218 kilobytes (60%) DUMPED.
Backup Server: 4.188.1.1: Database BWD: 20699278 kilobytes (61%) 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.188.1.1: Database BWD: 20815906 kilobytes (100%) DUMPED.
Backup Server: 4.190.1.1: Database BWD: Verification reported 0 errors.
Backup Server: 3.42.1.1: DUMP is complete (database BWD).
1> dump transaction BWD using config = 'BWDlog'
2> go
Backup Server session id is: 9. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 4.41.1.1: Creating new disk file
/sapbackup/BWD/log_archives/BWD.TRAN.20160406.155943.000.
Backup Server: 6.28.1.1: Dumpfile name 'BWD160970E0EF    ' section number 1
mounted on disk file '/sapbackup/BWD/log_archives/BWD.TRAN.20160406.155943.000'
Backup Server: 3.43.1.1: Dump phase number 3 completed.
Backup Server: 4.58.1.1: Database BWD: 106 kilobytes DUMPED.
Backup Server: 4.190.1.1: Database BWD: Verification reported 0 errors.

Backup Server: 3.42.1.1: DUMP is complete (database BWD).

还原数据库

1> load database BWD from '/sapbackup/BWD/backups/BWD.DB.20160406.154208.000'
2> go
Backup Server session id is: 12. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'BWD160970DCD0    ' section number 1
mounted on disk file '/sapbackup/BWD/backups/BWD.DB.20160406.154208.000'
Backup Server: 4.188.1.1: Database BWD: 555294 kilobytes (1%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 1080632 kilobytes (2%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 1605858 kilobytes (3%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 2135148 kilobytes (4%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 2660486 kilobytes (5%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 3185824 kilobytes (6%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 3692986 kilobytes (7%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 4225494 kilobytes (8%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 4743152 kilobytes (9%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 5265930 kilobytes (10%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 5783844 kilobytes (11%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 6313022 kilobytes (12%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 6838360 kilobytes (13%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 7363698 kilobytes (14%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 7889036 kilobytes (15%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 8411046 kilobytes (16%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 8936384 kilobytes (17%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 9451226 kilobytes (18%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 9992822 kilobytes (19%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 10525842 kilobytes (20%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 11024300 kilobytes (21%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 11565512 kilobytes (22%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 12090850 kilobytes (23%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 12605820 kilobytes (24%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 13131158 kilobytes (25%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 13656496 kilobytes (26%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 14177994 kilobytes (27%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 14703332 kilobytes (28%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 15217282 kilobytes (29%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 15743262 kilobytes (30%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 16267332 kilobytes (31%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 16790116 kilobytes (32%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 17306752 kilobytes (33%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 17865116 kilobytes (34%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 18382518 kilobytes (35%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 18907856 kilobytes (36%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 19422058 kilobytes (37%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 19947396 kilobytes (38%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 20469406 kilobytes (39%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 20983224 kilobytes (40%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 21503722 kilobytes (41%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 22023580 kilobytes (42%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 22544592 kilobytes (43%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 23076492 kilobytes (44%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 23601088 kilobytes (45%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 24138738 kilobytes (46%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 24654882 kilobytes (47%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 25171026 kilobytes (48%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 25708676 kilobytes (49%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 26224820 kilobytes (50%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 26740964 kilobytes (51%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 27278614 kilobytes (52%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 27794758 kilobytes (53%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 28332408 kilobytes (54%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 28848552 kilobytes (55%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 29364696 kilobytes (56%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 29902346 kilobytes (57%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 30418490 kilobytes (58%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 30934634 kilobytes (59%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 31472284 kilobytes (60%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 32168004 kilobytes (61%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 32512070 kilobytes (62%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 33200202 kilobytes (63%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 33888334 kilobytes (64%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 34232400 kilobytes (65%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 34920532 kilobytes (66%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 35264598 kilobytes (67%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 35952730 kilobytes (68%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 36296796 kilobytes (69%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 36984928 kilobytes (70%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 37328994 kilobytes (71%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 38017126 kilobytes (72%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 38361192 kilobytes (73%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 39049324 kilobytes (74%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 39393390 kilobytes (75%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 40081522 kilobytes (76%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 40425588 kilobytes (77%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 41113720 kilobytes (78%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 41457786 kilobytes (79%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 42145918 kilobytes (80%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 42489984 kilobytes (81%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 43178116 kilobytes (82%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 43522182 kilobytes (83%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 44210314 kilobytes (84%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 44898446 kilobytes (85%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 45242512 kilobytes (86%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 45930644 kilobytes (87%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 46274710 kilobytes (88%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 46962842 kilobytes (89%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 47306908 kilobytes (90%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 47995040 kilobytes (91%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 48339106 kilobytes (92%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 49027238 kilobytes (93%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 49371304 kilobytes (94%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 50059436 kilobytes (95%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 50403502 kilobytes (96%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 51091634 kilobytes (97%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 51435700 kilobytes (98%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 52123832 kilobytes (99%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 52431018 kilobytes (100%) LOADED.
Backup Server: 4.188.1.1: Database BWD: 52431346 kilobytes (100%) LOADED.
Backup Server: 3.42.1.1: LOAD is complete (database BWD).
Started estimating recovery log boundaries for database 'BWD'.
Database 'BWD', checkpoint=(3063858, 25), first=(3063858, 25), last=(3063861,
52).
Completed estimating recovery log boundaries for database 'BWD'.
Started ANALYSIS pass for database 'BWD'.
Completed ANALYSIS pass for database 'BWD'.
Started REDO pass for database 'BWD'. The total number of log records to process
is 393.
Roll forward transaction '$systsflush'.
Roll forward transaction '$write_stats'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Redo pass of recovery has processed 57 committed and 0 aborted transactions.
Completed REDO pass for database 'BWD'.
Use the ONLINE DATABASE command to bring this database online; ASE will not
bring it online automatically.
1> load transaction BWD from '/sapbackup/BWD/log_archives/'BWD.TRAN.20160406.155943.000'
2> go
Msg 102, Level 15, State 181:
Server 'BWD', Line 1:
Incorrect syntax near '.'.
Msg 105, Level 15, State 2:
Server 'BWD', Line 1:
Unclosed quote before the character string '
'.
1> load transaction BWD from '/sapbackup/BWD/log_archives/BWD.TRAN.20160406.155943.000'
2> go
Backup Server session id is: 15. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'BWD160970E0EF    ' section number 1
mounted on disk file '/sapbackup/BWD/log_archives/BWD.TRAN.20160406.155943.000'
Backup Server: 4.58.1.1: Database BWD: 106 kilobytes LOADED.
Backup Server: 3.42.1.1: LOAD is complete (database BWD).
Started estimating recovery log boundaries for database 'BWD'.
Database 'BWD', checkpoint=(3063858, 25), first=(3063858, 25), last=(3063862,
48).
Completed estimating recovery log boundaries for database 'BWD'.
Started ANALYSIS pass for database 'BWD'.
Completed ANALYSIS pass for database 'BWD'.
Started full REDO pass for database 'BWD'. The total number of log records to
process is 510.
Roll forward transaction '$systsflush'.
Roll forward transaction '$write_stats'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$rep_xact_for_dumpdb'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$chained_transaction'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$systsflush'.
Roll forward transaction '$chained_transaction'.
Redo pass of recovery has processed 75 committed and 0 aborted transactions.
Completed REDO pass for database 'BWD'.
Use the ONLINE DATABASE command to bring this database online; ASE will not
bring it online automatically.
1> online database "BWD"
2> go
Started estimating recovery log boundaries for database 'BWD'.
Database 'BWD', checkpoint=(3063862, 48), first=(3063858, 47), last=(3063862,
48).
Completed estimating recovery log boundaries for database 'BWD'.
Started ANALYSIS pass for database 'BWD'.
Completed ANALYSIS pass for database 'BWD'.
Recovery of database 'BWD' will undo incomplete nested top actions.
Started UNDO pass for database 'BWD'. The total number of log records to process
is 489.
Roll back transaction '$dmpxact' -- was aborted.
Roll back transaction '$chained_transaction' -- was aborted.
Roll back transaction '$chained_transaction' -- was aborted.
Roll back transaction '$chained_transaction' -- was aborted.
Roll back transaction '$chained_transaction' -- was aborted.
Roll back transaction '$chained_transaction' -- was aborted.
Undo pass of recovery has processed 6 incomplete transactions.
Completed UNDO pass for database 'BWD'.
Checking external objects.
Database 'BWD' is now online.