Home » RDBMS Server » Backup & Recovery » Incremental Level Backup (ORACLE 10g R2 (10.2.0.1.0))
Incremental Level Backup [message #489643] Tue, 18 January 2011 05:02 Go to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hi All,

I want to schedule incremental level backup for my company's databases but implementing it I want to test on my local server.

I first run the job mode command for 0 level backup:

RMAN> run
2> {
3> allocate channel c1 device type disk;
4> backup incremental level 0 database plus archivelog;
5> }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=151 devtype=DISK


Starting backup at 18-JAN-11
current log archived
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=1 recid=13 stamp=740329771
input archive log thread=1 sequence=2 recid=14 stamp=740329772
input archive log thread=1 sequence=3 recid=15 stamp=740329783
input archive log thread=1 sequence=4 recid=16 stamp=740329784
input archive log thread=1 sequence=5 recid=17 stamp=740329801
input archive log thread=1 sequence=6 recid=18 stamp=740333273
input archive log thread=1 sequence=7 recid=19 stamp=740338941
input archive log thread=1 sequence=8 recid=20 stamp=740372491
input archive log thread=1 sequence=9 recid=21 stamp=740432129
input archive log thread=1 sequence=10 recid=22 stamp=740464607
input archive log thread=1 sequence=11 recid=23 stamp=740501590
input archive log thread=1 sequence=12 recid=24 stamp=740658963
input archive log thread=1 sequence=13 recid=25 stamp=740685225
input archive log thread=1 sequence=14 recid=26 stamp=740716264
input archive log thread=1 sequence=15 recid=27 stamp=740762573
input archive log thread=1 sequence=16 recid=28 stamp=740763528
input archive log thread=1 sequence=17 recid=29 stamp=740765124
channel c1: starting piece 1 at 18-JAN-11
channel c1: finished piece 1 at 18-JAN-11
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DBADEEPA\BACKUPSET\2011_01_18\O1_MF_ANNNN_TAG20110118T160524_6MBV7J4W_.BKP tag=TAG20110118T160524 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:27
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=9 recid=8 stamp=740244324
input archive log thread=1 sequence=10 recid=9 stamp=740245893
input archive log thread=1 sequence=11 recid=10 stamp=740245950
input archive log thread=1 sequence=12 recid=11 stamp=740283142
input archive log thread=1 sequence=13 recid=12 stamp=740314318
channel c1: starting piece 1 at 18-JAN-11
channel c1: finished piece 1 at 18-JAN-11
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DBADEEPA\BACKUPSET\2011_01_18\O1_MF_ANNNN_TAG20110118T160524_6MBV8BCR_.BKP tag=TAG20110118T160524 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:08
Finished backup at 18-JAN-11

Starting backup at 18-JAN-11
channel c1: starting incremental level 0 datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\DBADEEPAK\SYSTEM01.DBF
input datafile fno=00003 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\DBADEEPAK\SYSAUX01.DBF
input datafile fno=00002 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\DBADEEPAK\UNDOTBS01.DBF
input datafile fno=00004 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\DBADEEPAK\USERS01.DBF
channel c1: starting piece 1 at 18-JAN-11
channel c1: finished piece 1 at 18-JAN-11
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DBADEEPA\BACKUPSET\2011_01_18\O1_MF_NNND0_TAG20110118T160601_6MBV8L7W_.BKP tag=TAG20110118T160601 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:36
channel c1: starting incremental level 0 datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel c1: starting piece 1 at 18-JAN-11
channel c1: finished piece 1 at 18-JAN-11
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DBADEEPA\BACKUPSET\2011_01_18\O1_MF_NCSN0_TAG20110118T160601_6MBV9PVZ_.BKP tag=TAG20110118T160601 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
Finished backup at 18-JAN-11

Starting backup at 18-JAN-11
current log archived
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=18 recid=30 stamp=740765202
channel c1: starting piece 1 at 18-JAN-11
channel c1: finished piece 1 at 18-JAN-11
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DBADEEPA\BACKUPSET\2011_01_18\O1_MF_ANNNN_TAG20110118T160642_6MBV9W1M_.BKP tag=TAG20110118T160642 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
Finished backup at 18-JAN-11
released channel: c1


There after I ran level 1 incremental backup command:

RMAN> run
2> {
3> allocate channel c1 device type disk;
4> backup incremental level 1 database plus archivelog;
5> }

allocated channel: c1
channel c1: sid=151 devtype=DISK


Starting backup at 18-JAN-11
current log archived
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=1 recid=13 stamp=740329771
input archive log thread=1 sequence=2 recid=14 stamp=740329772
input archive log thread=1 sequence=3 recid=15 stamp=740329783
input archive log thread=1 sequence=4 recid=16 stamp=740329784
input archive log thread=1 sequence=5 recid=17 stamp=740329801
input archive log thread=1 sequence=6 recid=18 stamp=740333273
input archive log thread=1 sequence=7 recid=19 stamp=740338941
input archive log thread=1 sequence=8 recid=20 stamp=740372491
input archive log thread=1 sequence=9 recid=21 stamp=740432129
input archive log thread=1 sequence=10 recid=22 stamp=740464607
input archive log thread=1 sequence=11 recid=23 stamp=740501590
input archive log thread=1 sequence=12 recid=24 stamp=740658963
input archive log thread=1 sequence=13 recid=25 stamp=740685225
input archive log thread=1 sequence=14 recid=26 stamp=740716264
input archive log thread=1 sequence=15 recid=27 stamp=740762573
input archive log thread=1 sequence=16 recid=28 stamp=740763528
input archive log thread=1 sequence=17 recid=29 stamp=740765124
input archive log thread=1 sequence=18 recid=30 stamp=740765202
input archive log thread=1 sequence=19 recid=31 stamp=740766321
channel c1: starting piece 1 at 18-JAN-11
channel c1: finished piece 1 at 18-JAN-11
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DBADEEPA\BACKUPSET\2011_01_18\O1_MF_ANNNN_TAG20110118T162522_6MBWDWHZ_.BKP tag=TAG20110118T162522 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:27
Finished backup at 18-JAN-11

Starting backup at 18-JAN-11
channel c1: starting incremental level 1 datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\DBADEEPAK\SYSTEM01.DBF
input datafile fno=00003 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\DBADEEPAK\SYSAUX01.DBF
input datafile fno=00002 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\DBADEEPAK\UNDOTBS01.DBF
input datafile fno=00004 name=E:\ORACLE\PRODUCT\10.2.0\ORADATA\DBADEEPAK\USERS01.DBF
channel c1: starting piece 1 at 18-JAN-11
channel c1: finished piece 1 at 18-JAN-11
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DBADEEPA\BACKUPSET\2011_01_18\O1_MF_NNND1_TAG20110118T162549_6MBWFP75_.BKP tag=TAG20110118T162549 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:16
channel c1: starting incremental level 1 datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel c1: starting piece 1 at 18-JAN-11
channel c1: finished piece 1 at 18-JAN-11
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DBADEEPA\BACKUPSET\2011_01_18\O1_MF_NCSN1_TAG20110118T162549_6MBWG6XN_.BKP tag=TAG20110118T162549 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
Finished backup at 18-JAN-11

Starting backup at 18-JAN-11
current log archived
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=20 recid=32 stamp=740766369
channel c1: starting piece 1 at 18-JAN-11
channel c1: finished piece 1 at 18-JAN-11
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\DBADEEPA\BACKUPSET\2011_01_18\O1_MF_ANNNN_TAG20110118T162609_6MBWGC94_.BKP tag=TAG20110118T162609 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
Finished backup at 18-JAN-11
released channel: c1


In have include
plus archivelog 
both the times, I want to know Is it necessary to include plus archive log everytime in the command.

Thanks
Deepak

[Updated on: Tue, 18 January 2011 05:04]

Report message to a moderator

Re: Incremental Level Backup [message #489645 is a reply to message #489643] Tue, 18 January 2011 05:13 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
Quote:
plus archive log


by this you are instructing to backup the archivelogs ,,

complete/incremental,,,,to recover from database backup to point in time,you will require archive log backups.
Re: Incremental Level Backup [message #489646 is a reply to message #489645] Tue, 18 January 2011 05:29 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hey Thanks for the reply knight

You are right that for point in time recovery bakcup of the archive logs is essential, but if we check the logs carefully, we will find that that everytime the archivelog that are being backed up include the previous archivelogs as well.

I want that only the new archive should be included not the old ones. What to do for that?

Thanks
Deepak
Re: Incremental Level Backup [message #489647 is a reply to message #489643] Tue, 18 January 2011 05:38 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
backup optimization is not configured.
post
RMAN>show all;

Re: Incremental Level Backup [message #489651 is a reply to message #489647] Tue, 18 January 2011 06:09 Go to previous messageGo to next message
John Watson
Messages: 8500
Registered: January 2010
Location: Global Village
Senior Member
There are many techniques to achieve this. How about removing the "plus archivelog" clause, and instead use a separate job such as:

backup archivelog all not backed up 1 times;

Re: Incremental Level Backup [message #489764 is a reply to message #489647] Tue, 18 January 2011 22:56 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Thanks everyone for your efforts, now I have use
run
{
allocate channel c1 device type disk;
backup incremental level 1 database database;
backup archivelog all delete input;
}
and my problem is solved not it is not taking the backup of all archives again and again.

but I am just wondering, what the result is gonna be If I use the below mentioned command;

run
{
allocate channel c1 device type disk;
backup incremental level 2 database;
backup archivelog all delete input;
}


I am just confuse that what the difference it makes using different values for keyword "level" and values "1,2,3,4".

Please help me to understand this.

Regards
Deepak

[Updated on: Tue, 18 January 2011 22:57]

Report message to a moderator

Re: Incremental Level Backup [message #489767 is a reply to message #489764] Tue, 18 January 2011 23:24 Go to previous message
Michel Cadot
Messages: 67754
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot use 2, 3, 4 only 0 or 1.

Regards
Michel
Previous Topic: date time changes
Next Topic: RMAN Backup
Goto Forum:
  


Current Time: Wed Mar 03 06:37:11 CST 2021