Results 1 to 3 of 3
  1. #1
    Join Date
    May 2015
    Posts
    14

    Lightbulb Answered: Backup Online - SQL2413N

    I was trying to backup my main database and I found this error:

    SQL2413N Online backup is not allowed because the database is not recoverable
    or a backup pending condition is in effect.


    Any suggestion??


    Regards.

  2. Best Answer
    Posted by tafster

    "As Guy said, the first stop is the manual which tells you what to do
    SQL2413N

    Online backup is not allowed because the database is not recoverable or a backup pending condition is in effect.


    Explanation


    Online backup cannot be performed while the database is not logging for forward recovery as forward recovery will be required at restore time. Forward recovery is placed into effect by setting either the database configuration LOGARCHMETH1 or LOGARCHMETH2 and then performing an offline backup of the database.

    User response


    Execute an offline backup or reconfigure the database for roll-forward recovery and issue an offline backup so that subsequent online backups will be allowed"


  3. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if you look at the doc, you would notice that online backup is only allowed/possible if the db has been enabled for log-recovery
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #3
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    As Guy said, the first stop is the manual which tells you what to do
    SQL2413N

    Online backup is not allowed because the database is not recoverable or a backup pending condition is in effect.


    Explanation


    Online backup cannot be performed while the database is not logging for forward recovery as forward recovery will be required at restore time. Forward recovery is placed into effect by setting either the database configuration LOGARCHMETH1 or LOGARCHMETH2 and then performing an offline backup of the database.

    User response


    Execute an offline backup or reconfigure the database for roll-forward recovery and issue an offline backup so that subsequent online backups will be allowed
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

Tags for this Thread

Posting Permissions

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