Start a copy of running sqlanywhere database











up vote
0
down vote

favorite












On our server we have a backup job that takes a backup of the running database and truncates the log-file. (Parameters: dbbackup -c "" -y -t -r -n path)



The backup is then copied off server and validated.



Often we want last nights backup up for checking something. But are unable to start the backup copy on the same server as the running database, because the transaction log-file is in use.



If we try to force it to start it without transaction log-file, it still tries to access the log-file.
dbsrv12 -f -n backup wisweb.db
Error message:
Starting database "backup" (/home/sybase/db_backup/wisweb.db) at Tue Nov 20 2018 13:49
Database recovery in progress
Last checkpoint at Tue Nov 20 2018 01:06
Checkpoint log...
Transaction log: /home/sybase/db/wisweb/wisweb.log...
Direct IO disabled for file '/home/sybase/db/wisweb/wisweb.log' because the file system on which it resides does not support it
Error: Cannot open transaction log file -- Resource temporarily unavailable
Cannot open transaction log file -- Resource temporarily unavailable
Database server shutdown due to startup error
Database server stopped at Tue Nov 20 2018 13:49



What SyBooks states for the -f switch (http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbadmin/da-dbserver.html)



"If there is no transaction log, the database server performs a checkpoint recovery of the database and then shuts down—it doesn't continue to run. You can then restart the database server without the -f option for normal operation.



If there is a transaction log in the same directory as the database, the database server performs a checkpoint recovery, and a recovery using the transaction log, and then shuts down—it doesn't continue to run. You can then restart the database server without the -f option for normal operation.



Specifying a cache size when starting the server can reduce recovery time."



It clearly tries to reach the transaction log on the original location. Tried with an empty file with the same name as the transaction log, but with the same result.










share|improve this question


























    up vote
    0
    down vote

    favorite












    On our server we have a backup job that takes a backup of the running database and truncates the log-file. (Parameters: dbbackup -c "" -y -t -r -n path)



    The backup is then copied off server and validated.



    Often we want last nights backup up for checking something. But are unable to start the backup copy on the same server as the running database, because the transaction log-file is in use.



    If we try to force it to start it without transaction log-file, it still tries to access the log-file.
    dbsrv12 -f -n backup wisweb.db
    Error message:
    Starting database "backup" (/home/sybase/db_backup/wisweb.db) at Tue Nov 20 2018 13:49
    Database recovery in progress
    Last checkpoint at Tue Nov 20 2018 01:06
    Checkpoint log...
    Transaction log: /home/sybase/db/wisweb/wisweb.log...
    Direct IO disabled for file '/home/sybase/db/wisweb/wisweb.log' because the file system on which it resides does not support it
    Error: Cannot open transaction log file -- Resource temporarily unavailable
    Cannot open transaction log file -- Resource temporarily unavailable
    Database server shutdown due to startup error
    Database server stopped at Tue Nov 20 2018 13:49



    What SyBooks states for the -f switch (http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbadmin/da-dbserver.html)



    "If there is no transaction log, the database server performs a checkpoint recovery of the database and then shuts down—it doesn't continue to run. You can then restart the database server without the -f option for normal operation.



    If there is a transaction log in the same directory as the database, the database server performs a checkpoint recovery, and a recovery using the transaction log, and then shuts down—it doesn't continue to run. You can then restart the database server without the -f option for normal operation.



    Specifying a cache size when starting the server can reduce recovery time."



    It clearly tries to reach the transaction log on the original location. Tried with an empty file with the same name as the transaction log, but with the same result.










    share|improve this question
























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      On our server we have a backup job that takes a backup of the running database and truncates the log-file. (Parameters: dbbackup -c "" -y -t -r -n path)



      The backup is then copied off server and validated.



      Often we want last nights backup up for checking something. But are unable to start the backup copy on the same server as the running database, because the transaction log-file is in use.



      If we try to force it to start it without transaction log-file, it still tries to access the log-file.
      dbsrv12 -f -n backup wisweb.db
      Error message:
      Starting database "backup" (/home/sybase/db_backup/wisweb.db) at Tue Nov 20 2018 13:49
      Database recovery in progress
      Last checkpoint at Tue Nov 20 2018 01:06
      Checkpoint log...
      Transaction log: /home/sybase/db/wisweb/wisweb.log...
      Direct IO disabled for file '/home/sybase/db/wisweb/wisweb.log' because the file system on which it resides does not support it
      Error: Cannot open transaction log file -- Resource temporarily unavailable
      Cannot open transaction log file -- Resource temporarily unavailable
      Database server shutdown due to startup error
      Database server stopped at Tue Nov 20 2018 13:49



      What SyBooks states for the -f switch (http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbadmin/da-dbserver.html)



      "If there is no transaction log, the database server performs a checkpoint recovery of the database and then shuts down—it doesn't continue to run. You can then restart the database server without the -f option for normal operation.



      If there is a transaction log in the same directory as the database, the database server performs a checkpoint recovery, and a recovery using the transaction log, and then shuts down—it doesn't continue to run. You can then restart the database server without the -f option for normal operation.



      Specifying a cache size when starting the server can reduce recovery time."



      It clearly tries to reach the transaction log on the original location. Tried with an empty file with the same name as the transaction log, but with the same result.










      share|improve this question













      On our server we have a backup job that takes a backup of the running database and truncates the log-file. (Parameters: dbbackup -c "" -y -t -r -n path)



      The backup is then copied off server and validated.



      Often we want last nights backup up for checking something. But are unable to start the backup copy on the same server as the running database, because the transaction log-file is in use.



      If we try to force it to start it without transaction log-file, it still tries to access the log-file.
      dbsrv12 -f -n backup wisweb.db
      Error message:
      Starting database "backup" (/home/sybase/db_backup/wisweb.db) at Tue Nov 20 2018 13:49
      Database recovery in progress
      Last checkpoint at Tue Nov 20 2018 01:06
      Checkpoint log...
      Transaction log: /home/sybase/db/wisweb/wisweb.log...
      Direct IO disabled for file '/home/sybase/db/wisweb/wisweb.log' because the file system on which it resides does not support it
      Error: Cannot open transaction log file -- Resource temporarily unavailable
      Cannot open transaction log file -- Resource temporarily unavailable
      Database server shutdown due to startup error
      Database server stopped at Tue Nov 20 2018 13:49



      What SyBooks states for the -f switch (http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbadmin/da-dbserver.html)



      "If there is no transaction log, the database server performs a checkpoint recovery of the database and then shuts down—it doesn't continue to run. You can then restart the database server without the -f option for normal operation.



      If there is a transaction log in the same directory as the database, the database server performs a checkpoint recovery, and a recovery using the transaction log, and then shuts down—it doesn't continue to run. You can then restart the database server without the -f option for normal operation.



      Specifying a cache size when starting the server can reduce recovery time."



      It clearly tries to reach the transaction log on the original location. Tried with an empty file with the same name as the transaction log, but with the same result.







      database sybase






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 20 at 12:59









      Ove Halseth

      12




      12



























          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "3"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1376966%2fstart-a-copy-of-running-sqlanywhere-database%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown






























          active

          oldest

          votes













          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Super User!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.





          Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


          Please pay close attention to the following guidance:


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1376966%2fstart-a-copy-of-running-sqlanywhere-database%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          AnyDesk - Fatal Program Failure

          How to calibrate 16:9 built-in touch-screen to a 4:3 resolution?

          QoS: MAC-Priority for clients behind a repeater