Oracle Expert Blog: Oracle Transparent Data Encryption for the Wise DBA

Introducing an Oracle TDE

Simplified Encryption Method

Oracle Transparent Data Encryption technology utilizes a variety of methods and techniques in order to encrypt a database at both the logical and physical object levels, and provides support for a variety of options such as encryption domain instantiation (SALT), wallet-driven encryption, encryption methods and models, and a variety of encryption algorithms; thus, OTDE attains an outstanding level of data protection and data privacy. This session presents a quick and efficient way to attain the best from Oracle TDE with any major obfuscation, introducing an agile model to optimal encryption with Oracle TDE, including control on network processes under TCP/IP, HTTP, and multi-VPN, operating system authentication, operating system level encryption, and complex network topology environments.

The core purpose of this presentation is to elucidate Oracle Transparent Data Encryption as too complex and getting the best benefits out of it rather than fearing the worst from encrypting your database.

Exhibit 1. Oracle TDE Conceptual View

Exhibit 2. Oracle12c provides support with native pre-built encryption

Main Configuration Method

With the Oracle instance down, execute the following step-by-step process:

1. Customize the sqlnet.ora file as provided below:

# sqlnet.ora Network Configuration File: C:\app\oracle\product\12.1.0\dbhome_1\network\admin\sqlnet.ora

# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to

# install "Software Only", this file wont exist and without the native

# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SSL_CLIENT_VERSION = 0

SSL_VERSION = 1.0

NAMES.DIRECTORY_PATH= (TNSNAMES)

SSL_CLIENT_AUTHENTICATION = FALSE

SQLNET.INBOUND_CONNECT_TIMEOUT = 0

ADR_BASE = C:\app\oracle\product\12.1.0\dbhome_1\log

#SQLNET.WALLET_OVERRIDE = FALSE

WALLET_LOCATION =

