Online backups won't restore

OK, Issue resolved but root cause is a mystery,  Ended up stopping everything and making an off-line backup and tried restoring that to Test.  It worked fine.  So truncated the B1 file on the Live DB and tried an on-line backup.  It restored OK.  So the B1 file was causing the grief.   My first "fire" with the new company.


-Todd C,

Electroimpact, Inc.

Mukilteo, WA


Now at a 9.05.702A site and having an issue with restoring an online backup.  Backup looks like it completes OK but when restored as a Test database it can not be accessed.  The B1 file for the Live DB is pretty large and is not shrinking as is usual after a successful backup.  It appears there may be a stuck App Server but we can't tell.  Last time this happened they ended up taking the database down and it got corrupted so trying to avoid that now.

Any ideas what to look for or at that might be causing bad backups?  Plan at moment is to kick everybody off and truncate the B1 and see if it allows a good backup.  If not they are looking at an index rebuild which could take a long time.  I think this is a bit drastic but I am not familiar enough with E9 to contradict them (and only 3rd day here).


Thanks,

Todd Caughey

Electroimpact, Inc.


So when you are in the testdb directory and run prorest mfgsys /pathto/backup.1 it tells you that it cannot be accessed?

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 31, 2016 2:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Online backups won't restore

 

 

Now at a 9.05.702A site and having an issue with restoring an online backup.  Backup looks like it completes OK but when restored as a Test database it can not be accessed.  The B1 file for the Live DB is pretty large and is not shrinking as is usual after a successful backup.  It appears there may be a stuck App Server but we can't tell.  Last time this happened they ended up taking the database down and it got corrupted so trying to avoid that now.

Any ideas what to look for or at that might be causing bad backups?  Plan at moment is to kick everybody off and truncate the B1 and see if it allows a good backup.  If not they are looking at an index rebuild which could take a long time.  I think this is a bit drastic but I am not familiar enough with E9 to contradict them (and only 3rd day here).

 

Thanks,

Todd Caughey

Electroimpact, Inc.

 



Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

Actually the restore fails. 


Unable to extend before-image files enough to proceed. (6743)

Check for fixed length extents. (6744)

Restore failed. (1618)

!!! ERROR - Database restore utility FAILED !!! (8564)

The B1 file is 3.3GB and we are suspecting there is a binary "magic" number around 2GB that is messing it up so we are going to try truncatiing the B1 file and backing up again to test a restore.


On Thursday, March 31, 2016 3:33 PM, "Miguel Santillan msantillan@… [vantage]" <vantage@yahoogroups.com> wrote:



 

<div id="ygrps-yiv-129574525yiv3527580491ygrp-text">
  
  
  <div>
 
Miguel A. Santillan
Compass Manufacturing Systems
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 31, 2016 2:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Online backups won't restore
 
 
Now at a 9.05.702A site and having an issue with restoring an online backup.  Backup looks like it completes OK but when restored as a Test database it can not be accessed.  The B1 file for the Live DB is pretty large and is not shrinking as is usual after a successful backup.  It appears there may be a stuck App Server but we can't tell.  Last time this happened they ended up taking the database down and it got corrupted so trying to avoid that now.
Any ideas what to look for or at that might be causing bad backups?  Plan at moment is to kick everybody off and truncate the B1 and see if it allows a good backup.  If not they are looking at an index rebuild which could take a long time.  I think this is a bit drastic but I am not familiar enough with E9 to contradict them (and only 3rd day here).
 
Thanks,
Todd Caughey
Electroimpact, Inc.
 


Disclaimer
The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

</div>
 


<div style="height:0px;color:rgb(255, 255, 255);"></div></div>
#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491 -- #ygrps-yiv-129574525yiv3527580491ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-mkp #ygrps-yiv-129574525yiv3527580491hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-mkp #ygrps-yiv-129574525yiv3527580491ads {
margin-bottom:10px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-mkp .ygrps-yiv-129574525yiv3527580491ad {
padding:0 0;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-mkp .ygrps-yiv-129574525yiv3527580491ad p {
margin:0;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-mkp .ygrps-yiv-129574525yiv3527580491ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-sponsor #ygrps-yiv-129574525yiv3527580491ygrp-lc {
font-family:Arial;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-sponsor #ygrps-yiv-129574525yiv3527580491ygrp-lc #ygrps-yiv-129574525yiv3527580491hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-sponsor #ygrps-yiv-129574525yiv3527580491ygrp-lc .ygrps-yiv-129574525yiv3527580491ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491activity span {
font-weight:700;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491activity span span {
color:#ff7900;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491activity span .ygrps-yiv-129574525yiv3527580491underline {
text-decoration:underline;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 .ygrps-yiv-129574525yiv3527580491attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 .ygrps-yiv-129574525yiv3527580491attach div a {
text-decoration:none;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 .ygrps-yiv-129574525yiv3527580491attach img {
border:none;padding-right:5px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 .ygrps-yiv-129574525yiv3527580491attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 .ygrps-yiv-129574525yiv3527580491attach label a {
text-decoration:none;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 .ygrps-yiv-129574525yiv3527580491bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 .ygrps-yiv-129574525yiv3527580491bold a {
text-decoration:none;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 dd.ygrps-yiv-129574525yiv3527580491last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 dd.ygrps-yiv-129574525yiv3527580491last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 dd.ygrps-yiv-129574525yiv3527580491last p span.ygrps-yiv-129574525yiv3527580491yshortcuts {
margin-right:0;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 div.ygrps-yiv-129574525yiv3527580491attach-table div div a {
text-decoration:none;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 div.ygrps-yiv-129574525yiv3527580491attach-table {
width:400px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 div.ygrps-yiv-129574525yiv3527580491file-title a, #ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 div.ygrps-yiv-129574525yiv3527580491file-title a:active, #ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 div.ygrps-yiv-129574525yiv3527580491file-title a:hover, #ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 div.ygrps-yiv-129574525yiv3527580491file-title a:visited {
text-decoration:none;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 div.ygrps-yiv-129574525yiv3527580491photo-title a, #ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 div.ygrps-yiv-129574525yiv3527580491photo-title a:active, #ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 div.ygrps-yiv-129574525yiv3527580491photo-title a:hover, #ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 div.ygrps-yiv-129574525yiv3527580491photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 div#ygrps-yiv-129574525yiv3527580491ygrp-mlmsg #ygrps-yiv-129574525yiv3527580491ygrp-msg p a span.ygrps-yiv-129574525yiv3527580491yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 .ygrps-yiv-129574525yiv3527580491green {
color:#628c2a;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 .ygrps-yiv-129574525yiv3527580491MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 o {
font-size:0;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491photos div {
float:left;width:72px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491reco-category {
font-size:77%;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491reco-desc {
font-size:77%;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 .ygrps-yiv-129574525yiv3527580491replbq {
margin:4px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-mlmsg select, #ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 input, #ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-mlmsg pre, #ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 code {
font:115% monospace;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-mlmsg #ygrps-yiv-129574525yiv3527580491logo {
padding-bottom:10px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-msg p#ygrps-yiv-129574525yiv3527580491attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-reco #ygrps-yiv-129574525yiv3527580491reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-sponsor #ygrps-yiv-129574525yiv3527580491ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-sponsor #ygrps-yiv-129574525yiv3527580491ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-sponsor #ygrps-yiv-129574525yiv3527580491ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-text {
font-family:Georgia;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-text tt {
font-size:120%;}

#ygrps-yiv-129574525 #ygrps-yiv-129574525yiv3527580491 #ygrps-yiv-129574525yiv3527580491ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-129574525