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 | 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 | |
N | no default | Optionally specifies a directory for the output of the bporaexp utility. | Directory | |
HELP | N | Displays a help message with descriptions of bporaexp parameters. Does not export data if HELP=Y. | Directory | |
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 | 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 | no default | The name of the master XML schema file. | Directory | |
NB_ORA_SERV | default master server | Optionally specifies the name of the NetBackup master server. | Storage Unit | |
NB_ORA_CLIENT | default client | Optionally specifies the name of the NetBackup for Oracle client. | Storage Unit | |
NB_ORA_POLICY | default Oracle policy | Optionally specifies the name of the NetBackup for Oracle policy. | Storage Unit | |
NB_ORA_SCHED | default backup policy schedule | Optionally specifies the name of the backup policy schedule to use. | Storage Unit | |
OWNER | 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 | Y | Optionally specifies whether or not table partitions are included. Only valid when used with the OWNER parameter. | Directory | |
QUERY | 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:
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 | 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 | 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 | 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 | Y | Optionally specifies whether or not views are included. Only valid when used with the OWNER parameter. | Directory |