Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2004
    Posts
    6

    Unanswered: How to backup DB and AP on one tape?

    Hi,

    I've only one tape driver on my Informix server.
    I need to backup Informix and applications on one tape via cron job.
    What shall I do? How can I "ontape" databases and "tar" applications to one
    tape? And, How to restore them?
    Thank.

  2. #2
    Join Date
    May 2004
    Posts
    45
    I don't think it's possible since ontape and tar are different formats - each will be unaware of the other's presence on the tape. If you really have to backup both the server and filesystem together you may need to move to the dbspace file format as opposed to raw devices. That way the dbspace files will be visible to tar and can be backed up as part of the filesystem. The only drawback would be referential-integrity issues - don't have transaction-processing occuring when you are backing up the dbspace files!
    Keith Brownlow
    ServerMetrics DB Monitoring (www.servermetrics.com)

  3. #3
    Join Date
    Apr 2004
    Location
    zxczxczxc
    Posts
    52

    How to backup DB and AP on one tape?

    Hi,
    Do a Ontape on to the disk itself and backup all the filesystems with tar.
    If u want to resore the same, extract the ontape backup from tape to disk and perform a restore.

    Bye.
    zxczxczc

  4. #4
    Join Date
    Jul 2004
    Posts
    6
    What command or syntax can let "ontape" to save the DB to disk instead of backuping to tape?
    Thank you.

  5. #5
    Join Date
    Apr 2004
    Location
    zxczxczxc
    Posts
    52

    How to backup DB and AP on one tape?

    Hi,
    Change the TAPEDEV parameter to the file you want to backup the DB. eg
    TAPEDEV /software/newdbtar/backup2007. Also change the TAPEBLK size accordingly and do a ontape -s -L 0 at command prompt. This will backup your DB to the file you specified. Then you can take a tar of the filesystem.

    bye.
    zxczxczc

  6. #6
    Join Date
    Feb 2004
    Posts
    32
    There is a way to do this without overwriting, check with your sysadmin.
    When you run ontape, the backup completes and then rewinds the tape which makes the tape viable for destruction if another backup( in your case the file system backup) is run. There is a way to instruct ontape not to rewind the tape after the backup is completed.

    Hope you find that option.

    -Abraham

Posting Permissions

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