Release 10.1A: OpenEdge Data Management:
Database Administration

> ## Database restore examples

> This section includes examples of database restores using PROREST. The examples use UNIX. For Windows, the only difference is the format of drive specification.

> ##### Full backup restore example

> The database administrator of Company X’s Development department wants to restore the `devel.db` database that was previously backed up.

> | To restore `devel.db` to a new database from a full backup:

> 1. Enter the following command:

>     prorest newdev /dev/rrm/0m

> The `newdev.db` database is an empty database. The 9-track tape drive (`/dev/rrm/0m`) specifies the device from which the full backup is being restored. As the restore begins, the following report appears:

>     This is a full backup of /usr1/develop/devel.db. (6759)
>     This backup was taken Wed Nov 18 15:34:43 1999. (6760)
>     The blocksize is 1024. (6990)
>     It will require a minimum of 3065 blocks to restore. (6763)
>     Read 41 blocks in 00:00:02

> This command restores the database `devel.db` from a tape to `newdev.db`. The report indicates that volume 1 is being processed.

> 2. Connect to `newdev.db` once the restore is complete.

> ##### Incremental backup restore example

> If you want to restore an incremental backup of the `devel.db` database to a new database, you must first restore a full backup.

> | To restore an incremental backup of `devel.db` to a new database:

> 1. Enter the following command to run an incremental restore of the database from a tape once the full restore is done:

>     prorest newdev /dev/rrm/0m

> The following report appears as the restore begins:

>     This is an incremental backup of /usr1/develop/devel.db. (6759)
>     This backup was taken Wed Nov 18 15:41:47 1999. (6760)
>     The blocksize is 1024. (6990)
>     It is based on the full backup of Wed Nov 18 15:34:43 1999. (6761)
>     It will require a minimum of 3065 blocks to restore. (6763)
>     Read 41 blocks in 00:00:00

> 2. Once the restore is complete, connect to `newdev.db`.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095