Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2010
    Posts
    18

    Unanswered: Regarding Online Backup

    Hi,

    I am trying to online backup for 8 tablespaces

    First I have configured LOGARCHMETH1 using

    db2 update db cfg for visilog using LOGARCHMETH1 DISK:/data1/db2inst1/visilog

    and issuing command

    db2 "backup db visilog tablespace (SYSCATSPACE,TEMPSPACE1,USERSPACE1,SYSTOOLSPACE,TS 32,TS8,TSSTMP32,TSSTMP8) online"

    still i am getting error like

    [db2inst1@brahmagupta ~]$ db2 "backup db test tablespace (SYSCATSPACE,TEMPSPACE1,USERSPACE1,SYSTOOLSPACE,TS 32,TS8,TSSTMP32,TSSTMP8) online"
    SQL2421N Table space level backup is not allowed because roll-forward
    recovery is not enabled.

    Please suggest me...

  2. #2
    Join Date
    Oct 2007
    Posts
    246
    u need to force off all application and take a offline backup then only ur configured parameter gets enabled.. chk db2 get db cfg show detail and chk the LOGARCHMETH1 status...

    once offline db backup taken it will allow to take the tablespace level online backup

    regds
    Paul

  3. #3
    Join Date
    Oct 2010
    Posts
    18
    Yeah thnx alot..

    It worked...

    One more doubt, is restore procedure is same for both online and offline backups??

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Restore is the same; it's rollforward that is different.

Posting Permissions

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