安装oracle 12C
停止防火墙,selinux
chkconfig iptables off
service iptables stop
vim /etc/selinux/config 修改SELINUX=disabled ,重启后生效
setenforce 0 ,不需要重启,立即生效,只限于当次
检查rpm包
rpm -q --queryformat "%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n" \
binutils \
compat-libstdc++-33 \
elfutils-libelf \
elfutils-libelf-devel \
gcc \
gcc-c++ \
glibc \
glibc-common \
glibc-devel \
glibc-headers \
ksh \
libaio \
libaio-devel \
libgcc \
libstdc++ \
libstdc++-devel \
make \
sysstat \
numactl \
unixODBC \
unixODBC-devel \
| grep "not installed" | grep -v grep | awk'{print "yum install -y " $2 }'
vi /etc/hosts
192.168.80.177 node1
vi /etc/sysctl.conf
cat >> /etc/sysctl.conf <<EOF
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
EOF
sysctl -p
vim /etc/security/limits.conf
cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
EOF
vi /etc/pam.d/login
cat >> /etc/pam.d/login <<EOF
session required pam_limits.so
EOF
session required /lib/security/pam_limits.so ---32bit
session required /lib64/security/pam_limits.so ---64bit
vi /etc/profile
cat >> /etc/profile <<EOF
if [ \$USER = "oracle" ]; then
if [ \$SHELL ="/bin/ksh" ];then
ulimit -p 16384
ulimit -n65536
else
ulimit -u 16384-n 65536
fi
fi
EOF
找到ulimit –S –c 0 > /dev/null 2>&1
改成
ulimit -S -c unlimited > /dev/null 2>&1
vi /etc/csh.login
cat >> /etc/csh.login <<EOF
if( \$USER == "oracle" ) then
limit maxproc16384
limitdescriptors 65536
umask 022
endif
EOF
/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/useradd-g oinstall -G dba oracle
passwd oracle
mkdir -p /u01/app/oracle/product/12.1.0/dbhome_1
mkdir -p /u01/app/oraInventory
chown -R oracle:oinstall /u01/app/
chmod -R 775 /u01/app/
su - oracle
vim .bash_profile
ORACLE_BASE=/u01/app/oracle
ORACLE_SID=demo
ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
export ORACLE_BASE ORACLE_SID ORACLE_HOME
export PATH=$PATH:$ORACLE_HOME/bin
或者 参考:
vim demo.env
umask 022
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
export ORACLE_SID=demo
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
exportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export PS1=$LOGNAME@`hostname`:'$PWD>'
export SQLPATH=$ORACLE_HOME/sqlplus/admin:/home/oracle/admin/sql
alias ohome="cd $ORACLE_HOME"
alias taf="tail -f/u01/app/oracle/diag/rdbms/demo/demo/trace/alert_demo.log"
ulimit -u 16384 -n 63536 #linux
esc="033["
echo " "
echo " "
echo -e "${esc}31;1m******************************************************************${esc}0m"
echo -e "${esc}31;1m***This is PRODUCT , Please becareful of your operation!***${esc}0m"
echo -e"${esc}31;1m******************************************************************${esc}0m"
echo " "
echo " "
安装
此步骤很重要,如果忽略 ,最终会提示inventory 文件目录非空 导致静默安装失败
vim /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
因为12.1的静默安装需要提供MOS的username,password 所以静默安装 12.1.0 采用 debug模式安装 ,如果有异常则更容易发现错误原因。
./runInstaller-silent -noconfig -ignorePrereq -responseFile /home/oracle/db.rsp ---会报错
cd $ORACLESOFT_mount/database
./runInstaller -silent -debug -force \
FROM_LOCATION=/mnt/hgfs/database/stage/products.xml \
oracle.install.option=INSTALL_DB_SWONLY \
UNIX_GROUP_NAME=oinstall \
INVENTORY_LOCATION=/u01/app/oraInventory \
ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 \
ORACLE_HOME_NAME="Oracle111" \
ORACLE_BASE=/u01/app/oracle \
oracle.install.db.InstallEdition=EE \
oracle.install.db.isCustomInstall=false \
oracle.install.db.DBA_GROUP=dba \
oracle.install.db.OPER_GROUP=dba \
oracle.install.db.BACKUPDBA_GROUP=dba \
oracle.install.db.DGDBA_GROUP=dba \
oracle.install.db.KMDBA_GROUP=dba \
DECLINE_SECURITY_UPDATES=true
运行到
The following configuration scripts need to be executedas the "root" user.
#!/bin/sh
#Root scripts torun
/u01/app/oracle/product/12.1.0/dbhome_1/root.sh
To execute the configuration scripts:
1. Open aterminal window
2. Log inas "root"
3. Run the scripts
4. Returnto this window and hit "Enter" key to continue
另打开一个终端 运行root.sh
最好先运行/u01/app/oraInventory/orainstRoot.sh
./u01/app/oraInventory/orainstRoot.sh
./u01/app/oracle/product/12.1.0/dbhome_1/root.sh
至此软件安装成功
直接编辑监听文件 不使用netca建立listener.ora
cat listener.ora
# listener.ora Network Configuration File:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =node1)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
grep -Ev '^(#|$)' urfile
静默安装db
安装完成oracle软件之后还没创建db,我们可以继续使用静默方式创建数据库。
cd /mnt/hgfs/database/response
[oracle@test6 response]$ grep -Ev '^(#|$)' dbca.rsp
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "orcl11g.us.oracle.com"
SID = "orcl11g"
TEMPLATENAME = "General_Purpose.dbc"
[createTemplateFromDB]
SOURCEDB = "myhost:1521:orcl"
SYSDBAUSERNAME = "system"
TEMPLATENAME = "My Copy TEMPLATE"
[createCloneTemplate]
SOURCEDB = "orcl"
TEMPLATENAME = "My Clone TEMPLATE"
[DELETEDATABASE]
SOURCEDB = "orcl"
[generateScripts]
TEMPLATENAME = "New Database"
GDBNAME = "orcl11.us.oracle.com"
[CONFIGUREDATABASE]
[ADDINSTANCE]
DB_UNIQUE_NAME = "orcl11g.us.oracle.com"
NODELIST=
SYSDBAUSERNAME = "sys"
[DELETEINSTANCE]
DB_UNIQUE_NAME = "orcl11g.us.oracle.com"
INSTANCENAME = "orcl11g"
SYSDBAUSERNAME = "sys"
grep -Ev '^(#|$)' dbca.rsp >> /home/oracle/dbca.rsp
cd /home/oracle
[oracle@node1 ~]$ vim dbca.rsp
[GENERAL]
RESPONSEFILE_VERSION = "12.1.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "demo"
SID = "demo"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "oracle"
SYSTEMPASSWORD = "oracle"
SYSMANPASSWORD = "oracle"
DBSNMPPASSWORD = "oracle"
DATAFILEDESTINATION ="/u01/app/oracle/oradata"
STORAGETYPE=FS
CHARACTERSET = "AL32UTF8"
DATABASETYPE = "MULTIPURPOSE"
AUTOMATICMEMORYMANAGEMENT = "FALSE"
TOTALMEMORY =8192
运行:
[oracle@node1 ~]$ dbca -silent -responseFile/home/oracle/dbca.rsp
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
33% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file"/u01/app/oracle/cfgtoollogs/dbca/demo/demo.log" for further details.
[oracle@node1 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
DEMO =
(DESCRIPTION =
(ADDRESS =(PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
(CONNECT_DATA=
(SERVER =DEDICATED)
(SERVICE_NAME = demo)
)
)
**********************参考
http://blog.itpub.net/22664653/viewspace-1062585/
附上oracle软件静默安装的参数含义如下:
-silent 表示以静默方式安装,不会有任何提示
-force 表示允许安装到一个非空目录
-noconfig 表示不运行配置助手netca
-responseFile 表示使用哪个响应文件,必需使用绝对路径
oracle.install.responseFileVersion 响应文件模板的版本,该参数不要更改
oracle.install.option 安装模式选项,本例只安装oracle软件,该参数不要更改
DECLINE_SECURITY_UPDATES 是否需要在线安全更新,设置为false,该参数不要更改
UNIX_GROUP_NAME oracle 用户用于安装软件的组名
INVENTORY_LOCATION oracle 产品清单目录
SELECTED_LANGUAGES oracle 运行语言环境,一般包括引文和简繁体中文
ORACLE_HOME oracle安装目录
ORACLE_BASE oracle基础目录
oracle.install.db.InstallEdition 安装版本类型,一般是企业版
oracle.install.db.isCustomInstall 是否定制安装,默认Partitioning,OLAP,RAT都选上。根据自己的需要选择组件。
oracle.install.db.customComponents 定制安装组件列表:除了以上默认的,可加上LabelSecurity和Database Vault
oracle.install.db.DBA_GROUP oracle 用户用于授予osdba权限的组名
oracle.install.db.OPER_GROUP oracle 用户用于授予osoper权限的组名
问题一 相信这个问题也是很多人也会遇到
[FATAL] [INS-32035] Unable to create a new centralinventory at the specified location.
CAUSE: The central inventory location provided is notempty.
ACTION: Please provide another location for theinventory, or clean up the current location.
解决方法:
使用root vim /etc/oraInst.doc 加入
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
问题二
[WARNING] [INS-32055] The Central Inventory is locatedin the Oracle base.
CAUSE: The Central Inventory is located in the Oraclebase.
ACTION: Oracle recommends placing this Central Inventoryin a location outside the Oracle base directory.
解决方法:
如提示所言 Inventory 目录安装在了$ORACLE_BASE 目录下了,所以调整Inventory 目录不在$ORACLE_BASE 目录下,即可解决问题。
oraInventory 存放Oracle软件安装的目录信息,Oralce的安装和升级都需要用到这个目录,删除或丢失oraInventory目录的内容就会导致安装/升级失败。
Oracle官方文档对oraInventory的说明:
All Oracle software installations rely on thisdirectory.
Ensure that you back it up regularly.
Do not delete this directory unless you have completelyremoved
all Oracle software from the system.
oraInventory 目录的位置是由oraInst.loc 文件决定的:
/etc/oraInst.loc (AIX and Linux Platform)
/var/opt/oracle/OraInst.loc (Solaris and HP-UX platform)
安装配置TSM server参考
http://www.docin.com/p-220851378.html
安装具体TSMclient参考
http://blog.sina.com.cn/s/blog_7012bd080100lug9.html
安装TSM tdop
安装tsmclient
[root@node1 Packages]# rpm -ivhcompat-libstdc++-33-3.2.3-69.el6.x86_64.rpm
[root@node1 TSM]# rpm -ivh TIVsm-API64.rpmTIVsm-API.i386.rpm TIVsm-BA.i386.rpm
安装tdop
export DISPLAY=:0.0
xhost +
./TDP-Oracle.x86_64.bin
server:
REGISTER NODE node1 junshi DOMAIN=do_vtl ARCHDELETE=YESBACKDELETE=YES
测试备份文件
dsmc selective /home/ -subdir=yes
查看备份的文件
dsmc q backup /home/ -subdir=yes
配置Oracle目录下
将ba下dsm.opt与dsm.sys拷贝到oracle目录下,并将TSMSERVER相关删除
修改tdpo.conf文件
# more tdpo.opt
***************************************************************************
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the Linux86 Data Protection forOracle
*********************************************************************
DSMI_ORC_CONFIG/opt/tivoli/tsm/client/oracle/bin/dsm.opt
DSMI_LOG /opt/tivoli/tsm/client/oracle/bin
*TDPO_FS adsmorc
TDPO_NODE ORA_JYPDGD
*TDPO_OWNER <username>
*TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin
*TDPO_DATE_FMT 1
*TDPO_NUM_FMT 1
*TDPO_TIME_FMT 1
*TDPO_MGMT_CLASS_2 mgmtclass2
*TDPO_MGMT_CLASS_3 mgmtclass3
*TDPO_MGMT_CLASS_4 mgmtclass4
为TSM目录赋oracle用户执行权限
chown -R oracle.oinstall/opt/tivoli/tsm/client/oracle/bin64
chmod -R 755 /opt/tivoli/tsm/client/oracle/bin64
chmod -R 755 /opt/tivoli/tsm/client
chown -R oracle.oinstall /opt/tivoli/tsm/client
链接libobk.so
ln -sf /opt/tivoli/tsm/client/oracle/bin64/libobk.so/usr/lib/libobk.so
ln -sf /usr/lib/libobk.so/u01/app/oracle/product/12.1.0/dbhome_1/lib/libobk.so
生成password文件
[root@node1 bin64]# ./tdpoconf password
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 5, Level 1.0
(C) Copyright IBM Corporation 1997, 2008. All rightsreserved.
***************************************************************
* IBM TivoliStorage Manager for Databases Utility
* Password fileinitialization/update program
***************************************************************
Please enter current password:
Please enter new password:
Please reenter new password for verification:
ANU0260I Password successfully changed.
[root@node1 bin64]# ls -la
total 1580
drwxrwxrwx 3 oracle oinstall 4096 Jul 31 17:01 .
drwxrwxrwx 5 oracle oinstall 4096 Jul 31 16:11 ..
-rwxrwxrwx 1 oracle oinstall 67 Mar 28 2008 agent.lic
-rwxrwxrwx 1 oracle oinstall 806 Jul 31 16:35 dsm.opt
-rwxrwxrwx 1 oracle oinstall 1017 Jul 31 16:52 dsm.sys
drwxrwxrwx 2 oracle oinstall 4096 Jul 31 16:11 en_US
-rwxrwxrwx 1 oracle oinstall 604488 Mar 28 2008 libobk.so
-rwxrwxrwx 1 oracle oinstall 507072 Mar 28 2008 tdpoconf
-rwxrwxrwx 1 oracle oinstall 114 Jul 31 16:53 tdpoerror.log
-rw-r--r-- 1 root root 48 Jul 31 17:01TDPO.node1
-rwxrwxrwx 1 oracle oinstall 712 Jul 31 16:53 tdpo.opt
-rwxrwxrwx 1 oracle oinstall 721 Mar 28 2008 tdpo.opt.smp
-rwxrwxrwx 1 oracle oinstall 460712 Mar 28 2008 tdposync
几个dsm.opt 都是一样的
/opt/tivoli/tsm/client/oracle/bin64/dsm.opt
/opt/tivoli/tsm/client/ba/bin/dsm.opt
/opt/tivoli/tsm/client/api/bin/dsm.opt
/opt/tivoli/tsm/client/api/bin64/dsm.opt
[root@node1 bin64]# cat dsm.opt
************************************************************************
* IBM Tivoli Storage Manager *
* *
* Sample Client User Options file for UNIX(dsm.opt.smp) *
************************************************************************
* This filecontains an option you can use to specify the TSM
* server tocontact if more than one is defined in your client
* system options file(dsm.sys). Copy dsm.opt.smp to dsm.opt.
* If you enter aserver name for the option below, remove the
* leadingasterisk (*).
************************************************************************
* SErvername A server name defined in the dsm.sys file
SErvername TSM_SVR1
dsm.sys:
/opt/tivoli/tsm/client/api/bin/dsm.sys
/opt/tivoli/tsm/client/api/bin64/dsm.sys
[root@node1 bin]# cat dsm.sys
************************************************************************
* IBM Tivoli Storage Manager *
* *
* Sample Client System Options file for UNIX(dsm.sys.smp) *
************************************************************************
* This filecontains the minimum options required to get started
* using TSM. Copy dsm.sys.smp to dsm.sys. In the dsm.sys file,
* enter theappropriate values for each option listed below and
* remove theleading asterisk (*) for each one.
* If your clientnode communicates with multiple TSM servers, be
* sure to add astanza, beginning with the SERVERNAME option, for
* each additionalserver.
************************************************************************
SErvername TSM_SVR1
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 192.168.80.90
NODEName node1
passwordaccess prompt
[root@node1 bin]#
/opt/tivoli/tsm/client/ba/bin
[root@node1 bin]# cat dsm.sys
************************************************************************
* IBM Tivoli Storage Manager *
* *
* Sample Client System Options file for UNIX(dsm.sys.smp) *
************************************************************************
* This filecontains the minimum options required to get started
* using TSM. Copy dsm.sys.smp to dsm.sys. In the dsm.sys file,
* enter theappropriate values for each option listed below and
* remove theleading asterisk (*) for each one.
* If your clientnode communicates with multiple TSM servers, be
* sure to add astanza, beginning with the SERVERNAME option, for
* each additionalserver.
************************************************************************
SErvername TSM_SVR1
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 192.168.80.90
NODEName node1
passwordaccess generate
/opt/tivoli/tsm/client/oracle/bin64
[root@node1 bin64]# cat dsm.sys
************************************************************************
* IBM Tivoli Storage Manager *
* *
* Sample Client System Options file for UNIX(dsm.sys.smp) *
************************************************************************
* This filecontains the minimum options required to get started
* using TSM. Copy dsm.sys.smp to dsm.sys. In the dsm.sys file,
* enter theappropriate values for each option listed below and
* remove theleading asterisk (*) for each one.
* If your clientnode communicates with multiple TSM servers, be
* sure to add astanza, beginning with the SERVERNAME option, for
* each additionalserver.
************************************************************************
SErvername TSM_SVR1
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 192.168.80.90
NODEName node1
passwordaccess generate
tdpo.opt:
[root@node1 bin64]# cat tdpo.opt
***************************************************************************
* IBM Tivoli Storage Manager for Databases
* DataProtection for Oracle
*
* Sample tdpo.opt for the LinuxAMD64 Data Protection forOracle
*********************************************************************
DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /opt/tivoli/tsm/client/oracle/bin64
*TDPO_FS /adsmorc
TDPO_NODE node1
*TDPO_OWNER <username>
TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin64
*TDPO_DATE_FMT 1
*TDPO_NUM_FMT 1
*TDPO_TIME_FMT 1
*TDPO_MGMT_CLASS_2 mgmtclass2
*TDPO_MGMT_CLASS_3 mgmtclass3
*TDPO_MGMT_CLASS_4 mgmtclass4
[root@node1 bin64]# ./tdpoconf showenv
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 5, Level 1.0
(C) Copyright IBM Corporation 1997, 2008. All rightsreserved.
Data Protection for Oracle Information
Version: 5
Release: 5
Level: 1
Sublevel: 0
Platform: 64bit TDPO LinuxAMD64
Tivoli Storage Manager Server Information
Server Name: TSM_SVR1
ServerAddress: 192.168.80.90
Server Type: Linux/i386
Server Port: 1500
CommunicationMethod: TCP/IP
Session Information
Owner Name:
Node Name: node1
Node Type: TDPO LinuxAMD64
DSMI_DIR: /opt/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_OPTFILE: /opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
PasswordDirectory: /opt/tivoli/tsm/client/oracle/bin64
Compression: FALSE
LicenseInformation: License file exists andcontains valid license data.
做一次备份测试
脚本:
run{
allocate channel c1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
backup
incremental level 0 cumulative
format "%d_full_%s_%p"
filesperset 5
database include current controlfile;
sql "alter system archive log current";
backup
format "%d_arch_%s_%p"
filesperset 20
(archivelog all delete input);
release channel c1;
}
记录:
数据库开启归档
cd /u01/app/
mkdir arch
chmod -R 777 arch
chown -R oracle:oinstall ./arch
SQL> alter system setlog_archive_dest_1='location=/u01/app/arch' scope=both;
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;
SQL> archive log list;
SQL> alter system switch logfile;
/
/
[oracle@node1 ~]$ rman target /
Recovery Manager: Release 12.1.0.1.0 - Production on ThuJul 31 17:20:58 2014
Copyright (c) 1982, 2013, Oracle and/or itsaffiliates. All rights reserved.
connected to target database: DEMO (DBID=3598448651)
RMAN> run{
2> allocate channel c1 type 'sbt_tape' parms
3>'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4> backup
5> incremental level 0 cumulative
6> format "%d_full_%s_%p"
7> filesperset 5
8> database include current controlfile;
9> sql "alter system archive log current";
10> backup
11> format "%d_arch_%s_%p"
12> filesperset 20
13> (archivelog all delete input);
14> release channel c1;
15> }
using target database control file instead of recoverycatalog
allocated channel: c1
channel c1: SID=247 device type=SBT_TAPE
channel c1: Data Protection for Oracle: version 5.5.1.0
Starting backup at 31-JUL-14
channel c1: starting incremental level 0 datafile backupset
channel c1: specifying datafile(s) in backup set
input datafile file number=00001name=/u01/app/oracle/oradata/demo/system01.dbf
input datafile file number=00003name=/u01/app/oracle/oradata/demo/sysaux01.dbf
input datafile file number=00004name=/u01/app/oracle/oradata/demo/undotbs01.dbf
input datafile file number=00006name=/u01/app/oracle/oradata/demo/users01.dbf
channel c1: starting piece 1 at 31-JUL-14
channel c1: finished piece 1 at 31-JUL-14
piece handle=DEMO_full_3_1 tag=TAG20140731T172111comment=API Version 2.0,MMS Version 5.5.1.0
channel c1: backup set complete, elapsed time: 00:07:05
channel c1: starting incremental level 0 datafile backupset
channel c1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel c1: starting piece 1 at 31-JUL-14
channel c1: finished piece 1 at 31-JUL-14
piece handle=DEMO_full_4_1 tag=TAG20140731T172111comment=API Version 2.0,MMS Version 5.5.1.0
channel c1: backup set complete, elapsed time: 00:00:03
Finished backup at 31-JUL-14
sql statement: alter system archive log current
Starting backup at 31-JUL-14
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=10 RECID=1STAMP=854385647
input archived log thread=1 sequence=11 RECID=2STAMP=854385648
input archived log thread=1 sequence=12 RECID=3STAMP=854385653
input archived log thread=1 sequence=13 RECID=4STAMP=854385653
input archived log thread=1 sequence=14 RECID=5STAMP=854385653
input archived log thread=1 sequence=15 RECID=6STAMP=854386103
input archived log thread=1 sequence=16 RECID=7STAMP=854386104
channel c1: starting piece 1 at 31-JUL-14
channel c1: finished piece 1 at 31-JUL-14
piece handle=DEMO_arch_5_1 tag=TAG20140731T172824comment=API Version 2.0,MMS Version 5.5.1.0
channel c1: backup set complete, elapsed time: 00:00:01
channel c1: deleting archived log(s)
archived log file name=/u01/app/arch/1_10_854378318.dbfRECID=1 STAMP=854385647
archived log file name=/u01/app/arch/1_11_854378318.dbfRECID=2 STAMP=854385648
archived log file name=/u01/app/arch/1_12_854378318.dbfRECID=3 STAMP=854385653
archived log file name=/u01/app/arch/1_13_854378318.dbfRECID=4 STAMP=854385653
archived log file name=/u01/app/arch/1_14_854378318.dbfRECID=5 STAMP=854385653
archived log file name=/u01/app/arch/1_15_854378318.dbfRECID=6 STAMP=854386103
archived log file name=/u01/app/arch/1_16_854378318.dbfRECID=7 STAMP=854386104
Finished backup at 31-JUL-14
released channel: c1