Gurpartap Singh's Blog

Friday, December 25, 2015

Post 65 of the Series - Steps to change the IP of the existing VM's on Oracle Cluster without de-installing anything

By His Command, souls come into being; by His Command, glory and greatness are obtained.

By His Command, some are high and some are low; by His Written Command, pain and pleasure are obtained.

Some, by His Command, are blessed and forgiven; others, by His Command, wander aimlessly forever.

Everyone is subject to His Command; no one is beyond His Command.

O Nanak, one who understands His Command, does not speak in ego.

Index of all the posts of Gurpartap Singh's Blog

Here are the steps to do the ip change on the VM's that we have created. No need to do the full install for new VM.

just make the copy of your existing VM and change the ip's of the VM's and you will be able to run multiple clusters in the same network.

After ip change run machines on different computer or on the same computer. Only draw backup is that we cannot change the hostname of the VM's.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

#########

Change ip's on dbnodes:

On VM execute:

vi /etc/sysconfig/network-scripts/ifcfg-eth0 - IP change

vi /etc/sysconfig/network-scripts/ifcfg-eth1 - IP change

vi /etc/sysconfig/network-scripts/ifcfg-eth2 - IP change

vi /etc/sysconfig/network-scripts/ifcfg-eth3 - IP change

vi /etc/resolv.conf_shld_be - DNS change

vi /etc/hosts -

cd /etc/udev/rules.d/

rm 70-persistent-net.rules - Let server pick new IP's IP change

Cluster will come-up fine

=======

Fix the SCAN:

nslookup lv-lnp-db62-scan

$GRID_HOME/bin/srvctl config scan

$GRID_HOME/bin/srvctl stop scan_listener

$GRID_HOME/bin/srvctl stop scan

sudo /opt/app/oracle/grid11204/bin/srvctl modify scan -n lv-lnp-db62-scan

$GRID_HOME/bin/srvctl config scan

$GRID_HOME/bin/srvctl start scan

$GRID_HOME/bin/srvctl start scan_listener

$GRID_HOME/bin/srvctl modify scan_listener -u

sudo /opt/app/oracle/grid11204/bin/srvctl status scan

$GRID_HOME/bin/srvctl status scan_listener

reboot to make sure al looks good

#########

If you want to do the storage change as well then do the following:

So, that this storage is used only by new nodes that we just changed

#########

On db nodes execute the folowing

/u01/app/12.1.0.0/grid/bin/crsctl stop crs

/u01/app/12.1.0.0/grid/bin/crsctl disable crs

#########

On filer VM execute:

vi /etc/sysconfig/network-scripts/ifcfg-eth0 - IP change

vi /etc/sysconfig/network-scripts/ifcfg-eth1 - IP change

vi /etc/sysconfig/network-scripts/ifcfg-eth2 - IP change

vi /etc/sysconfig/network-scripts/ifcfg-eth3 - IP change

vi /etc/resolv.conf_shld_be - DNS change

vi /etc/hosts -

cd /etc/udev/rules.d/

rm 70-persistent-net.rules - Let server pick new IP's IP change

On dbnodes execute following to point to new storage:

service iscsi restart (may hang, just hit enter and after sometime control+c)

vi /etc/hosts (keep old filer entry and add new filer entry) thne entries will look like :

# iSCSI SAN Server

10.10.1.216 filer02.rac.meditate.com filer02

10.10.1.156 filer03.rac.meditate.com filer03

Delete the iscsi entry pointing to old filer:

iscsiadm -m node -o delete --portal 10.10.1.216:3260

Restart the iscsi, I just got stopping iscsi as:

[root@rac90 ~]# service iscsi restart

Stopping iscsi: [ OK ]

[root@rac90 ~]#

Add new ip to the server for filer:

iscsiadm -m discovery -t sendtargets -p 10.10.1.146

I got:

[root@rac90 ~]# iscsiadm -m discovery -t sendtargets -p 10.10.1.146

10.10.1.156:3260,1 iqm.mgmt.volumes-san

Update server to start iscsi at every reboot:

chkconfig --level 345 iscsi on

Bounce

and after bounce u should be able to see the disks

ls -lart /dev/asm*

enable crs

/u01/app/12.1.0.0/grid/bin/crsctl enable crs

start crs

/u01/app/12.1.0.0/grid/bin/crsctl start crs