(SOURCE =

(METHOD = FILE

(METHOD_DATA =

(DIRECTORY = C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN)

)

Exhibit 3. Successful customized pluggable sqlnet.ora file.

2. Rename the sqlnet.ora to sqlnet.ora.tmp

3. Start the listener without a sqlnet.ora

4. Once the listener is successfully started, plug in the sqlnet.ora file

5. Start the database instance and other oracle database services or processes

6. Create the Oracle database instance TDE wallet’s master key by using the command

Exhibit 4. Setting the Encryption Master Key

ALTER SYSTEM SET KEY IDENTIFIED BY "Password";, where password is your password as entered. In Oracle12c, this command will automatically create the wallet with the master key. In previous releases, including Oracle11g, the DBA will need to use either mkstore or orapki to create the wallet accordingly.

7. Create an oracle wallet and auto login local wallet using the mkstore or orapki utilites. mkstore does this with one single command, orapki requires two commands for equivalent outcome.

It is recommended to use the TNS_ADMIN directory as a DBA friendly reference to create the wallet. This directory should be referenced in the WALLET_LOCATION parameter in the just plugged sqlnet.ora file.

7.1 Using mkstore (skip if using orapki)

Navigate to the wallet_location directory, e.g., TNS_ADMIN. Enter the command:

For Oracle11g Release 2 and earlier releases including Oracle10g:

mkstore –wrl . –create

For Oracle12c, the DBA must specify the encryption wallet location, regardless of the current directory:

mkstore –wrl “C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN” –create

When prompted, enter the master key password.

This will create both the regular wallet and the auto login local wallet.

7.2 Equivalently, using orapki (skip if using mkstore)

The DBA can create as many wallets as needed, but only one master key will be

Navigate to the wallet_location directory, e.g., TNS_ADMIN. For Oracle 11g and earlier releases, enter the command:

orapki wallet create –wallet .

For Oracle12c, use the name of the subdirectory where the wallet is to be created:

orapki wallet create –wallet wallet

In this example, the wallet will reside in the wallet subdirectory.

For Oracle11g and earlier releases, when prompted for, enter the master key password. Then, from the same directory, enter the command:

orapki wallet create –wallet . auto_login_local

In Oracle11g and earlier releases, the mkstore utility creates both the ewallet.p11 and the auto login local sso wallet, which can also be accomplished with the two orapki utility commands.

Enter the password when prompted.

7.3 Create the necessary credentials

Navigate to the wallet_location directory, e.g., TNS_ADMIN. Enter the command:

mkstore –wrl . –createCredential {CredentialString} {dBUserName} [dbUserPwd}

mkstore –wrl –createCredential KEYHOLDER1 orcldba “orcldbapassword”

Exhibit 5. Creating wallet credential for privileged users

In Oracle12c, the creation of encrypted objects can be easily implemented as common user in the container database (CDB), but it is not currently permitted in a pluggable database (PDB). Also, small syntax migration may have the DBA make an explicit entry such as a required directory or file system name.

Exhibit 6. Creating an encrypted tablespace in the CDB.

Exibit 8. Creating and altering and object as a CDB common user after opening the wallet.

Exhibit 9. No direct object encryption at PDB level.

Exhibit 10. Creating further user credential to manage wallet and user Oracle TDE.

Exhibit 11. Listing TDE encrytion wallet credentials.

Finally, the scripts to automate the startup and shutdown of the database services may look like this:

startdb.bat

rename C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora sqlnet.ora.tmp

net start OracleOraDB12Home1TNSListener

rename C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora.tmp sqlnet.ora

net start OracleServiceADN12c

Net start OracleRemExecServiceV2

net start OracleOraDB12Home1MTSRecoveryService

net start Oraclec_app_oracle_product_121~1.0_dbhome_1ConfigurationManager

net start OracleJobSchedulerADN12C

net start OracleVssWriterADN12C

N.B. Unlike Linux or Unix operating systems, like Solaris11, under Windows, Oracle will not automatically open the wallet at startup. Therefore, the DBA may need to include the following script as well.

C:\BATCH\openwallet.bat

This batch file contains the following command lines including a call to openwallet.sql

#openwallet.bat set ORACLE_SID=ADN12C
set ORACLE_UNQNAME=ADN12C
sqlplus sys/%Pwd% as sysdba @c:\SQL\openwallet.sql
echo Wallet must have been opened

Subsequently, openwallet.sql will contain the following statements, namely:

rem openwallet.sql
rem opening encryption wallet
alter system set encryption wallet open identified by password;
rem wallet successfully opened
rem exiting SQL*Plus
exit;

But if the DBA can also write good PL/SQL code, he can actually write a more elegant solution using a startup trigger, an approach also used to open the PDBs, as shown below:

Exhibit 12. Using a trigger to open the wallet in the Windows platform

Exhibit 13. Verifying that the wallet was opened after startup

Beyond, the DBA may store the trigger code in a stored procedure, and wrap it for security and privacy reasons, and invoke the procedure from the trigger. The code, just like the wallet files, should be backed up and secure accordingly.

stopdb.bat

net stop OracleOraDB12Home1TNSListener
net stop OracleServiceADN12c
Net stop OracleRemExecServiceV2
net stop OracleOraDB12Home1MTSRecoveryService
net stop Oraclec_app_oracle_product_121~1.0_dbhome_1ConfigurationManager
net stop OracleJobSchedulerADN12C
net stop OracleVssWriterADN12C

I will subsequently edit this blog to add comments on specific issues, and include specific usage with the Linux and Unix operating systems.

In the meantime, I am attaching the log of a test RMAN backup using encryption:

Recovery Manager: Release 12.1.0.1.0 - Production on Tue Oct 15 16:53:50 2013

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

connected to target database: ADN12C (DBID=2688320599)
connected to recovery catalog database

RMAN> set encryption on;
2> # Will allow for encrpted rman backups without introducing any keys, once the wallet is opened...
3> # should pass tag as a partial parameter for the tag name.
4> run {
5> allocate channel cH1 type disk;
6> sql 'alter system archive log current';
7> crosscheck archivelog all;
8> release channel cH1;
9> allocate channel cH1 type disk;
10> allocate channel cH2 type disk;
11> allocate channel cH3 type disk;
12> allocate channel cH4 type disk;
13> set limit channel cH1 kbytes 16577216;
14> set limit channel cH2 kbytes 16577216;
15> set limit channel cH3 kbytes 16577216;
16> set limit channel cH4 kbytes 16577216;
17> BACKUP AS COMPRESSED BACKUPSET
18> incremental level 0
19> FORMAT 'C:\app\oracle\recovery_area\adn12c\backupset\%T_%s_%d_L0_bkp_Db_%s%t%U'
20> FILESPERSET 1
21> (database);
22> BACKUP AS COMPRESSED BACKUPSET
23> incremental level 0
24> FORMAT 'C:\app\oracle\recovery_area\adn12c\backupset\%T_%s_%d_L0_bkp_Ctl_%s%t%U'
25> (current controlfile);
26> sql 'alter system archive log current';
27> BACKUP AS COMPRESSED BACKUPSET
28> incremental level 0
29> FORMAT 'C:\app\oracle\recovery_area\adn12c\backupset\%T_%s_%d_L0_bkp_Arc_%s%t%U'
30> (archivelog all);
31> backup spfile;
32> sql 'alter database backup controlfile to trace';
33> release channel cH1;
34> release channel cH2;
35> release channel cH3;
36> release channel cH4;
37> }
38> resync catalog;
39> list backupset of database;
40> list backupset of controlfile;
41> list backupset of archivelog all;
42> list restore point all;
43> report schema;
44> validate check logical skip inaccessible database;
45> restore validate database;
46> restore validate archivelog all;
47> report obsolete;
48> delete noprompt obsolete;
49> exit;
executing command: SET encryption

allocated channel: cH1
channel cH1: SID=14 device type=DISK

sql statement: alter system archive log current

validation succeeded for archived log
archived log file name=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000076_0823424537.0001 RECID=20 STAMP=828895571
validation succeeded for archived log
archived log file name=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000077_0823424537.0001 RECID=21 STAMP=828895573
validation succeeded for archived log
archived log file name=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000078_0823424537.0001 RECID=22 STAMP=828896040
Crosschecked 3 objects

released channel: cH1

allocated channel: cH1
channel cH1: SID=14 device type=DISK

allocated channel: cH2
channel cH2: SID=280 device type=DISK

allocated channel: cH3
channel cH3: SID=36 device type=DISK

allocated channel: cH4
channel cH4: SID=268 device type=DISK

Starting backup at 15-OCT-2013 16:54:11
channel cH1: starting compressed incremental level 0 datafile backup set
channel cH1: specifying datafile(s) in backup set
input datafile file number=00003 name=C:\APP\ORACLE\ORADATA\ADN12C\SYSAUX01.DBF
channel cH1: starting piece 1 at 15-OCT-2013 16:54:15
channel cH2: starting compressed incremental level 0 datafile backup set
channel cH2: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\ORACLE\ORADATA\ADN12C\SYSTEM01.DBF
channel cH2: starting piece 1 at 15-OCT-2013 16:54:15
channel cH3: starting compressed incremental level 0 datafile backup set
channel cH3: specifying datafile(s) in backup set
input datafile file number=00005 name=C:\APP\ORACLE\ORADATA\ADN12C\UNDOTBS01.DBF
channel cH3: starting piece 1 at 15-OCT-2013 16:54:18
channel cH4: starting compressed incremental level 0 datafile backup set
channel cH4: specifying datafile(s) in backup set
input datafile file number=00008 name=C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SYSAUX01.DBF
channel cH4: starting piece 1 at 15-OCT-2013 16:54:20
channel cH3: finished piece 1 at 15-OCT-2013 16:54:28
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_112_ADN12C_L0_BKP_DB_1128288960563GOMFSPO_1_1 tag=TAG20131015T165413 comment=NONE
channel cH3: backup set complete, elapsed time: 00:00:11
channel cH3: starting compressed incremental level 0 datafile backup set
channel cH3: specifying datafile(s) in backup set
input datafile file number=00004 name=C:\APP\ORACLE\ORADATA\ADN12C\PDBSEED\SYSAUX01.DBF
channel cH3: starting piece 1 at 15-OCT-2013 16:54:30
channel cH4: finished piece 1 at 15-OCT-2013 16:58:31
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_113_ADN12C_L0_BKP_DB_1138288960583HOMFSPQ_1_1 tag=TAG20131015T165413 comment=NONE
channel cH4: backup set complete, elapsed time: 00:04:12
channel cH4: starting compressed incremental level 0 datafile backup set
channel cH4: specifying datafile(s) in backup set
input datafile file number=00010 name=C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\EXAMPLE01.DBF
channel cH4: starting piece 1 at 15-OCT-2013 16:58:34
channel cH1: finished piece 1 at 15-OCT-2013 16:58:42
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_110_ADN12C_L0_BKP_DB_1108288960543EOMFSPM_1_1 tag=TAG20131015T165413 comment=NONE
channel cH1: backup set complete, elapsed time: 00:04:28
channel cH1: starting compressed incremental level 0 datafile backup set
channel cH1: specifying datafile(s) in backup set
input datafile file number=00007 name=C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SYSTEM01.DBF
channel cH1: starting piece 1 at 15-OCT-2013 16:58:45
channel cH3: finished piece 1 at 15-OCT-2013 16:58:48
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_114_ADN12C_L0_BKP_DB_1148288960703IOMFSQ6_1_1 tag=TAG20131015T165413 comment=NONE
channel cH3: backup set complete, elapsed time: 00:04:19
channel cH3: starting compressed incremental level 0 datafile backup set
channel cH3: specifying datafile(s) in backup set
input datafile file number=00002 name=C:\APP\ORACLE\ORADATA\ADN12C\PDBSEED\SYSTEM01.DBF
channel cH3: starting piece 1 at 15-OCT-2013 16:58:51
channel cH4: finished piece 1 at 15-OCT-2013 16:59:07
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_115_ADN12C_L0_BKP_DB_1158288963133JOMFT1P_1_1 tag=TAG20131015T165413 comment=NONE
channel cH4: backup set complete, elapsed time: 00:00:34
channel cH4: starting compressed incremental level 0 datafile backup set
channel cH4: specifying datafile(s) in backup set
input datafile file number=00011 name=C:\APP\ORACLE\ORADATA\ADN12C\ENCRDATA1.DBF
channel cH4: starting piece 1 at 15-OCT-2013 16:59:09
channel cH4: finished piece 1 at 15-OCT-2013 16:59:10
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_118_ADN12C_L0_BKP_DB_1188288963493MOMFT2T_1_1 tag=TAG20131015T165413 comment=NONE
channel cH4: backup set complete, elapsed time: 00:00:02
channel cH4: starting compressed incremental level 0 datafile backup set
channel cH4: specifying datafile(s) in backup set
input datafile file number=00012 name=C:\APP\ORACLE\ORADATA\ADN12C\RMANTBS1.DBF
channel cH4: starting piece 1 at 15-OCT-2013 16:59:13
channel cH4: finished piece 1 at 15-OCT-2013 16:59:17
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_119_ADN12C_L0_BKP_DB_1198288963533NOMFT31_1_1 tag=TAG20131015T165413 comment=NONE
channel cH4: backup set complete, elapsed time: 00:00:04
channel cH4: starting compressed incremental level 0 datafile backup set
channel cH4: specifying datafile(s) in backup set
input datafile file number=00006 name=C:\APP\ORACLE\ORADATA\ADN12C\USERS01.DBF
channel cH4: starting piece 1 at 15-OCT-2013 16:59:19
channel cH4: finished piece 1 at 15-OCT-2013 16:59:20
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_120_ADN12C_L0_BKP_DB_1208288963593OOMFT37_1_1 tag=TAG20131015T165413 comment=NONE
channel cH4: backup set complete, elapsed time: 00:00:02
channel cH4: starting compressed incremental level 0 datafile backup set
channel cH4: specifying datafile(s) in backup set
input datafile file number=00009 name=C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SAMPLE_SCHEMA_USERS01.DBF
channel cH4: starting piece 1 at 15-OCT-2013 16:59:22
channel cH2: finished piece 1 at 15-OCT-2013 16:59:22
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_111_ADN12C_L0_BKP_DB_1118288960553FOMFSPN_1_1 tag=TAG20131015T165413 comment=NONE
channel cH2: backup set complete, elapsed time: 00:05:08
channel cH4: finished piece 1 at 15-OCT-2013 16:59:24
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_121_ADN12C_L0_BKP_DB_1218288963623POMFT3A_1_1 tag=TAG20131015T165413 comment=NONE
channel cH4: backup set complete, elapsed time: 00:00:03
channel cH1: finished piece 1 at 15-OCT-2013 17:00:00
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_116_ADN12C_L0_BKP_DB_1168288963243KOMFT24_1_1 tag=TAG20131015T165413 comment=NONE
channel cH1: backup set complete, elapsed time: 00:01:15
channel cH3: finished piece 1 at 15-OCT-2013 17:00:00
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_117_ADN12C_L0_BKP_DB_1178288963313LOMFT2B_1_1 tag=TAG20131015T165413 comment=NONE
channel cH3: backup set complete, elapsed time: 00:01:09
Finished backup at 15-OCT-2013 17:00:00

Starting backup at 15-OCT-2013 17:00:05
channel cH1: starting compressed incremental level 0 datafile backup set
channel cH1: specifying datafile(s) in backup set
including current control file in backup set
channel cH1: starting piece 1 at 15-OCT-2013 17:00:11
channel cH1: finished piece 1 at 15-OCT-2013 17:00:12
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_122_ADN12C_L0_BKP_CTL_1228288964073QOMFT4N_1_1 tag=TAG20131015T170007 comment=NONE
channel cH1: backup set complete, elapsed time: 00:00:01
Finished backup at 15-OCT-2013 17:00:12

Starting Control File and SPFILE Autobackup at 15-OCT-2013 17:00:12
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\AUTOBACKUP\2013_10_15\O1_MF_S_828896414_95VC70L8_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 15-OCT-2013 17:00:18

sql statement: alter system archive log current

Starting backup at 15-OCT-2013 17:00:26
current log archived
skipping archived logs of thread 1 from sequence 76 to 77; already backed up
channel cH1: starting compressed archived log backup set
channel cH1: specifying archived log(s) in backup set
input archived log thread=1 sequence=78 RECID=22 STAMP=828896040
channel cH1: starting piece 1 at 15-OCT-2013 17:00:29
channel cH2: starting compressed archived log backup set
channel cH2: specifying archived log(s) in backup set
input archived log thread=1 sequence=79 RECID=23 STAMP=828896424
channel cH2: starting piece 1 at 15-OCT-2013 17:00:30
channel cH3: starting compressed archived log backup set
channel cH3: specifying archived log(s) in backup set
input archived log thread=1 sequence=80 RECID=24 STAMP=828896426
channel cH3: starting piece 1 at 15-OCT-2013 17:00:30
channel cH1: finished piece 1 at 15-OCT-2013 17:00:31
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_124_ADN12C_L0_BKP_ARC_1248288964293SOMFT5D_1_1 tag=TAG20131015T170028 comment=NONE
channel cH1: backup set complete, elapsed time: 00:00:03
channel cH2: finished piece 1 at 15-OCT-2013 17:00:32
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_125_ADN12C_L0_BKP_ARC_1258288964293TOMFT5D_1_1 tag=TAG20131015T170028 comment=NONE
channel cH2: backup set complete, elapsed time: 00:00:02
channel cH3: finished piece 1 at 15-OCT-2013 17:00:32
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_126_ADN12C_L0_BKP_ARC_1268288964303UOMFT5E_1_1 tag=TAG20131015T170028 comment=NONE
channel cH3: backup set complete, elapsed time: 00:00:02
Finished backup at 15-OCT-2013 17:00:32

Starting backup at 15-OCT-2013 17:00:37
channel cH1: starting full datafile backup set
channel cH1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel cH1: starting piece 1 at 15-OCT-2013 17:00:40
channel cH1: finished piece 1 at 15-OCT-2013 17:00:41
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\2013_10_15\O1_MF_NNSNF_TAG20131015T170039_95VC7RF5_.BKP tag=TAG20131015T170039 comment=NONE
channel cH1: backup set complete, elapsed time: 00:00:01
Finished backup at 15-OCT-2013 17:00:41

Starting Control File and SPFILE Autobackup at 15-OCT-2013 17:00:41
piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\AUTOBACKUP\2013_10_15\O1_MF_S_828896443_95VC7XQG_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 15-OCT-2013 17:00:46

sql statement: alter database backup controlfile to trace

released channel: cH1

released channel: cH2

released channel: cH3

released channel: cH4

starting full resync of recovery catalog
full resync complete

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1469 Incr 0 1.95M DISK 00:00:08 15-OCT-2013 16:40:21
BP Key: 1483 Status: AVAILABLE Compressed: YES Tag: TAG20131015T164011
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_88_ADN12C_L0_BKP_DB_888288952132OOMFRVD_1_1
List of Datafiles in backup set 1469
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
5 0 Incr 3192036 15-OCT-2013 16:40:14 C:\APP\ORACLE\ORADATA\ADN12C\UNDOTBS01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1470 Incr 0 133.38M DISK 00:03:59 15-OCT-2013 16:44:13
BP Key: 1484 Status: AVAILABLE Compressed: YES Tag: TAG20131015T164011
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_89_ADN12C_L0_BKP_DB_898288952142POMFRVE_1_1
List of Datafiles in backup set 1470
Container ID: 3, PDB Name: PDBADN1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
8 0 Incr 3192039 15-OCT-2013 16:40:18 C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SYSAUX01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1471 Incr 0 132.38M DISK 00:04:06 15-OCT-2013 16:44:30
BP Key: 1485 Status: AVAILABLE Compressed: YES Tag: TAG20131015T164011
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_90_ADN12C_L0_BKP_DB_908288952242QOMFRVO_1_1
List of Datafiles in backup set 1471
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
4 0 Incr 2450075 14-AUG-2013 09:24:32 C:\APP\ORACLE\ORADATA\ADN12C\PDBSEED\SYSAUX01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1472 Incr 0 142.30M DISK 00:04:35 15-OCT-2013 16:44:46
BP Key: 1486 Status: AVAILABLE Compressed: YES Tag: TAG20131015T164011
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_86_ADN12C_L0_BKP_DB_868288952112MOMFRVB_1_1
List of Datafiles in backup set 1472
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
3 0 Incr 3192034 15-OCT-2013 16:40:12 C:\APP\ORACLE\ORADATA\ADN12C\SYSAUX01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1473 Incr 0 18.86M DISK 00:00:30 15-OCT-2013 16:44:50
BP Key: 1487 Status: AVAILABLE Compressed: YES Tag: TAG20131015T164011
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_91_ADN12C_L0_BKP_DB_918288954602ROMFS74_1_1
List of Datafiles in backup set 1473
Container ID: 3, PDB Name: PDBADN1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
10 0 Incr 3192157 15-OCT-2013 16:44:20 C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\EXAMPLE01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1474 Incr 0 1.02M DISK 00:00:01 15-OCT-2013 16:44:55
BP Key: 1488 Status: AVAILABLE Compressed: YES Tag: TAG20131015T164011
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_94_ADN12C_L0_BKP_DB_948288954942UOMFS86_1_1
List of Datafiles in backup set 1474
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
11 0 Incr 3192178 15-OCT-2013 16:44:54 C:\APP\ORACLE\ORADATA\ADN12C\ENCRDATA1.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1475 Incr 0 1.02M DISK 00:00:01 15-OCT-2013 16:44:58
BP Key: 1489 Status: AVAILABLE Compressed: YES Tag: TAG20131015T164011
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_95_ADN12C_L0_BKP_DB_958288954972VOMFS89_1_1
List of Datafiles in backup set 1475
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
12 0 Incr 3192180 15-OCT-2013 16:44:58 C:\APP\ORACLE\ORADATA\ADN12C\RMANTBS1.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1476 Incr 0 1.23M DISK 00:00:02 15-OCT-2013 16:45:01
BP Key: 1490 Status: AVAILABLE Compressed: YES Tag: TAG20131015T164011
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_96_ADN12C_L0_BKP_DB_9682889549930OMFS8B_1_1
List of Datafiles in backup set 1476
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
6 0 Incr 3192181 15-OCT-2013 16:45:00 C:\APP\ORACLE\ORADATA\ADN12C\USERS01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1477 Incr 0 1.05M DISK 00:00:01 15-OCT-2013 16:45:04
BP Key: 1491 Status: AVAILABLE Compressed: YES Tag: TAG20131015T164011
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_97_ADN12C_L0_BKP_DB_9782889550331OMFS8F_1_1
List of Datafiles in backup set 1477
Container ID: 3, PDB Name: PDBADN1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
9 0 Incr 3192195 15-OCT-2013 16:45:04 C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SAMPLE_SCHEMA_USERS01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1478 Incr 0 168.39M DISK 00:04:59 15-OCT-2013 16:45:11
BP Key: 1492 Status: AVAILABLE Compressed: YES Tag: TAG20131015T164011
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_87_ADN12C_L0_BKP_DB_878288952122NOMFRVC_1_1
List of Datafiles in backup set 1478
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
1 0 Incr 3192035 15-OCT-2013 16:40:13 C:\APP\ORACLE\ORADATA\ADN12C\SYSTEM01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1479 Incr 0 48.43M DISK 00:01:07 15-OCT-2013 16:45:43
BP Key: 1493 Status: AVAILABLE Compressed: YES Tag: TAG20131015T164011
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_92_ADN12C_L0_BKP_DB_928288954762SOMFS7K_1_1
List of Datafiles in backup set 1479
Container ID: 3, PDB Name: PDBADN1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
7 0 Incr 3192165 15-OCT-2013 16:44:37 C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SYSTEM01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1480 Incr 0 46.52M DISK 00:00:56 15-OCT-2013 16:45:48
BP Key: 1494 Status: AVAILABLE Compressed: YES Tag: TAG20131015T164011
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_93_ADN12C_L0_BKP_DB_938288954922TOMFS84_1_1
List of Datafiles in backup set 1480
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
2 0 Incr 2450075 14-AUG-2013 09:24:32 C:\APP\ORACLE\ORADATA\ADN12C\PDBSEED\SYSTEM01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2158 Incr 0 2.03M DISK 00:00:09 15-OCT-2013 16:54:25
BP Key: 2172 Status: AVAILABLE Compressed: YES Tag: TAG20131015T165413
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_112_ADN12C_L0_BKP_DB_1128288960563GOMFSPO_1_1
List of Datafiles in backup set 2158
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
5 0 Incr 3193897 15-OCT-2013 16:54:19 C:\APP\ORACLE\ORADATA\ADN12C\UNDOTBS01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2159 Incr 0 133.38M DISK 00:04:13 15-OCT-2013 16:58:31
BP Key: 2173 Status: AVAILABLE Compressed: YES Tag: TAG20131015T165413
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_113_ADN12C_L0_BKP_DB_1138288960583HOMFSPQ_1_1
List of Datafiles in backup set 2159
Container ID: 3, PDB Name: PDBADN1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
8 0 Incr 3193899 15-OCT-2013 16:54:22 C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SYSAUX01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2160 Incr 0 142.29M DISK 00:04:27 15-OCT-2013 16:58:41
BP Key: 2174 Status: AVAILABLE Compressed: YES Tag: TAG20131015T165413
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_110_ADN12C_L0_BKP_DB_1108288960543EOMFSPM_1_1
List of Datafiles in backup set 2160
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
3 0 Incr 3193894 15-OCT-2013 16:54:15 C:\APP\ORACLE\ORADATA\ADN12C\SYSAUX01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2161 Incr 0 132.38M DISK 00:04:16 15-OCT-2013 16:58:46
BP Key: 2175 Status: AVAILABLE Compressed: YES Tag: TAG20131015T165413
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_114_ADN12C_L0_BKP_DB_1148288960703IOMFSQ6_1_1
List of Datafiles in backup set 2161
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
4 0 Incr 2450075 14-AUG-2013 09:24:32 C:\APP\ORACLE\ORADATA\ADN12C\PDBSEED\SYSAUX01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2162 Incr 0 18.86M DISK 00:00:31 15-OCT-2013 16:59:04
BP Key: 2176 Status: AVAILABLE Compressed: YES Tag: TAG20131015T165413
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_115_ADN12C_L0_BKP_DB_1158288963133JOMFT1P_1_1
List of Datafiles in backup set 2162
Container ID: 3, PDB Name: PDBADN1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
10 0 Incr 3193997 15-OCT-2013 16:58:35 C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\EXAMPLE01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2163 Incr 0 1.02M DISK 00:00:01 15-OCT-2013 16:59:10
BP Key: 2177 Status: AVAILABLE Compressed: YES Tag: TAG20131015T165413
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_118_ADN12C_L0_BKP_DB_1188288963493MOMFT2T_1_1
List of Datafiles in backup set 2163
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
11 0 Incr 3194011 15-OCT-2013 16:59:10 C:\APP\ORACLE\ORADATA\ADN12C\ENCRDATA1.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2164 Incr 0 1.02M DISK 00:00:01 15-OCT-2013 16:59:14
BP Key: 2178 Status: AVAILABLE Compressed: YES Tag: TAG20131015T165413
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_119_ADN12C_L0_BKP_DB_1198288963533NOMFT31_1_1
List of Datafiles in backup set 2164
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
12 0 Incr 3194013 15-OCT-2013 16:59:14 C:\APP\ORACLE\ORADATA\ADN12C\RMANTBS1.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2165 Incr 0 1.24M DISK 00:00:01 15-OCT-2013 16:59:20
BP Key: 2179 Status: AVAILABLE Compressed: YES Tag: TAG20131015T165413
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_120_ADN12C_L0_BKP_DB_1208288963593OOMFT37_1_1
List of Datafiles in backup set 2165
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
6 0 Incr 3194016 15-OCT-2013 16:59:19 C:\APP\ORACLE\ORADATA\ADN12C\USERS01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2166 Incr 0 168.39M DISK 00:05:06 15-OCT-2013 16:59:21
BP Key: 2180 Status: AVAILABLE Compressed: YES Tag: TAG20131015T165413
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_111_ADN12C_L0_BKP_DB_1118288960553FOMFSPN_1_1
List of Datafiles in backup set 2166
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
1 0 Incr 3193895 15-OCT-2013 16:54:17 C:\APP\ORACLE\ORADATA\ADN12C\SYSTEM01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2167 Incr 0 1.05M DISK 00:00:01 15-OCT-2013 16:59:23
BP Key: 2181 Status: AVAILABLE Compressed: YES Tag: TAG20131015T165413
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_121_ADN12C_L0_BKP_DB_1218288963623POMFT3A_1_1
List of Datafiles in backup set 2167
Container ID: 3, PDB Name: PDBADN1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
9 0 Incr 3194018 15-OCT-2013 16:59:23 C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SAMPLE_SCHEMA_USERS01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2168 Incr 0 48.43M DISK 00:01:10 15-OCT-2013 16:59:54
BP Key: 2182 Status: AVAILABLE Compressed: YES Tag: TAG20131015T165413
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_116_ADN12C_L0_BKP_DB_1168288963243KOMFT24_1_1
List of Datafiles in backup set 2168
Container ID: 3, PDB Name: PDBADN1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
7 0 Incr 3194002 15-OCT-2013 16:58:45 C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SYSTEM01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2169 Incr 0 46.52M DISK 00:01:05 15-OCT-2013 16:59:56
BP Key: 2183 Status: AVAILABLE Compressed: YES Tag: TAG20131015T165413
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_117_ADN12C_L0_BKP_DB_1178288963313LOMFT2B_1_1
List of Datafiles in backup set 2169
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
2 0 Incr 2450075 14-AUG-2013 09:24:32 C:\APP\ORACLE\ORADATA\ADN12C\PDBSEED\SYSTEM01.DBF

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1669 Full 17.20M DISK 00:00:02 15-OCT-2013 16:46:38
BP Key: 1671 Status: AVAILABLE Compressed: NO Tag: TAG20131015T164636
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\AUTOBACKUP\2013_10_15\O1_MF_S_828895596_95VBFFYZ_.BKP
Control File Included: Ckp SCN: 3192523 Ckp time: 15-OCT-2013 16:46:36

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2253 Incr 0 1.05M DISK 00:00:05 15-OCT-2013 17:00:12
BP Key: 2255 Status: AVAILABLE Compressed: YES Tag: TAG20131015T170007
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_122_ADN12C_L0_BKP_CTL_1228288964073QOMFT4N_1_1
Control File Included: Ckp SCN: 3194154 Ckp time: 15-OCT-2013 17:00:07

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2286 Full 17.20M DISK 00:00:03 15-OCT-2013 17:00:17
BP Key: 2288 Status: AVAILABLE Compressed: NO Tag: TAG20131015T170014
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\AUTOBACKUP\2013_10_15\O1_MF_S_828896414_95VC70L8_.BKP
Control File Included: Ckp SCN: 3194197 Ckp time: 15-OCT-2013 17:00:14

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2552 Full 17.20M DISK 00:00:03 15-OCT-2013 17:00:46
BP Key: 2554 Status: AVAILABLE Compressed: NO Tag: TAG20131015T170043
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\AUTOBACKUP\2013_10_15\O1_MF_S_828896443_95VC7XQG_.BKP
Control File Included: Ckp SCN: 3194576 Ckp time: 15-OCT-2013 17:00:43

List of Backup Sets
===================

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
1609 1.08M DISK 00:00:02 15-OCT-2013 16:46:19
BP Key: 1615 Status: AVAILABLE Compressed: YES Tag: TAG20131015T164615
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_102_ADN12C_L0_BKP_ARC_10282889557736OMFSAP_1_1

List of Archived Logs in backup set 1609
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 75 3191103 15-OCT-2013 16:21:57 3191826 15-OCT-2013 16:39:59
1 76 3191826 15-OCT-2013 16:39:59 3192369 15-OCT-2013 16:46:10

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
1610 35.00K DISK 00:00:02 15-OCT-2013 16:46:20
BP Key: 1616 Status: AVAILABLE Compressed: YES Tag: TAG20131015T164615
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_103_ADN12C_L0_BKP_ARC_10382889557837OMFSAQ_1_1

List of Archived Logs in backup set 1610
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 77 3192369 15-OCT-2013 16:46:10 3192399 15-OCT-2013 16:46:13

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
2442 950.50K DISK 00:00:02 15-OCT-2013 17:00:31
BP Key: 2447 Status: AVAILABLE Compressed: YES Tag: TAG20131015T170028
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_125_ADN12C_L0_BKP_ARC_1258288964293TOMFT5D_1_1

List of Archived Logs in backup set 2442
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 79 3193622 15-OCT-2013 16:53:59 3194325 15-OCT-2013 17:00:23

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
2443 71.50K DISK 00:00:01 15-OCT-2013 17:00:31
BP Key: 2448 Status: AVAILABLE Compressed: YES Tag: TAG20131015T170028
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_126_ADN12C_L0_BKP_ARC_1268288964303UOMFT5E_1_1

List of Archived Logs in backup set 2443
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 80 3194325 15-OCT-2013 17:00:23 3194379 15-OCT-2013 17:00:26

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
2444 1.40M DISK 00:00:02 15-OCT-2013 17:00:31
BP Key: 2449 Status: AVAILABLE Compressed: YES Tag: TAG20131015T170028
Piece Name: C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_124_ADN12C_L0_BKP_ARC_1248288964293SOMFT5D_1_1

List of Archived Logs in backup set 2444
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 78 3192399 15-OCT-2013 16:46:13 3193622 15-OCT-2013 16:53:59

SCN RSP Time Type Time Name
---------------- -------------------- ---------- -------------------- ----

Report of database schema for database with db_unique_name ADN12C

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 800 SYSTEM YES C:\APP\ORACLE\ORADATA\ADN12C\SYSTEM01.DBF
2 260 PDB$SEED:SYSTEM NO C:\APP\ORACLE\ORADATA\ADN12C\PDBSEED\SYSTEM01.DBF
3 860 SYSAUX NO C:\APP\ORACLE\ORADATA\ADN12C\SYSAUX01.DBF
4 640 PDB$SEED:SYSAUX NO C:\APP\ORACLE\ORADATA\ADN12C\PDBSEED\SYSAUX01.DBF
5 725 UNDOTBS1 YES C:\APP\ORACLE\ORADATA\ADN12C\UNDOTBS01.DBF
6 10 USERS NO C:\APP\ORACLE\ORADATA\ADN12C\USERS01.DBF
7 280 PDBADN1:SYSTEM NO C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SYSTEM01.DBF
8 710 PDBADN1:SYSAUX NO C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SYSAUX01.DBF
9 5 PDBADN1:USERS NO C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SAMPLE_SCHEMA_USERS01.DBF
10 358 PDBADN1:EXAMPLE NO C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\EXAMPLE01.DBF
11 200 ENCRDATA1 NO C:\APP\ORACLE\ORADATA\ADN12C\ENCRDATA1.DBF
12 100 RMANTBS NO C:\APP\ORACLE\ORADATA\ADN12C\RMANTBS1.DBF

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 88 TEMP 32767 C:\APP\ORACLE\ORADATA\ADN12C\TEMP01.DBF
2 87 PDB$SEED:TEMP 32767 C:\APP\ORACLE\ORADATA\ADN12C\PDBSEED\PDBSEED_TEMP01.DBF
3 87 PDBADN1:TEMP 32767 C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\PDBADN1_TEMP01.DBF

Starting validate at 15-OCT-2013 17:01:26
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=14 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00003 name=C:\APP\ORACLE\ORADATA\ADN12C\SYSAUX01.DBF
input datafile file number=00001 name=C:\APP\ORACLE\ORADATA\ADN12C\SYSTEM01.DBF
input datafile file number=00005 name=C:\APP\ORACLE\ORADATA\ADN12C\UNDOTBS01.DBF
input datafile file number=00011 name=C:\APP\ORACLE\ORADATA\ADN12C\ENCRDATA1.DBF
input datafile file number=00012 name=C:\APP\ORACLE\ORADATA\ADN12C\RMANTBS1.DBF
input datafile file number=00006 name=C:\APP\ORACLE\ORADATA\ADN12C\USERS01.DBF
channel ORA_DISK_1: validation complete, elapsed time: 00:01:15
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 17249 102400 3195228
File Name: C:\APP\ORACLE\ORADATA\ADN12C\SYSTEM01.DBF
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 67267
Index 0 13994
Other 0 3890

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3 OK 0 27798 110089 3195383
File Name: C:\APP\ORACLE\ORADATA\ADN12C\SYSAUX01.DBF
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 20287
Index 0 11726
Other 0 50269

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5 OK 0 1 92841 3195316
File Name: C:\APP\ORACLE\ORADATA\ADN12C\UNDOTBS01.DBF
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 92799

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 249 1319 3195315
File Name: C:\APP\ORACLE\ORADATA\ADN12C\USERS01.DBF
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 210
Index 0 151
Other 0 670

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11 OK 0 25473 25600 2808986
File Name: C:\APP\ORACLE\ORADATA\ADN12C\ENCRDATA1.DBF
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
12 OK 0 12673 12800 2844207
File Name: C:\APP\ORACLE\ORADATA\ADN12C\RMANTBS1.DBF
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127

channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00004 name=C:\APP\ORACLE\ORADATA\ADN12C\PDBSEED\SYSAUX01.DBF
input datafile file number=00002 name=C:\APP\ORACLE\ORADATA\ADN12C\PDBSEED\SYSTEM01.DBF
channel ORA_DISK_1: validation complete, elapsed time: 00:00:15
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2 OK 0 7215 33285 2450072
File Name: C:\APP\ORACLE\ORADATA\ADN12C\PDBSEED\SYSTEM01.DBF
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 14446
Index 0 8974
Other 0 2645

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4 OK 0 15078 81930 2450068
File Name: C:\APP\ORACLE\ORADATA\ADN12C\PDBSEED\SYSAUX01.DBF
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 15525
Index 0 7053
Other 0 44264

channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00008 name=C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SYSAUX01.DBF
input datafile file number=00010 name=C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\EXAMPLE01.DBF
input datafile file number=00007 name=C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SYSTEM01.DBF
input datafile file number=00009 name=C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SAMPLE_SCHEMA_USERS01.DBF
channel ORA_DISK_1: validation complete, elapsed time: 00:00:35
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7 OK 0 8346 35845 3194336
File Name: C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SYSTEM01.DBF
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 15461
Index 0 9340
Other 0 2693

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8 OK 0 21524 90888 3194336
File Name: C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SYSAUX01.DBF
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 16103
Index 0 7654
Other 0 45599

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9 OK 0 30 641 2804872
File Name: C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\SAMPLE_SCHEMA_USERS01.DBF
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 15
Index 0 2
Other 0 593

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
10 OK 0 34248 45840 2815452
File Name: C:\APP\ORACLE\ORADATA\ADN12C\PDBADN1\EXAMPLE01.DBF
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6744
Index 0 1199
Other 0 3649

channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
including current control file for validation
including current SPFILE in backup set
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE OK 0 2
Control File OK 0 1096
Finished validate at 15-OCT-2013 17:03:42

Starting restore at 15-OCT-2013 17:03:44
using channel ORA_DISK_1

channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_112_ADN12C_L0_BKP_DB_1128288960563GOMFSPO_1_1
channel ORA_DISK_1: piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_112_ADN12C_L0_BKP_DB_1128288960563GOMFSPO_1_1 tag=TAG20131015T165413
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_113_ADN12C_L0_BKP_DB_1138288960583HOMFSPQ_1_1
channel ORA_DISK_1: piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_113_ADN12C_L0_BKP_DB_1138288960583HOMFSPQ_1_1 tag=TAG20131015T165413
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_110_ADN12C_L0_BKP_DB_1108288960543EOMFSPM_1_1
channel ORA_DISK_1: piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_110_ADN12C_L0_BKP_DB_1108288960543EOMFSPM_1_1 tag=TAG20131015T165413
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_114_ADN12C_L0_BKP_DB_1148288960703IOMFSQ6_1_1
channel ORA_DISK_1: piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_114_ADN12C_L0_BKP_DB_1148288960703IOMFSQ6_1_1 tag=TAG20131015T165413
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_115_ADN12C_L0_BKP_DB_1158288963133JOMFT1P_1_1
channel ORA_DISK_1: piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_115_ADN12C_L0_BKP_DB_1158288963133JOMFT1P_1_1 tag=TAG20131015T165413
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_118_ADN12C_L0_BKP_DB_1188288963493MOMFT2T_1_1
channel ORA_DISK_1: piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_118_ADN12C_L0_BKP_DB_1188288963493MOMFT2T_1_1 tag=TAG20131015T165413
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_119_ADN12C_L0_BKP_DB_1198288963533NOMFT31_1_1
channel ORA_DISK_1: piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_119_ADN12C_L0_BKP_DB_1198288963533NOMFT31_1_1 tag=TAG20131015T165413
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_120_ADN12C_L0_BKP_DB_1208288963593OOMFT37_1_1
channel ORA_DISK_1: piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_120_ADN12C_L0_BKP_DB_1208288963593OOMFT37_1_1 tag=TAG20131015T165413
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_111_ADN12C_L0_BKP_DB_1118288960553FOMFSPN_1_1
channel ORA_DISK_1: piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_111_ADN12C_L0_BKP_DB_1118288960553FOMFSPN_1_1 tag=TAG20131015T165413
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_121_ADN12C_L0_BKP_DB_1218288963623POMFT3A_1_1
channel ORA_DISK_1: piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_121_ADN12C_L0_BKP_DB_1218288963623POMFT3A_1_1 tag=TAG20131015T165413
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:02
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_116_ADN12C_L0_BKP_DB_1168288963243KOMFT24_1_1
channel ORA_DISK_1: piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_116_ADN12C_L0_BKP_DB_1168288963243KOMFT24_1_1 tag=TAG20131015T165413
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_117_ADN12C_L0_BKP_DB_1178288963313LOMFT2B_1_1
channel ORA_DISK_1: piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_117_ADN12C_L0_BKP_DB_1178288963313LOMFT2B_1_1 tag=TAG20131015T165413
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:15
Finished restore at 15-OCT-2013 17:07:43

Starting restore at 15-OCT-2013 17:07:46
using channel ORA_DISK_1

channel ORA_DISK_1: scanning archived log C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000076_0823424537.0001
channel ORA_DISK_1: scanning archived log C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000077_0823424537.0001
channel ORA_DISK_1: scanning archived log C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000078_0823424537.0001
channel ORA_DISK_1: scanning archived log C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000079_0823424537.0001
channel ORA_DISK_1: scanning archived log C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000080_0823424537.0001
channel ORA_DISK_1: starting validation of archived log backup set
channel ORA_DISK_1: reading from backup piece C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_102_ADN12C_L0_BKP_ARC_10282889557736OMFSAP_1_1
channel ORA_DISK_1: piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_102_ADN12C_L0_BKP_ARC_10282889557736OMFSAP_1_1 tag=TAG20131015T164615
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:02
Finished restore at 15-OCT-2013 17:07:55

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 1469 15-OCT-2013 16:40:21
Backup Piece 1483 15-OCT-2013 16:40:21 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_88_ADN12C_L0_BKP_DB_888288952132OOMFRVD_1_1
Backup Set 1470 15-OCT-2013 16:44:13
Backup Piece 1484 15-OCT-2013 16:44:13 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_89_ADN12C_L0_BKP_DB_898288952142POMFRVE_1_1
Backup Set 1471 15-OCT-2013 16:44:30
Backup Piece 1485 15-OCT-2013 16:44:30 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_90_ADN12C_L0_BKP_DB_908288952242QOMFRVO_1_1
Backup Set 1472 15-OCT-2013 16:44:42
Backup Piece 1486 15-OCT-2013 16:44:42 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_86_ADN12C_L0_BKP_DB_868288952112MOMFRVB_1_1
Backup Set 1473 15-OCT-2013 16:44:50
Backup Piece 1487 15-OCT-2013 16:44:50 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_91_ADN12C_L0_BKP_DB_918288954602ROMFS74_1_1
Backup Set 1474 15-OCT-2013 16:44:55
Backup Piece 1488 15-OCT-2013 16:44:55 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_94_ADN12C_L0_BKP_DB_948288954942UOMFS86_1_1
Backup Set 1475 15-OCT-2013 16:44:58
Backup Piece 1489 15-OCT-2013 16:44:58 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_95_ADN12C_L0_BKP_DB_958288954972VOMFS89_1_1
Backup Set 1476 15-OCT-2013 16:45:01
Backup Piece 1490 15-OCT-2013 16:45:01 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_96_ADN12C_L0_BKP_DB_9682889549930OMFS8B_1_1
Backup Set 1477 15-OCT-2013 16:45:04
Backup Piece 1491 15-OCT-2013 16:45:04 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_97_ADN12C_L0_BKP_DB_9782889550331OMFS8F_1_1
Backup Set 1478 15-OCT-2013 16:45:11
Backup Piece 1492 15-OCT-2013 16:45:11 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_87_ADN12C_L0_BKP_DB_878288952122NOMFRVC_1_1
Backup Set 1479 15-OCT-2013 16:45:43
Backup Piece 1493 15-OCT-2013 16:45:43 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_92_ADN12C_L0_BKP_DB_928288954762SOMFS7K_1_1
Archive Log 1582 15-OCT-2013 16:46:11 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000076_0823424537.0001
Backup Set 1480 15-OCT-2013 16:45:48
Backup Piece 1494 15-OCT-2013 16:45:48 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_93_ADN12C_L0_BKP_DB_938288954922TOMFS84_1_1
Archive Log 1596 15-OCT-2013 16:46:13 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000077_0823424537.0001
Backup Set 1609 15-OCT-2013 16:46:19
Backup Piece 1615 15-OCT-2013 16:46:19 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_102_ADN12C_L0_BKP_ARC_10282889557736OMFSAP_1_1
Backup Set 1610 15-OCT-2013 16:46:19
Backup Piece 1616 15-OCT-2013 16:46:19 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_103_ADN12C_L0_BKP_ARC_10382889557837OMFSAQ_1_1
Archive Log 2051 15-OCT-2013 16:54:00 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000078_0823424537.0001
Backup Set 1669 15-OCT-2013 16:46:38
Backup Piece 1671 15-OCT-2013 16:46:38 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\AUTOBACKUP\2013_10_15\O1_MF_S_828895596_95VBFFYZ_.BKP
Backup Set 2253 15-OCT-2013 17:00:12
Backup Piece 2255 15-OCT-2013 17:00:12 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_122_ADN12C_L0_BKP_CTL_1228288964073QOMFT4N_1_1
Backup Set 2286 15-OCT-2013 17:00:17
Backup Piece 2288 15-OCT-2013 17:00:17 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\AUTOBACKUP\2013_10_15\O1_MF_S_828896414_95VC70L8_.BKP
Backup Set 2444 15-OCT-2013 17:00:31
Backup Piece 2449 15-OCT-2013 17:00:31 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_124_ADN12C_L0_BKP_ARC_1248288964293SOMFT5D_1_1
Backup Set 2516 15-OCT-2013 17:00:40
Backup Piece 2518 15-OCT-2013 17:00:40 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\2013_10_15\O1_MF_NNSNF_TAG20131015T170039_95VC7RF5_.BKP

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 1469 15-OCT-2013 16:40:21
Backup Piece 1483 15-OCT-2013 16:40:21 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_88_ADN12C_L0_BKP_DB_888288952132OOMFRVD_1_1
Backup Set 1470 15-OCT-2013 16:44:13
Backup Piece 1484 15-OCT-2013 16:44:13 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_89_ADN12C_L0_BKP_DB_898288952142POMFRVE_1_1
Backup Set 1471 15-OCT-2013 16:44:30
Backup Piece 1485 15-OCT-2013 16:44:30 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_90_ADN12C_L0_BKP_DB_908288952242QOMFRVO_1_1
Backup Set 1472 15-OCT-2013 16:44:42
Backup Piece 1486 15-OCT-2013 16:44:42 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_86_ADN12C_L0_BKP_DB_868288952112MOMFRVB_1_1
Backup Set 1473 15-OCT-2013 16:44:50
Backup Piece 1487 15-OCT-2013 16:44:50 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_91_ADN12C_L0_BKP_DB_918288954602ROMFS74_1_1
Backup Set 1474 15-OCT-2013 16:44:55
Backup Piece 1488 15-OCT-2013 16:44:55 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_94_ADN12C_L0_BKP_DB_948288954942UOMFS86_1_1
Backup Set 1475 15-OCT-2013 16:44:58
Backup Piece 1489 15-OCT-2013 16:44:58 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_95_ADN12C_L0_BKP_DB_958288954972VOMFS89_1_1
Backup Set 1476 15-OCT-2013 16:45:01
Backup Piece 1490 15-OCT-2013 16:45:01 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_96_ADN12C_L0_BKP_DB_9682889549930OMFS8B_1_1
Backup Set 1477 15-OCT-2013 16:45:04
Backup Piece 1491 15-OCT-2013 16:45:04 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_97_ADN12C_L0_BKP_DB_9782889550331OMFS8F_1_1
Backup Set 1478 15-OCT-2013 16:45:11
Backup Piece 1492 15-OCT-2013 16:45:11 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_87_ADN12C_L0_BKP_DB_878288952122NOMFRVC_1_1
Backup Set 1479 15-OCT-2013 16:45:43
Backup Piece 1493 15-OCT-2013 16:45:43 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_92_ADN12C_L0_BKP_DB_928288954762SOMFS7K_1_1
Archive Log 1582 15-OCT-2013 16:46:11 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000076_0823424537.0001
Backup Set 1480 15-OCT-2013 16:45:48
Backup Piece 1494 15-OCT-2013 16:45:48 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_93_ADN12C_L0_BKP_DB_938288954922TOMFS84_1_1
Archive Log 1596 15-OCT-2013 16:46:13 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000077_0823424537.0001
Backup Set 1609 15-OCT-2013 16:46:19
Backup Piece 1615 15-OCT-2013 16:46:19 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_102_ADN12C_L0_BKP_ARC_10282889557736OMFSAP_1_1
Backup Set 1610 15-OCT-2013 16:46:19
Backup Piece 1616 15-OCT-2013 16:46:19 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_103_ADN12C_L0_BKP_ARC_10382889557837OMFSAQ_1_1
Archive Log 2051 15-OCT-2013 16:54:00 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000078_0823424537.0001
Backup Set 1669 15-OCT-2013 16:46:38
Backup Piece 1671 15-OCT-2013 16:46:38 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\AUTOBACKUP\2013_10_15\O1_MF_S_828895596_95VBFFYZ_.BKP
Backup Set 2253 15-OCT-2013 17:00:12
Backup Piece 2255 15-OCT-2013 17:00:12 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_122_ADN12C_L0_BKP_CTL_1228288964073QOMFT4N_1_1
Backup Set 2286 15-OCT-2013 17:00:17
Backup Piece 2288 15-OCT-2013 17:00:17 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\AUTOBACKUP\2013_10_15\O1_MF_S_828896414_95VC70L8_.BKP
Backup Set 2444 15-OCT-2013 17:00:31
Backup Piece 2449 15-OCT-2013 17:00:31 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_124_ADN12C_L0_BKP_ARC_1248288964293SOMFT5D_1_1
Backup Set 2516 15-OCT-2013 17:00:40
Backup Piece 2518 15-OCT-2013 17:00:40 C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\2013_10_15\O1_MF_NNSNF_TAG20131015T170039_95VC7RF5_.BKP
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_88_ADN12C_L0_BKP_DB_888288952132OOMFRVD_1_1 RECID=58 STAMP=828895216
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_89_ADN12C_L0_BKP_DB_898288952142POMFRVE_1_1 RECID=59 STAMP=828895218
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_90_ADN12C_L0_BKP_DB_908288952242QOMFRVO_1_1 RECID=60 STAMP=828895225
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_86_ADN12C_L0_BKP_DB_868288952112MOMFRVB_1_1 RECID=61 STAMP=828895212
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_91_ADN12C_L0_BKP_DB_918288954602ROMFS74_1_1 RECID=62 STAMP=828895460
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_94_ADN12C_L0_BKP_DB_948288954942UOMFS86_1_1 RECID=63 STAMP=828895494
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_95_ADN12C_L0_BKP_DB_958288954972VOMFS89_1_1 RECID=64 STAMP=828895498
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_96_ADN12C_L0_BKP_DB_9682889549930OMFS8B_1_1 RECID=65 STAMP=828895500
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_97_ADN12C_L0_BKP_DB_9782889550331OMFS8F_1_1 RECID=66 STAMP=828895504
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_87_ADN12C_L0_BKP_DB_878288952122NOMFRVC_1_1 RECID=67 STAMP=828895214
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_92_ADN12C_L0_BKP_DB_928288954762SOMFS7K_1_1 RECID=68 STAMP=828895477
deleted archived log
archived log file name=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000076_0823424537.0001 RECID=20 STAMP=828895571
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_93_ADN12C_L0_BKP_DB_938288954922TOMFS84_1_1 RECID=69 STAMP=828895493
deleted archived log
archived log file name=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000077_0823424537.0001 RECID=21 STAMP=828895573
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_102_ADN12C_L0_BKP_ARC_10282889557736OMFSAP_1_1 RECID=72 STAMP=828895578
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_103_ADN12C_L0_BKP_ARC_10382889557837OMFSAQ_1_1 RECID=73 STAMP=828895579
deleted archived log
archived log file name=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\ARCHIVELOG\ARC0000000078_0823424537.0001 RECID=22 STAMP=828896040
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\AUTOBACKUP\2013_10_15\O1_MF_S_828895596_95VBFFYZ_.BKP RECID=77 STAMP=828895597
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_122_ADN12C_L0_BKP_CTL_1228288964073QOMFT4N_1_1 RECID=90 STAMP=828896411
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\AUTOBACKUP\2013_10_15\O1_MF_S_828896414_95VC70L8_.BKP RECID=91 STAMP=828896416
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\20131015_124_ADN12C_L0_BKP_ARC_1248288964293SOMFT5D_1_1 RECID=94 STAMP=828896429
deleted backup piece
backup piece handle=C:\APP\ORACLE\RECOVERY_AREA\ADN12C\BACKUPSET\2013_10_15\O1_MF_NNSNF_TAG20131015T170039_95VC7RF5_.BKP RECID=95 STAMP=828896440
Deleted 22 objects

Recovery Manager complete.

Although I personally prefer to look at my backupsets in one unique folder, for those who asked me about how to place each backupset on a daily folder (Oracle's recommended option), simply change the script, as follows:

set encryption on;
# Will allow for encrpted rman backups without introducing any keys, once the wallet is opened...
# should pass tag as a partial parameter for the tag name.
run {
allocate channel cH1 type disk;
sql 'alter system archive log current';
crosscheck archivelog all;
release channel cH1;
allocate channel cH1 type disk;
allocate channel cH2 type disk;
allocate channel cH3 type disk;
allocate channel cH4 type disk;
set limit channel cH1 kbytes 16577216;
set limit channel cH2 kbytes 16577216;
set limit channel cH3 kbytes 16577216;
set limit channel cH4 kbytes 16577216;
backup spfile;
BACKUP AS COMPRESSED BACKUPSET
incremental level 0
FORMAT 'C:\app\oracle\recovery_area\adn12c\backupset\%Y_%M_%D\%T_%s_%d_L0_bkp_Db_%s%t%U'
FILESPERSET 1
(database);
BACKUP AS COMPRESSED BACKUPSET
incremental level 0
FORMAT 'C:\app\oracle\recovery_area\adn12c\backupset\%Y_%M_%D\%T_%s_%d_L0_bkp_Ctl_%s%t%U'
(current controlfile);
sql 'alter system archive log current';
BACKUP AS COMPRESSED BACKUPSET
incremental level 0
FORMAT 'C:\app\oracle\recovery_area\adn12c\backupset\%Y_%M_%D\%T_%s_%d_L0_bkp_Arc_%s%t%U'
(archivelog all);
backup spfile;
sql 'alter database backup controlfile to trace';
release channel cH1;
release channel cH2;
release channel cH3;
release channel cH4;
}
resync catalog;
list backupset of database;
list backupset of controlfile;
list backupset of archivelog all;
list restore point all;
report schema;
validate check logical skip inaccessible database;
restore validate database;
restore validate archivelog all;
report obsolete;
delete noprompt obsolete;
exit;

Also, it is important to remark that since this script explicitly attempts to backup the spfile, you must have started the database using the spifle rather than a pfile file.