HammerDB setup issues - libXss.so.1 and x11 fonts

A couple of problems (missing x11 libraries and fonts) when installing HammerDB to test my Oracle 12c Centos 6 / RHEL 6 server i.e. not really setup with GUI access in mind.

I setup x11 forwarding and tested in via xclock first.

My first hammerdb error was

[oracle@ora12c66 hammerora-2.6]$ ./hammerora.tcl

wish8.5: error while loading shared libraries: libXss.so.1: cannot open shared object file: No such file or directory

I got passed this error by installing

sudo yum install libXScrnSaver

The next problem was

[oracle@ora12c66 hammerora-2.6]$ ./hammerora.tcl

Error in startup script: failed to allocate font due to internal system font engine problem

   (default value for "-font" in widget ".title")

   invoked from within

"label .title -text " Hammerora v2.6 by smshaw@users.sourceforge.net "  -font $mid  -bg $gbg  -fg red3  -padx 0"

   (in namespace eval "::LoadingProgressMeter" script line 481)

   invoked from within

"namespace eval LoadingProgressMeter {

   set max 14

   wm title            . "Loading Hammerora"

   wm protocol         . WM_DELETE_WINDOW {#Do no..."

   (file "./hammerora.tcl" line 53)

I got passed this by installing:

sudo yum install xorg-x11-fonts*

and voila … I am into the HammerDB GUI :)

12c Unified Auditing expdp example

Summary

Oracle 12c introduces "unified all" so all the various audit activities :

• Ability to Audit Any Role.
• Auditing Application Context Values.
• Auditing Oracle Database Real Application Security Events.
• Auditing Oracle Recovery Manager Events.
• Auditing Oracle Database Vault Events.
• Auditing Oracle Label Security Events.
• Auditing Oracle Data Mining Events.
• Auditing Oracle Data Pump Events.
• Auditing Oracle SQL*Loader Direct Load Path Events.
• Moving Operating System Audit Records into the Unified Audit Trail. https://blogs.oracle.com/imc/entry/oracle_database_12c_new_unified

can be viewed in the single sys.unified_audit_trail table.

As above you can now audit datapump operations, below I show how to set this up and some sample output from the new sys.unified_audit_trail table.

Details - datapump example

I was initially following:  http://oracle-base.com/articles/12c/data-pump-enhancements-12cr1.php

So I set up my new audit policy and applied to the scott

SQL> CONN / AS SYSDBA

Connected.

SQL> CREATE AUDIT POLICY audit_dp_all_policy ACTIONS COMPONENT=DATAPUMP ALL;

Audit policy created.

SQL> AUDIT POLICY audit_dp_all_policy BY scott;

Audit succeeded.

SQL> EXEC DBMS_AUDIT_MGMT.FLUSH_UNIFIED_AUDIT_TRAIL;

PL/SQL procedure successfully completed.

and kicked off my export:

[oracle@ora12c66 ~]$ expdp system/qwe123@ora12c66/orcl12c tables=scott.emp directory=TEMP_DIR

