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.
Thursday, April 28, 2016
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
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
"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
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
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
about RMAN compression
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
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
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
Subscribe to:
Posts (Atom)