All should come-up fine

Enjoy and have FUN !

Great is His greatness, as great as His Name.

Great is His greatness, as True is His justice.

Great is His greatness, as permanent as His Throne.

Great is His greatness, as He knows our utterances.

Great is His greatness, as He understands all our affections.

Great is His greatness, as He gives without being asked.

Great is His greatness, as He Himself is all-in-all.

O Nanak, His actions cannot be described.

Whatever He has done, or will do, is all by His Own Will.

Sunday, August 10, 2014

Post 64 of Series - Some errors and their fixes

FOURTH MEHL: Great is the greatness of that humble being, whom the Guru Himself anointed in His Presence. All the world comes and bows to him, falling at his feet. His praises spread throughout the world. The galaxies and solar systems bow in reverence to him; the Perfect Guru has placed His hand upon his head, and he has become perfect. The glorious greatness of the Guru increases day by day; no one can equal it. O servant Nanak, the Creator Lord Himself established him; God reserves his honor.

Index of all the posts of Gurpartap Singh's Blog

CRS-0245: User doesn't have enough privilege to perform the operation

When you try to add 11gR2 database on 12c cluster (Grid Infrastructure) using the following commands, you get and error after first command as:

srvctl add database -d SDIEGO -o /u01/app/oracle/product/database/11.2.0.3 -p '+DATA/SDIEGO/PARAMETERFILE/spfile.268.830972273'
srvctl add instance -d SDIEGO -i SDIEGO1 -n rac20
srvctl add instance -d SDIEGO -i SDIEGO2 -n rac21

16:42 : oracle : rac20.rac.meditate.com : @DUMMY : /u01/app/oracle/product/database/11.2.0.3
$ srvctl add database -d SDIEGO -o /u01/app/oracle/product/database/11.2.0.3 -p '+DATA/SDIEGO/PARAMETERFILE/spfile.268.830972273'
PRCR-1006 : Failed to add resource ora.sdiego.db for sdiego
PRCD-1184 : Failed to upgrade configuration of database type to version 11.2.0.3.0
PRCR-1071 : Failed to register or update resource type ora.database.type
CRS-0245: User doesn't have enough privilege to perform the operation

Fix is:

On 12c cluster the default value is :

[root@rac20 ~]# /u01/app/grid/12.1.0.0/bin/crsctl status type ora.database.type -p | grep DEFAULT_VALUE=owner
DEFAULT_VALUE=owner:root:rwx,pgrp:oinstall:rwx,other::r--,group:oinstall:r-x,user:oracle:r-x

Update the permissions for both and service using following commands as root:

/u01/app/grid/12.1.0.0/bin/crsctl modify type ora.database.type -attr "ATTRIBUTE=TYPE_ACL, DEFAULT_VALUE='owner:root:rwx,pgrp:dba:rwx,other::r--,group:dba:r-x,user:oracle:rwx'"
/u01/app/grid/12.1.0.0/bin/crsctl modify type ora.service.type -attr "ATTRIBUTE=TYPE_ACL, DEFAULT_VALUE='owner:root:rwx,pgrp:dba:rwx,other::r--,group:dba:r-x,user:oracle:rwx'"

as :

[root@rac20 ~]# /u01/app/grid/12.1.0.0/bin/crsctl modify type ora.database.type -attr "ATTRIBUTE=TYPE_ACL, DEFAULT_VALUE='owner:root:rwx,pgrp:dba:rwx,other::r--,group:dba:r-x,user:oracle:rwx'"
[root@rac20 ~]# /u01/app/grid/12.1.0.0/bin/crsctl modify type ora.service.type -attr "ATTRIBUTE=TYPE_ACL, DEFAULT_VALUE='owner:root:rwx,pgrp:dba:rwx,other::r--,group:dba:r-x,user:oracle:rwx'"
[root@rac20 ~]#

Now add the database as:

16:45 : oracle : rac20.rac.meditate.com : @DUMMY : /u01/app/oracle/product/database/11.2.0.3
$ srvctl add database -d SDIEGO -o /u01/app/oracle/product/database/11.2.0.3 -p '+DATA/SDIEGO/PARAMETERFILE/spfile.268.830972273'

16:49 : oracle : rac20.rac.meditate.com : @DUMMY : /u01/app/oracle/product/database/11.2.0.3
$ srvctl add instance -d SDIEGO -i SDIEGO1 -n rac20

