Browsing XML export archives using bporaimp parameters
To use the bporaimp (bporaimp64 on some platforms) command to browse XML export archives created by using bporaexp (bporaexp64 on some platforms), create a parameter file with the desired search criteria. First, set the variables LIST=Y and USERID=username/. Only the archives created using the Oracle USERID are listed.
The Oracle password is not required. The operating system account that is running bporaimp has access only to archives that were created using the same account.
Note:
Only XML export archives created using NetBackup mode are searched. Exports stored in an operating system directory using the DIRECTORY parameter are not searched.
Use the NB_ORA_SERV and NB_ORA_CLIENT parameters to specify the NetBackup server and client. Otherwise, the order of precedence for the runtime configuration variable settings is used. You can also include the LOG parameter.
Information is available on the LIST, LOG, NB_ORA_CLIENT, NB_ORA_SERV, and USERID parameters.
See About bporaimp parameters.
Table: Parameters you can include in a parameter file shows other parameters you can include in the parameter file.
Table: Parameters you can include in a parameter file
Parameter | Default | Description |
|---|---|---|
no default | Optionally specifies a start date for the archive search. Used with ARCHIVE_DATE_TO to specify a range. The date format is mm/dd/yyyy [hh:mm:ss]. | |
no default | Optionally specifies an end date for the archive search. Used with ARCHIVE_DATE_FROM to specify a range. The date format is mm/dd/yyyy [hh:mm:ss]. | |
no default | Optionally specifies a keyword phrase for NetBackup to use when searching for archives. | |
NAME | no default | The name of the primary XML schema file. |
no default | Optionally specifies a comma-separated list of table owners. | |
no default | Optionally specifies a list of table and partition names that were included in an archive. |
For example, assume you named the list parameter file bporaimp_list.param. At the command prompt, type the following:
bporaimp parfile = bporaimp_list.param