Restoring the entire database

Follow these tasks to restore IBM® Storage Protect backups as an entire database.

Procedure

To restore an entire database backup, complete the following steps:

If the database is running, enter the following command to stop the database:
```
shutdown;
```
Enter the following command to mount the database:
```
startup mount;
```
Enter the following command to start RMAN and connect to the target database and the recovery catalog:
```
rman target username/password rcvcat username/password@connect_string
```

Issue the RMAN run command by specifying the allocation of channels and the restoration of the database. The following example is from an AIX® installation:

run
{
allocate channel t1 type 'sbt_tape' parms 
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
allocate channel t2 type 'sbt_tape' parms 
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
allocate channel t3 type 'sbt_tape' parms 
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
allocate channel t4 type 'sbt_tape' parms 
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
restore database;
}

The previous example also applies to Linux™, Solaris, and HP-UX, except that the path to the tdpo.opt file differs. On Linux, Solaris and HP-UX, the path is likely to start with /opt/tivoli.

Recover the database by entering the following command to connect to the target database:
```
recover database;
```

What to do next

If your restore is not successful and you receive an error message, see the default tdpoerror.log error log file for assistance.