#***************************************************************************
# $Copyright: Copyright (c) 2022 Veritas Technologies LLC. All rights reserved $
#***************************************************************************
#
# ---------------------------------------------------------------------------
#                  bporaexp_tables_rows.param
# ---------------------------------------------------------------------------
#
#  Archives rows from multiple tables using a NetBackup Policy.
#
#  Script run by:
#      bporaexp parfile=bporaexp_tables_rows.param
#
# ---------------------------------------------------------------------------
#
#  Maximum number of rows fetched at a time
#
ROW_BUFFER = 1000
#
#  Use SET TRANSACTION READ ONLY so that each table that is archived
#  is consistent to a single point in time
#
CONSISTENT = Y
#
#  Keyword phrase that NetBackup associates with the archive
#
KEYWORD = "ArchiveName Keywords"
#
#  Name of the archive
#  The master XML schema file will be called ArchiveName.xsd
#
NAME = ArchiveName
#
#  Names of the tables to be archived
#  The userid must have SELECT access on all tables
#
TABLES = username1.table1, username2.table2
#
#  Query that restricts the rows to be selected
#  The where clause must apply to all tables listed in the TABLES parameter
#
QUERY = "where column1 = 'SALES'"
#
#  Oracle login credentials 
#
USERID = username1/password
#
#  File name to receive informational and error messages
#
LOG = /db/oracle/logs/archive/bporaexp_tables.log
#
#  NetBackup master server
#
NB_ORA_SERV = ServerName
#
#  NetBackup Oracle client
#
NB_ORA_CLIENT = ClientName
#
#  NetBackup Oracle policy
#
NB_ORA_POLICY = PolicyName
#
#  NetBackup Oracle backup policy schedule
#
NB_ORA_SCHED = Default-Application-Backup