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
change fast recovery area location, no impact to existing backup
The database RCATT's FRA was set to /rman001/oradata/fast_recovery_area/, now I want to change to another directory, i.e. /dbfra/wiadb01d. Wondering if the recovery catalog still knows it.
The answer is no impact based on my below test.
The old FRA location
RMAN> list backup;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
172 Full 2.14M DISK 00:00:01 2016-APR-12 11:30:05
BP Key: 172 Status: AVAILABLE Compressed: YES Tag: TAG20160412T113004
Piece Name: /rman001/oradata/fast_recovery_area/RCATT/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T113004_cjrtxx0n_.bkp
List of Datafiles in backup set 172
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
5 Full 4550801 2016-APR-12 11:30:04 /rman001/oradata/RCATT/undotbs01.dbf
Change to new FRA location
--change FRA location , and backup pluggable database rcatpdb1
RCATT:testdb01:/software/orarman/product/12.1.0/dbs> sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 13 17:44:32 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> alter system set db_recovery_file_dest='/dbfra/testdb01' scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2914560 bytes
Variable Size 922748672 bytes
Database Buffers 671088640 bytes
Redo Buffers 13860864 bytes
Database mounted.
Database opened.
SQL> alter pluggable database rcatpdb1 open;
Pluggable database altered.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
RCATT:testdb01:/software/orarman/product/12.1.0/dbs> rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Wed Apr 13 17:46:15 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: RCATT (DBID=4101766741)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name RCATT are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/software/orarman/product/12.1.0/dbs/snapcf_RCATT.f'; # default
RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
new RMAN configuration parameters are successfully stored
RMAN> backup pluggable database rcatpdb1;
Starting backup at 2016-APR-13 17:47:29
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=422 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=443 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00008 name=/rman001/oradata/RCATT/RCATPDB1/sysaux01.dbf
channel ORA_DISK_1: starting piece 1 at 2016-APR-13 17:47:31
channel ORA_DISK_2: starting compressed full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00007 name=/rman001/oradata/RCATT/RCATPDB1/system01.dbf
input datafile file number=00009 name=/rman001/oradata/RCATT/RCATPDB1/RCATPDB1_users01.dbf
channel ORA_DISK_2: starting piece 1 at 2016-APR-13 17:47:31
channel ORA_DISK_2: finished piece 1 at 2016-APR-13 17:47:56
piece handle=/dbfra/testdb01/RCATT/2D98C99BF6722388E05400144FF8A527/backupset/2016_04_13/o1_mf_nnndf_TAG20160413T174730_ cjw5fm7m_.bkp tag=TAG20160413T174730 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: finished piece 1 at 2016-APR-13 17:48:16
piece handle=/dbfra/testdb01/RCATT/2D98C99BF6722388E05400144FF8A527/backupset/2016_04_13/o1_mf_nnndf_TAG20160413T174730_ cjw5fm5g_.bkp tag=TAG20160413T174730 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
Finished backup at 2016-APR-13 17:48:16
Starting Control File and SPFILE Autobackup at 2016-APR-13 17:48:16
piece handle=/dbfra/testdb01/RCATT/autobackup/2016_04_13/o1_mf_s_909078496_cjw5h0v1_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2016-APR-13 17:48:17
Note that "2D98C99BF6722388E05400144FF8A527" (the funny directory name) is meant for pluggable database's backuppiece.
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- -------------------- ------- ------- ---------- ---
146 B F A DISK 2016-APR-12 11:20:05 1 1 YES TAG20160412T112004
147 B F A DISK 2016-APR-12 11:21:01 1 1 YES TAG20160412T112004
148 B F A DISK 2016-APR-12 11:21:11 1 1 YES TAG20160412T112004
149 B F A DISK 2016-APR-12 11:21:46 1 1 YES TAG20160412T112004
150 B F A DISK 2016-APR-12 11:21:48 1 1 YES TAG20160412T112004
151 B F A DISK 2016-APR-12 11:22:03 1 1 YES TAG20160412T112004
152 B F A DISK 2016-APR-12 11:22:03 1 1 YES TAG20160412T112004
153 B F A DISK 2016-APR-12 11:22:04 1 1 YES TAG20160412T112004
154 B F A DISK 2016-APR-12 11:22:07 1 1 YES TAG20160412T112004
156 B A A DISK 2016-APR-12 11:22:11 1 1 YES TAG20160412T112210
157 B A A DISK 2016-APR-12 11:22:11 1 1 YES TAG20160412T112210
....
234 B A A DISK 2016-APR-12 19:02:25 1 1 YES TAG20160412T190223
235 B A A DISK 2016-APR-12 19:02:27 1 1 YES TAG20160412T190223
236 B A A DISK 2016-APR-12 19:02:27 1 1 YES TAG20160412T190223
237 B F A DISK 2016-APR-12 19:02:28 1 1 NO TAG20160412T190227
238 B F A DISK 2016-APR-13 17:47:49 1 1 YES TAG20160413T174730
239 B F A DISK 2016-APR-13 17:48:08 1 1 YES TAG20160413T174730
240 B F A DISK 2016-APR-13 17:48:17 1 1 NO TAG20160413T174816
The answer is no impact based on my below test.
The old FRA location
RMAN> list backup;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
172 Full 2.14M DISK 00:00:01 2016-APR-12 11:30:05
BP Key: 172 Status: AVAILABLE Compressed: YES Tag: TAG20160412T113004
Piece Name: /rman001/oradata/fast_recovery_area/RCATT/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T113004_cjrtxx0n_.bkp
List of Datafiles in backup set 172
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
5 Full 4550801 2016-APR-12 11:30:04 /rman001/oradata/RCATT/undotbs01.dbf
Change to new FRA location
--change FRA location , and backup pluggable database rcatpdb1
RCATT:testdb01:/software/orarman/product/12.1.0/dbs> sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 13 17:44:32 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> alter system set db_recovery_file_dest='/dbfra/testdb01' scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2914560 bytes
Variable Size 922748672 bytes
Database Buffers 671088640 bytes
Redo Buffers 13860864 bytes
Database mounted.
Database opened.
SQL> alter pluggable database rcatpdb1 open;
Pluggable database altered.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
RCATT:testdb01:/software/orarman/product/12.1.0/dbs> rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Wed Apr 13 17:46:15 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: RCATT (DBID=4101766741)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name RCATT are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/software/orarman/product/12.1.0/dbs/snapcf_RCATT.f'; # default
RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
new RMAN configuration parameters are successfully stored
RMAN> backup pluggable database rcatpdb1;
Starting backup at 2016-APR-13 17:47:29
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=422 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=443 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00008 name=/rman001/oradata/RCATT/RCATPDB1/sysaux01.dbf
channel ORA_DISK_1: starting piece 1 at 2016-APR-13 17:47:31
channel ORA_DISK_2: starting compressed full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00007 name=/rman001/oradata/RCATT/RCATPDB1/system01.dbf
input datafile file number=00009 name=/rman001/oradata/RCATT/RCATPDB1/RCATPDB1_users01.dbf
channel ORA_DISK_2: starting piece 1 at 2016-APR-13 17:47:31
channel ORA_DISK_2: finished piece 1 at 2016-APR-13 17:47:56
piece handle=/dbfra/testdb01/RCATT/2D98C99BF6722388E05400144FF8A527/backupset/2016_04_13/o1_mf_nnndf_TAG20160413T174730_ cjw5fm7m_.bkp tag=TAG20160413T174730 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: finished piece 1 at 2016-APR-13 17:48:16
piece handle=/dbfra/testdb01/RCATT/2D98C99BF6722388E05400144FF8A527/backupset/2016_04_13/o1_mf_nnndf_TAG20160413T174730_ cjw5fm5g_.bkp tag=TAG20160413T174730 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
Finished backup at 2016-APR-13 17:48:16
Starting Control File and SPFILE Autobackup at 2016-APR-13 17:48:16
piece handle=/dbfra/testdb01/RCATT/autobackup/2016_04_13/o1_mf_s_909078496_cjw5h0v1_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2016-APR-13 17:48:17
Note that "2D98C99BF6722388E05400144FF8A527" (the funny directory name) is meant for pluggable database's backuppiece.
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- -------------------- ------- ------- ---------- ---
146 B F A DISK 2016-APR-12 11:20:05 1 1 YES TAG20160412T112004
147 B F A DISK 2016-APR-12 11:21:01 1 1 YES TAG20160412T112004
148 B F A DISK 2016-APR-12 11:21:11 1 1 YES TAG20160412T112004
149 B F A DISK 2016-APR-12 11:21:46 1 1 YES TAG20160412T112004
150 B F A DISK 2016-APR-12 11:21:48 1 1 YES TAG20160412T112004
151 B F A DISK 2016-APR-12 11:22:03 1 1 YES TAG20160412T112004
152 B F A DISK 2016-APR-12 11:22:03 1 1 YES TAG20160412T112004
153 B F A DISK 2016-APR-12 11:22:04 1 1 YES TAG20160412T112004
154 B F A DISK 2016-APR-12 11:22:07 1 1 YES TAG20160412T112004
156 B A A DISK 2016-APR-12 11:22:11 1 1 YES TAG20160412T112210
157 B A A DISK 2016-APR-12 11:22:11 1 1 YES TAG20160412T112210
....
234 B A A DISK 2016-APR-12 19:02:25 1 1 YES TAG20160412T190223
235 B A A DISK 2016-APR-12 19:02:27 1 1 YES TAG20160412T190223
236 B A A DISK 2016-APR-12 19:02:27 1 1 YES TAG20160412T190223
237 B F A DISK 2016-APR-12 19:02:28 1 1 NO TAG20160412T190227
238 B F A DISK 2016-APR-13 17:47:49 1 1 YES TAG20160413T174730
239 B F A DISK 2016-APR-13 17:48:08 1 1 YES TAG20160413T174730
240 B F A DISK 2016-APR-13 17:48:17 1 1 NO TAG20160413T174816
Tuesday, April 12, 2016
"list backup" command can not be in a RUN command block
Ha, just learned.
RCATT:/software/orarman/ops/exec> cat t.rman
run {
list backup summary;
}
RCATT:/software/orarman/ops/exec> cat t.rman
run {
list backup summary;
}
RMAN> @t.rman
RMAN> run {
2> list
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "list": expecting one of: "advise, allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, convert, copy, create, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop database, duplicate, execute, explain plan, flashback, flashback table, grant, host, insert, lock, merge, mount, noaudit, open, purge, recover, release, rename, repair, report, restore, resync, revoke, rollback, savepoint, select, send, set, set constraint, set role, set transaction, show, shutdown, sql, startup, switch, transport, "
RMAN-01007: at line 2 column 1 file: t.rman
RMAN> exit
Recovery Manager complete.
Remove it out of {}
RCATT:/software/orarman/ops/exec> cat t.rman
list backup summary;
RCATT:/software/orarman/ops/exec> rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Tue Apr 12 15:27:52 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: RCATT (DBID=4101766741)
RMAN> @t.rman
RMAN> list backup summary;
using target database control file instead of recovery catalog
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- -------------------- ------- ------- ---------- ---
133 B F A DISK 2016-APR-12 10:06:04 1 1 YES TAG20160412T100602
134 B F A DISK 2016-APR-12 10:07:02 1 1 YES TAG20160412T100602
135 B F A DISK 2016-APR-12 10:07:10 1 1 YES TAG20160412T100602
136 B F A DISK 2016-APR-12 10:07:45 1 1 YES TAG20160412T100602
137 B F A DISK 2016-APR-12 10:07:48 1 1 YES TAG20160412T100602
138 B F A DISK 2016-APR-12 10:08:02 1 1 YES TAG20160412T100602
rman backup set and backup piece concepts
backup piece
The physical file format used to store RMAN backup sets
A backup of one or more datafiles, control files, SPFILEs and archived redo log files. Each backup set consists of one or more binary files called backup pieces. Backup pieces are written in a proprietary format that can only be created or restored by RMAN.
The physical file format used to store RMAN backup sets
backup set
A backup of one or more datafiles, control files, SPFILEs and archived redo log files. Each backup set consists of one or more binary files called backup pieces. Backup pieces are written in a proprietary format that can only be created or restored by RMAN.
Backup sets are produced by the RMAN BACKUP command. A backup set usually consists of only one backup piece. RMAN divides the contents of a backup set among multiple backup pieces only if you limit the backup piece size using the MAXPIECESIZE option of the ALLOCATE CHANNEL.
Backup Sets and Backup Pieces
RMAN can store backup data in a logical structure called a backup set, which is the smallest unit of an RMAN backup. A backup set contains the data from one or more datafiles, archived redo logs, control files, or server parameter file. Backup sets, which are only created and accessed through RMAN, are the only form in which RMAN can write backups to media managers such as tape drives and tape libraries.
A backup set contains one or more binary files in an RMAN-specific format. Each of these files is known as a backup piece. A backup set can contain multiple datafiles. For example, you can back up 10 datafiles into a single backup set consisting of a single backup piece. In this case, RMAN creates one backup piece as output. The backup set contains only this backup piece.
If you specify the
SECTION SIZE parameter on the BACKUP command, then RMAN produces a multisection backup. This is a backup of a single large file, produced by multiple channels in parallel, each of which produces one backup piece. Each backup piece contains one file section of the file being backed up.
For non-multisection backups, RMAN only records backup sets in the repository that complete successfully. There is no such thing as a partial backup set. This differs from an unsuccessful multisection backup, where it is possible for RMAN metadata to contain a record for a partial backup set. In the latter case, you must use the
DELETE command to delete the partial backup set.
Monday, April 11, 2016
two RMAN tips learned when using disk
1. to delete obsolete command, I have to change the command worked for tape device from
delete noprompt obsolte;
to
delete noprompt obsolte to device type disk;
2. When using FRA, I can't use FORMAT option as discussed here, irregardless I was happy with the conversion for device type tape BACKUP FULL FILESPERSET 1 FORMAT 'DB%I.%d_%N_%U' DATABASE;. Otherwise, the backupset is written to $ORACLE_HOME/dbs instead FRA location.
delete noprompt obsolte;
to
delete noprompt obsolte to device type disk;
2. When using FRA, I can't use FORMAT option as discussed here, irregardless I was happy with the conversion for device type tape BACKUP FULL FILESPERSET 1 FORMAT 'DB%I.%d_%N_%U' DATABASE;. Otherwise, the backupset is written to $ORACLE_HOME/dbs instead FRA location.
Subscribe to:
Posts (Atom)