Thursday, April 28, 2016

RMAN-06059: expected archived log not found

manually deleted some files, and when backup archived log files using RMAN,


Starting backup at 2016-APR-27 11:33:09
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=160 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=162 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/27/2016 11:33:29
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /cc014/oraarch/TESTDB/TESTDB_0001_761215983_43224.arc
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3


issued ,

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=303 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=160 device type=DISK
validation succeeded for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57463.arc RECID=57445 STAMP=908551327
validation succeeded for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57464.arc RECID=57446 STAMP=908551336
validation succeeded for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57465.arc RECID=57447 STAMP=908551347
validation succeeded for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57466.arc RECID=57448 STAMP=908551357
validation succeeded for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57467.arc RECID=57449 STAMP=908551366
validation succeeded for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57468.arc RECID=57450 STAMP=908551377
validation succeeded for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57469.arc RECID=57451 STAMP=908551384
validation succeeded for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57470.arc RECID=57452 STAMP=908551390
validation succeeded for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57471.arc RECID=57453 STAMP=908551398
validation succeeded for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57472.arc RECID=57454 STAMP=908551404
...

archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_47965.arc RECID=47947 STAMP=843054910
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_47966.arc RECID=47948 STAMP=843054994
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_47967.arc RECID=47949 STAMP=843058390
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_47968.arc RECID=47950 STAMP=843058474
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_47969.arc RECID=47951 STAMP=843058505
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_47970.arc RECID=47952 STAMP=843058591
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_47971.arc RECID=47953 STAMP=843062002
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_47972.arc RECID=47954 STAMP=843062090
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_47973.arc RECID=47955 STAMP=843062111
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_47974.arc RECID=47956 STAMP=843062196
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_47975.arc RECID=47957 STAMP=843065605
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_47976.arc RECID=47958 STAMP=843065687
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_47977.arc RECID=47959 STAMP=843065782
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_47978.arc RECID=47960 STAMP=843065802
validation failed for archived log

...
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57456.arc RECID=57438 STAMP=908491636
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57457.arc RECID=57439 STAMP=908500971
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57458.arc RECID=57440 STAMP=908502821
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57459.arc RECID=57441 STAMP=908506176
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57460.arc RECID=57442 STAMP=908508642
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57461.arc RECID=57443 STAMP=908521666
validation failed for archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57462.arc RECID=57444 STAMP=908538814
Crosschecked 14239 objects

For record type DELETED OBJECT RECIDS from 2 to 3 are re-used before resync


Now continue the backup for archived log files.


Wednesday, April 27, 2016

Ubuntu Hibernate button

Like to use the suspend/Hibernate function of Ubuntu, which saves me time from Bootup.

It find this is in gnome flashback(Metachity) session.only. Would like to try other Gnome new desktop session, but didn't switch to, due to lacking of the hibernate button.

Googled and finally find it is there, just need to press ALT button, and the power off icon becomes PAUSE icon, which means suspend/Hibernate.



Later on, I also find my favorite taskbar / panel by configure it with gnome-tweak-tool

solutions for handling RMAN-08138

configured
"CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;  "


when

RMAN> delete noprompt archivelog until time 'sysdate-14';

starting full resync of recovery catalog
full resync complete
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=156 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=279 device type=DISK
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_43224.arc thread=1 sequence=43224
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_43225.arc thread=1 sequence=43225
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_43226.arc thread=1 sequence=43226
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_43227.arc thread=1 sequence=43227
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_43228.arc thread=1 sequence=43228
RMAN-08138: WARNING: archived log not deleted - must create more backups


We can also notice those archive log files are marked as X (expired).

457433  1    50363   X 2014-AUG-04 21:55:02
        Name: /cc014/oraarch/TESTDB/TESTDB_0001_761215983_50363.arc

457434  1    50364   X 2014-AUG-04 21:56:31
        Name: /cc014/oraarch/TESTDB/TESTDB_0001_761215983_50364.arc

457435  1    50365   X 2014-AUG-04 22:32:17
        Name: /cc014/oraarch/TESTDB/TESTDB_0001_761215983_50365.arc