16:49 : oracle : rac20.rac.meditate.com : @DUMMY : /u01/app/oracle/product/database/11.2.0.3
$ srvctl add instance -d SDIEGO -i SDIEGO2 -n rac21

16:49 : oracle : rac20.rac.meditate.com : @DUMMY : /u01/app/oracle/product/database/11.2.0.3
$

He Himself created the world, O my Lord of the Universe; the Lord Himself plays in so many ways! Some enjoy enjoyments, O my Lord of the Universe, while others wander around naked, the poorest of the poor. He Himself created the world, O my Lord of the Universe; the Lord gives His gifts to all who beg for them. His devotees have the Support of the Naam, O my Lord of the Universe; they beg for the sublime sermon of the Lord.

Saturday, August 2, 2014

Post 63 of Series : Restore Oracle Database on 11gr2 RAC using RMAN from Tape using Oracle Secure Backup (OSB)

AASAA, FIRST MEHL: There are six systems of philosophy, six teachers, and six doctrines; but the Teacher of teachers is the One Lord, who appears in so many forms. || 1 || That system, where the Praises of the Creator are sung — follow that system; in it rests greatness. || 1 || Pause || As the seconds, minutes,

hours, days, weekdays months and seasons all originate from the one sun, O Nanak, so do all forms originate from the One

Creator. || 2 || 30 ||

Index to all the posts of Gurpartap Singh's Blog

Lets restore the database using Oracle Secure Backup (OSB).

Stop the database and drop all the datafiles and controlfiles from ASM.

After dropping all the datafiles and the controlfiles, now lets restore hte database from tape on using Oracle Secure Backup (OSB)

Restore controlfile from tape:
SQL> select dbid from v$database;

DBID
----------
3927905288

SQL> show parameter control

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string +DATA/sdiego/controlfile/curre
nt.260.830971465
control_management_pack_access string DIAGNOSTIC+TUNING
SQL>

SQL> alter system set control_files='+DATA','+FLASH' scope=spfile;

System altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

22:47 : oracle : rac70.rac.meditate.com : @SDIEGO1 : /home/oracle
$ srvctl stop database -d SDIEGO

22:49 : oracle : rac70.rac.meditate.com : @SDIEGO1 : /home/oracle
$

22:49 : oracle : rac70.rac.meditate.com : @SDIEGO1 : /home/oracle
$

rman target /
set DBID=3927905288
run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
RESTORE CONTROLFILE FROM '3jp6ktn6_1_1';
release channel ch00;
}

22:49 : oracle : rac70.rac.meditate.com : @SDIEGO1 : /home/oracle
$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 29 22:49:28 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 384143360 bytes
Fixed Size 2228624 bytes
Variable Size 243273328 bytes
Database Buffers 134217728 bytes
Redo Buffers 4423680 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

22:49 : oracle : rac70.rac.meditate.com : @SDIEGO1 : /home/oracle
$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Apr 29 22:49:51 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: SDIEGO (not mounted)

RMAN> set DBID=3927905288
run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
RESTORE CONTROLFILE FROM '3jp6ktn6_1_1';
release channel ch00;
}
executing command: SET DBID

RMAN> 2> 3> 4> 5>

using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: SID=34 instance=SDIEGO1 device type=SBT_TAPE
channel ch00: Oracle Secure Backup

Starting restore at 29-APR-14

channel ch00: restoring control file
channel ch00: restore complete, elapsed time: 00:00:46
output file name=+DATA/sdiego/controlfile/current.275.846197443
output file name=+FLASH/sdiego/controlfile/current.318.846197447
Finished restore at 29-APR-14

released channel: ch00

RMAN>

23:01 : oracle : rac70.rac.meditate.com : @SDIEGO1 : /home/oracle

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 29 23:01:50 2014

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

SQL> show parameter control

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

control_file_record_keep_time integer 7

control_files string +DATA/sdiego/controlfile/curre

nt.275.846197443, +FLASH/sdieg

o/controlfile/current.318.8461

97447

control_management_pack_access string DIAGNOSTIC+TUNING

SQL> alter database mount;

Database altered.

SQL>

rman target /

run

{

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';

ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';

set until time "to_date('2014-04-25 19:05:04','YYYY-MM-DD hh24:mi:ss')";

RESTORE DATABASE;

recover database;

release channel t1;

release channel t2;

}

