The restoreFile command initiates an offline restore of all database files specified in the file-list argument from the backup directory specified by using the backupDir argument to the database location (which must be valid on the server) specified in the path argument.
The restoreFile command enables you to restore groups of database files concurrently by executing jdbutilb processes to exploit hardware parallelism, if available. Information or errors from the file restore operation are recorded in the recovery.log file located in the directory specified in the
The syntax of the restoreFile command in the jdbutilb command line is as follows.
jdbutilb path=database-path ini=initialization-file-name restoreFile backupDir=backup-directory file-list [clearFilePaths] [excludeFrozenFiles] [excludeFrozenPartitions] [verify] [nostatus]
When you restore a file:
The first database file in the restored file list must be the control file (that is, _control.dat).
After you have restored the control file, you can initiate concurrent file restore operations by creating multiple jdbutilb processes.
Each file in a list is space-separated.
Specify only the file prefix; that is, do not include the .dat file suffix.
Simple file masks are not supported; for example, a file list of _user* is invalid.
When restoring the database control file (_control.dat), the restoreinfo file in the database directory is created. If you do not want frozen (read-only) files or partitions carried over from the backupinfo file to the restoreinfo file, specify the optional excludeFrozenFiles or excludeFrozenPartitions argument, respectively. This will cause the excluded files and partitions to be marked offline, when the restored database is initialized.
Owing to increased disk contention and disk head movement, concurrent restore operations run slower if the restore is sent to a single disk drive.
If errors are encountered during the file restore operation, you will not be able to use the database. Do not use the database until all files are restored.
The following example shows the use of the restoreFile command in the jdbutilb command line to restore the userdata1.dat and userdata2.dat files from the last backup made to the e:\jade\backup3103 directory.
jdbutilb path=d:\jade\system ini=d:\jade\jade.ini restore backupDir=e:\jade\backup3103 _control userdata1 userdata2 verify nostatus