Transaction Log backup
Posted in 1998
Topics: High Availability & Replication, Backup & Restore, Storage & Space Management, Transactions, Locking & Isolation, Logging & Checkpoints, Cloud, Docker & Containers
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------ =_NextPart_000_01BE11AE.EE413E6C
Content-Type: text/plain
Thanks for the responses re backing up transaction log. I'm posting the
message again since one of the respondents said that he did not get the
following message in his log file when he pretty much followed the same
procedure on a UNIX box.
===============
Before I execute the level 0 backup, I kill the ontape -c session by typing
CTRL-C in the korn shell window where ontape -c is running). This kind of
weirds me out because the online.log file always shows:
Logical log #### Complete
Logical Log #### - Backup started
Logical Log #### - Backup aborted
Aborted by client
Checkpoint complete: duration was # seconds
Level 0 Archive started on rootdbs, elitedbs
Can I force the backup of that last logical log thru and THEN do the Level 0
backup? I'm also swapping the DAT backup tape for the transaction log as
I'm kicking off the level 0 backup to the DLT.
System is:
Dell 4200/6100 with quad processors
DLT tape drive is used for level 0 backups
DAT drive is used for transaction logging to tape
MKS Toolkit is running on the NT 4.0 server (all commands run thru Toolkit's
Korn shell)
Thanks again.
-Patricia Noe
Brown, Rudnick, Freed & Gesmer
------ =_NextPart_000_01BE11AE.EE413E6C
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+Ii0WAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAYAAAAVHJhbnNhY3Rpb24gTG9nIGJhY2t1cCAAfggBCYAB
ACEAAABGNzlCMzZCNjMwN0REMjExODk4RjAwQzA0RkEzNDJGRAAvBwEggAMADgAAAM4HCwAQABEA
EQArAAEAPgEBBYADAA4AAADOBwsAEAASABIALQABAEIBAQ2ABAACAAAAAgACAAEDkAYA0AgAAC0A
AAALAAIAAQAAAEAAOQCgoGZ1txG+AR4AcAABAAAAGAAAAFRyYW5zYWN0aW9uIExvZyBiYWNrdXAg
AAIBcQABAAAAFgAAAAG+Ebd1TLY2m/l9MBHSiY8AwE+jQv0AAAIBCRABAAAAwgMAAL4DAACrBQAA
TFpGdQXfH7wDAAoAcmNwZzEyNRYyAPgLYG4OEDAzMx0B9yACpAPjAgBwcnERDlBmY2gKwHNldHww
IAcTAoMAUBB2EV59GQqBdWMAUAsDdWxuJQIgZQumIFQRYG5rhwQgAhAFwHRoZSAJcDxzcAIgEZAE
IAlwIGKFANBrC4BnIHVwFoCmcgBxANB0aQIgIAkAgGcuIEknbSAXAL5zGMAX8RaSB4EYkGcWsMsa
oAtxIACQbmMWsBUhfRuQZhaJAQACMAQgGJBp2mQWgWEFQBahZB0xFRDfBUAasAVAFpICEGwJAAPw
9xfxGmYbEWgEABkCFkADEH0WsHcWoCARFrAQ8BGgdPZ5GlAUYGge1QmAFoMYkOsHgCFxbxtwZAhw
G4Ia0CAgVU5JWBeQb3hvGUAKogqECoA9Jbwk5UKHARAFsBawSSBleAWQnHV0FrAWkiDQdmUDIPcR
wBeiGCAsJ3EX0B8AFoPJAiFhcBawLWMbMBpxLRjSYiHQIcBwF+JDVLBSTC1DH/IWkmsFsO8bIRag
KaEfMWQfICDyI9NjKjYgQXJ1bgMADyApfxlAFdEgQRfRHUAb4SKQaV8LIAQgIzEIYAVAYgWQYZZ1
EZApxWwLgGUuIHdRB0B3YXkc8WgfIHN6OiT6TBkgDeAHQCBjI/81cSvAA3ALUBGgFUA0azSx8TVk
LSBCKPMbMAGQACC/CYA2TzddAaAJETiWQTrE3SsiYzJAHMEk9EMWoBfA/xcAC4AFQAWgNeQz4AGR
HdD/CHAdgBjSM0AEIDWgEZAFoL8coBDANGQodQcQEVBpKICPODYj8gNgHjBkYnMpQN0okGk4gUJA
JPpDA5EngP8WURtxFpIo5BvUHYELYBnAPxkCNOcWkC8AGtAwIVRIdEVOHdBvFoNARijkP/cvkBli
B0BzR7AD4CpAK4PxFpJEQVREtiozFlYYXf8a0AQgGWIX0BfEG+Ab9ChswxaAR7RETFQuJPoGsK0Z
wGUZgAQAOiTlRC0i4jQB0DAvNg9AEcAD8OEWkCBxdWEdQCNjBBDvBbA/1U/RSyRkBRBBESBB/zGh
HUAWUihsVAZKkVUPGE6fNNAZ8kexKkEk9E1LBfD6VEIAbBfQBUAu2CPyFpKyTkqgNC4RwBGQciiA
/QXAKAdAAyA9oQOBMMEvAatGtFslJwQgSyzHKST6zyT0FeUa41ALLVAdgAUQVmMHMAewbzY1QgNg
d+JuKUBSdWQDABfAKUDGRgnRHUAmIEcHkAeAvnIk+AswAEElAxQhAGegAAADAP0/UgMAAB4AMUAB
AAAADgAAAE5PRVBCMTA4NjhCODEAAAADABpAAAAAAB4AMEABAAAADgAAAE5PRVBCMTA4NjhCODEA
AAADABlAAAAAAAMA3j+vbwAACwAAgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAKACCAG
AAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMABYAIIAYAAAAAAMAAAAAAAABGAAAAAFKFAADwEwAA
HgAlgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC41AAsA2oAIIAYAAAAAAMAAAAAA
AABGAAAAAAaFAAAAAAAAAwAmgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALAC+ACCAGAAAA
AADAAAAAAAAARgAAAAAOhQAAAAAAAAMAMIAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwAy
gAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeAEGACCAGAAAAAADAAAAAAAAARgAAAAA2hQAA
AQAAAAEAAAAAAAAAHgBCgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4AQ4AI
IAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAALAMaACyAGAAAAAADAAAAAAAAARgAA
AAAAiAAAAAAAAAsAyIALIAYAAAAAAMAAAAAAAABGAAAAAAWIAAAAAAAAAwAmAAAAAAADADYAAAAA
AAMAgBD/////AgH5PwEAAABnAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAABgAAAC9PPUJST1dO
LCBSVUROSUNLLCBGUkVFRCAmIEdFU01FUi9PVT1CT1NUT04vQ049UkVDSVBJRU5UUy9DTj1OT0VQ
QjEwODY4QjgxAAAeAPg/AQAAABEAAABOb2UsIFBhdHJpY2lhIEIuAAAAAB4AOEABAAAADgAAAE5P
RVBCMTA4NjhCODEAAAACAfs/AQAAAGcAAAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAGAAAAL089
QlJPV04sIFJVRE5JQ0ssIEZSRUVEICYgR0VTTUVSL09VPUJPU1RPTi9DTj1SRUNJUElFTlRTL0NO
PU5PRVBCMTA4NjhCODEAAB4A+j8BAAAAEQAAAE5vZSwgUGF0cmljaWEgQi4AAAAAHgA5QAEAAAAO
AAAATk9FUEIxMDg2OEI4MQAAAEAABzDgfO1VthG+AUAACDBsPkHurhG+AR4APQABAAAAAQAAAAAA
AAAeAB0OAQAAABgAAABUcmFuc2FjdGlvbiBMb2cgYmFja3VwIAALACkAAAAAAAsAIwAAAAAAAwAG
EO9FjPsDAAcQpQMAAAMAEBAAAAAAAwAREAAAAAAeAAgQAQAAAGUAAABUSEFOS1NGT1JUSEVSRVNQ
T05TRVNSRUJBQ0tJTkdVUFRSQU5TQUNUSU9OTE9HSU1QT1NUSU5HVEhFTUVTU0FHRUFHQUlOU0lO
Q0VPTkVPRlRIRVJFU1BPTkRFTlRTU0FJRFRIAAAAAC0I
------ =_NextPart_000_01BE11AE.EE413E6C--