Restoring database servers from archive for Windows

If you archived to tape, insert the most recent level 0 tape before you run the ccmsrv restore command. If you used a directory as the archive device, you must perform some manual steps to simulate an archive device.

Procedure

  1. Restore the database server from an archive tape.

    > ccmsrv restore /device \\.\TAPE0

    \\.\TAPE0 is a tape device.

    The following warning displays:

    WARNING: this program will restore database server from an archive. All existing data will be destroyed.

    When asked to continue, type y.

    Messages like the following display on the screen:

    Please mount tape 1 on \\.\TAPE0 and press Return to continue...
    Archive Tape Information
    Tape type: Archive Backup Tape
    Online version: Informix Version 7.20.TC2
    Archive date: Mon Dec 02 08:51:17 2006
    User id: cougie
    Terminal id: ASAL
    Archive level: 0
    Tape device: \\.\TAPE0
    Tape blocksize (in k): 16
    Tape size (in k): 10240
    Tape number in series: 1
    Space to restore:1 [rootdbs]
    2 [log]
    3 [ccm]
    Archive Information
    Informix-OnLine Copyright (C)1999-2006 Informix Software, Inc.
    Initialization Time    11/26/06 10:53:31
    System Page Size       4096
    Version                4
    Archive CheckPoint Time  12/02/06 08:51:19
    Dbspaces
    number   flags   fchunk   nchunks   flags   owner      name
    1          1       1        1        N      informix   rootdbs
    2          1       2        1        N      informix   log
    3          1       3        1        N      informix   ccm
    Chunks
    chk/dbs   offset     size   free    bpages   flags     pathname
    1           1          0    2560     1246     PO-      D:\ifmxdata\rootdbs.000
    2           2          0    2048     459      PO-      D:\ifmxdata\log.000
    3           3          0    2560     1111     PO-      D:\ifmxdata\ccm.000

    You are asked to continue the restoration.

    Continue restore? (y/n)

    Type y to continue.

  2. You are asked to back up the logs.

    Do you want to back up the logs? (y/n)

    Type n.

  3. You are asked to restore a level 1 archive.

    Restore a level 1 archive? (y/n)

    For this example, you are restoring incremental archives, so type y.

  4. You are asked to insert the tape containing your most recent level 1 archive.
    Ready for level 1 tape
    Please mount tape 1 on \\.\TAPE0 and press Return to continue
    ...

    You see the information about the following page display on screen.

    Archive Tape Information
    Tape type: Archive Backup Tape
    Online version: Informix-OnLine Version 7.20.TC2
    Archive date: Mon Dec 02 08:54:52 2006
    User id: cougie
    Terminal id: ASAL
    Archive level: 1
    Tape device: \\.\TAPE0
    Tape blocksize (in k): 16
    Tape size (in k): 10240
    Tape number in series: 1
  5. You are asked to restore a level 2 archive.

    Restore a level 2 archive? (y/n)

    For this example, you are restoring incremental archives, so type y.

  6. You are asked to insert the tape containing your most recent level 2 archive.
    Ready for level 2 tape
    Please mount tape 2 on \\.\TAPE0 and press Return to continue ...

    You see the following information about the screen.

    Archive Tape Information
    Tape type: Archive Backup Tape
    Online version: Informix-OnLine Version 7.20.TC2
    Archive date: Mon Dec 02 08:57:50 2006
    User id: sue
    Terminal id: ASAL
    Archive level: 2
    Tape device: \\.\TAPE0
    Tape blocksize (in k): 16
    Tape size (in k): 10240
    Tape number in series: 	2
  7. You are asked to restore the log tapes.

    Do you want to restore log tapes? (y/n)

    Type n.

  8. The restoration finishes, and then you see the following message:
    Program over.
    Database server restored successfully.
  9. Bring the database server online.

    > ccmsrv online


Feedback