RMAN> run

{
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
set until time "to_date('2014-04-25 19:05:04','YYYY-MM-DD hh24:mi:ss')";
RESTORE DATABASE;
recover database;
release channel ch00;
release channel ch01;
}2> 3> 4> 5> 6> 7> 8> 9> 10>

allocated channel: ch00
channel ch00: SID=37 instance=SDIEGO1 device type=SBT_TAPE
channel ch00: Oracle Secure Backup

allocated channel: ch01
channel ch01: SID=38 instance=SDIEGO1 device type=SBT_TAPE
channel ch01: Oracle Secure Backup

executing command: SET until clause

Starting restore at 29-APR-14

channel ch00: starting datafile backup set restore
channel ch00: specifying datafile(s) to restore from backup set
channel ch00: restoring datafile 00001 to +DATA/sdiego/datafile/system.256.830971357
channel ch00: restoring datafile 00003 to +DATA/sdiego/datafile/undotbs1.258.830971359
channel ch00: restoring datafile 00005 to +DATA/sdiego/datafile/example.264.830971505
channel ch00: restoring datafile 00010 to +DATA/sdiego/datafile/ggdata.272.839362901
channel ch00: reading from backup piece 3ip6kt8k_1_1
channel ch01: starting datafile backup set restore
channel ch01: specifying datafile(s) to restore from backup set
channel ch01: restoring datafile 00002 to +DATA/sdiego/datafile/sysaux.257.830971359
channel ch01: restoring datafile 00004 to +DATA/sdiego/datafile/users.259.845573737
channel ch01: restoring datafile 00006 to +DATA/sdiego/datafile/undotbs2.265.830971971
channel ch01: restoring datafile 00007 to +DATA/sdiego/datafile/read.269.838771155
channel ch01: restoring datafile 00008 to +DATA/sdiego/datafile/goldengate.270.839193779
channel ch01: reading from backup piece 3hp6kt8j_1_1
channel ch00: piece handle=3ip6kt8k_1_1 tag=TAG20140425T185307
channel ch00: restored backup piece 1
channel ch00: restore complete, elapsed time: 00:05:05
channel ch01: piece handle=3hp6kt8j_1_1 tag=TAG20140425T185307
channel ch01: restored backup piece 1
channel ch01: restore complete, elapsed time: 00:06:46
Finished restore at 29-APR-14

Starting recover at 29-APR-14
datafile 7 not processed because file is read-only

starting media recovery

archived log for thread 1 with sequence 414 is already on disk as file +FLASH/sdiego/archivelog/2014_04_25/thread_1_seq_414.286.845838239
archived log for thread 1 with sequence 415 is already on disk as file +FLASH/sdiego/archivelog/2014_04_26/thread_1_seq_415.290.845870441
archived log for thread 2 with sequence 340 is already on disk as file +FLASH/sdiego/archivelog/2014_04_25/thread_2_seq_340.284.845838235
archived log for thread 2 with sequence 341 is already on disk as file +FLASH/sdiego/archivelog/2014_04_25/thread_2_seq_341.287.845849531
archived log file name=+FLASH/sdiego/archivelog/2014_04_25/thread_1_seq_414.286.845838239 thread=1 sequence=414
archived log file name=+FLASH/sdiego/archivelog/2014_04_25/thread_2_seq_340.284.845838235 thread=2 sequence=340
archived log file name=+FLASH/sdiego/archivelog/2014_04_26/thread_1_seq_415.290.845870441 thread=1 sequence=415
archived log file name=+FLASH/sdiego/archivelog/2014_04_25/thread_2_seq_341.287.845849531 thread=2 sequence=341
media recovery complete, elapsed time: 00:00:15
Finished recover at 29-APR-14

released channel: ch00
released channel: ch01
RMAN>

obtool documentation:

http://docs.oracle.com/cd/E14812_01/doc/doc.103/e12838/obtool_commands.htm

http://docs.oracle.com/cd/B19306_01/install.102/b14235/obins_uninst.htm

O my wandering mind, you are like a camel — how will you meet the Lord, your Mother? When I found the Guru, by the

destiny of perfect good fortune, my Beloved came and embraced me. || 1 || O camel-like mind, meditate on the True Guru,

