Translate

Sunday, September 1, 2013

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.

2 comments:

Jeevananthan C said...

Its really helpful for me to understand where we i lost in my previous interview. Thanks.
If anyone wants to Learn oracle in Chennai go to the Besant Technologies which is No.1 Training Institute in Chennai.

http://www.oracletrainingchennai.in

Path Infotech said...

Path Infotech is in the field of oracle training program from past several years.

For more info : Oracle Certification Courses