457436  1    50366   X 2014-AUG-04 22:53:36
        Name: /cc014/oraarch/TESTDB/TESTDB_0001_761215983_50366.arc

457437  1    50367   X 2014-AUG-04 22:55:08
        Name: /cc014/oraarch/TESTDB/TESTDB_0001_761215983_50367.arc

457438  1    50368   X 2014-AUG-04 22:56:33
        Name: /cc014/oraarch/TESTDB/TESTDB_0001_761215983_50368.arc

457439  1    50369   X 2014-AUG-04 23:51:36


since those files are manually purged and no longer on disk, my workaround for this test database is to temporally clear the archivelog deletion policy.

CONFIGURE ARCHIVELOG DELETION POLICY CLEAR;


Then, re-execute the command again, which went through.

archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57460.arc RECID=57442 STAMP=908508642
deleted archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57461.arc RECID=57443 STAMP=908521666
deleted archived log
archived log file name=/cc014/oraarch/TESTDB/TESTDB_0001_761215983_57462.arc RECID=57444 STAMP=908538814
Deleted 14239 objects



Now , I can enable the deletion policy again.

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;  



Believe below two methods also work which I googled.

http://oraclehariprasathdba.blogspot.sg/2013/02/how-to-force-oracle-rman-to-delete-all.html

delete force archivelog all;

http://oraclebyravi.blogspot.sg/2013/08/rman-08138-warning-archived-log-not.html

delete noprompt expired archivelog all;





Monday, April 25, 2016

Ubuntu login loop

Upgraded to Ubuntu 15.10 from 15.10, resolved blank screen by playing with gdm/lightdm. Finally lightdm is my choice, which works with the video driver xserver-xorg-video-nouveau.

Then I am facing loop login, read very thoroughly on below two articles.


http://askubuntu.com/questions/223501/ubuntu-gets-stuck-in-a-login-loop

http://askubuntu.com/questions/590561/ubuntu-14-04-login-loop-problem


End up , found the .Xauthority is owned by root, however even I changed its ownership/renamed it , didn't solove my problem.

The hint .xsession_errors saved me, the message is :
line 31  /etc/X11/Xsession.d/20desktop-profiles_activateDesktopProfiles ambiguous redirect.

Searched the ERRFILE in the file, seems it is not defined.

Comment out the line, and I made it !

however, it is better to set ERRFILE=~/.xsession_errors   

before line


  echo "Shell library $LIB is missing -> assuming desktop-profiles is removed (but not purged)" >> $ERRFILE;




Now I see below message, seems no much indexed in google. anyway it is affecting my login.

 hmc@hmc-P55A-UD3:/mnt/localubt/hmc$ cat .xsession_errors
Shell library /usr/share/desktop-profiles/listingmodule is missing -> assuming desktop-profiles is removed (but not purged)

Friday, April 22, 2016

Friday, April 15, 2016

Happened to issue "BACKUP filesperset 2 incremental level 1 DATABASE ;", without knowing that there is no LEVEL 0 backup has been created, for  a 11.2.0.3 EE database.  As we know , if there is no LEVEL 0 exists, the RMAN will automatically created the very first as LEVEL 0 backup.  This is a good feature.

However, based on my below investigation, this feature is not efficient.

While waiting and waiting, which didn't complete within my expect time.

Then I am interested to know what happened, as the time is 5x than what was taken for a fresh LEVEL 0 backup.

Furthermore investigation shows the backupset size is 5.7x times larger than a fresh LEVEL 0 backupset.


This is very surprising.  For this case, I learned it is better to have LEVEL 0 pre-created before running LEVEL 1.

Below are technical numbers.


--full backup size