Export: Release 12.1.0.1.0 - Production on Wed Mar 18 20:20:52 2015

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Starting "SYSTEM"."SYS_EXPORT_TABLE_01":  system/********@ora12c66/orcl12c tables=scott.emp directory=TEMP_DIR

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 64 KB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER

. . exported "SCOTT"."EMP"                               8.742 KB      14 rows

Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:

 /tmp/expdat.dmp

Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at Wed Mar 18 20:21:13 2015 elapsed 0 00:00:20

and initially this failed to generate a unified_audit_trail record:

SET LINESIZE 200

COLUMN event_timestamp FORMAT A30

COLUMN dp_text_parameters1 FORMAT A30

COLUMN dp_boolean_parameters1 FORMAT A30

SQL> SELECT event_timestamp, dp_text_parameters1, dp_boolean_parameters1 FROM  sys.unified_audit_trail WHERE  audit_type = 'Datapump';

no rows selected

my problem was that I was only auditing on the user_name scott (i.e. not the scott schema objects)

SQL> col USER_NAME form a30

SQL> col POLICY_NAME form a30

SQL> select * from AUDIT_UNIFIED_ENABLED_POLICIES where POLICY_NAME like '%DP%';

USER_NAME       POLICY_NAME      ENABLED_ SUC FAI

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

SCOTT       AUDIT_DP_ALL_POLICY      BY       YES YES

i.e. not the user_name system and after

SQL> AUDIT POLICY audit_dp_all_policy BY system;

Audit succeeded.

SQL> select * from AUDIT_UNIFIED_ENABLED_POLICIES where POLICY_NAME like '%DP%';

USER_NAME       POLICY_NAME      ENABLED_ SUC FAI

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

SCOTT       AUDIT_DP_ALL_POLICY      BY       YES YES

SYSTEM       AUDIT_DP_ALL_POLICY      BY       YES YES

and rerun my expdp:

SQL> SELECT event_timestamp, dp_text_parameters1, dp_boolean_parameters1 FROM  sys.unified_audit_trail WHERE  audit_type = 'Datapump';

EVENT_TIMESTAMP       DP_TEXT_PARAMETERS1      DP_BOOLEAN_PARAMETERS1

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

18-MAR-15 08.28.36.157025 PM   MASTER TABLE:  "SYSTEM"."SYS_E MASTER_ONLY: FALSE, DATA_ONLY:

      XPORT_TABLE_01" , JOB_TYPE: EX  FALSE, METADATA_ONLY: FALSE,

      PORT, METADATA_JOB_MODE: TABLE DUMPFILE_PRESENT: TRUE, JOB_RE

      _EXPORT, JOB VERSION: 12.1.0.0 STARTED: FALSE

      .0, ACCESS METHOD: AUTOMATIC,

      DATA OPTIONS: 0, DUMPER DIRECT

      ORY: NULL  REMOTE LINK: NULL,

      TABLE EXISTS: NULL, PARTITION

      OPTIONS: NONE

manually making this a bit more readable:

EVENT_TIMESTAMP
---------------------------------------------------------------------------
18-MAR-15 08.28.36.157025 PM

DP_TEXT_PARAMETERS1
--------------------------------------------------------------------------------
MASTER TABLE:  "SYSTEM"."SYS_EXPORT_TABLE_01" , JOB_TYPE: EXPORT, METADATA_JOB_M
ODE: TABLE_EXPORT, JOB VERSION: 12.1.0.0.0, ACCESS METHOD: AUTOMATIC, DATA OPTIO
NS: 0, DUMPER DIRECTORY: NULL  REMOTE LINK: NULL, TABLE EXISTS: NULL, PARTITION
OPTIONS: NONE

DP_BOOLEAN_PARAMETERS1
--------------------------------------------------------------------------------

MASTER_ONLY: FALSE, DATA_ONLY: FALSE, METADATA_ONLY: FALSE, DUMPFILE_PRESENT: TR UE, JOB_RESTARTED: FALSE

alternatively I could have selected all users:

SQL> AUDIT POLICY audit_dp_all_policy;

Audit succeeded.

SQL> select * from AUDIT_UNIFIED_ENABLED_POLICIES where POLICY_NAME like '%DP%';

USER_NAME       POLICY_NAME      ENABLED_ SUC FAI

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

SCOTT       AUDIT_DP_ALL_POLICY      BY       YES YES

SYSTEM       AUDIT_DP_ALL_POLICY      BY       YES YES

ALL USERS       AUDIT_DP_ALL_POLICY      BY       YES YES

Strangle it appears that my

SQL> select value from v$option where PARAMETER = 'Unified Auditing';

VALUE

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

FALSE

I guess this refers to some more global / default level auditing?

RMAN PITR Container - Pluggable DB RMAN-06025 Failure

Summary

As per http://dba-amsterdam.blogspot.nl/2015/03/RMAN-PITR-Background-Table-Recovery-12c.html I have this Oracle 12c new feature working with a tradition database.

However when I tried with my 12c Container Database, the first attempt failed with a fairly trival error: http://dba-amsterdam.blogspot.nl/2015/03/rman-06024-no-backup-of-control-file.html

More interestingly this 2nd attempt of recovering a table in a pluggable database (i.e. PDB3 below), failed in a far more elusive manner:

• I have backups from from around SCN 2792428 onwards
• RMAN is trying to recover pdb3 to SCN 2868390
• Unfortunately the PITR recovery script want to restore the parent container database (i.e. CDBORCL) to archived log sequence 70 / SCN 2664814

I haven't got a root cause for this issue/failure, it appears that we are trying to restore the container db to an earlier point i.e.  before I had run my initial backup of CDB/PDB3. I imagine this relates to the rather minimal initial backups I took, for a real project I would be keeping multiple backups? Still if I was going to be using Containers and Pluggable databases for a real-world project, I would want to test my backup strategy and the point in time recovery extra carefully.

Details

Basically the setup was the same as before, i.e. I run an RMAN backup on the database, archivelog and controlfile i.e. around SCN 2792428 … so I should be able to restore to SCN after this. Please see Appendix B for the  

Some time later (SCN 2868390) I add small table and add some data

SQL> create table dave.test_table(col1 varchar2(30));

Table created.

SQL> insert into dave.test_table values ('blah');

1 row created.

SQL> SELECT current_scn FROM V$DATABASE;

CURRENT_SCN

-----------

   2868385

SQL> commit;

Commit complete.

SQL> SELECT current_scn FROM V$DATABASE;

CURRENT_SCN

-----------

   2868390

SQL> insert into dave.test_table values ('blah2');

1 row created.

SQL> commit;

Commit complete.

I then ran from rman:

RECOVER TABLE dave.test_table OF PLUGGABLE DATABASE pdb3 until scn 2868390 AUXILIARY DESTINATION '/u01/aux' REMAP TABLE 'DAVE'.'TEST_TABLE':'TEST_TABLE_RECOVERED';

However as the logs (appendix A) this fails:

RMAN-06025: no backup of archived log for thread 1 with sequence 70 and starting SCN of 2664814 found to restore

although  the backup details (see Appendix B - RMAN list backup details) below indicate that we have backups from around SCN 2792428 onwards i.e. comfortable before the PITR at SCN 2868390?

Appendix A ... full rman log, including

RMAN> RECOVER TABLE dave.test_table OF PLUGGABLE DATABASE pdb3 until scn 2868390 AUXILIARY DESTINATION '/u01/aux' REMAP TABLE 'DAVE'.'TEST_TABLE':'TEST_TABLE_RECOVERED';

Starting recover at 16-MAR-15

current log archived

using channel ORA_DISK_1

RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time

List of tablespaces expected to have UNDO segments

Tablespace SYSTEM

Tablespace UNDOTBS1

Creating automatic instance, with SID='guej'

initialization parameters used for automatic instance:

db_name=CDBORCL

db_unique_name=guej_pitr_pdb3_CDBORCL

compatible=12.1.0.0.0

db_block_size=8192

db_files=200

sga_target=1G

processes=80

diagnostic_dest=/u01

db_create_file_dest=/u01/aux

log_archive_dest_1='location=/u01/aux'

enable_pluggable_database=true

_clone_one_pdb_recovery=true

#No auxiliary parameter file used

starting up automatic instance CDBORCL

Oracle instance started

Total System Global Area    1068937216 bytes

Fixed Size                     2296576 bytes

Variable Size                281019648 bytes

Database Buffers             780140544 bytes

Redo Buffers                   5480448 bytes

Automatic instance created

contents of Memory Script:

{

# set requested point in time

set until  scn 2868390;

# restore the controlfile

restore clone controlfile;

# mount the controlfile

sql clone 'alter database mount clone database';

# archive current online log

sql 'alter system archive log current';

}

executing Memory Script

executing command: SET until clause

Starting restore at 16-MAR-15

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=7 device type=DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: restoring control file

channel ORA_AUX_DISK_1: reading from backup piece /u01/fast_recovery_area/CDBORCL/autobackup/2015_03_16/o1_mf_s_874530648_bjgkps2b_.bkp

channel ORA_AUX_DISK_1: piece handle=/u01/fast_recovery_area/CDBORCL/autobackup/2015_03_16/o1_mf_s_874530648_bjgkps2b_.bkp tag=TAG20150316T211048

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/u01/aux/CDBORCL/controlfile/o1_mf_bjgkywvd_.ctl

Finished restore at 16-MAR-15

sql statement: alter database mount clone database

sql statement: alter system archive log current

contents of Memory Script:

{

# set requested point in time

set until  scn 2868390;

# set destinations for recovery set and auxiliary set datafiles

set newname for clone datafile  1 to new;

set newname for clone datafile  4 to new;

set newname for clone datafile  3 to new;

set newname for clone datafile  14 to new;

set newname for clone datafile  15 to new;

set newname for clone tempfile  1 to new;

set newname for clone tempfile  5 to new;

# switch all tempfiles

switch clone tempfile all;

# restore the tablespaces in the recovery set and the auxiliary set

restore clone datafile  1, 4, 3, 14, 15;

switch clone datafile all;

}

executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to /u01/aux/CDBORCL/datafile/o1_mf_temp_%u_.tmp in control file

renamed tempfile 5 to /u01/aux/CDBORCL/datafile/o1_mf_temp_%u_.tmp in control file

Starting restore at 16-MAR-15

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/aux/CDBORCL/datafile/o1_mf_system_%u_.dbf

channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/aux/CDBORCL/datafile/o1_mf_undotbs1_%u_.dbf

channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/aux/CDBORCL/datafile/o1_mf_sysaux_%u_.dbf

channel ORA_AUX_DISK_1: reading from backup piece /u01/fast_recovery_area/CDBORCL/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgkmzch_.bkp

channel ORA_AUX_DISK_1: piece handle=/u01/fast_recovery_area/CDBORCL/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgkmzch_.bkp tag=TAG20150316T210919

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00014 to /u01/aux/CDBORCL/datafile/o1_mf_system_%u_.dbf

channel ORA_AUX_DISK_1: restoring datafile 00015 to /u01/aux/CDBORCL/datafile/o1_mf_sysaux_%u_.dbf

channel ORA_AUX_DISK_1: reading from backup piece /u01/fast_recovery_area/CDBORCL/113D000B83CC49F7E0530100007FA366/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgknrqc_.bkp

channel ORA_AUX_DISK_1: piece handle=/u01/fast_recovery_area/CDBORCL/113D000B83CC49F7E0530100007FA366/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgknrqc_.bkp tag=TAG20150316T210919

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25

Finished restore at 16-MAR-15

datafile 1 switched to datafile copy

input datafile copy RECID=12 STAMP=874530977 file name=/u01/aux/CDBORCL/datafile/o1_mf_system_bjgkz52x_.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=13 STAMP=874530977 file name=/u01/aux/CDBORCL/datafile/o1_mf_undotbs1_bjgkz536_.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=14 STAMP=874530977 file name=/u01/aux/CDBORCL/datafile/o1_mf_sysaux_bjgkz528_.dbf

datafile 14 switched to datafile copy

input datafile copy RECID=15 STAMP=874530977 file name=/u01/aux/CDBORCL/datafile/o1_mf_system_bjgl085n_.dbf

datafile 15 switched to datafile copy

input datafile copy RECID=16 STAMP=874530977 file name=/u01/aux/CDBORCL/datafile/o1_mf_sysaux_bjgl0864_.dbf

contents of Memory Script:

{

# set requested point in time

set until  scn 2868390;

# online the datafiles restored or switched

sql clone "alter database datafile  1 online";

sql clone "alter database datafile  4 online";

sql clone "alter database datafile  3 online";

sql clone 'PDB3' "alter database datafile

14 online";

sql clone 'PDB3' "alter database datafile

15 online";

# recover and open database read only

recover clone database tablespace  "SYSTEM", "UNDOTBS1", "SYSAUX", "PDB3":"SYSTEM", "PDB3":"SYSAUX";

sql clone 'alter database open read only';

}

executing Memory Script

executing command: SET until clause

sql statement: alter database datafile  1 online

sql statement: alter database datafile  4 online

sql statement: alter database datafile  3 online

sql statement: alter database datafile  14 online

sql statement: alter database datafile  15 online

Starting recover at 16-MAR-15

using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 84 is already on disk as file /u01/fast_recovery_area/CDBORCL/archivelog/2015_03_16/o1_mf_1_84_bjgkpqd3_.arc

archived log for thread 1 with sequence 85 is already on disk as file /u01/fast_recovery_area/CDBORCL/archivelog/2015_03_16/o1_mf_1_85_bjgky8hw_.arc

Removing automatic instance

shutting down automatic instance

Oracle instance shut down

Automatic instance removed

auxiliary instance file /u01/aux/CDBORCL/datafile/o1_mf_sysaux_bjgl0864_.dbf deleted

auxiliary instance file /u01/aux/CDBORCL/datafile/o1_mf_system_bjgl085n_.dbf deleted

auxiliary instance file /u01/aux/CDBORCL/datafile/o1_mf_sysaux_bjgkz528_.dbf deleted

auxiliary instance file /u01/aux/CDBORCL/datafile/o1_mf_undotbs1_bjgkz536_.dbf deleted

auxiliary instance file /u01/aux/CDBORCL/datafile/o1_mf_system_bjgkz52x_.dbf deleted

auxiliary instance file /u01/aux/CDBORCL/controlfile/o1_mf_bjgkywvd_.ctl deleted

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 03/16/2015 21:16:18

RMAN-03015: error occurred in stored script Memory Script

RMAN-06053: unable to perform media recovery because of missing log

RMAN-06025: no backup of archived log for thread 1 with sequence 70 and starting SCN of 2664814 found to restore

Appendix B - RMAN list backup details

RMAN> list backup;

List of Backup Sets

===================

BS Key  Size       Device Type Elapsed Time Completion Time

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

5       36.34M     DISK        00:00:00     15-MAR-15

       BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20150315T142321

       Piece Name: /u01/fast_recovery_area/CDBORCL/backupset/2015_03_15/o1_mf_annnn_TAG20150315T142321_bjc5gs94_.bkp

 List of Archived Logs in backup set 5

 Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

 1    78      2781205    15-MAR-15 2792295    15-MAR-15

BS Key  Size       Device Type Elapsed Time Completion Time

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

6       56.00K     DISK        00:00:00     15-MAR-15

       BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150315T142511

       Piece Name: /u01/fast_recovery_area/CDBORCL/backupset/2015_03_15/o1_mf_annnn_TAG20150315T142511_bjc5l7m4_.bkp

 List of Archived Logs in backup set 6

 Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

 1    79      2792295    15-MAR-15 2792422    15-MAR-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

7       Full    1.33G      DISK        00:00:18     15-MAR-15

       BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20150315T142512

       Piece Name: /u01/fast_recovery_area/CDBORCL/backupset/2015_03_15/o1_mf_nnndf_TAG20150315T142512_bjc5l8wf_.bkp

 List of Datafiles in backup set 7

 File LV Type Ckp SCN    Ckp Time  Name

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

 1       Full 2792428    15-MAR-15 /u01/oradata/cdborcl/system01.dbf

 3       Full 2792428    15-MAR-15 /u01/oradata/cdborcl/sysaux01.dbf

 4       Full 2792428    15-MAR-15 /u01/oradata/cdborcl/undotbs01.dbf

 6       Full 2792428    15-MAR-15 /u01/oradata/cdborcl/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

8       Full    1.24G      DISK        00:00:16     15-MAR-15

       BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150315T142512

       Piece Name: /u01/fast_recovery_area/CDBORCL/113D000B83CC49F7E0530100007FA366/backupset/2015_03_15/o1_mf_nnndf_TAG20150315T142512_bjc5m29v_.bkp

 List of Datafiles in backup set 8

 Container ID: 5, PDB Name: PDB3

 File LV Type Ckp SCN    Ckp Time  Name

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

 14      Full 2792437    15-MAR-15 /u01/oradata/cdborcl/pdb3/system01.dbf

 15      Full 2792437    15-MAR-15 /u01/oradata/cdborcl/pdb3/sysaux01.dbf

 16      Full 2792437    15-MAR-15 /u01/oradata/cdborcl/pdb3/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

9       Full    752.21M    DISK        00:00:08     15-MAR-15

       BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20150315T142512

       Piece Name: /u01/fast_recovery_area/CDBORCL/115447DBB3BA056DE0530100007FB780/backupset/2015_03_15/o1_mf_nnndf_TAG20150315T142512_bjc5mwf4_.bkp

 List of Datafiles in backup set 9

 Container ID: 6, PDB Name: PDB4

 File LV Type Ckp SCN    Ckp Time  Name

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

 20      Full 2792447    15-MAR-15 /u01/oradata/cdborcl/pdb4/system01.dbf

 21      Full 2792447    15-MAR-15 /u01/oradata/cdborcl/pdb4/sysaux01.dbf

 22      Full 2792447    15-MAR-15 /u01/oradata/cdborcl/pdb4/pdb4_users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

10      Full    751.98M    DISK        00:00:10     15-MAR-15

       BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20150315T142512

       Piece Name: /u01/fast_recovery_area/CDBORCL/113065F11B2B3357E0530100007F557D/backupset/2015_03_15/o1_mf_nnndf_TAG20150315T142512_bjc5ncpk_.bkp

 List of Datafiles in backup set 10

 Container ID: 4, PDB Name: PDB2

 File LV Type Ckp SCN    Ckp Time  Name

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

 12      Full 2792453    15-MAR-15 /u01/oradata/cdborcl/pdb2/system01.dbf

 13      Full 2792453    15-MAR-15 /u01/oradata/cdborcl/pdb2/sysaux01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

11      Full    741.55M    DISK        00:00:08     15-MAR-15

       BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20150315T142512

       Piece Name: /u01/fast_recovery_area/CDBORCL/11043883E1AC1CBAE0530100007F7552/backupset/2015_03_15/o1_mf_nnndf_TAG20150315T142512_bjc5nvtr_.bkp

 List of Datafiles in backup set 11

 Container ID: 2, PDB Name: PDB$SEED

 File LV Type Ckp SCN    Ckp Time  Name

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

 5       Full 1929877    11-MAR-15 /u01/oradata/cdborcl/pdbseed/system01.dbf

 7       Full 1929877    11-MAR-15 /u01/oradata/cdborcl/pdbseed/sysaux01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time

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

12      4.50K      DISK        00:00:00     15-MAR-15

       BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20150315T142651

       Piece Name: /u01/fast_recovery_area/CDBORCL/backupset/2015_03_15/o1_mf_annnn_TAG20150315T142651_bjc5ocm4_.bkp

 List of Archived Logs in backup set 12

 Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

 1    80      2792422    15-MAR-15 2792468    15-MAR-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

13      Full    17.20M     DISK        00:00:01     15-MAR-15

       BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20150315T142652

       Piece Name: /u01/fast_recovery_area/CDBORCL/autobackup/2015_03_15/o1_mf_s_874420012_bjc5of16_.bkp

 SPFILE Included: Modification time: 15-MAR-15

 SPFILE db_unique_name: CDBORCL

 Control File Included: Ckp SCN: 2792477      Ckp time: 15-MAR-15

BS Key  Size       Device Type Elapsed Time Completion Time

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

14      110.55M    DISK        00:00:00     16-MAR-15

       BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: TAG20150316T210917

       Piece Name: /u01/fast_recovery_area/CDBORCL/backupset/2015_03_16/o1_mf_annnn_TAG20150316T210917_bjgkmy4d_.bkp

 List of Archived Logs in backup set 14

 Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

 1    79      2792295    15-MAR-15 2792422    15-MAR-15

 1    80      2792422    15-MAR-15 2792468    15-MAR-15

 1    81      2792468    15-MAR-15 2823573    16-MAR-15

 1    82      2823573    16-MAR-15 2849663    16-MAR-15

 1    83      2849663    16-MAR-15 2868230    16-MAR-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

15      Full    1.36G      DISK        00:00:18     16-MAR-15

       BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150316T210919

       Piece Name: /u01/fast_recovery_area/CDBORCL/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgkmzch_.bkp

 List of Datafiles in backup set 15

 File LV Type Ckp SCN    Ckp Time  Name

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

 1       Full 2868236    16-MAR-15 /u01/oradata/cdborcl/system01.dbf

 3       Full 2868236    16-MAR-15 /u01/oradata/cdborcl/sysaux01.dbf

 4       Full 2868236    16-MAR-15 /u01/oradata/cdborcl/undotbs01.dbf

 6       Full 2868236    16-MAR-15 /u01/oradata/cdborcl/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

16      Full    1.24G      DISK        00:00:16     16-MAR-15

       BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20150316T210919

       Piece Name: /u01/fast_recovery_area/CDBORCL/113D000B83CC49F7E0530100007FA366/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgknrqc_.bkp

 List of Datafiles in backup set 16

 Container ID: 5, PDB Name: PDB3

 File LV Type Ckp SCN    Ckp Time  Name

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

 14      Full 2868247    16-MAR-15 /u01/oradata/cdborcl/pdb3/system01.dbf

 15      Full 2868247    16-MAR-15 /u01/oradata/cdborcl/pdb3/sysaux01.dbf

 16      Full 2868247    16-MAR-15 /u01/oradata/cdborcl/pdb3/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

17      Full    752.29M    DISK        00:00:07     16-MAR-15

       BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: TAG20150316T210919

       Piece Name: /u01/fast_recovery_area/CDBORCL/115447DBB3BA056DE0530100007FB780/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgkoky1_.bkp

 List of Datafiles in backup set 17

 Container ID: 6, PDB Name: PDB4

 File LV Type Ckp SCN    Ckp Time  Name

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

 20      Full 2868280    16-MAR-15 /u01/oradata/cdborcl/pdb4/system01.dbf

 21      Full 2868280    16-MAR-15 /u01/oradata/cdborcl/pdb4/sysaux01.dbf

 22      Full 2868280    16-MAR-15 /u01/oradata/cdborcl/pdb4/pdb4_users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

18      Full    752.02M    DISK        00:00:07     16-MAR-15

       BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20150316T210919

       Piece Name: /u01/fast_recovery_area/CDBORCL/113065F11B2B3357E0530100007F557D/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgkos17_.bkp

 List of Datafiles in backup set 18

 Container ID: 4, PDB Name: PDB2

 File LV Type Ckp SCN    Ckp Time  Name

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

 12      Full 2868283    16-MAR-15 /u01/oradata/cdborcl/pdb2/system01.dbf

 13      Full 2868283    16-MAR-15 /u01/oradata/cdborcl/pdb2/sysaux01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

19      Full    741.55M    DISK        00:00:08     16-MAR-15

       BP Key: 20   Status: AVAILABLE  Compressed: NO  Tag: TAG20150316T210919

       Piece Name: /u01/fast_recovery_area/CDBORCL/11043883E1AC1CBAE0530100007F7552/backupset/2015_03_16/o1_mf_nnndf_TAG20150316T210919_bjgkp877_.bkp

 List of Datafiles in backup set 19

 Container ID: 2, PDB Name: PDB$SEED

 File LV Type Ckp SCN    Ckp Time  Name

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

 5       Full 1929877    11-MAR-15 /u01/oradata/cdborcl/pdbseed/system01.dbf

 7       Full 1929877    11-MAR-15 /u01/oradata/cdborcl/pdbseed/sysaux01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time

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

20      36.50K     DISK        00:00:00     16-MAR-15

       BP Key: 21   Status: AVAILABLE  Compressed: NO  Tag: TAG20150316T211047

       Piece Name: /u01/fast_recovery_area/CDBORCL/backupset/2015_03_16/o1_mf_annnn_TAG20150316T211047_bjgkpqml_.bkp

 List of Archived Logs in backup set 20

 Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

 1    84      2868230    16-MAR-15 2868300    16-MAR-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

21      Full    17.20M     DISK        00:00:01     16-MAR-15

       BP Key: 22   Status: AVAILABLE  Compressed: NO  Tag: TAG20150316T211048

       Piece Name: /u01/fast_recovery_area/CDBORCL/autobackup/2015_03_16/o1_mf_s_874530648_bjgkps2b_.bkp

 SPFILE Included: Modification time: 16-MAR-15

 SPFILE db_unique_name: CDBORCL

 Control File Included: Ckp SCN: 2868309      Ckp time: 16-MAR-15

RMAN> backup archivelog all;

Starting backup at 16-MAR-15

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

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

input archived log thread=1 sequence=79 RECID=8 STAMP=874419911

input archived log thread=1 sequence=80 RECID=9 STAMP=874420011

input archived log thread=1 sequence=81 RECID=10 STAMP=874461302

input archived log thread=1 sequence=82 RECID=11 STAMP=874501239

input archived log thread=1 sequence=83 RECID=12 STAMP=874530557

input archived log thread=1 sequence=84 RECID=13 STAMP=874530647

input archived log thread=1 sequence=85 RECID=14 STAMP=874530888

input archived log thread=1 sequence=86 RECID=15 STAMP=874530916

input archived log thread=1 sequence=87 RECID=16 STAMP=874531090

channel ORA_DISK_1: starting piece 1 at 16-MAR-15

channel ORA_DISK_1: finished piece 1 at 16-MAR-15

piece handle=/u01/fast_recovery_area/CDBORCL/backupset/2015_03_16/o1_mf_annnn_TAG20150316T211810_bjgl4lcg_.bkp tag=TAG20150316T211810 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

Finished backup at 16-MAR-15

Starting Control File and SPFILE Autobackup at 16-MAR-15

piece handle=/u01/fast_recovery_area/CDBORCL/autobackup/2015_03_16/o1_mf_s_874531093_bjgl4oly_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 16-MAR-15

RMAN> Connection to 127.0.0.1 closed by remote host.

Connection to 127.0.0.1 closed.