the Primal Being. || 1 || Pause || O camel-like mind, contemplate the Lord, and meditate on the Lord’s Name. When you

are called to answer for your account, the Lord Himself shall release you. || 2 || O camel-like mind, you were once very

pure; the filth of egotism has now attached itself to you. Your Beloved Husband is now manifest before you in your own home,

but you are separated from Him, and you suffer such pain! || 3 || O my beloved camel-like mind, search for the Lord within

your own heart. He cannot be found by any device; the Guru will show you the Lord within your heart. || 4 || O my beloved

camel-like mind, day and night, lovingly attune yourself to the Lord. Return to your own home, and find the palace of love;

meet the Guru, and meet the Lord. || 5 ||

Post 62 of Series : Backup Oracle Database on 11gr2 RAC using RMAN to Tape using Oracle Secure Backup (OSB)

The Name of the Lord — this alone is my wealth. I do not tie it up to hide it, nor do I sell it to make my living. || 1 || Pause || The Name is my crop, and the Name is my field. As Your humble servant, I perform devotional worship to You; I seek Your Sanctuary. || 1 || The Name is Maya and wealth for me; the Name is my capital. I do not forsake You; I do not know any

other at all. || 2 || The Name is my family, the Name is my brother. The Name is my companion, who will help me in the

end. || 3 || One whom the Lord keeps detached from Maya — says Kabeer, I am his slave.

Index to all the posts of Gurpartap Singh's Blog

Add 3 more tapes making them 4 tapes now :
ob> mkdev -t tape -o -a rac71:/vt2 -v -l vlib -d 2 vt2
ob> mkdev -t tape -o -a rac71:/vt3-v -l vlib -d 3 vt3
ob> mkdev -t tape -o -a rac71:/vt4 -v -l vlib -d 4 vt4
ob>
ob> lsvol -l -L vlib
Inventory of library vlib:
in mte: vacant
in 1: volume VOL000001, barcode 3ff2d1b8ae90103b3b0000c2939ceef, oid 105, 46919616 kb remaining
in 2: unlabeled, barcode 402ee388ae90103b3b0000c2939ceef, oid 101
in 3: unlabeled, barcode 403e1fe2ae90103b3b0000c2939ceef, oid 102
in 4: unlabeled, barcode 40519d6aae90103b3b0000c2939ceef, oid 103
in dte1: vacant
in dte2: vacant
in dte3: vacant
in dte4: vacant
ob>

Create User through GUI as:
Manage -> Users -> Add

Authorize the user through GUI:

Create Database Storage Selectors:

Configure -> Add ->

User can also be added from commandline using the following command:

ob> mkuser -c oracle -p oracle -U oracle -G dba -N no -h *:*:*+rman+cmdline oracle

ob>

Now start RMAN backup from client i.e. rac70 as:

run

{

allocate channel t1 type SBT_TAPE;

allocate channel t2 type SBT_TAPE;

BACKUP AS BACKUPSET DATABASE PLUS ARCHIVELOG;

release channel t1;

release channel t2;

}

Following is the log of the script of the rman and in the end I have shown the screens in OSB (Oracle Secure Backup) that the backup is now happening in OSB as well.

RMAN> run

{

allocate channel t1 type SBT_TAPE;

allocate channel t2 type SBT_TAPE;

BACKUP AS BACKUPSET DATABASE PLUS ARCHIVELOG;

release channel t1;

release channel t2;

}2> 3> 4> 5> 6> 7> 8>

using target database control file instead of recovery catalog

allocated channel: t1

channel t1: SID=46 instance=SDIEGO1 device type=SBT_TAPE

channel t1: Oracle Secure Backup

allocated channel: t2

channel t2: SID=54 instance=SDIEGO1 device type=SBT_TAPE

channel t2: Oracle Secure Backup

Starting backup at 25-APR-14

current log archived

channel t1: starting archived log backup set

channel t1: specifying archived log(s) in backup set

input archived log thread=2 sequence=290 RECID=655 STAMP=843230745

input archived log thread=1 sequence=357 RECID=657 STAMP=843230802

input archived log thread=2 sequence=291 RECID=656 STAMP=843230762

input archived log thread=1 sequence=358 RECID=658 STAMP=843230844

input archived log thread=2 sequence=292 RECID=659 STAMP=843232587

input archived log thread=1 sequence=359 RECID=662 STAMP=843232670

input archived log thread=2 sequence=293 RECID=660 STAMP=843232628

input archived log thread=2 sequence=294 RECID=661 STAMP=843232668

input archived log thread=2 sequence=295 RECID=663 STAMP=843232689

input archived log thread=1 sequence=360 RECID=665 STAMP=843232741

input archived log thread=2 sequence=296 RECID=664 STAMP=843232711

input archived log thread=2 sequence=297 RECID=666 STAMP=843232741

input archived log thread=2 sequence=298 RECID=667 STAMP=843247083

input archived log thread=1 sequence=361 RECID=669 STAMP=843271793

input archived log thread=2 sequence=299 RECID=668 STAMP=843257090

input archived log thread=2 sequence=300 RECID=670 STAMP=843292024

input archived log thread=1 sequence=362 RECID=671 STAMP=843312140

input archived log thread=2 sequence=301 RECID=673 STAMP=843328855

input archived log thread=1 sequence=363 RECID=672 STAMP=843326325

input archived log thread=1 sequence=364 RECID=674 STAMP=843328871

input archived log thread=1 sequence=365 RECID=676 STAMP=843365476

input archived log thread=2 sequence=302 RECID=675 STAMP=843343427

input archived log thread=2 sequence=303 RECID=677 STAMP=843373949

input archived log thread=1 sequence=366 RECID=678 STAMP=843404425

input archived log thread=2 sequence=304 RECID=679 STAMP=843418014

input archived log thread=1 sequence=367 RECID=680 STAMP=843429933

input archived log thread=2 sequence=305 RECID=682 STAMP=843430847

input archived log thread=1 sequence=368 RECID=681 STAMP=843430787

input archived log thread=1 sequence=369 RECID=683 STAMP=843430871

input archived log thread=1 sequence=370 RECID=685 STAMP=843465579

input archived log thread=2 sequence=306 RECID=684 STAMP=843458586

input archived log thread=2 sequence=307 RECID=686 STAMP=843472930

input archived log thread=1 sequence=371 RECID=687 STAMP=843501662

input archived log thread=2 sequence=308 RECID=688 STAMP=843501758

input archived log thread=1 sequence=372 RECID=689 STAMP=843517328

input archived log thread=2 sequence=309 RECID=690 STAMP=843518903

input archived log thread=1 sequence=373 RECID=691 STAMP=843523275

input archived log thread=2 sequence=310 RECID=692 STAMP=843544948

input archived log thread=1 sequence=374 RECID=693 STAMP=843559260

input archived log thread=2 sequence=311 RECID=694 STAMP=843565838

input archived log thread=1 sequence=375 RECID=695 STAMP=843588046

channel t1: starting piece 1 at 25-APR-14

channel t2: starting archived log backup set

channel t2: specifying archived log(s) in backup set

input archived log thread=2 sequence=312 RECID=697 STAMP=843606711

input archived log thread=1 sequence=376 RECID=696 STAMP=843602659

input archived log thread=1 sequence=377 RECID=698 STAMP=843620443

input archived log thread=2 sequence=313 RECID=700 STAMP=843636740

input archived log thread=1 sequence=378 RECID=699 STAMP=843636725

input archived log thread=2 sequence=314 RECID=701 STAMP=843636741

input archived log thread=1 sequence=379 RECID=702 STAMP=843638722

input archived log thread=1 sequence=380 RECID=703 STAMP=843681645

input archived log thread=1 sequence=381 RECID=704 STAMP=843689048

input archived log thread=1 sequence=382 RECID=705 STAMP=843724829

input archived log thread=1 sequence=383 RECID=706 STAMP=843768597

input archived log thread=1 sequence=384 RECID=707 STAMP=845548165

input archived log thread=1 sequence=385 RECID=708 STAMP=845549713

input archived log thread=2 sequence=315 RECID=711 STAMP=845549869

input archived log thread=1 sequence=386 RECID=709 STAMP=845549791

input archived log thread=1 sequence=387 RECID=710 STAMP=845549840

input archived log thread=1 sequence=388 RECID=712 STAMP=845549900

input archived log thread=2 sequence=316 RECID=714 STAMP=845549977

input archived log thread=1 sequence=389 RECID=713 STAMP=845549929

input archived log thread=1 sequence=390 RECID=715 STAMP=845549987

input archived log thread=1 sequence=391 RECID=716 STAMP=845550047

input archived log thread=2 sequence=317 RECID=719 STAMP=845550128

input archived log thread=1 sequence=392 RECID=717 STAMP=845550093

input archived log thread=1 sequence=393 RECID=718 STAMP=845550126

input archived log thread=1 sequence=394 RECID=720 STAMP=845550157

input archived log thread=2 sequence=318 RECID=722 STAMP=845571676

input archived log thread=1 sequence=395 RECID=721 STAMP=845550206

input archived log thread=1 sequence=396 RECID=723 STAMP=845571696

input archived log thread=1 sequence=397 RECID=725 STAMP=845573414

input archived log thread=2 sequence=319 RECID=724 STAMP=845573412

input archived log thread=2 sequence=320 RECID=726 STAMP=845577042

input archived log thread=1 sequence=398 RECID=727 STAMP=845577044

input archived log thread=1 sequence=399 RECID=728 STAMP=845578614

input archived log thread=2 sequence=321 RECID=729 STAMP=845578614

input archived log thread=2 sequence=322 RECID=730 STAMP=845590669

input archived log thread=1 sequence=400 RECID=731 STAMP=845611598

input archived log thread=2 sequence=323 RECID=732 STAMP=845615707

input archived log thread=1 sequence=401 RECID=733 STAMP=845650193

input archived log thread=2 sequence=324 RECID=734 STAMP=845656786

input archived log thread=1 sequence=402 RECID=735 STAMP=845658954

input archived log thread=2 sequence=325 RECID=736 STAMP=845658963

input archived log thread=1 sequence=403 RECID=738 STAMP=845659990

input archived log thread=2 sequence=326 RECID=737 STAMP=845659988

input archived log thread=2 sequence=327 RECID=740 STAMP=845660337

input archived log thread=1 sequence=404 RECID=739 STAMP=845660334

input archived log thread=1 sequence=405 RECID=742 STAMP=845661496

input archived log thread=2 sequence=328 RECID=741 STAMP=845661495

input archived log thread=2 sequence=329 RECID=743 STAMP=845677007

input archived log thread=1 sequence=406 RECID=744 STAMP=845697661

input archived log thread=2 sequence=330 RECID=745 STAMP=845706674

input archived log thread=1 sequence=407 RECID=746 STAMP=845736495

input archived log thread=2 sequence=331 RECID=747 STAMP=845746220

input archived log thread=1 sequence=408 RECID=749 STAMP=845773272

input archived log thread=2 sequence=332 RECID=748 STAMP=845763610

channel t2: starting piece 1 at 25-APR-14

channel t1: finished piece 1 at 25-APR-14

piece handle=3ep6krti_1_1 tag=TAG20140425T182949 comment=API Version 2.0,MMS Version 10.4.0.3

channel t1: backup set complete, elapsed time: 00:21:25

channel t1: starting archived log backup set

channel t1: specifying archived log(s) in backup set

input archived log thread=2 sequence=333 RECID=750 STAMP=845784086

input archived log thread=1 sequence=409 RECID=751 STAMP=845809257

input archived log thread=2 sequence=334 RECID=752 STAMP=845823589

input archived log thread=1 sequence=410 RECID=755 STAMP=845829871

input archived log thread=2 sequence=335 RECID=753 STAMP=845829859

input archived log thread=2 sequence=336 RECID=754 STAMP=845829863

input archived log thread=1 sequence=411 RECID=757 STAMP=845830282

input archived log thread=2 sequence=337 RECID=756 STAMP=845830280

input archived log thread=2 sequence=338 RECID=759 STAMP=845835770

input archived log thread=1 sequence=412 RECID=758 STAMP=845835769

input archived log thread=1 sequence=413 RECID=761 STAMP=845836182

input archived log thread=2 sequence=339 RECID=760 STAMP=845836182

channel t1: starting piece 1 at 25-APR-14

channel t2: finished piece 1 at 25-APR-14

piece handle=3fp6krtj_1_1 tag=TAG20140425T182949 comment=API Version 2.0,MMS Version 10.4.0.3

channel t2: backup set complete, elapsed time: 00:21:50

channel t1: finished piece 1 at 25-APR-14

piece handle=3gp6kt5v_1_1 tag=TAG20140425T182949 comment=API Version 2.0,MMS Version 10.4.0.3