testdbdev:TESTDB:/dbfra/testdbdev/TESTDB/backupset/2016_04_13> ls -lrt *T142516*
-rw-r-----   1 oratest   oratest   8839168 Apr 13 13:43 o1_mf_nnndf_TAG20160413T142516_cjvsldnj_.bkp
-rw-r-----   1 oratest   oratest   38264832 Apr 13 13:43 o1_mf_nnndf_TAG20160413T142516_cjvsw8k3_.bkp
-rw-r-----   1 oratest   oratest   8224768 Apr 13 13:45 o1_mf_nnndf_TAG20160413T142516_cjvsx1vn_.bkp
-rw-r-----   1 oratest   oratest   37568512 Apr 13 13:49 o1_mf_nnndf_TAG20160413T142516_cjvszfhs_.bkp
-rw-r-----   1 oratest   oratest   2370019328 Apr 13 13:55 o1_mf_nnndf_TAG20160413T142516_cjvsldo0_.bkp
-rw-r-----   1 oratest   oratest   2252800 Apr 13 13:56 o1_mf_nnndf_TAG20160413T142516_cjvtmrx9_.bkp
-rw-r-----   1 oratest   oratest   17235968 Apr 13 13:56 o1_mf_nnndf_TAG20160413T142516_cjvtnw8y_.bkp
-rw-r-----   1 oratest   oratest   18685952 Apr 13 13:57 o1_mf_nnndf_TAG20160413T142516_cjvtocmk_.bkp
-rw-r-----   1 oratest   oratest   1310720 Apr 13 13:57 o1_mf_nnndf_TAG20160413T142516_cjvtphbl_.bkp
-rw-r-----   1 oratest   oratest   2809856 Apr 13 13:58 o1_mf_nnndf_TAG20160413T142516_cjvtpyr6_.bkp
-rw-r-----   1 oratest   oratest   2097152 Apr 13 13:58 o1_mf_nnndf_TAG20160413T142516_cjvtrp7p_.bkp
-rw-r-----   1 oratest   oratest   1105920 Apr 13 13:58 o1_mf_nnndf_TAG20160413T142516_cjvtrxhf_.bkp
-rw-r-----   1 oratest   oratest   1753088 Apr 13 13:58 o1_mf_nnndf_TAG20160413T142516_cjvts0wr_.bkp
-rw-r-----   1 oratest   oratest   12312576 Apr 13 13:58 o1_mf_nnndf_TAG20160413T142516_cjvts2b7_.bkp
-rw-r-----   1 oratest   oratest   380239872 Apr 13 14:01 o1_mf_nnndf_TAG20160413T142516_cjvts9w8_.bkp
-rw-r-----   1 oratest   oratest   1277952 Apr 13 14:01 o1_mf_nnndf_TAG20160413T142516_cjvtyh70_.bkp
-rw-r-----   1 oratest   oratest   1114112 Apr 13 14:01 o1_mf_nnndf_TAG20160413T142516_cjvtypkv_.bkp
-rw-r-----   1 oratest   oratest   24395776 Apr 13 14:02 o1_mf_nnndf_TAG20160413T142516_cjvtyqxp_.bkp
-rw-r-----   1 oratest   oratest   2891776 Apr 13 14:02 o1_mf_nnndf_TAG20160413T142516_cjvtzkfw_.bkp
-rw-r-----   1 oratest   oratest   1130496 Apr 13 14:02 o1_mf_nnndf_TAG20160413T142516_cjvtzrlc_.bkp
-rw-r-----   1 oratest   oratest   2410258432 Apr 13 14:03 o1_mf_nnndf_TAG20160413T142516_cjvt6s11_.bkp

testdbdev:TESTDB:/dbfra/testdbdev/TESTDB/backupset/2016_04_13> ls -lrt *T142516* |wc -l
      21


testdbdev:TESTDB:/dbfra/testdbdev/TESTDB/backupset/2016_04_13> ls -lrt *T142516* |awk '{ sum += $5 } END { print sum }'
5343789056

It is about 5.3GB.


--this is the level 0 created by very first level 1

