Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    3

    Unanswered: load transaction error

    I loaded the database and transaction from server A to a separate server B, then online the database. After several minutes I make a dump transaction from the server A then I load it to the server B then i get this error message

    There was activity on database since last load, unable to load. Must restart load sequence with the load database to continue.

    What should i do? i dont want to load database again if possible.

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    Once the database has been onlined you can no longer load transaction dumps to it.

    The alternative is to make your DUMP TRANSACTIONS with the FOR STANDBY ACCESS option. Then you can ONLINE your database with the FOR STANDBY ACCESS option, and continue loading your transaction dumps.

    Please read the manual (in particular the System & Admin guide chapter on backups and recovery) to understand how these options interact.

    Michael

  3. #3
    Join Date
    Sep 2006
    Posts
    3
    Thanks Michael

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •