Install Oracle XE on AWS EC2

This is assuming that you already have an AWS account and have launched a T1 Micro EC2 instance

--login to your instance
login as: ec2-user
Authenticating with public key "imported-openssh-key"
Last login: Thu Jan 30 09:36:29 2014 from 195.188.99.253
[ec2-user@ec2-micro ~]$ sudo su -
[root@ec2-micro ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/xvde1 6.0G 1.8G 4.1G 31% /
none 296M 0 296M 0% /dev/shm


--Install packages

[root@ec2-micro ~]# yum install libaio bc flex
Loaded plugins: amazon-id, rhui-lb, security
rhui-REGION-client-config-server-6 | 2.6 kB 00:00
rhui-REGION-client-config-server-6/primary_db | 5.3 kB 00:00
rhui-REGION-rhel-server-releases | 3.7 kB 00:00
rhui-REGION-rhel-server-releases/primary_db | 25 MB 00:01
rhui-REGION-rhel-server-releases-optional | 3.5 kB 00:00
rhui-REGION-rhel-server-releases-optional/primary_db | 2.7 MB 00:00
Setting up Install Process
Package libaio-0.3.107-10.el6.x86_64 already installed and latest version
Package bc-1.06.95-1.el6.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package flex.x86_64 0:2.5.35-8.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version
================================================================================
Installing:
flex x86_64 2.5.35-8.el6
Transaction Summary
================================================================================
Install 1 Package(s)
Total download size: 286 k
Installed size: 724 k
Is this ok [y/N]: y
Downloading Packages:
flex-2.5.35-8.el6.x86_64.rpm
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : flex-2.5.35-8.el6.x86_64
Verifying : flex-2.5.35-8.el6.x86_64
Installed:
flex.x86_64 0:2.5.35-8.el6
Complete!

-- scp the oracle-xe.rpm.zip file to the EC2 instance

[root@ec2-micro ~]# cd /tmp
[root@ec2-micro tmp]# df -h .
Filesystem Size Used Avail Use% Mounted on
/dev/xvde1 6.0G 2.0G 3.9G 34% /

[root@ec2-micro tmp]# ls -lrt
total 308488
-rw-rw-r--. 1 ec2-user ec2-user 315891481 Oct 21 05:39 oracle-xe-11.2.0-1.0.x86_64.rpm.zip
 
-- unzip the file

[root@ec2-micro tmp]# unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
Archive: oracle-xe-11.2.0-1.0.x86_64.rpm.zip
creating: Disk1/
creating: Disk1/upgrade/
inflating: Disk1/upgrade/gen_inst.sql
creating: Disk1/response/
inflating: Disk1/response/xe.rsp
inflating: Disk1/oracle-xe-11.2.0-1.0.x86_64.rpm
[root@ec2-micro tmp]# cd Disk1
[root@ec2-micro Disk1]# ls -lrt
total 309892
-rw-rw-r--. 1 root root 317320273 Aug 29 2011 oracle-xe-11.2.0-1.0.x86_64.rpm
drwxrwxr-x. 2 root root 4096 Aug 29 2011 upgrade
drwxr-xr-x. 2 root root 4096 Aug 29 2011 response
 
-- install the rpm

[root@ec2-micro Disk1]# rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm
Preparing... ########################################### [100%]
This system does not meet the minimum requirements for swap space. Based on
the amount of physical memory available on the system, Oracle Database 11g
Express Edition requires 1180 MB of swap space. This system has 0 MB
of swap space. Configure more swap space on the system and retry the
installation.
error: %pre(oracle-xe-11.2.0-1.0.x86_64) scriptlet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping oracle-xe-11.2.0-1.0
 
-- add swap space to EC2

[root@ec2-micro Disk1]# cat /proc/meminfo | grep Swap
SwapCached: 0 kB
SwapTotal: 0 kB
SwapFree: 0 kB

[root@ec2-micro Disk1]# sudo dd if=/dev/zero of=/swapfile bs=1M count=1200
1200+0 records in
1200+0 records out
1258291200 bytes (1.3 GB) copied, 59.1424 s, 21.3 MB/s

[root@ec2-micro Disk1]# sudo mkswap /swapfile
mkswap: /swapfile: warning: don't erase bootbits sectors
on whole disk. Use -f to force.
Setting up swapspace version 1, size = 1228796 KiB
no label, UUID=c7e8a884-2262-403b-968c-dec286cd27a8

[root@ec2-micro Disk1]# sudo swapon /swapfile
[root@ec2-micro Disk1]# sudo vi /etc/fstab
[root@ec2-micro Disk1]# cat /proc/meminfo | grep Swap
SwapCached: 0 kB
SwapTotal: 1228792 kB
SwapFree: 1228792 kB

[root@ec2-micro Disk1]# pwd
/tmp/Disk1
[root@ec2-micro Disk1]# ls -lrt
total 309892
-rw-rw-r--. 1 root root 317320273 Aug 29 2011 oracle-xe-11.2.0-1.0.x86_64.rpm
drwxrwxr-x. 2 root root 4096 Aug 29 2011 upgrade
drwxr-xr-x. 2 root root 4096 Aug 29 2011 response

-- Try installing the rpm again

[root@ec2-micro Disk1]# rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm
Preparing... ########################################### [100%]
1:oracle-xe ########################################### [100%]
Executing post-install steps...
You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.

-- Run the configure process: leave defaults as they are and enter passwords

[root@ec2-micro Disk1]# /etc/init.d/oracle-xe configure
Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express
Edition. The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts. Press <Enter> to accept the defaults.
Ctrl-C will abort.
Specify the HTTP port that will be used for Oracle Application Express [8080]:
Specify a port that will be used for the database listener [1521]:
Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:
Confirm the password:
Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:y
Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
You have mail in /var/spool/mail/root

-- switch user to oracle

[root@ec2-micro oracle]# su - oracle
-bash-4.1$ pwd
/u01/app/oracle
-bash-4.1$ ls -lrt
total 24
drwxr-xr-x. 3 root root 4096 Feb 3 07:59 product
drwxr-x---. 4 oracle dba 4096 Feb 3 08:02 admin
drwxr-x---. 3 oracle dba 4096 Feb 3 08:02 fast_recovery_area
drwxr-x---. 3 oracle dba 4096 Feb 3 08:02 oradata
drwxr-xr-x. 3 oracle dba 4096 Feb 3 08:02 oradiag_oracle
drwxrwxr-x. 4 oracle dba 4096 Feb 3 08:02 diag
-bash-4.1$ cd /u01/app/oracle/product/11.2.0/xe/bin
-- setup your environment

-bash-4.1$ vi oracle_env.sh
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=$ORACLE_HOME/bin/nls_lang.sh
export PATH=$ORACLE_HOME/bin:$PATH
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 ;
export PS1="`id -un` 11g XE: "
-bash-4.1$ . ./oracle_env.sh
oracle 11g XE:

--check database/listener running

oracle 11g XE: ps -ef | grep pmon
oracle 2038 1 0 08:05 ? 00:00:00 xe_pmon_XE
oracle 25592 2156 0 08:13 pts/0 00:00:00 grep pmon

oracle 11g XE: ps -ef | grep tns
root 10 2 0 07:37 ? 00:00:00 [netns]
oracle 1788 1 0 08:02 ? 00:00:00 /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr LISTENER -inherit
oracle 25602 2156 0 08:14 pts/0 00:00:00 grep tns
oracle 11g XE: lsnrctl status LISTENER
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 03-FEB-2014 08:26:52
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 03-FEB-2014 08:02:17
Uptime 0 days 0 hr. 24 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/ec2-micro/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ec2-micro.eu-west-1.compute.internal)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ec2-micro.eu-west-1.compute.internal)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully

-- try a connection

oracle 11g XE: sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.2.0 Production on Mon Feb 3 08:23:58 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> select name from v$database;
NAME
---------
XE
SQL> conn system/**********@xe
Connected.
SQL> show user
USER is "SYSTEM"
SQL> col comp_name format a35
SQL> col comp_id format a15
SQL> set pages 1000
SQL> set lines 300
SQL> select comp_id, comp_name, version, status from dba_registry
COMP_ID COMP_NAME VERSION STATUS
--------------- ----------------------------------- ------------------------------ --------------------------------------------
APEX Oracle Application Express 4.0.2.00.09 VALID
XDB Oracle XML Database 11.2.0.2.0 VALID
CONTEXT Oracle Text 11.2.0.2.0 VALID
CATALOG Oracle Database Catalog Views 11.2.0.2.0 VALID
CATPROC Oracle Database Packages and Types 11.2.0.2.0 VALID
 
--Allow remote access to GUI

SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> exit

--disable IP tables

oracle 11g XE: exit
logout
[root@ec2-micro ~]# service iptables stop
iptables: Flushing firewall rules: [ OK ]
iptables: Setting chains to policy ACCEPT: filter [ OK ]
iptables: Unloading modules: [ OK ]
[root@ec2-micro ~]# chkconfig iptables off

--Now go to your AWS console and go to your VPC and select Security Groups on the left



--Check your security Group Click "Inbound" at bottom and add in the 8080 port and 1521 port



--Hit the "Apply Rule Changes" then test the URL:
http://your host:8080/apex/f?p=4950:1

--Now we need to add some EBS volumes to our instance for the FRA. Login to your AWS console and go to EC2 and select Volumes: 

--Click Create Volume and add in the details (create in same zone as EC2)

--Under volumes again, find the volume that was created, right click and select Attach volume:

In the Attach Volume box, specify an instance and select Attach

--In the Amazon EC2 console, in the navigation pane, click Instances, and select the gateway instance to show its details

--To make an Amazon EBS volume available for use on Linux:

[root@ec2-micro ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/xvde1 6.0G 4.8G 1.2G 81% /
none 296M 156M 140M 53% /dev/shm
--Use the lsblk command to view your available disk devices and their mount points (if applicable)
[root@ec2-micro ~]# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
xvde1 202:65 0 6G 0 disk /
xvdf 202:80 0 8G 0 disk
xvdj 202:144 0 5G 0 disk
--check the file system type
[root@ec2-micro ~]# sudo file -s /dev/xvdf
/dev/xvdf: data
[root@ec2-micro ~]# sudo file -s /dev/xvdj
/dev/xvdj: data
[root@ec2-micro ~]#
--create an ext4 filesystem
[root@ec2-micro ~]# sudo mkfs -t ext4 /dev/xvdf
mke2fs 1.41.12 (17-May-2010)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=0 blocks
524288 inodes, 2097152 blocks
104857 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=2147483648
64 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632
Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done
This filesystem will be automatically checked every 29 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.
--create mount point directory
[root@ec2-micro ~]# sudo mkdir /fra
--mount the volume on directory
[root@ec2-micro ~]# sudo mount /dev/xvdf /fra
[root@ec2-micro ~]# sudo mkfs -t ext4 /dev/xvdj
mke2fs 1.41.12 (17-May-2010)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=0 blocks
327680 inodes, 1310720 blocks
65536 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=1342177280
40 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736
Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done
This filesystem will be automatically checked every 26 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.
[root@ec2-micro ~]# sudo mkdir /data
[root@ec2-micro ~]# sudo mount /dev/xvdj /data
--check filesystem
[root@ec2-micro ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/xvde1 6.0G 4.8G 1.2G 81% /
none 296M 156M 140M 53% /dev/shm
/dev/xvdf 7.9G 146M 7.4G 2% /fra
/dev/xvdj 5.0G 138M 4.6G 3% /data
--add in to fstab so mounts available on reboot
[root@ec2-micro ~]# sudo vi /etc/fstab
LABEL=_/ / ext4 defaults 1 1
/dev/xvdb /mnt ext3 defaults,context=system_u:object_r:usr_t:s0 0 0
none /proc proc defaults 0 0
none /sys sysfs defaults 0 0
none /dev/pts devpts gid=5,mode=620 0 0
none /dev/shm tmpfs defaults 0 0
/swapfile swap swap defaults 0 0
/dev/xvdf /fra ext4 defaults 0 2
/dev/xvdj /data ext4 defaults 0 2
--change permissions/ownership of filesystems
[root@ec2-micro /]# chown -R oracle:dba /fra
[root@ec2-micro /]# chown -R oracle:dba /data
[root@ec2-micro /]# chown -R oracle:dba /u01
--Move FRA
oracle 11g XE: mkdir -p /fra/xe
oracle 11g XE: sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.2.0 Production on Tue Feb 4 08:46:57 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> show parameter db_recovery_file_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/fast_recovery_area
db_recovery_file_dest_size big integer 10G
SQL> alter system set db_recovery_file_dest='/fra/xe';
System altered.
SQL> alter system set db_recovery_file_dest_size=2G;
System altered.
SQL> show parameter db_recovery_file_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /fra/xe
db_recovery_file_dest_size big integer 2G
-configure the online logs
oracle 11g XE: mkdir -p /fra/xe/redoa
oracle 11g XE: mkdir -p /data/xe/redob
SQL> select * from v$logfile
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------------------------------------- ---
2 ONLINE /u01/app/oracle/fast_recovery_area/XE/onlinelog/o1_mf_2_9gz4zqw1_.log YES
1 ONLINE /u01/app/oracle/fast_recovery_area/XE/onlinelog/o1_mf_1_9gz4zool_.log YES
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ ------------ ------------------
1 1 1 52428800 512 1 NO INACTIVE 353178 03-FEB-14 353308 03-FEB-14
2 1 2 52428800 512 1 NO CURRENT 353308 03-FEB-14 2.8147E+14
--add a third group before deleting as have to have atleast 2

SQL> alter database add logfile group 3 ('/fra/xe/redoa/log3a.rdo','/data/xe/redob/log3b.rdo') size 100M blocksize 512 reuse;
Database altered.

SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ ------------ ------------------
1 1 1 52428800 512 1 NO INACTIVE 353178 03-FEB-14 353308 03-FEB-14
2 1 2 52428800 512 1 NO CURRENT 353308 03-FEB-14 2.8147E+14
3 1 0 104857600 512 2 YES UNUSED 0 0
SQL> alter database drop logfile group 1;
Database altered.
SQL> alter database add logfile group 1 ('/fra/xe/redoa/log1a.rdo','/data/xe/redob/log1b.rdo') size 100M blocksize 512 reuse;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ ------------ ------------------
1 1 6 104857600 512 2 NO CURRENT 363158 04-FEB-14 2.8147E+14
2 1 5 52428800 512 1 NO INACTIVE 363153 04-FEB-14 363158 04-FEB-14
3 1 4 104857600 512 2 NO INACTIVE 363147 04-FEB-14 363153 04-FEB-14
SQL> alter database drop logfile group 2;
Database altered.
SQL> alter database add logfile group 2 ('/fra/xe/redoa/log2a.rdo','/data/xe/redob/log2b.rdo') size 100M blocksize 512 reuse;
Database altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ ------------ ------------------
1 1 6 104857600 512 2 NO CURRENT 363158 04-FEB-14 2.8147E+14
2 1 0 104857600 512 2 YES UNUSED 0 0
3 1 4 104857600 512 2 NO INACTIVE 363147 04-FEB-14 363153 04-FEB-14
--enable archive logging
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 4
Current log sequence 6
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 246349824 bytes
Fixed Size 2225432 bytes
Variable Size 209717992 bytes
Database Buffers 29360128 bytes
Redo Buffers 5046272 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;
LOG_MODE
------------
ARCHIVELOG
--Set up backups
oracle 11g XE: cd /u01/app/oracle/product/11.2.0/xe/config/scripts/
oracle 11g XE: ls
backupdatabase.sh conmsg.sql initXETemp.ora oracle-xe.sles registerforonlineforum.sh rmanRestoreDatafiles.sql startdb.sql XE.sh
backup.sh gettingstarted.sh oracle-xe postDBCreation.sql restoredatabase.sh runsqlplus.sh stopall.sh XE.sql
cloneDBCreation.sql gotoonlineforum.sh oraclexe.menu postScripts.sql restore.sh sqlplus.sh stopdb.sh
CloneRmanRestore.sql init.ora oraclexe-merge.menu readdocumentation.sh rmanBackup.sql startdb.sh stopdb.sql
oracle 11g XE: ./backup.sh
Doing online backup of the database.
Backup of the database succeeded.
Log file is at /u01/app/oracle/oxe_backup_current.log.
Press ENTER key to exit
oracle 11g XE: cd /fra/xe/XE
oracle 11g XE: ls -lrt
total 12
drwxr-x---. 3 oracle dba 4096 Feb 4 09:09 backupset
drwxr-x---. 3 oracle dba 4096 Feb 4 09:10 autobackup
drwxr-x---. 3 oracle dba 4096 Feb 4 09:10 archivelog
oracle 11g XE: cat /u01/app/oracle/oxe_backup_current.log
XE Backup Log
Recovery Manager: Release 11.2.0.2.0 - Production on Tue Feb 4 09:09:06 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: XE (DBID=2719661794)
RMAN>
echo set on

RMAN> configure retention policy to redundancy 2;
using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored

RMAN> configure controlfile autobackup format for device type disk clear;
RMAN configuration parameters are successfully reset to default value

RMAN> configure controlfile autobackup on;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

RMAN> sql "create pfile=''/u01/app/oracle/product/11.2.0/xe/dbs/spfile2init.ora'' from spfile";
sql statement: create pfile=''/u01/app/oracle/product/11.2.0/xe/dbs/spfile2init.ora'' from spfile

RMAN> backup as backupset device type disk database;
Starting backup at 04-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=38 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/XE/sysaux.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/XE/system.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/XE/users.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/XE/undotbs1.dbf
channel ORA_DISK_1: starting piece 1 at 04-FEB-14
channel ORA_DISK_1: finished piece 1 at 04-FEB-14
piece handle=/fra/xe/XE/backupset/2014_02_04/o1_mf_nnndf_TAG20140204T090910_9h1x476p_.bkp tag=TAG20140204T090910 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56
Finished backup at 04-FEB-14
Starting Control File and SPFILE Autobackup at 04-FEB-14
piece handle=/fra/xe/XE/autobackup/2014_02_04/o1_mf_s_838631406_9h1x5z92_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 04-FEB-14

RMAN> configure controlfile autobackup off;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully stored

RMAN> delete noprompt obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
using channel ORA_DISK_1
no obsolete backups found

RMAN>
Recovery Manager complete.
Recovery Manager: Release 11.2.0.2.0 - Production on Tue Feb 4 09:10:11 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: XE (DBID=2719661794)
RMAN>
using target database control file instead of recovery catalog
sql statement: alter system archive log current
RMAN>
Recovery Manager complete.