testdbdev:TESTDB:/dbfra/testdbdev/TESTDB/backupset/2016_04_13> ls -lrt *T150822*
-rw-r-----   1 oratest   oratest   9838592 Apr 13 14:27 o1_mf_nnnd1_TAG20160413T150822_cjvw37f7_.bkp
-rw-r-----   1 oratest   oratest   10159611904 Apr 13 15:41 o1_mf_nnnd1_TAG20160413T150822_cjvw37f2_.bkp
-rw-r-----   1 oratest   oratest   8804286464 Apr 13 15:41 o1_mf_nnnd1_TAG20160413T150822_cjvwgz4w_.bkp
-rw-r-----   1 oratest   oratest   403144704 Apr 13 15:49 o1_mf_nnnd1_TAG20160413T150822_cjw0swgl_.bkp
-rw-r-----   1 oratest   oratest   3922280448 Apr 13 16:11 o1_mf_nnnd1_TAG20160413T150822_cjw0s379_.bkp
-rw-r-----   1 oratest   oratest   1470185472 Apr 13 16:23 o1_mf_nnnd1_TAG20160413T150822_cjw2l7bw_.bkp
-rw-r-----   1 oratest   oratest   4727996416 Apr 13 16:23 o1_mf_nnnd1_TAG20160413T150822_cjw18rk1_.bkp
-rw-r-----   1 oratest   oratest   234045440 Apr 13 16:24 o1_mf_nnnd0_TAG20160413T150822_cjw38mvs_.bkp
-rw-r-----   1 oratest   oratest   1351680 Apr 13 16:25 o1_mf_nnnd1_TAG20160413T150822_cjw3c67g_.bkp
-rw-r-----   1 oratest   oratest   2703360 Apr 13 16:26 o1_mf_nnnd1_TAG20160413T150822_cjw3dxqy_.bkp
-rw-r-----   1 oratest   oratest   2056192 Apr 13 16:27 o1_mf_nnnd1_TAG20160413T150822_cjw3gofy_.bkp
-rw-r-----   1 oratest   oratest   2482176 Apr 13 16:27 o1_mf_nnnd1_TAG20160413T150822_cjw3j2co_.bkp
-rw-r-----   1 oratest   oratest   16982016 Apr 13 16:28 o1_mf_nnnd1_TAG20160413T150822_cjw3jkmp_.bkp
-rw-r-----   1 oratest   oratest   527409152 Apr 13 16:28 o1_mf_nnnd1_TAG20160413T150822_cjw38tpx_.bkp
-rw-r-----   1 oratest   oratest   16621568 Apr 13 16:28 o1_mf_nnnd1_TAG20160413T150822_cjw3kbwl_.bkp
-rw-r-----   1 oratest   oratest   27369472 Apr 13 16:28 o1_mf_nnnd1_TAG20160413T150822_cjw3klhk_.bkp
-rw-r-----   1 oratest   oratest   1302528 Apr 13 16:28 o1_mf_nnnd1_TAG20160413T150822_cjw3l2fo_.bkp
-rw-r-----   1 oratest   oratest   1114112 Apr 13 16:29 o1_mf_nnnd1_TAG20160413T150822_cjw3lk6v_.bkp
-rw-r-----   1 oratest   oratest   2875392 Apr 13 16:29 o1_mf_nnnd1_TAG20160413T150822_cjw3m43h_.bkp
-rw-r-----   1 oratest   oratest   1081344 Apr 13 16:29 o1_mf_nnnd1_TAG20160413T150822_cjw3mmb2_.bkp
-rw-r-----   1 oratest   oratest   141950976 Apr 13 16:29 o1_mf_nnnd0_TAG20160413T150822_cjw3lnyk_.bkp

testdbdev:TESTDB:/dbfra/testdbdev/TESTDB/backupset/2016_04_13> ls -lrt *T150822* |wc -l
      21

testdbdev:TESTDB:/dbfra/testdbdev/TESTDB/backupset/2016_04_13> ls -lrt *T150822* | awk '{ sum += $5 } END { print sum }'
30476689408


The size is about 30GB. 
Duration for this run is about 102 minutes.



-- run a level 0 backup using command "BACKUP filesperset 2 incremental level 0 DATABASE ;"


testdb01:EDWD:/dbfra/testdb01/EDWD/backupset/2016_04_13> ls -lrt *T173009* |wc -l
      21
