Hello everybody
I created a Oracle Database Template for my Oracle Database that runs over a Windows Server 2003.
This backup has to be a cold backup, because the archivelog were not running.
There is a option in Wizard Oracle Tempalte that bring the database offline before backup and then bring it up after backup.
I choosed that options, but when I took a look at the template, there wasn´t a command shutdown or startup in the template.
How can my Netbackup 773 will perform this shutdown an startup commands?
more /usr/openv/netbackup/db/dbtemplates/oracle/svponto-oracle-off.tpl
#^oracle template configuration file <<MUST BE FIRST IN FILE, DO NOT REMOVE>>
# -----------------------------------------------------------------
# Veritas NetBackup for oracle: Backup Configuration Template
# $Copyright: Copyright (c) 2016 Veritas Technologies LLC. All rights reserved VT25-0977-2658-84-51-3 $
#
# Template level: 1.9.0
# Generated on: 08/25/16 13:56:58
# -----------------------------------------------------------------
TEMPLATE_ID1=10331
TEMPLATE_ID2=4308
TEMPLATE_OWNER=administrator
# -----------------------------------------------------------------
# BACKUP_TYPE is derived from the schedule type when this script
# is used in a NetBackup scheduled backup. For example, when:
# schedule type is BACKUP_TYPE is
# ---------------- --------------
# Automatic Full INCREMENTAL LEVEL=0
# Automatic Differential Incremental INCREMENTAL LEVEL=1
# Automatic Cumulative Incremental INCREMENTAL LEVEL=1 CUMULATIVE
#
# For a non-proxy user initiated backup, BACKUP_TYPE is defined as shown.
# -----------------------------------------------------------------
BACKUP_TYPE=INCREMENTAL LEVEL=0
PRE_AUTO_MOUNT=Y
ORACLE_HOME=c:\oraclexe\app\oracle\product\10.2.0\server
ORACLE_SID=XE
TARGETDB_LOGIN=sys
TARGETDB_PASSWD=4f0e904261b561aa1c3f8950488982ccbd491e4c2e23b8fff58a4bc447151d662aaf60367771e566d58468fea199eedc9c627a10a202f628fdb46e9c81c6597a
TARGETDB_TNSNAME=XE
POST_AUTO_OPEN=Y
# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------
RUN {
ALLOCATE CHANNEL ch00
TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01
TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=svponto,NB_ORA_SID=XE,NB_ORA_POLICY=svponto-oracle-offline,NB_ORA_SERV=svbackup7,NB_ORA_SCHED=full';
BACKUP
INCREMENTAL LEVEL=0
FORMAT 'bk_d%d_u%u_s%s_p%p_t%t'
DATABASE;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
# Control File Backup
ALLOCATE CHANNEL ch00
TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=svponto,NB_ORA_SID=XE,NB_ORA_POLICY=svponto-oracle-offline,NB_ORA_SERV=svbackup7,NB_ORA_SCHED=full';
BACKUP
FORMAT 'ctrl_u%u_s%s_p%p_t%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
