Home » RDBMS Server » Backup & Recovery » Strange problem about incremental level 1 cumulative backup (oracle 10g, linux)
Strange problem about incremental level 1 cumulative backup [message #610418] Wed, 19 March 2014 21:57 Go to next message
cawind2
Messages: 2
Registered: March 2014
Junior Member
I used the following script to backup my DB( incremental level 1 cumulative).
-----------------------------------------------------------------------
# script : incr1.sh
# date:2013/07/15
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/product/10.2.0
export ORACLE_SID=headdb
export PATH=$ORACLE_HOME/bin:$PATH
rman target / << EOF_RMAN
run{
allocate channel c1 type disk;
backup incremental level 1 cumulative database tag 'db1' format
'/oracle/databackup/headdb/db1_%d_%T_%s' database include current
controlfile;
delete noprompt obsolete;
release channel c1;
}
# end
-----------------------------------------------
The result is here:
.......
input datafile fno=00004 name=/oracle/oradata/headdb/users01.dbf
channel c1: starting piece 1 at 18-MAR-14
channel c1: finished piece 1 at 18-MAR-14
piece handle=/oracle/databackup/headdb/db1_HEADDB_20140318_961 tag=DB1 comment=NONE
channel c1: backup set complete, elapsed time: 00:01:35

......
piece handle=/oracle/flash_recovery_area/HEADDB/backupset/2014_03_18/o1_mf_nnnd1_TAG20140318T153724_9lhy0phd_.bkp tag=TAG20140318T153724 comment=NONE
channel c1: backup set complete, elapsed time: 00:03:06
channel c1: starting incremental level 1 datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
channel c1: starting piece 1 at 18-MAR-14
channel c1: finished piece 1 at 18-MAR-14
piece handle=/oracle/flash_recovery_area/HEADDB/backupset/2014_03_18/o1_mf_ncnn1_TAG20140318T153724_9lhy6hyb_.bkp tag=TAG20140318T153724 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
Finished backup at 18-MAR-14

Starting Control File and SPFILE Autobackup at 18-MAR-14
piece handle=/oracle/flash_recovery_area/HEADDB/autobackup/2014_03_18/o1_mf_s_842542929_9lhy6kxc_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 18-MAR-14

released channel: c1
--------------------------------------------------------------

My question is why RMAN store the controlfile piece under the flash_recovery_area folder, since I specify the destination folder with format option.

I also use a similar script to do a level 0 backup. The result is fine. The controlfile piece is under my specified folder.
Re: Strange problem about incremental level 1 cumulative backup [message #610472 is a reply to message #610418] Thu, 20 March 2014 07:40 Go to previous messageGo to next message
EdStevens
Messages: 286
Registered: September 2013
Senior Member
That backup of control file you show is probably the result of "CONFIGURE CONTROLFILE AUTOBACKUP ON;" and is apart and separate from the 'include controlfile' in your backup command. Do a LIST BACKUP and compare the results with the output log of your backup.
Re: Strange problem about incremental level 1 cumulative backup [message #610524 is a reply to message #610472] Thu, 20 March 2014 20:22 Go to previous message
cawind2
Messages: 2
Registered: March 2014
Junior Member
thank you for your reply!
After I remove 'database' in my script, I get correct result.
The modified script is here:
-------
run{
allocate channel c1 type disk;
backup incremental level 1 cumulative tag 'db1' format ---here, I remove 'database'
'/oracle/databackup/headdb/db1_%d_%T_%s' database include current
controlfile;
delete noprompt obsolete;
release channel c1;
}
Previous Topic: How to change the default location of an RMAN backup in 10g
Next Topic: Problem after restoring a database on new host
Goto Forum:
  


Current Time: Tue Sep 23 06:23:45 CDT 2014

Total time taken to generate the page: 0.08332 seconds