testdb01:EDWD:/dbfra/testdb01/EDWD/backupset/2016_04_13> ls -lrt *T173009*
-rw-r-----   1 oratest   oratest   38264832 Apr 13 16:43 o1_mf_nnnd0_TAG20160413T173009_cjw4f3hk_.bkp
-rw-r-----   1 oratest   oratest   8224768 Apr 13 16:45 o1_mf_nnnd0_TAG20160413T173009_cjw4f3t3_.bkp
-rw-r-----   1 oratest   oratest   2203648 Apr 13 16:45 o1_mf_nnnd0_TAG20160413T173009_cjw4jx5z_.bkp
-rw-r-----   1 oratest   oratest   17235968 Apr 13 16:46 o1_mf_nnnd0_TAG20160413T173009_cjw4l0xx_.bkp
-rw-r-----   1 oratest   oratest   18685952 Apr 13 16:46 o1_mf_nnnd0_TAG20160413T173009_cjw4ltlb_.bkp
-rw-r-----   1 oratest   oratest   1310720 Apr 13 16:47 o1_mf_nnnd0_TAG20160413T173009_cjw4n8d9_.bkp
-rw-r-----   1 oratest   oratest   2809856 Apr 13 16:48 o1_mf_nnnd0_TAG20160413T173009_cjw4ooqv_.bkp
-rw-r-----   1 oratest   oratest   2097152 Apr 13 16:48 o1_mf_nnnd0_TAG20160413T173009_cjw4qfgm_.bkp
-rw-r-----   1 oratest   oratest   1105920 Apr 13 16:48 o1_mf_nnnd0_TAG20160413T173009_cjw4qwvk_.bkp
-rw-r-----   1 oratest   oratest   1753088 Apr 13 16:48 o1_mf_nnnd0_TAG20160413T173009_cjw4r4jj_.bkp
-rw-r-----   1 oratest   oratest   12312576 Apr 13 16:49 o1_mf_nnnd0_TAG20160413T173009_cjw4r7wf_.bkp
-rw-r-----   1 oratest   oratest   8839168 Apr 13 16:50 o1_mf_nnnd0_TAG20160413T173009_cjw4f37p_.bkp
-rw-r-----   1 oratest   oratest   37568512 Apr 13 16:51 o1_mf_nnnd0_TAG20160413T173009_cjw4f4d1_.bkp
-rw-r-----   1 oratest   oratest   1114112 Apr 13 16:51 o1_mf_nnnd0_TAG20160413T173009_cjw4w1t9_.bkp
-rw-r-----   1 oratest   oratest   1277952 Apr 13 16:51 o1_mf_nnnd0_TAG20160413T173009_cjw4w1bb_.bkp
-rw-r-----   1 oratest   oratest   2891776 Apr 13 16:51 o1_mf_nnnd0_TAG20160413T173009_cjw4wc9q_.bkp
-rw-r-----   1 oratest   oratest   1130496 Apr 13 16:51 o1_mf_nnnd0_TAG20160413T173009_cjw4wlqb_.bkp
-rw-r-----   1 oratest   oratest   24395776 Apr 13 16:51 o1_mf_nnnd0_TAG20160413T173009_cjw4w3l3_.bkp
-rw-r-----   1 oratest   oratest   380403712 Apr 13 16:52 o1_mf_nnnd0_TAG20160413T173009_cjw4rqrp_.bkp
-rw-r-----   1 oratest   oratest   2410258432 Apr 13 17:02 o1_mf_nnnd0_TAG20160413T173009_cjw4gvf8_.bkp
-rw-r-----   1 oratest   oratest   2370019328 Apr 13 17:04 o1_mf_nnnd0_TAG20160413T173009_cjw4f38v_.bkp
testdb01:EDWD:/dbfra/testdb01/EDWD/backupset/2016_04_13> ls -lrt *T173009* | awk '{ sum += $5 } END { print sum }'
5343903744


The size is 5.3GB. The duration is about 22 minutes.





I have tested twice for this finding to support my conclusion.  Interesting and can someone explains? Thanks.

12c multitenant database backupset location

Organize  a chart based on below full list of backup information.



Note that if BACKUP OPTIMIZATION is turned on , the seeds files then are backed up once only.


Appendix