channel t1: backup set complete, elapsed time: 00:01:06

Finished backup at 25-APR-14

Starting backup at 25-APR-14

channel t1: starting full datafile backup set

channel t1: specifying datafile(s) in backup set

input datafile file number=00002 name=+DATA/sdiego/datafile/sysaux.257.830971359

input datafile file number=00008 name=+DATA/sdiego/datafile/goldengate.270.839193779

input datafile file number=00004 name=+DATA/sdiego/datafile/users.259.845573737

input datafile file number=00007 name=+DATA/sdiego/datafile/read.269.838771155

input datafile file number=00006 name=+DATA/sdiego/datafile/undotbs2.265.830971971

channel t1: starting piece 1 at 25-APR-14

channel t2: starting full datafile backup set

channel t2: specifying datafile(s) in backup set

input datafile file number=00001 name=+DATA/sdiego/datafile/system.256.830971357

input datafile file number=00003 name=+DATA/sdiego/datafile/undotbs1.258.830971359

input datafile file number=00005 name=+DATA/sdiego/datafile/example.264.830971505

input datafile file number=00010 name=+DATA/sdiego/datafile/ggdata.272.839362901

channel t2: starting piece 1 at 25-APR-14

channel t2: finished piece 1 at 25-APR-14

piece handle=3ip6kt8k_1_1 tag=TAG20140425T185307 comment=API Version 2.0,MMS Version 10.4.0.3

channel t2: backup set complete, elapsed time: 00:07:45

channel t2: starting full datafile backup set

channel t2: specifying datafile(s) in backup set

including current control file in backup set

channel t2: starting piece 1 at 25-APR-14

channel t2: finished piece 1 at 25-APR-14

piece handle=3jp6ktn6_1_1 tag=TAG20140425T185307 comment=API Version 2.0,MMS Version 10.4.0.3

channel t2: backup set complete, elapsed time: 00:01:15

channel t2: starting full datafile backup set

channel t2: specifying datafile(s) in backup set

including current SPFILE in backup set

channel t2: starting piece 1 at 25-APR-14

channel t1: finished piece 1 at 25-APR-14

piece handle=3hp6kt8j_1_1 tag=TAG20140425T185307 comment=API Version 2.0,MMS Version 10.4.0.3

channel t1: backup set complete, elapsed time: 00:10:24

channel t2: finished piece 1 at 25-APR-14

piece handle=3kp6ktq1_1_1 tag=TAG20140425T185307 comment=API Version 2.0,MMS Version 10.4.0.3

channel t2: backup set complete, elapsed time: 00:00:55

Finished backup at 25-APR-14

Starting backup at 25-APR-14

current log archived

channel t1: starting archived log backup set

channel t1: specifying archived log(s) in backup set

input archived log thread=2 sequence=340 RECID=762 STAMP=845838243

channel t1: starting piece 1 at 25-APR-14

channel t2: starting archived log backup set

channel t2: specifying archived log(s) in backup set

input archived log thread=1 sequence=414 RECID=763 STAMP=845838257

channel t2: starting piece 1 at 25-APR-14

channel t1: finished piece 1 at 25-APR-14

piece handle=3lp6ktts_1_1 tag=TAG20140425T190427 comment=API Version 2.0,MMS Version 10.4.0.3

channel t1: backup set complete, elapsed time: 00:00:26

channel t2: finished piece 1 at 25-APR-14

piece handle=3mp6ktts_1_1 tag=TAG20140425T190427 comment=API Version 2.0,MMS Version 10.4.0.3

channel t2: backup set complete, elapsed time: 00:00:35

Finished backup at 25-APR-14

released channel: t1

released channel: t2

RMAN>

Backup was happening in Oracle Secure Backup (OSB) as well:

Naked we come, and naked we go. No one, not even the kings and queens, shall remain. || 1 || The Sovereign Lord is the nine treasures for me. The possessions and the spouse to which the mortal is lovingly attached, are Your wealth, O Lord. || 1 || Pause || They do not come with the mortal, and they do not go with him. What good does it do him, if he has elephants tied up at his doorway? || 2 || The fortress of Sri Lanka was made out of gold, but what could the foolish Raawan take with him when he left? || 3 || Says Kabeer, think of doing some good deeds. In the end, the gambler shall depart empty-handed.