Search <book_title>...

Veritas NetBackup™ for Oracle Administrator's Guide

Last Published: 2019-06-28

Product(s): NetBackup (8.2)

About bporaexp parameters

This topic describes the available bporaexp (bporaexp64 on some platforms) parameters.

Note the following:

Use the NetBackup parameters NB_ORA_SERV, NB_ORA_CLIENT, NB_ORA_POLICY, and NB_ORA_SCHED to specify the NetBackup runtime configuration. Otherwise, the order of precedence for the runtime configuration variable settings is used.
Some parameters are valid only when you write to a storage unit. Other parameters are valid only when you write to a directory. In the following table, the Target Location column contains either Storage Unit or Directory to indicate whether the parameter in that row applies to writing to a storage unit or to a directory. Parameters that are recognized when you write to a directory are ignored when you write to a storage unit.

Table: bporaexp parameters and default values shows the available bporaexp parameters with their default values.

Table: bporaexp parameters and default values

Parameter	Required?	Default	Description	Target location
CONSISTENT	N	N	Specifies if bporaexp uses the SET TRANSACTION READ ONLY statement to ensure that the data from all tables is consistent to a single point in time and does not change during the execution of the bporaexp command. If the default of CONSISTENT=N is used, each table is exported as an independent transaction.	Directory
DIRECTORY	N	no default	Optionally specifies a directory for the output of the bporaexp utility.	Directory
HELP	N	N	Displays a help message with descriptions of bporaexp parameters. Does not export data if HELP=Y.	Directory
KEYWORD	N	no default	Optionally specifies a keyword phrase that NetBackup associates with the image being created by the archive operation. Values for KEYWORD must be in double quotes.	Storage Unit
LOG	N	no default	Optionally specifies a file name to receive informational and error messages. If so, messages are logged on the log file and not displayed to the terminal display.	Directory
NAME	Y	no default	The name of the master XML schema file.	Directory
NB_ORA_SERV	N	default master server	Optionally specifies the name of the NetBackup master server.	Storage Unit
NB_ORA_CLIENT	N	default client	Optionally specifies the name of the NetBackup for Oracle client.	Storage Unit
NB_ORA_POLICY	N	default Oracle policy	Optionally specifies the name of the NetBackup for Oracle policy.	Storage Unit
NB_ORA_SCHED	N	default backup policy schedule	Optionally specifies the name of the backup policy schedule to use.	Storage Unit
OWNER	N	no default	Lists the Oracle schema owners to export. For each owner, the tables, partitions, and views that are owned by that Oracle account are exported by default. The PARTITIONS and VIEWS parameters can be used to exclude partitions and views.	Directory
PARTITIONS	N	Y	Optionally specifies whether or not table partitions are included. Only valid when used with the OWNER parameter.	Directory
QUERY	N	no default	Selects a subset of rows from a set of tables. The value of the query parameter is a string that contains a WHERE clause for a SQL select statement that is applied to all tables and table partitions listed in the TABLES parameter. For example, if TABLES = emp, bonus and QUERY = "where job = 'SALESMAN' and sal < 1600", two SQL statements are run: *SELECTFROM emp where job='SALESMAN' and sal<1600; SELECTFROM bonus where job='SALESMAN' and sal<1600;* Each query that runs refers to a single table at a time in the FROM clause, so it is illegal to have a join in the WHERE clause.	Directory
ROW_BUFFER	N	1000	Specifies the size, in rows, of the buffer used to fetch rows. Tables with LONG columns are fetched one row at a time. The maximum value allowed is 32767.	Directory
TABLES	Y	no default	Lists the table names, view names, and partition names to export. The USERID must have SELECT privilege on the tables and views. The syntax used is:schema.table: partition name or schema.view name	Directory
USERID	Y	no default	Specifies the username/password (and optional connect string) of the user initiating the export. If a connect string is not provided, the ORACLE_SID environment variable is used.	Directory
VIEWS	N	Y	Optionally specifies whether or not views are included. Only valid when used with the OWNER parameter.	Directory