RMAN> list backupset;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
133     Full    4.34M      DISK        00:00:02     2016-APR-12 10:06:04
        BP Key: 133   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp0bls_.bkp
  List of Datafiles in backup set 133
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  5       Full 4542086    2016-APR-12 10:06:02 /rman001/oradata/RCATT/undotbs01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
134     Full    189.24M    DISK        00:00:57     2016-APR-12 10:07:02
        BP Key: 134   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp0ftk_.bkp
  List of Datafiles in backup set 134
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1       Full 4542088    2016-APR-12 10:06:05 /rman001/oradata/RCATT/system01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
135     Full    200.26M    DISK        00:01:08     2016-APR-12 10:07:10
        BP Key: 135   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp0blb_.bkp
  List of Datafiles in backup set 135
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  3       Full 4542084    2016-APR-12 10:06:02 /rman001/oradata/RCATT/sysaux01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
136     Full    102.60M    DISK        00:00:34     2016-APR-12 10:07:45
        BP Key: 136   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/2D960D0F8745635EE05400144FF8A527/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp2hj0_.bkp
  List of Datafiles in backup set 136
  Container ID: 2, PDB Name: PDB$SEED
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  4       Full 2043027    2016-MAR-09 14:26:29 /rman001/oradata/RCATT/pdbseed/sysaux01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
137     Full    110.38M    DISK        00:00:37     2016-APR-12 10:07:48
        BP Key: 137   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/2D98C99BF6722388E05400144FF8A527/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp2h52_.bkp
  List of Datafiles in backup set 137
  Container ID: 3, PDB Name: RCATPDB1
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  8       Full 4542112    2016-APR-12 10:07:11 /rman001/oradata/RCATT/RCATPDB1/sysaux01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
138     Full    47.09M     DISK        00:00:16     2016-APR-12 10:08:02
        BP Key: 138   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/2D98C99BF6722388E05400144FF8A527/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp3lw2_.bkp
  List of Datafiles in backup set 138
  Container ID: 3, PDB Name: RCATPDB1
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  7       Full 4542130    2016-APR-12 10:07:46 /rman001/oradata/RCATT/RCATPDB1/system01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
139     Full    43.30M     DISK        00:00:14     2016-APR-12 10:08:04
        BP Key: 139   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/2D960D0F8745635EE05400144FF8A527/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp3p2s_.bkp
  List of Datafiles in backup set 139
  Container ID: 2, PDB Name: PDB$SEED
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  2       Full 2043027    2016-MAR-09 14:26:29 /rman001/oradata/RCATT/pdbseed/system01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
140     Full    1.06M      DISK        00:00:00     2016-APR-12 10:08:05
        BP Key: 140   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp45tc_.bkp
  List of Datafiles in backup set 140
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  6       Full 4542138    2016-APR-12 10:08:05 /rman001/oradata/RCATT/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
141     Full    9.34M      DISK        00:00:03     2016-APR-12 10:08:08
        BP Key: 141   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/2D98C99BF6722388E05400144FF8A527/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp45cf_.bkp
  List of Datafiles in backup set 141
  Container ID: 3, PDB Name: RCATPDB1
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  9       Full 4542137    2016-APR-12 10:08:05 /rman001/oradata/RCATT/RCATPDB1/RCATPDB1_users01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
143     2.50K      DISK        00:00:00     2016-APR-12 10:08:11
        BP Key: 143   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100811
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/backupset/2016_04_12/o1_mf_annnn_TAG20160412T100811_cjrp4cmh_.bkp

  List of Archived Logs in backup set 143
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    442     4542164    2016-APR-12 10:08:10 4542172    2016-APR-12 10:08:11

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
144     1.70M      DISK        00:00:00     2016-APR-12 10:08:11
        BP Key: 144   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100811
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/backupset/2016_04_12/o1_mf_annnn_TAG20160412T100811_cjrp4cl8_.bkp

  List of Archived Logs in backup set 144
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    441     4541226    2016-APR-12 09:56:17 4542164    2016-APR-12 10:08:10

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
145     Full    17.30M     DISK        00:00:01     2016-APR-12 10:08:13
        BP Key: 145   Status: AVAILABLE  Compressed: NO  Tag: TAG20160412T100812
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/autobackup/2016_04_12/o1_mf_s_908964492_cjrp4f6j_.bkp
  SPFILE Included: Modification time: 2016-APR-09 07:07:00
  SPFILE db_unique_name: RCATT
  Control File Included: Ckp SCN: 4542190      Ckp time: 2016-APR-12 10:08:12