UNSOLVED
Restore translogs from fullbackup
Cu will restore from his sybase database the translogs only.
He will restore it not from the last fullbackup, he will restore it from fullbackup before last fullbackup.
He use this command:
/usr/sbin/nsrsybrc -v -s bsb-sun11 -c bsb-sun10 -U sa -P xxx SYBASE:/bsbSYB/sisis
but with this, he restore the database and translogs. But he will the translogs only.
I find nothing in the sybase document, how I can do it.
It is possible?
And how I can do it?
He will restore it not from the last fullbackup, he will restore it from fullbackup before last fullbackup.
He use this command:
/usr/sbin/nsrsybrc -v -s bsb-sun11 -c bsb-sun10 -U sa -P xxx SYBASE:/bsbSYB/sisis
but with this, he restore the database and translogs. But he will the translogs only.
I find nothing in the sybase document, how I can do it.
It is possible?
And how I can do it?
- I found one way in the Networker Guide from Sybase Admin Guide Page 113:
---
*Recovering a Database and Transaction Logs*
Use the Sybase load command from the isql command line to recover a
database or a transaction log.
To recover database and transaction logs:
1. Ensure that either of the following XBSA environment variables are
set for
the Sybase Backup Server:
? NSR_SERVER
? NSR_CLIENT
######
Note: The load command uses the XBSA environment variables that are
set for the Sybase Backup Server.
######
2. Load a database from the isql command line:
load database database_name from ?bms::?
#####
Note: To load a database or transaction log fromthe isql command line, the
timestamp for each database or transaction log might be required. If a
timestamp is not included, the NetWorker software uses the most recent
backup. If there are multiple transaction logs, then it is useful to
indicate
the timestamp when a transaction log is loaded.
#####
If required, find the timestamp for a save set by using either of the
following methods:
? Enter the following command to obtain a list of all the Sybase save
sets for the NetWorker client:
nsrinfo -X all -n sybase networker_client
? Select the save set to be recovered:
a. Use the Save Set Recover window in the NetWorker
Administrator program to select the save set.
The date and time are displayed in the Instances window.
b. At the isql command line, enter the load command.
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Important: Use the nsrsybrc command to recover databases and transaction
logs. Use the Save Set Recover window to recover Sybase data. For
details, see
"Chapter 5: Restoring Data" on page 77.
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
3. Apply the transaction logs to the database:
load transaction database_name from ?bms::?
4. Bring the database back online:
online database database_name
mg115301
2 Intern
•
100 Posts
510
0
Posted June 8th, 2006 03:00
We test it, but see this error:
Specified file 'dump device' is out of sequence. Current time stamp is Jun 8
2006 11:15:38:313AM while dump was from Mrz 31 2005 8:12:01:793PM.
Here what cu do:
root@bsb-sun12 # /usr/sbin/nsrsybsv -v -s bsb-sun11 -b DBDay -g DBDay -l incr -U sa -P xxx .......
2006-06-08 11:15:38 nsrsybsv: Datenbankkontext auf 'master' geändert.2006-06-08 11:15:38 nsrsybsv: Backing up transaction log qk.
2006-06-08 11:15:38 nsrsybsv: Backup Server-Sitzungs-ID: 119. Verwenden Sie diesen Wert bei der Ausführung der gespeicherten Prozedur 'sp_volchanged' nach einem vom Backup Server angeforderten Datenträgerwechsel.2006-06-08 11:15:38 nsrsybsv: Backup Server: 4.132.1.1: Versuch, ein Bytestrom-Gerät zu öffnen: 'bms::bsb-sun12.bsbSYBTest12.qk../nsr/tmp/syNDaqMq::00'
2006-06-08 11:16:41 nsrsybsv: Backup Server: 6.28.1.1: Sicherungsdateiname 'qk0615909E5A ', Sektion-Nummer 1, gemountet auf Bytestrom 'bms::bsb-sun12.bsbSYBTest12.qk../nsr/tmp/syNDaqMq::00'
2006-06-08 11:16:41 nsrsybsv: Backup Server: 4.58.1.1: Datenbank qk: 6 KByte DUMP.
2006-06-08 11:16:41 nsrsybsv: Backup Server: 3.43.1.1: Sicherungsphase Nummer 3 beendet.
2006-06-08 11:16:41 nsrsybsv: Backup Server: 4.58.1.1: Datenbank qk: 10 KByte DUMP.
2006-06-08 11:16:54 nsrsybsv: Backup Server: 3.42.1.1: DUMP ist beendet (Datenbank qk).
bsb-sun12: SYBASE:/bsbSYBTest12/qk level=incr, 23 KB 00:01:22 3 files
completed savetime=1149758138
Restore Transaktionslog :
1> load transaction qk from "bms::bsb-sun12.bsbSYBTest12.qk.20060608111538313"
2> go
Backup Server-Sitzungs-ID: 12. Verwenden Sie diesen Wert bei der Ausführung der
gespeicherten Prozedur 'sp_volchanged' nach einem vom Backup Server
angeforderten Datenträgerwechsel.
Backup Server: 4.132.1.1: Versuch, ein Bytestrom-Gerät zu öffnen:
'bms::bsb-sun12.bsbSYBTest12.qk.20060608111538313::00'
Backup Server: 6.28.1.1: Sicherungsdateiname 'qk0615909E5A ', Sektion-Nummer 1, gemountet auf Bytestrom
'bms::bsb-sun12.bsbSYBTest12.qk.20060608111538313::00'
Msg 4305, Level 16, State 1:
Server 'bsbSYBTest12', Line 1:
Specified file 'dump device' is out of sequence. Current time stamp is Jun 8
2006 11:15:38:313AM while dump was from Mrz 31 2005 8:12:01:793PM.
Have anyone idea what we make wrong?